-- ----------------------- --
-- Trend Channels For Ironville - Sun Oil --
-- ----------------------- --

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'AvgImbal'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'AvgImbal'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(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 = 'Ironville - Sun Oil'),
		(SELECT ID FROM Asset WHERE AssetName = 'Ironville - Sun Oil'),
		(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 = 'Ironville - Sun Oil')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_IC_10MIN')
GO