INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I RMS N' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'IN_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Imbalance Avg LN' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'V_IMB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Imbalance Avg LN' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'I_IMB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDVC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I THD N' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'THDIN_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VA');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VB');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'PST_10MIN_VC');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_VC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IA_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IB_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM2_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM3_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM4_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM5_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM6_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM7_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM8_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM9_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM10_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM11_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM12_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM13_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM14_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM15_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM16_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM17_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM18_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM19_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM20_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM21_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM22_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM23_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM24_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM25_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM26_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM27_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM28_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM29_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM30_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM31_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM32_IC_10MIN');
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes) VALUES
((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Avon%')),
(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
'HRMM33_IC_10MIN');