Create multi-series line Chart with huge (large) data using C# and VB.Net in ASP.Net

hsku6482

SOLVED CLOSED ACTIVE ANSWERED
User: hsku6482
Posted: on Dec 04, 2020 10:46 PM
Forum: ASP.Net Web Forms
Answer: 1
Views: 1909
Sample Code: Download

I would like to make a multi-Series Line chart for showing the Rate or number of Case from 2005 to 2020 base on my selection such as Period ,Department (not more than 20), Case type and Period(can be monthly, yearly or quarterly)

It will be showing the rate of case with over 6 departments in the same graph

The selection part I finished that through SQL data source. The selected data I store it into a GridView and the chart data table is copying from GridView.

After I tried many times it seems not to work on my chart, for the Legend it divided with the different department with my selection.

It the problem of my array?

It is because Data Type of Period_shown is string?

Here is the source code to generate the chart.

  Protected Sub btn_Int_Click(sender As Object, e As EventArgs) Handles btn_Int.Click
      Label001.Visible = False
      Label37.Visible = True
      Label39.Visible = True
      Label48.Visible = True
      Label51.Visible = False
      Label52.Visible = False
      Label37.Text = "The Chart of " & Label38.Text & " by Number of Incidents "
      Label48.Text = "From" & " " & Label42.Text & " " & "to" & " " & Label45.Text
      If DropDownList13.SelectedIndex = -1 Then
          Label39.Text = Label40.Text
      Else
          Label39.Text = Label40.Text & Label41.Text
      End If
      btn_Print.Visible = True
      RateChart.Visible = True
          Dim dtInt As DataTable = New DataTable("dtInts")
          For Each cell As TableCell In gvInt.HeaderRow.Cells
              dtInt.Columns.Add(cell.Text.Trim())
          Next
          For Each row As GridViewRow In gvInt.Rows
              dtInt.Rows.Add()
              For i As Integer = 0 To row.Cells.Count = -1
                  Dim j As Integer = i
                  dtInt.Rows(row.RowIndex)(j) = row.Cells(j).Text.Trim()
              Next
          Next
          Dim departments As List(Of String) = New List(Of String)()
          departments = (From p In dtInt.AsEnumerable() Select p.Field(Of String)("Department")).Distinct().ToList()
          If RateChart.Series.Count() = 1 Then
              RateChart.Series.Remove(RateChart.Series(0))
          End If
          For Each department As String In departments.ToList()
              Dim department1 As String = department
              Dim X As Integer()
              X = (From p In dtInt.AsEnumerable()
                      Where p.Field(Of String)("Department") = department1
                      Order By p.Field(Of String)("Period_Shown")
                      Select Convert.ToInt32(p.Field(Of String)("Period_Shown"))).ToArray()
              Dim Y As Decimal()
              Y = (From p In dtInt.AsEnumerable()
                      Where p.Field(Of String)("Department") = department1
                      Order By p.Field(Of String)("Period_Shown")
                      Select Convert.ToDecimal(p.Field(Of String)("Num_Int"))).ToArray()
              departments.Add(department1)
              RateChart.Series.Add(New Series(department1))
              RateChart.Series(department1).IsValueShownAsLabel = True
              RateChart.Series(department1).BorderWidth = 3
              RateChart.Series(department1).ChartType = SeriesChartType.Line
              RateChart.Series(department1).Points.DataBindXY(X, Y)
          Next
      RateChart.Legends(0).Enabled = True
  End Sub

Here is the sample of data-table:

Department	Period_Shown	Num_Int
DMG	2015_Jan	0
DMG	2015_Feb	0
DMG	2015_Mar	0
DMG	2015_Apr	0
DMG	2015_May	0
DMG	2015_Jun	0
DMG	2015_Jul	9
DMG	2015_Aug	13
DMG	2015_Sep	12
DMG	2015_Oct	6
DMG	2015_Nov	6
DMG	2015_Dec	7
DMG	2016_Jan	5
DMG	2016_Feb	6
DMG	2016_Mar	7
DMG	2016_Apr	3
DMG	2016_May	7
DMG	2016_Jun	6
DMG	2016_Jul	4
DMG	2016_Aug	11
DMG	2016_Sep	10
DMG	2016_Oct	10
DMG	2016_Nov	14
DMG	2016_Dec	7
DMG	2017_Jan	9
DMG	2017_Feb	5
DMG	2017_Mar	7
DMG	2017_Apr	10
DMG	2017_May	14
DMG	2017_Jun	11
DMG	2017_Jul	8
DMG	2017_Aug	8
DMG	2017_Sep	6
DMG	2017_Oct	6
DMG	2017_Nov	5
DMG	2017_Dec	8
DMG	2018_Jan	11
DMG	2018_Feb	7
DMG	2018_Mar	10
DMG	2018_Apr	13
DMG	2018_May	11
DMG	2018_Jun	11
DMG	2018_Jul	12
DMG	2018_Aug	15
DMG	2018_Sep	7
DMG	2018_Oct	9
DMG	2018_Nov	13
DMG	2018_Dec	7
DMG	2019_Jan	10
DMG	2019_Feb	7
DMG	2019_Mar	4
DMG	2019_Apr	17
DMG	2019_May	11
DMG	2019_Jun	6
DMG	2019_Jul	8
DMG	2019_Aug	13
DMG	2019_Sep	10
DMG	2019_Oct	13
DMG	2019_Nov	11
DMG	2019_Dec	10
DMG	2020_Jan	12
ACH	2015_Jan	0
ACH	2015_Feb	0
ACH	2015_Mar	0
ACH	2015_Apr	0
ACH	2015_May	0
ACH	2015_Jun	0
ACH	2015_Jul	9
ACH	2015_Aug	13
ACH	2015_Sep	12
ACH	2015_Oct	6
ACH	2015_Nov	6
ACH	2015_Dec	7
ACH	2016_Jan	5
ACH	2016_Feb	6
ACH	2016_Mar	7
ACH	2016_Apr	3
ACH	2016_May	7
ACH	2016_Jun	6
ACH	2016_Jul	4
ACH	2016_Aug	11
ACH	2016_Sep	10
ACH	2016_Oct	10
ACH	2016_Nov	14
ACH	2016_Dec	7
ACH	2017_Jan	9
ACH	2017_Feb	5
ACH	2017_Mar	7
ACH	2017_Apr	10
ACH	2017_May	14
ACH	2017_Jun	11
ACH	2017_Jul	8
ACH	2017_Aug	8
ACH	2017_Sep	6
ACH	2017_Oct	6
ACH	2017_Nov	5
ACH	2017_Dec	8
ACH	2018_Jan	11
ACH	2018_Feb	7
ACH	2018_Mar	10
ACH	2018_Apr	13
ACH	2018_May	11
ACH	2018_Jun	11
ACH	2018_Jul	12
ACH	2018_Aug	15
ACH	2018_Sep	7
ACH	2018_Oct	9
ACH	2018_Nov	13
ACH	2018_Dec	7
ACH	2019_Jan	10
ACH	2019_Feb	7
ACH	2019_Mar	4
ACH	2019_Apr	17
ACH	2019_May	11
ACH	2019_Jun	6
ACH	2019_Jul	8
ACH	2019_Aug	13
ACH	2019_Sep	10
ACH	2019_Oct	13
ACH	2019_Nov	11
ACH	2019_Dec	10
ACH	2020_Jan	12

dharmend...

0 6

Reply
ANSWER
User: dharmendr
Replied: on Dec 07, 2020 04:16 AM
Report

Hi hsku6482,

Refer below sample.

HTML

<table>
    <tr>
        <td>Country 1:</td>
        <td>
            <asp:DropDownList ID="ddlCountries1" runat="server" AutoPostBack="true" DataSourceID="SqlDataSource1"
                DataTextField="ShipCountry" DataValueField="ShipCountry" AppendDataBoundItems="true">
                <asp:ListItem Text="Select Country" Value="" />
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConStr %>"
                SelectCommand="SELECT DISTINCT ShipCountry FROM Orders ORDER BY ShipCountry"></asp:SqlDataSource>
        </td>
        <td>Country 2:</td>
        <td>
            <asp:DropDownList ID="ddlCountries2" runat="server" AutoPostBack="true" DataSourceID="SqlDataSource2"
                DataTextField="ShipCountry" DataValueField="ShipCountry" AppendDataBoundItems="true">
                <asp:ListItem Text="Select Country" Value="" />
            </asp:DropDownList>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConStr %>"
                SelectCommand="SELECT DISTINCT ShipCountry FROM Orders ORDER BY ShipCountry"></asp:SqlDataSource>
        </td>
    </tr>
</table>
<asp:GridView runat="server" ID="gvInt" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Department" HeaderText="Department" />
        <asp:BoundField DataField="Period_Shown" HeaderText="Period_Shown" />
        <asp:BoundField DataField="Num_Int" HeaderText="Num_Int" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="GridDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConStr %>"
    SelectCommand="SELECT ShipCountry, DATEPART(Year, OrderDate) [Year], COUNT(OrderId) [Total] FROM Orders 
    WHERE ShipCountry = @Country1 OR ShipCountry = @Country2 GROUP BY ShipCountry, DATEPART(Year, OrderDate)">
    <SelectParameters>
        <asp:ControlParameter ControlID="ddlCountries1" Name="Country1" PropertyName="SelectedValue" Type="String" />
        <asp:ControlParameter ControlID="ddlCountries2" Name="Country2" PropertyName="SelectedValue" Type="String" />
    </SelectParameters>
</asp:SqlDataSource>
<br />
<asp:Button Text="Generate Chart" runat="server" OnClick="OnGenerate" />
<hr />
<asp:Chart ID="RateChart" runat="server" Height="300px" Width="1000px">
    <Titles>
        <asp:Title ShadowOffset="3" Name="Items" />
    </Titles>
    <%--<Legends>
        <asp:Legend Alignment="Center" Docking="Bottom" IsTextAutoFit="False" Name="Default"
            LegendStyle="Row" />
    </Legends>--%>
    <ChartAreas>
        <asp:ChartArea Name="ChartArea1" BorderWidth="0" />
    </ChartAreas>
</asp:Chart>

Code

protected void OnGenerate(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Columns.Add("Department");
    dt.Columns.Add("Period_Shown");
    dt.Columns.Add("Num_Int");

    dt.Rows.Add("DMG", "2015_Jan", 0);
    dt.Rows.Add("DMG", "2015_Feb", 0);
    dt.Rows.Add("DMG", "2015_Mar", 0);
    dt.Rows.Add("DMG", "2015_Apr", 0);
    dt.Rows.Add("DMG", "2015_May", 0);
    dt.Rows.Add("DMG", "2015_Jun", 0);
    dt.Rows.Add("DMG", "2015_Jul", 9);
    dt.Rows.Add("DMG", "2015_Aug", 13);
    dt.Rows.Add("DMG", "2015_Sep", 12);
    dt.Rows.Add("DMG", "2015_Oct", 6);
    dt.Rows.Add("DMG", "2015_Nov", 6);
    dt.Rows.Add("DMG", "2015_Dec", 7);
    dt.Rows.Add("DMG", "2016_Jan", 5);
    dt.Rows.Add("DMG", "2016_Feb", 6);
    dt.Rows.Add("DMG", "2016_Mar", 7);
    dt.Rows.Add("DMG", "2016_Apr", 3);
    dt.Rows.Add("DMG", "2016_May", 7);
    dt.Rows.Add("DMG", "2016_Jun", 6);
    dt.Rows.Add("DMG", "2016_Jul", 4);
    dt.Rows.Add("DMG", "2016_Aug", 11);
    dt.Rows.Add("DMG", "2016_Sep", 10);
    dt.Rows.Add("DMG", "2016_Oct", 10);
    dt.Rows.Add("DMG", "2016_Nov", 14);
    dt.Rows.Add("DMG", "2016_Dec", 7);
    dt.Rows.Add("DMG", "2017_Jan", 9);
    dt.Rows.Add("DMG", "2017_Feb", 5);
    dt.Rows.Add("DMG", "2017_Mar", 7);
    dt.Rows.Add("DMG", "2017_Apr", 10);
    dt.Rows.Add("DMG", "2017_May", 14);
    dt.Rows.Add("DMG", "2017_Jun", 11);
    dt.Rows.Add("DMG", "2017_Jul", 8);
    dt.Rows.Add("DMG", "2017_Aug", 8);
    dt.Rows.Add("DMG", "2017_Sep", 6);
    dt.Rows.Add("DMG", "2017_Oct", 6);
    dt.Rows.Add("DMG", "2017_Nov", 5);
    dt.Rows.Add("DMG", "2017_Dec", 8);
    dt.Rows.Add("DMG", "2018_Jan", 11);
    dt.Rows.Add("DMG", "2018_Feb", 7);
    dt.Rows.Add("DMG", "2018_Mar", 10);
    dt.Rows.Add("DMG", "2018_Apr", 13);
    dt.Rows.Add("DMG", "2018_May", 11);
    dt.Rows.Add("DMG", "2018_Jun", 11);
    dt.Rows.Add("DMG", "2018_Jul", 12);
    dt.Rows.Add("DMG", "2018_Aug", 15);
    dt.Rows.Add("DMG", "2018_Sep", 7);
    dt.Rows.Add("DMG", "2018_Oct", 9);
    dt.Rows.Add("DMG", "2018_Nov", 13);
    dt.Rows.Add("DMG", "2018_Dec", 7);
    dt.Rows.Add("DMG", "2019_Jan", 10);
    dt.Rows.Add("DMG", "2019_Feb", 7);
    dt.Rows.Add("DMG", "2019_Mar", 4);
    dt.Rows.Add("DMG", "2019_Apr", 17);
    dt.Rows.Add("DMG", "2019_May", 11);
    dt.Rows.Add("DMG", "2019_Jun", 6);
    dt.Rows.Add("DMG", "2019_Jul", 8);
    dt.Rows.Add("DMG", "2019_Aug", 13);
    dt.Rows.Add("DMG", "2019_Sep", 10);
    dt.Rows.Add("DMG", "2019_Oct", 13);
    dt.Rows.Add("DMG", "2019_Nov", 11);
    dt.Rows.Add("DMG", "2019_Dec", 10);
    dt.Rows.Add("DMG", "2020_Jan", 12);
    dt.Rows.Add("MGW_11A", "2015_Jan", 0);
    dt.Rows.Add("MGW_11A", "2015_Feb", 0);
    dt.Rows.Add("MGW_11A", "2015_Mar", 0);
    dt.Rows.Add("MGW_11A", "2015_Apr", 0);
    dt.Rows.Add("MGW_11A", "2015_May", 0);
    dt.Rows.Add("MGW_11A", "2015_Jun", 0);
    dt.Rows.Add("MGW_11A", "2015_Jul", 1);
    dt.Rows.Add("MGW_11A", "2015_Aug", 2);
    dt.Rows.Add("MGW_11A", "2015_Sep", 3);
    dt.Rows.Add("MGW_11A", "2015_Oct", 0);
    dt.Rows.Add("MGW_11A", "2015_Nov", 1);
    dt.Rows.Add("MGW_11A", "2015_Dec", 2);
    dt.Rows.Add("MGW_11A", "2016_Jan", 0);
    dt.Rows.Add("MGW_11A", "2016_Feb", 0);
    dt.Rows.Add("MGW_11A", "2016_Mar", 0);
    dt.Rows.Add("MGW_11A", "2016_Apr", 0);
    dt.Rows.Add("MGW_11A", "2016_May", 0);
    dt.Rows.Add("MGW_11A", "2016_Jun", 0);
    dt.Rows.Add("MGW_11A", "2016_Jul", 1);
    dt.Rows.Add("MGW_11A", "2016_Aug", 0);
    dt.Rows.Add("MGW_11A", "2016_Sep", 1);
    dt.Rows.Add("MGW_11A", "2016_Oct", 1);
    dt.Rows.Add("MGW_11A", "2016_Nov", 2);
    dt.Rows.Add("MGW_11A", "2016_Dec", 0);
    dt.Rows.Add("MGW_11A", "2017_Jan", 1);
    dt.Rows.Add("MGW_11A", "2017_Feb", 0);
    dt.Rows.Add("MGW_11A", "2017_Mar", 0);
    dt.Rows.Add("MGW_11A", "2017_Apr", 0);
    dt.Rows.Add("MGW_11A", "2017_May", 0);
    dt.Rows.Add("MGW_11A", "2017_Jun", 1);
    dt.Rows.Add("MGW_11A", "2017_Jul", 0);
    dt.Rows.Add("MGW_11A", "2017_Aug", 0);
    dt.Rows.Add("MGW_11A", "2017_Sep", 1);
    dt.Rows.Add("MGW_11A", "2017_Oct", 1);
    dt.Rows.Add("MGW_11A", "2017_Nov", 0);
    dt.Rows.Add("MGW_11A", "2017_Dec", 1);
    dt.Rows.Add("MGW_11A", "2018_Jan", 2);
    dt.Rows.Add("MGW_11A", "2018_Feb", 1);
    dt.Rows.Add("MGW_11A", "2018_Mar", 1);
    dt.Rows.Add("MGW_11A", "2018_Apr", 0);
    dt.Rows.Add("MGW_11A", "2018_May", 1);
    dt.Rows.Add("MGW_11A", "2018_Jun", 2);
    dt.Rows.Add("MGW_11A", "2018_Jul", 2);
    dt.Rows.Add("MGW_11A", "2018_Aug", 2);
    dt.Rows.Add("MGW_11A", "2018_Sep", 0);
    dt.Rows.Add("MGW_11A", "2018_Oct", 0);
    dt.Rows.Add("MGW_11A", "2018_Nov", 0);
    dt.Rows.Add("MGW_11A", "2018_Dec", 0);
    dt.Rows.Add("MGW_11A", "2019_Jan", 0);
    dt.Rows.Add("MGW_11A", "2019_Feb", 0);
    dt.Rows.Add("MGW_11A", "2019_Mar", 1);
    dt.Rows.Add("MGW_11A", "2019_Apr", 1);
    dt.Rows.Add("MGW_11A", "2019_May", 1);
    dt.Rows.Add("MGW_11A", "2019_Jun", 1);
    dt.Rows.Add("MGW_11A", "2019_Sep", 0);
    dt.Rows.Add("MGW_11A", "2019_Oct", 3);
    dt.Rows.Add("MGW_11A", "2019_Nov", 0);
    dt.Rows.Add("MGW_11A", "2019_Dec", 0);
    dt.Rows.Add("MGW_11A", "2020_Jan", 2);
    dt.Rows.Add("MGW_11B", "2015_Jan", 0);
    dt.Rows.Add("MGW_11B", "2015_Feb", 0);
    dt.Rows.Add("MGW_11B", "2015_Mar", 0);
    dt.Rows.Add("MGW_11B", "2015_Apr", 0);
    dt.Rows.Add("MGW_11B", "2015_May", 0);
    dt.Rows.Add("MGW_11B", "2015_Jun", 0);
    dt.Rows.Add("MGW_11B", "2015_Jul", 0);
    dt.Rows.Add("MGW_11B", "2015_Aug", 0);
    dt.Rows.Add("MGW_11B", "2015_Sep", 0);
    dt.Rows.Add("MGW_11B", "2015_Oct", 0);
    dt.Rows.Add("MGW_11B", "2015_Nov", 0);
    dt.Rows.Add("MGW_11B", "2015_Dec", 0);
    dt.Rows.Add("MGW_11B", "2016_Jan", 0);
    dt.Rows.Add("MGW_11B", "2016_Feb", 0);
    dt.Rows.Add("MGW_11B", "2016_Mar", 0);
    dt.Rows.Add("MGW_11B", "2016_Apr", 0);
    dt.Rows.Add("MGW_11B", "2016_May", 0);
    dt.Rows.Add("MGW_11B", "2016_Jun", 0);
    dt.Rows.Add("MGW_11B", "2016_Jul", 0);
    dt.Rows.Add("MGW_11B", "2016_Aug", 1);
    dt.Rows.Add("MGW_11B", "2016_Sep", 0);
    dt.Rows.Add("MGW_11B", "2016_Oct", 0);
    dt.Rows.Add("MGW_11B", "2016_Nov", 1);
    dt.Rows.Add("MGW_11B", "2016_Dec", 0);
    dt.Rows.Add("MGW_11B", "2017_Jan", 0);
    dt.Rows.Add("MGW_11B", "2017_Feb", 0);
    dt.Rows.Add("MGW_11B", "2017_Mar", 0);
    dt.Rows.Add("MGW_11B", "2017_Apr", 1);
    dt.Rows.Add("MGW_11B", "2017_May", 1);
    dt.Rows.Add("MGW_11B", "2017_Jun", 0);
    dt.Rows.Add("MGW_11B", "2017_Jul", 0);
    dt.Rows.Add("MGW_11B", "2017_Aug", 0);
    dt.Rows.Add("MGW_11B", "2017_Sep", 0);
    dt.Rows.Add("MGW_11B", "2017_Oct", 0);
    dt.Rows.Add("MGW_11B", "2017_Nov", 0);
    dt.Rows.Add("MGW_11B", "2017_Dec", 0);
    dt.Rows.Add("MGW_11B", "2018_Jan", 0);
    dt.Rows.Add("MGW_11B", "2018_Feb", 1);
    dt.Rows.Add("MGW_11B", "2018_Mar", 0);
    dt.Rows.Add("MGW_11B", "2018_Apr", 0);
    dt.Rows.Add("MGW_11B", "2018_May", 0);
    dt.Rows.Add("MGW_11B", "2018_Jun", 1);
    dt.Rows.Add("MGW_11B", "2018_Jul", 1);
    dt.Rows.Add("MGW_11B", "2018_Aug", 0);
    dt.Rows.Add("MGW_11B", "2018_Sep", 1);
    dt.Rows.Add("MGW_11B", "2018_Oct", 0);
    dt.Rows.Add("MGW_11B", "2018_Nov", 0);
    dt.Rows.Add("MGW_11B", "2018_Dec", 0);
    dt.Rows.Add("MGW_11B", "2019_Jan", 0);
    dt.Rows.Add("MGW_11B", "2019_Feb", 2);
    dt.Rows.Add("MGW_11B", "2019_Mar", 0);
    dt.Rows.Add("MGW_11B", "2019_Apr", 1);
    dt.Rows.Add("MGW_11B", "2019_May", 1);
    dt.Rows.Add("MGW_11B", "2019_Jun", 0);
    dt.Rows.Add("MGW_11B", "2019_Jul", 0);
    dt.Rows.Add("MGW_11B", "2019_Aug", 2);
    dt.Rows.Add("MGW_11B", "2019_Sep", 0);
    dt.Rows.Add("MGW_11B", "2019_Oct", 1);
    dt.Rows.Add("MGW_11B", "2019_Nov", 2);
    dt.Rows.Add("MGW_11B", "2019_Dec", 1);
    dt.Rows.Add("MGW_11B", "2020_Jan", 0);
    dt.Rows.Add("MGW_12A", "2015_Jan", 0);
    dt.Rows.Add("MGW_12A", "2015_Feb", 0);
    dt.Rows.Add("MGW_12A", "2015_Mar", 0);
    dt.Rows.Add("MGW_12A", "2015_Apr", 0);
    dt.Rows.Add("MGW_12A", "2015_May", 0);
    dt.Rows.Add("MGW_12A", "2015_Jun", 0);
    dt.Rows.Add("MGW_12A", "2015_Jul", 1);
    dt.Rows.Add("MGW_12A", "2015_Aug", 0);
    dt.Rows.Add("MGW_12A", "2015_Sep", 0);
    dt.Rows.Add("MGW_12A", "2015_Oct", 0);
    dt.Rows.Add("MGW_12A", "2015_Nov", 2);
    dt.Rows.Add("MGW_12A", "2015_Dec", 0);
    dt.Rows.Add("MGW_12A", "2016_Jan", 0);
    dt.Rows.Add("MGW_12A", "2016_Feb", 0);
    dt.Rows.Add("MGW_12A", "2016_Mar", 0);
    dt.Rows.Add("MGW_12A", "2016_Apr", 0);
    dt.Rows.Add("MGW_12A", "2016_May", 0);
    dt.Rows.Add("MGW_12A", "2016_Jun", 0);
    dt.Rows.Add("MGW_12A", "2016_Jul", 0);
    dt.Rows.Add("MGW_12A", "2016_Aug", 0);
    dt.Rows.Add("MGW_12A", "2016_Sep", 1);
    dt.Rows.Add("MGW_12A", "2016_Oct", 1);
    dt.Rows.Add("MGW_12A", "2016_Nov", 0);
    dt.Rows.Add("MGW_12A", "2016_Dec", 1);
    dt.Rows.Add("MGW_12A", "2017_Jan", 1);
    dt.Rows.Add("MGW_12A", "2017_Feb", 1);
    dt.Rows.Add("MGW_12A", "2017_Mar", 1);
    dt.Rows.Add("MGW_12A", "2017_Apr", 1);
    dt.Rows.Add("MGW_12A", "2017_May", 1);
    dt.Rows.Add("MGW_12A", "2017_Jun", 0);
    dt.Rows.Add("MGW_12A", "2017_Jul", 2);
    dt.Rows.Add("MGW_12A", "2017_Aug", 1);
    dt.Rows.Add("MGW_12A", "2017_Sep", 0);
    dt.Rows.Add("MGW_12A", "2017_Oct", 2);
    dt.Rows.Add("MGW_12A", "2017_Nov", 1);
    dt.Rows.Add("MGW_12A", "2017_Dec", 0);
    dt.Rows.Add("MGW_12A", "2018_Jan", 0);
    dt.Rows.Add("MGW_12A", "2018_Feb", 1);
    dt.Rows.Add("MGW_12A", "2018_Mar", 2);
    dt.Rows.Add("MGW_12A", "2018_Apr", 1);
    dt.Rows.Add("MGW_12A", "2018_May", 2);
    dt.Rows.Add("MGW_12A", "2018_Jun", 1);
    dt.Rows.Add("MGW_12A", "2018_Jul", 0);
    dt.Rows.Add("MGW_12A", "2018_Aug", 0);
    dt.Rows.Add("MGW_12A", "2018_Sep", 0);
    dt.Rows.Add("MGW_12A", "2018_Oct", 0);
    dt.Rows.Add("MGW_12A", "2018_Nov", 2);
    dt.Rows.Add("MGW_12A", "2018_Dec", 0);
    dt.Rows.Add("MGW_12A", "2019_Jan", 2);
    dt.Rows.Add("MGW_12A", "2019_Feb", 0);
    dt.Rows.Add("MGW_12A", "2019_Mar", 0);
    dt.Rows.Add("MGW_12A", "2019_Apr", 1);
    dt.Rows.Add("MGW_12A", "2019_May", 1);
    dt.Rows.Add("MGW_12A", "2019_Jun", 2);
    dt.Rows.Add("MGW_12A", "2019_Jul", 1);
    dt.Rows.Add("MGW_12A", "2019_Aug", 1);
    dt.Rows.Add("MGW_12A", "2019_Sep", 1);
    dt.Rows.Add("MGW_12A", "2019_Oct", 1);
    dt.Rows.Add("MGW_12A", "2019_Nov", 2);
    dt.Rows.Add("MGW_12A", "2019_Dec", 0);
    dt.Rows.Add("MGW_12A", "2020_Jan", 0);
    dt.Rows.Add("MGW_12B", "2015_Jan", 0);
    dt.Rows.Add("MGW_12B", "2015_Feb", 0);
    dt.Rows.Add("MGW_12B", "2015_Mar", 0);
    dt.Rows.Add("MGW_12B", "2015_Apr", 0);
    dt.Rows.Add("MGW_12B", "2015_May", 0);
    dt.Rows.Add("MGW_12B", "2015_Jun", 0);
    dt.Rows.Add("MGW_12B", "2015_Jul", 2);
    dt.Rows.Add("MGW_12B", "2015_Aug", 1);
    dt.Rows.Add("MGW_12B", "2015_Sep", 1);
    dt.Rows.Add("MGW_12B", "2015_Oct", 0);
    dt.Rows.Add("MGW_12B", "2015_Nov", 0);
    dt.Rows.Add("MGW_12B", "2015_Dec", 1);
    dt.Rows.Add("MGW_12B", "2016_Jan", 1);
    dt.Rows.Add("MGW_12B", "2016_Feb", 0);
    dt.Rows.Add("MGW_12B", "2016_Mar", 3);
    dt.Rows.Add("MGW_12B", "2016_Apr", 0);
    dt.Rows.Add("MGW_12B", "2016_May", 1);
    dt.Rows.Add("MGW_12B", "2016_Jun", 0);
    dt.Rows.Add("MGW_12B", "2016_Jul", 2);
    dt.Rows.Add("MGW_12B", "2016_Aug", 1);
    dt.Rows.Add("MGW_12B", "2016_Sep", 1);
    dt.Rows.Add("MGW_12B", "2016_Oct", 2);
    dt.Rows.Add("MGW_12B", "2016_Nov", 1);
    dt.Rows.Add("MGW_12B", "2016_Dec", 0);
    dt.Rows.Add("MGW_12B", "2017_Jan", 1);
    dt.Rows.Add("MGW_12B", "2017_Feb", 0);
    dt.Rows.Add("MGW_12B", "2017_Mar", 1);
    dt.Rows.Add("MGW_12B", "2017_Apr", 0);
    dt.Rows.Add("MGW_12B", "2017_May", 1);
    dt.Rows.Add("MGW_12B", "2017_Jun", 1);
    dt.Rows.Add("MGW_12B", "2017_Jul", 1);
    dt.Rows.Add("MGW_12B", "2017_Aug", 1);
    dt.Rows.Add("MGW_12B", "2017_Sep", 0);
    dt.Rows.Add("MGW_12B", "2017_Oct", 0);
    dt.Rows.Add("MGW_12B", "2017_Nov", 0);
    dt.Rows.Add("MGW_12B", "2017_Dec", 1);
    dt.Rows.Add("MGW_12B", "2018_Jan", 0);
    dt.Rows.Add("MGW_12B", "2018_Feb", 0);
    dt.Rows.Add("MGW_12B", "2018_Mar", 0);
    dt.Rows.Add("MGW_12B", "2018_Apr", 0);
    dt.Rows.Add("MGW_12B", "2018_May", 0);
    dt.Rows.Add("MGW_12B", "2018_Jun", 1);
    dt.Rows.Add("MGW_12B", "2018_Jul", 1);
    dt.Rows.Add("MGW_12B", "2018_Aug", 0);
    dt.Rows.Add("MGW_12B", "2018_Sep", 1);
    dt.Rows.Add("MGW_12B", "2018_Oct", 0);
    dt.Rows.Add("MGW_12B", "2018_Nov", 0);
    dt.Rows.Add("MGW_12B", "2018_Dec", 0);
    dt.Rows.Add("MGW_12B", "2019_Jan", 1);
    dt.Rows.Add("MGW_12B", "2019_Feb", 0);
    dt.Rows.Add("MGW_12B", "2019_Mar", 0);
    dt.Rows.Add("MGW_12B", "2019_Apr", 0);
    dt.Rows.Add("MGW_12B", "2019_May", 0);
    dt.Rows.Add("MGW_12B", "2019_Jun", 0);
    dt.Rows.Add("MGW_12B", "2019_Jul", 0);
    dt.Rows.Add("MGW_12B", "2019_Aug", 1);
    dt.Rows.Add("MGW_12B", "2019_Sep", 0);
    dt.Rows.Add("MGW_12B", "2019_Oct", 1);
    dt.Rows.Add("MGW_12B", "2019_Nov", 1);
    dt.Rows.Add("MGW_12B", "2019_Dec", 2);
    dt.Rows.Add("MGW_12B", "2020_Jan", 0);
    dt.Rows.Add("MGW_13A", "2015_Jan", 0);
    dt.Rows.Add("MGW_13A", "2015_Feb", 0);
    dt.Rows.Add("MGW_13A", "2015_Mar", 0);
    dt.Rows.Add("MGW_13A", "2015_Apr", 0);
    dt.Rows.Add("MGW_13A", "2015_May", 0);
    dt.Rows.Add("MGW_13A", "2015_Jun", 0);
    dt.Rows.Add("MGW_13A", "2015_Jul", 1);
    dt.Rows.Add("MGW_13A", "2015_Aug", 0);
    dt.Rows.Add("MGW_13A", "2015_Sep", 0);
    dt.Rows.Add("MGW_13A", "2015_Oct", 0);
    dt.Rows.Add("MGW_13A", "2015_Nov", 1);
    dt.Rows.Add("MGW_13A", "2015_Dec", 0);
    dt.Rows.Add("MGW_13A", "2016_Jan", 1);
    dt.Rows.Add("MGW_13A", "2016_Feb", 0);
    dt.Rows.Add("MGW_13A", "2016_Mar", 1);
    dt.Rows.Add("MGW_13A", "2016_Apr", 0);
    dt.Rows.Add("MGW_13A", "2016_May", 1);
    dt.Rows.Add("MGW_13A", "2016_Jun", 0);
    dt.Rows.Add("MGW_13A", "2016_Jul", 0);
    dt.Rows.Add("MGW_13A", "2016_Aug", 0);
    dt.Rows.Add("MGW_13A", "2016_Sep", 0);
    dt.Rows.Add("MGW_13A", "2016_Oct", 0);
    dt.Rows.Add("MGW_13A", "2016_Nov", 1);
    dt.Rows.Add("MGW_13A", "2016_Dec", 0);
    dt.Rows.Add("MGW_13A", "2017_Jan", 0);
    dt.Rows.Add("MGW_13A", "2017_Feb", 0);
    dt.Rows.Add("MGW_13A", "2017_Mar", 1);
    dt.Rows.Add("MGW_13A", "2017_Apr", 1);
    dt.Rows.Add("MGW_13A", "2017_May", 2);
    dt.Rows.Add("MGW_13A", "2017_Jun", 2);
    dt.Rows.Add("MGW_13A", "2017_Jul", 0);
    dt.Rows.Add("MGW_13A", "2017_Aug", 0);
    dt.Rows.Add("MGW_13A", "2017_Sep", 0);
    dt.Rows.Add("MGW_13A", "2017_Oct", 0);
    dt.Rows.Add("MGW_13A", "2017_Nov", 0);
    dt.Rows.Add("MGW_13A", "2017_Dec", 0);
    dt.Rows.Add("MGW_13A", "2018_Jan", 1);
    dt.Rows.Add("MGW_13A", "2018_Feb", 0);
    dt.Rows.Add("MGW_13A", "2018_Mar", 0);
    dt.Rows.Add("MGW_13A", "2018_Apr", 4);
    dt.Rows.Add("MGW_13A", "2018_May", 0);
    dt.Rows.Add("MGW_13A", "2018_Jun", 0);
    dt.Rows.Add("MGW_13A", "2018_Jul", 3);
    dt.Rows.Add("MGW_13A", "2018_Aug", 0);
    dt.Rows.Add("MGW_13A", "2018_Sep", 1);
    dt.Rows.Add("MGW_13A", "2018_Oct", 2);
    dt.Rows.Add("MGW_13A", "2018_Nov", 2);
    dt.Rows.Add("MGW_13A", "2018_Dec", 1);
    dt.Rows.Add("MGW_13A", "2019_Jan", 1);
    dt.Rows.Add("MGW_13A", "2019_Feb", 1);
    dt.Rows.Add("MGW_13A", "2019_Mar", 0);
    dt.Rows.Add("MGW_13A", "2019_Apr", 2);
    dt.Rows.Add("MGW_13A", "2019_May", 0);
    dt.Rows.Add("MGW_13A", "2019_Jun", 1);
    dt.Rows.Add("MGW_13A", "2019_Jul", 1);
    dt.Rows.Add("MGW_13A", "2019_Aug", 2);
    dt.Rows.Add("MGW_13A", "2019_Sep", 1);
    dt.Rows.Add("MGW_13A", "2019_Oct", 1);
    dt.Rows.Add("MGW_13A", "2019_Nov", 0);
    dt.Rows.Add("MGW_13A", "2019_Dec", 0);
    dt.Rows.Add("MGW_13A", "2020_Jan", 1);
    dt.Rows.Add("MGW_13B", "2020_Jan", 0);
    dt.Rows.Add("MGW_14B", "2019_Jan", 0);
    dt.Rows.Add("MGW_14B", "2019_Feb", 0);
    dt.Rows.Add("MGW_14B", "2019_Mar", 0);
    dt.Rows.Add("MGW_14B", "2019_Apr", 2);
    dt.Rows.Add("MGW_14B", "2019_May", 1);
    dt.Rows.Add("MGW_14B", "2019_Jun", 0);
    dt.Rows.Add("MGW_14B", "2019_Jul", 0);
    dt.Rows.Add("MGW_14B", "2019_Aug", 0);
    dt.Rows.Add("MGW_14B", "2019_Sep", 1);
    dt.Rows.Add("MGW_14B", "2019_Oct", 0);
    dt.Rows.Add("MGW_14B", "2019_Nov", 1);
    dt.Rows.Add("MGW_14B", "2019_Dec", 0);
    dt.Rows.Add("MGW_14B", "2020_Jan", 0);
    dt.Rows.Add("MGW_2C", "2015_Jan", 0);
    dt.Rows.Add("MGW_2C", "2015_Feb", 0);
    dt.Rows.Add("MGW_2C", "2015_Mar", 0);
    dt.Rows.Add("MGW_2C", "2015_Apr", 0);
    dt.Rows.Add("MGW_2C", "2015_May", 0);
    dt.Rows.Add("MGW_2C", "2015_Jun", 0);
    dt.Rows.Add("MGW_2C", "2015_Jul", 0);
    dt.Rows.Add("MGW_2C", "2015_Aug", 1);
    dt.Rows.Add("MGW_2C", "2015_Sep", 1);
    dt.Rows.Add("MGW_2C", "2015_Oct", 1);
    dt.Rows.Add("MGW_2C", "2015_Nov", 1);
    dt.Rows.Add("MGW_2C", "2015_Dec", 0);
    dt.Rows.Add("MGW_2C", "2016_Jan", 0);
    dt.Rows.Add("MGW_2C", "2016_Feb", 2);
    dt.Rows.Add("MGW_2C", "2016_Mar", 0);
    dt.Rows.Add("MGW_2C", "2016_Apr", 0);
    dt.Rows.Add("MGW_2C", "2016_May", 1);
    dt.Rows.Add("MGW_2C", "2016_Jun", 0);
    dt.Rows.Add("MGW_2C", "2016_Jul", 0);
    dt.Rows.Add("MGW_2C", "2016_Aug", 1);
    dt.Rows.Add("MGW_2C", "2016_Sep", 1);
    dt.Rows.Add("MGW_2C", "2016_Oct", 3);
    dt.Rows.Add("MGW_2C", "2016_Nov", 1);
    dt.Rows.Add("MGW_2C", "2016_Dec", 0);
    dt.Rows.Add("MGW_2C", "2017_Jan", 0);
    dt.Rows.Add("MGW_2C", "2017_Feb", 0);
    dt.Rows.Add("MGW_2C", "2017_Mar", 0);
    dt.Rows.Add("MGW_2C", "2017_Apr", 0);
    dt.Rows.Add("MGW_2C", "2017_May", 1);
    dt.Rows.Add("MGW_2C", "2017_Jun", 0);
    dt.Rows.Add("MGW_2C", "2017_Jul", 1);
    dt.Rows.Add("MGW_2C", "2017_Aug", 2);
    dt.Rows.Add("MGW_2C", "2017_Sep", 2);
    dt.Rows.Add("MGW_2C", "2017_Oct", 0);
    dt.Rows.Add("MGW_2C", "2017_Nov", 2);
    dt.Rows.Add("MGW_2C", "2017_Dec", 1);
    dt.Rows.Add("MGW_2C", "2018_Jan", 1);
    dt.Rows.Add("MGW_2C", "2018_Feb", 0);
    dt.Rows.Add("MGW_2C", "2018_Mar", 3);
    dt.Rows.Add("MGW_2C", "2018_Apr", 3);
    dt.Rows.Add("MGW_2C", "2018_May", 1);
    dt.Rows.Add("MGW_2C", "2018_Jun", 0);
    dt.Rows.Add("MGW_2C", "2018_Jul", 1);
    dt.Rows.Add("MGW_2C", "2018_Aug", 1);
    dt.Rows.Add("MGW_2C", "2018_Sep", 0);
    dt.Rows.Add("MGW_2C", "2018_Oct", 1);
    dt.Rows.Add("MGW_2C", "2018_Nov", 0);
    dt.Rows.Add("MGW_2C", "2018_Dec", 0);
    dt.Rows.Add("MGW_2C", "2019_Jan", 0);
    dt.Rows.Add("MGW_2C", "2019_Feb", 0);
    dt.Rows.Add("MGW_2C", "2019_Mar", 0);
    dt.Rows.Add("MGW_2C", "2019_Apr", 1);
    dt.Rows.Add("MGW_2C", "2019_May", 0);
    dt.Rows.Add("MGW_2C", "2019_Jun", 0);
    dt.Rows.Add("MGW_2C", "2019_Jul", 0);
    dt.Rows.Add("MGW_2C", "2019_Aug", 1);
    dt.Rows.Add("MGW_2C", "2019_Sep", 1);
    dt.Rows.Add("MGW_2C", "2019_Oct", 0);
    dt.Rows.Add("MGW_2C", "2019_Nov", 0);
    dt.Rows.Add("MGW_2C", "2019_Dec", 2);
    dt.Rows.Add("MGW_2C", "2020_Jan", 1);
    dt.Rows.Add("MGW_2D", "2015_Jan", 0);
    dt.Rows.Add("MGW_2D", "2015_Feb", 0);
    dt.Rows.Add("MGW_2D", "2015_Mar", 0);
    dt.Rows.Add("MGW_2D", "2015_Apr", 0);
    dt.Rows.Add("MGW_2D", "2015_May", 0);
    dt.Rows.Add("MGW_2D", "2015_Jun", 0);
    dt.Rows.Add("MGW_2D", "2015_Jul", 0);
    dt.Rows.Add("MGW_2D", "2015_Aug", 1);
    dt.Rows.Add("MGW_2D", "2015_Sep", 2);
    dt.Rows.Add("MGW_2D", "2015_Oct", 1);
    dt.Rows.Add("MGW_2D", "2015_Nov", 0);
    dt.Rows.Add("MGW_2D", "2015_Dec", 0);
    dt.Rows.Add("MGW_2D", "2016_Jan", 0);
    dt.Rows.Add("MGW_2D", "2016_Feb", 2);
    dt.Rows.Add("MGW_2D", "2016_Mar", 0);
    dt.Rows.Add("MGW_2D", "2016_Apr", 0);
    dt.Rows.Add("MGW_2D", "2016_May", 0);
    dt.Rows.Add("MGW_2D", "2016_Jun", 1);
    dt.Rows.Add("MGW_2D", "2016_Jul", 0);
    dt.Rows.Add("MGW_2D", "2016_Aug", 2);
    dt.Rows.Add("MGW_2D", "2016_Sep", 0);
    dt.Rows.Add("MGW_2D", "2016_Oct", 0);
    dt.Rows.Add("MGW_2D", "2016_Nov", 2);
    dt.Rows.Add("MGW_2D", "2016_Dec", 0);
    dt.Rows.Add("MGW_2D", "2017_Jan", 2);
    dt.Rows.Add("MGW_2D", "2017_Feb", 1);
    dt.Rows.Add("MGW_2D", "2017_Mar", 0);
    dt.Rows.Add("MGW_2D", "2017_Apr", 1);
    dt.Rows.Add("MGW_2D", "2017_May", 3);
    dt.Rows.Add("MGW_2D", "2017_Jun", 0);
    dt.Rows.Add("MGW_2D", "2017_Jul", 0);
    dt.Rows.Add("MGW_2D", "2017_Aug", 0);
    dt.Rows.Add("MGW_2D", "2017_Sep", 0);
    dt.Rows.Add("MGW_2D", "2017_Oct", 1);
    dt.Rows.Add("MGW_2D", "2017_Nov", 1);
    dt.Rows.Add("MGW_2D", "2017_Dec", 0);
    dt.Rows.Add("MGW_2D", "2018_Jan", 2);
    dt.Rows.Add("MGW_2D", "2018_Feb", 1);
    dt.Rows.Add("MGW_2D", "2018_Mar", 2);
    dt.Rows.Add("MGW_2D", "2018_Apr", 0);
    dt.Rows.Add("MGW_2D", "2018_May", 2);
    dt.Rows.Add("MGW_2D", "2018_Jun", 2);
    dt.Rows.Add("MGW_2D", "2018_Jul", 2);
    dt.Rows.Add("MGW_2D", "2018_Aug", 1);
    dt.Rows.Add("MGW_2D", "2018_Sep", 2);
    dt.Rows.Add("MGW_2D", "2018_Oct", 1);
    dt.Rows.Add("MGW_2D", "2018_Nov", 1);
    dt.Rows.Add("MGW_2D", "2018_Dec", 0);
    dt.Rows.Add("MGW_2D", "2019_Jan", 2);
    dt.Rows.Add("MGW_2D", "2019_Feb", 0);
    dt.Rows.Add("MGW_2D", "2019_Mar", 0);
    dt.Rows.Add("MGW_2D", "2019_Apr", 2);
    dt.Rows.Add("MGW_2D", "2019_May", 0);
    dt.Rows.Add("MGW_2D", "2019_Jun", 0);
    dt.Rows.Add("MGW_2D", "2019_Jul", 1);
    dt.Rows.Add("MGW_2D", "2019_Aug", 1);
    dt.Rows.Add("MGW_2D", "2019_Sep", 1);
    dt.Rows.Add("MGW_2D", "2019_Oct", 0);
    dt.Rows.Add("MGW_2D", "2019_Nov", 0);
    dt.Rows.Add("MGW_2D", "2019_Dec", 1);
    dt.Rows.Add("MGW_2D", "2020_Jan", 1);
    dt.Rows.Add("MGW_5AM", "2020_Jan", 0);
    dt.Rows.Add("MGW_5B", "2015_Jan", 0);
    dt.Rows.Add("MGW_5B", "2015_Feb", 0);
    dt.Rows.Add("MGW_5B", "2015_Mar", 0);
    dt.Rows.Add("MGW_5B", "2015_Apr", 0);
    dt.Rows.Add("MGW_5B", "2015_May", 0);
    dt.Rows.Add("MGW_5B", "2015_Jun", 0);
    dt.Rows.Add("MGW_5B", "2015_Jul", 0);
    dt.Rows.Add("MGW_5B", "2015_Aug", 2);
    dt.Rows.Add("MGW_5B", "2015_Sep", 0);
    dt.Rows.Add("MGW_5B", "2015_Oct", 0);
    dt.Rows.Add("MGW_5B", "2015_Nov", 0);
    dt.Rows.Add("MGW_5B", "2015_Dec", 2);
    dt.Rows.Add("MGW_5B", "2016_Jan", 0);
    dt.Rows.Add("MGW_5B", "2016_Feb", 0);
    dt.Rows.Add("MGW_5B", "2016_Mar", 1);
    dt.Rows.Add("MGW_5B", "2016_Apr", 0);
    dt.Rows.Add("MGW_5B", "2016_May", 0);
    dt.Rows.Add("MGW_5B", "2016_Jun", 0);
    dt.Rows.Add("MGW_5B", "2016_Jul", 0);
    dt.Rows.Add("MGW_5B", "2016_Aug", 1);
    dt.Rows.Add("MGW_5B", "2016_Sep", 2);
    dt.Rows.Add("MGW_5B", "2016_Oct", 0);
    dt.Rows.Add("MGW_5B", "2016_Nov", 0);
    dt.Rows.Add("MGW_5B", "2016_Dec", 0);
    dt.Rows.Add("MGW_5B", "2017_Jan", 0);
    dt.Rows.Add("MGW_5B", "2017_Feb", 0);
    dt.Rows.Add("MGW_5B", "2017_Mar", 0);
    dt.Rows.Add("MGW_5B", "2017_Apr", 0);
    dt.Rows.Add("MGW_5B", "2017_May", 0);
    dt.Rows.Add("MGW_5B", "2017_Jun", 0);
    dt.Rows.Add("MGW_5B", "2017_Jul", 1);
    dt.Rows.Add("MGW_5B", "2017_Aug", 0);
    dt.Rows.Add("MGW_5B", "2017_Sep", 1);
    dt.Rows.Add("MGW_5B", "2017_Oct", 1);
    dt.Rows.Add("MGW_5B", "2017_Nov", 0);
    dt.Rows.Add("MGW_5B", "2017_Dec", 3);
    dt.Rows.Add("MGW_5B", "2018_Jan", 1);
    dt.Rows.Add("MGW_5B", "2018_Feb", 2);
    dt.Rows.Add("MGW_5B", "2018_Mar", 1);
    dt.Rows.Add("MGW_5B", "2018_Apr", 0);
    dt.Rows.Add("MGW_5B", "2018_May", 0);
    dt.Rows.Add("MGW_5B", "2018_Jun", 0);
    dt.Rows.Add("MGW_5B", "2018_Jul", 0);
    dt.Rows.Add("MGW_5B", "2018_Aug", 2);
    dt.Rows.Add("MGW_5B", "2018_Sep", 0);
    dt.Rows.Add("MGW_5B", "2018_Oct", 0);
    dt.Rows.Add("MGW_5B", "2018_Nov", 0);
    dt.Rows.Add("MGW_5B", "2018_Dec", 1);
    dt.Rows.Add("MGW_5B", "2019_Jan", 1);
    dt.Rows.Add("MGW_5B", "2019_Feb", 0);
    dt.Rows.Add("MGW_5B", "2019_Mar", 1);
    dt.Rows.Add("MGW_5B", "2019_Apr", 0);
    dt.Rows.Add("MGW_5B", "2019_May", 2);
    dt.Rows.Add("MGW_5B", "2019_Jun", 0);
    dt.Rows.Add("MGW_5B", "2019_Jul", 1);
    dt.Rows.Add("MGW_5B", "2019_Aug", 1);
    dt.Rows.Add("MGW_5B", "2019_Sep", 0);
    dt.Rows.Add("MGW_5B", "2019_Oct", 0);
    dt.Rows.Add("MGW_5B", "2019_Nov", 1);
    dt.Rows.Add("MGW_5B", "2019_Dec", 0);
    dt.Rows.Add("MGW_5B", "2020_Jan", 4);
    dt.Rows.Add("MGW_5D", "2015_Jan", 0);
    dt.Rows.Add("MGW_5D", "2015_Feb", 0);
    dt.Rows.Add("MGW_5D", "2015_Mar", 0);
    dt.Rows.Add("MGW_5D", "2015_Apr", 0);
    dt.Rows.Add("MGW_5D", "2015_May", 0);
    dt.Rows.Add("MGW_5D", "2015_Jun", 0);
    dt.Rows.Add("MGW_5D", "2015_Jul", 0);
    dt.Rows.Add("MGW_5D", "2015_Aug", 0);
    dt.Rows.Add("MGW_5D", "2015_Sep", 0);
    dt.Rows.Add("MGW_5D", "2015_Oct", 0);
    dt.Rows.Add("MGW_5D", "2015_Nov", 0);
    dt.Rows.Add("MGW_5D", "2015_Dec", 0);
    dt.Rows.Add("MGW_5D", "2016_Jan", 0);
    dt.Rows.Add("MGW_5D", "2016_Feb", 0);
    dt.Rows.Add("MGW_5D", "2016_Mar", 0);
    dt.Rows.Add("MGW_5D", "2016_Apr", 0);
    dt.Rows.Add("MGW_5D", "2016_May", 0);
    dt.Rows.Add("MGW_5D", "2016_Jun", 0);
    dt.Rows.Add("MGW_5D", "2016_Jul", 0);
    dt.Rows.Add("MGW_5D", "2016_Aug", 0);
    dt.Rows.Add("MGW_5D", "2016_Sep", 0);
    dt.Rows.Add("MGW_5D", "2016_Oct", 0);
    dt.Rows.Add("MGW_5D", "2016_Nov", 2);
    dt.Rows.Add("MGW_5D", "2016_Dec", 0);
    dt.Rows.Add("MGW_5D", "2017_Jan", 0);
    dt.Rows.Add("MGW_5D", "2017_Feb", 1);
    dt.Rows.Add("MGW_5D", "2017_Mar", 0);
    dt.Rows.Add("MGW_5D", "2017_Apr", 0);
    dt.Rows.Add("MGW_5D", "2017_May", 1);
    dt.Rows.Add("MGW_5D", "2017_Jun", 4);
    dt.Rows.Add("MGW_5D", "2017_Jul", 0);
    dt.Rows.Add("MGW_5D", "2017_Aug", 0);
    dt.Rows.Add("MGW_5D", "2017_Sep", 2);
    dt.Rows.Add("MGW_5D", "2017_Oct", 0);
    dt.Rows.Add("MGW_5D", "2017_Nov", 0);
    dt.Rows.Add("MGW_5D", "2017_Dec", 2);
    dt.Rows.Add("MGW_5D", "2018_Jan", 1);
    dt.Rows.Add("MGW_5D", "2018_Feb", 1);
    dt.Rows.Add("MGW_5D", "2018_Mar", 0);
    dt.Rows.Add("MGW_5D", "2018_Apr", 1);
    dt.Rows.Add("MGW_5D", "2018_May", 0);
    dt.Rows.Add("MGW_5D", "2018_Jun", 1);
    dt.Rows.Add("MGW_5D", "2018_Jul", 0);
    dt.Rows.Add("MGW_5D", "2018_Aug", 2);
    dt.Rows.Add("MGW_5D", "2018_Sep", 0);
    dt.Rows.Add("MGW_5D", "2018_Oct", 1);
    dt.Rows.Add("MGW_5D", "2018_Nov", 0);
    dt.Rows.Add("MGW_5D", "2018_Dec", 0);
    dt.Rows.Add("MGW_5D", "2019_Jan", 0);
    dt.Rows.Add("MGW_5D", "2019_Feb", 0);
    dt.Rows.Add("MGW_5D", "2019_Mar", 0);
    dt.Rows.Add("MGW_5D", "2019_Apr", 0);
    dt.Rows.Add("MGW_5D", "2019_May", 0);
    dt.Rows.Add("MGW_5D", "2019_Jun", 0);
    dt.Rows.Add("MGW_5D", "2019_Jul", 1);
    dt.Rows.Add("MGW_5D", "2019_Aug", 0);
    dt.Rows.Add("MGW_5D", "2019_Sep", 1);
    dt.Rows.Add("MGW_5D", "2019_Oct", 1);
    dt.Rows.Add("MGW_5D", "2019_Nov", 1);
    dt.Rows.Add("MGW_5D", "2019_Dec", 1);
    dt.Rows.Add("MGW_5D", "2020_Jan", 0);
    dt.Rows.Add("MGW_6A", "2015_Jan", 0);
    dt.Rows.Add("MGW_6A", "2015_Feb", 0);
    dt.Rows.Add("MGW_6A", "2015_Mar", 0);
    dt.Rows.Add("MGW_6A", "2015_Apr", 0);
    dt.Rows.Add("MGW_6A", "2015_May", 0);
    dt.Rows.Add("MGW_6A", "2015_Jun", 0);
    dt.Rows.Add("MGW_6A", "2015_Jul", 0);
    dt.Rows.Add("MGW_6A", "2015_Aug", 2);
    dt.Rows.Add("MGW_6A", "2015_Sep", 1);
    dt.Rows.Add("MGW_6A", "2015_Oct", 0);
    dt.Rows.Add("MGW_6A", "2015_Nov", 0);
    dt.Rows.Add("MGW_6A", "2015_Dec", 0);
    dt.Rows.Add("MGW_6A", "2016_Jan", 2);
    dt.Rows.Add("MGW_6A", "2016_Feb", 0);
    dt.Rows.Add("MGW_6A", "2016_Mar", 2);
    dt.Rows.Add("MGW_6A", "2016_Apr", 0);
    dt.Rows.Add("MGW_6A", "2016_May", 1);
    dt.Rows.Add("MGW_6A", "2016_Jun", 2);
    dt.Rows.Add("MGW_6A", "2016_Jul", 0);
    dt.Rows.Add("MGW_6A", "2016_Aug", 2);
    dt.Rows.Add("MGW_6A", "2016_Sep", 2);
    dt.Rows.Add("MGW_6A", "2016_Oct", 1);
    dt.Rows.Add("MGW_6A", "2016_Nov", 1);
    dt.Rows.Add("MGW_6A", "2016_Dec", 2);
    dt.Rows.Add("MGW_6A", "2017_Jan", 3);
    dt.Rows.Add("MGW_6A", "2017_Feb", 1);
    dt.Rows.Add("MGW_6A", "2017_Mar", 1);
    dt.Rows.Add("MGW_6A", "2017_Apr", 2);
    dt.Rows.Add("MGW_6A", "2017_May", 1);
    dt.Rows.Add("MGW_6A", "2017_Jun", 0);
    dt.Rows.Add("MGW_6A", "2017_Jul", 0);
    dt.Rows.Add("MGW_6A", "2017_Aug", 1);
    dt.Rows.Add("MGW_6A", "2017_Sep", 0);
    dt.Rows.Add("MGW_6A", "2017_Oct", 0);
    dt.Rows.Add("MGW_6A", "2017_Nov", 0);
    dt.Rows.Add("MGW_6A", "2017_Dec", 0);
    dt.Rows.Add("MGW_6A", "2018_Jan", 0);
    dt.Rows.Add("MGW_6A", "2018_Feb", 0);
    dt.Rows.Add("MGW_6A", "2018_Mar", 0);
    dt.Rows.Add("MGW_6A", "2018_Apr", 0);
    dt.Rows.Add("MGW_6A", "2018_May", 1);
    dt.Rows.Add("MGW_6A", "2018_Jun", 0);
    dt.Rows.Add("MGW_6A", "2018_Jul", 1);
    dt.Rows.Add("MGW_6A", "2018_Aug", 1);
    dt.Rows.Add("MGW_6A", "2018_Sep", 0);
    dt.Rows.Add("MGW_6A", "2018_Oct", 0);
    dt.Rows.Add("MGW_6A", "2018_Nov", 1);
    dt.Rows.Add("MGW_6A", "2018_Dec", 0);
    dt.Rows.Add("MGW_6A", "2019_Jan", 0);
    dt.Rows.Add("MGW_6A", "2019_Feb", 1);
    dt.Rows.Add("MGW_6A", "2019_Mar", 0);
    dt.Rows.Add("MGW_6A", "2019_Apr", 1);
    dt.Rows.Add("MGW_6A", "2019_May", 0);
    dt.Rows.Add("MGW_6A", "2019_Jun", 0);
    dt.Rows.Add("MGW_6A", "2019_Jul", 0);
    dt.Rows.Add("MGW_6A", "2019_Aug", 0);
    dt.Rows.Add("MGW_6A", "2019_Sep", 0);
    dt.Rows.Add("MGW_6A", "2019_Oct", 1);
    dt.Rows.Add("MGW_6A", "2019_Nov", 0);
    dt.Rows.Add("MGW_6A", "2019_Dec", 0);
    dt.Rows.Add("MGW_6A", "2020_Jan", 1);
    dt.Rows.Add("MGW_6B", "2015_Jan", 0);
    dt.Rows.Add("MGW_6B", "2015_Feb", 0);
    dt.Rows.Add("MGW_6B", "2015_Mar", 0);
    dt.Rows.Add("MGW_6B", "2015_Apr", 0);
    dt.Rows.Add("MGW_6B", "2015_May", 0);
    dt.Rows.Add("MGW_6B", "2015_Jun", 0);
    dt.Rows.Add("MGW_6B", "2015_Jul", 2);
    dt.Rows.Add("MGW_6B", "2015_Aug", 2);
    dt.Rows.Add("MGW_6B", "2015_Sep", 2);
    dt.Rows.Add("MGW_6B", "2015_Oct", 1);
    dt.Rows.Add("MGW_6B", "2015_Nov", 0);
    dt.Rows.Add("MGW_6B", "2015_Dec", 0);
    dt.Rows.Add("MGW_6B", "2016_Jan", 0);
    dt.Rows.Add("MGW_6B", "2016_Feb", 0);
    dt.Rows.Add("MGW_6B", "2016_Mar", 0);
    dt.Rows.Add("MGW_6B", "2016_Apr", 0);
    dt.Rows.Add("MGW_6B", "2016_May", 0);
    dt.Rows.Add("MGW_6B", "2016_Jun", 2);
    dt.Rows.Add("MGW_6B", "2016_Jul", 0);
    dt.Rows.Add("MGW_6B", "2016_Aug", 1);
    dt.Rows.Add("MGW_6B", "2016_Sep", 2);
    dt.Rows.Add("MGW_6B", "2016_Oct", 1);
    dt.Rows.Add("MGW_6B", "2016_Nov", 1);
    dt.Rows.Add("MGW_6B", "2016_Dec", 3);
    dt.Rows.Add("MGW_6B", "2017_Jan", 0);
    dt.Rows.Add("MGW_6B", "2017_Feb", 1);
    dt.Rows.Add("MGW_6B", "2017_Mar", 1);
    dt.Rows.Add("MGW_6B", "2017_Apr", 1);
    dt.Rows.Add("MGW_6B", "2017_May", 0);
    dt.Rows.Add("MGW_6B", "2017_Jun", 3);
    dt.Rows.Add("MGW_6B", "2017_Jul", 1);
    dt.Rows.Add("MGW_6B", "2017_Aug", 2);
    dt.Rows.Add("MGW_6B", "2017_Sep", 0);
    dt.Rows.Add("MGW_6B", "2017_Oct", 1);
    dt.Rows.Add("MGW_6B", "2017_Nov", 1);
    dt.Rows.Add("MGW_6B", "2017_Dec", 0);
    dt.Rows.Add("MGW_6B", "2018_Jan", 1);
    dt.Rows.Add("MGW_6B", "2018_Feb", 0);
    dt.Rows.Add("MGW_6B", "2018_Mar", 0);
    dt.Rows.Add("MGW_6B", "2018_Apr", 2);
    dt.Rows.Add("MGW_6B", "2018_May", 3);
    dt.Rows.Add("MGW_6B", "2018_Jun", 2);
    dt.Rows.Add("MGW_6B", "2018_Jul", 1);
    dt.Rows.Add("MGW_6B", "2018_Aug", 4);
    dt.Rows.Add("MGW_6B", "2018_Sep", 1);
    dt.Rows.Add("MGW_6B", "2018_Oct", 1);
    dt.Rows.Add("MGW_6B", "2018_Nov", 3);
    dt.Rows.Add("MGW_6B", "2018_Dec", 1);
    dt.Rows.Add("MGW_6B", "2019_Jan", 2);
    dt.Rows.Add("MGW_6B", "2019_Feb", 1);
    dt.Rows.Add("MGW_6B", "2019_Mar", 0);
    dt.Rows.Add("MGW_6B", "2019_Apr", 4);
    dt.Rows.Add("MGW_6B", "2019_May", 1);
    dt.Rows.Add("MGW_6B", "2019_Jun", 0);
    dt.Rows.Add("MGW_6B", "2019_Jul", 1);
    dt.Rows.Add("MGW_6B", "2019_Aug", 3);
    dt.Rows.Add("MGW_6B", "2019_Sep", 3);
    dt.Rows.Add("MGW_6B", "2019_Oct", 4);
    dt.Rows.Add("MGW_6B", "2019_Nov", 2);
    dt.Rows.Add("MGW_6B", "2019_Dec", 2);
    dt.Rows.Add("MGW_6B", "2020_Jan", 0);
    dt.Rows.Add("MGW_9B", "2015_Jan", 0);
    dt.Rows.Add("MGW_9B", "2015_Feb", 0);
    dt.Rows.Add("MGW_9B", "2015_Mar", 0);
    dt.Rows.Add("MGW_9B", "2015_Apr", 0);
    dt.Rows.Add("MGW_9B", "2015_May", 0);
    dt.Rows.Add("MGW_9B", "2015_Jun", 0);
    dt.Rows.Add("MGW_9B", "2015_Jul", 2);
    dt.Rows.Add("MGW_9B", "2015_Aug", 2);
    dt.Rows.Add("MGW_9B", "2015_Sep", 2);
    dt.Rows.Add("MGW_9B", "2015_Oct", 3);
    dt.Rows.Add("MGW_9B", "2015_Nov", 1);
    dt.Rows.Add("MGW_9B", "2015_Dec", 2);
    dt.Rows.Add("MGW_9B", "2016_Jan", 1);
    dt.Rows.Add("MGW_9B", "2016_Feb", 2);
    dt.Rows.Add("MGW_9B", "2016_Mar", 0);
    dt.Rows.Add("MGW_9B", "2016_Apr", 3);
    dt.Rows.Add("MGW_9B", "2016_May", 3);
    dt.Rows.Add("MGW_9B", "2016_Jun", 1);
    dt.Rows.Add("MGW_9B", "2016_Jul", 1);
    dt.Rows.Add("MGW_9B", "2016_Aug", 2);
    dt.Rows.Add("MGW_9B", "2016_Sep", 0);
    dt.Rows.Add("MGW_9B", "2016_Oct", 1);
    dt.Rows.Add("MGW_9B", "2016_Nov", 2);
    dt.Rows.Add("MGW_9B", "2016_Dec", 1);
    dt.Rows.Add("MGW_9B", "2017_Jan", 1);
    dt.Rows.Add("MGW_9B", "2017_Feb", 0);
    dt.Rows.Add("MGW_9B", "2017_Mar", 2);
    dt.Rows.Add("MGW_9B", "2017_Apr", 3);
    dt.Rows.Add("MGW_9B", "2017_May", 3);
    dt.Rows.Add("MGW_9B", "2017_Jun", 0);
    dt.Rows.Add("MGW_9B", "2017_Jul", 2);
    dt.Rows.Add("MGW_9B", "2017_Aug", 1);
    dt.Rows.Add("MGW_9B", "2017_Sep", 0);
    dt.Rows.Add("MGW_9B", "2017_Oct", 0);
    dt.Rows.Add("MGW_9B", "2017_Nov", 0);
    dt.Rows.Add("MGW_9B", "2017_Dec", 0);
    dt.Rows.Add("MGW_9B", "2018_Jan", 2);
    dt.Rows.Add("MGW_9B", "2018_Feb", 0);
    dt.Rows.Add("MGW_9B", "2018_Mar", 1);
    dt.Rows.Add("MGW_9B", "2018_Apr", 2);
    dt.Rows.Add("MGW_9B", "2018_May", 1);
    dt.Rows.Add("MGW_9B", "2018_Jun", 1);
    dt.Rows.Add("MGW_9B", "2018_Jul", 0);
    dt.Rows.Add("MGW_9B", "2018_Aug", 2);
    dt.Rows.Add("MGW_9B", "2018_Sep", 1);
    dt.Rows.Add("MGW_9B", "2018_Oct", 2);
    dt.Rows.Add("MGW_9B", "2018_Nov", 4);
    dt.Rows.Add("MGW_9B", "2018_Dec", 4);
    dt.Rows.Add("MGW_9B", "2019_Jan", 1);
    dt.Rows.Add("MGW_9B", "2019_Feb", 2);
    dt.Rows.Add("MGW_9B", "2019_Mar", 2);
    dt.Rows.Add("MGW_9B", "2019_Apr", 1);
    dt.Rows.Add("MGW_9B", "2019_May", 4);
    dt.Rows.Add("MGW_9B", "2019_Jun", 2);
    dt.Rows.Add("MGW_9B", "2019_Jul", 2);
    dt.Rows.Add("MGW_9B", "2019_Aug", 1);
    dt.Rows.Add("MGW_9B", "2019_Sep", 1);
    dt.Rows.Add("MGW_9B", "2019_Oct", 0);
    dt.Rows.Add("MGW_9B", "2019_Nov", 1);
    dt.Rows.Add("MGW_9B", "2019_Dec", 1);
    dt.Rows.Add("MGW_9B", "2020_Jan", 2);
    dt.Rows.Add("MGW_CCU", "2015_Jan", 0);
    dt.Rows.Add("MGW_CCU", "2015_Feb", 0);
    dt.Rows.Add("MGW_CCU", "2015_Mar", 0);
    dt.Rows.Add("MGW_CCU", "2015_Apr", 0);
    dt.Rows.Add("MGW_CCU", "2015_May", 0);
    dt.Rows.Add("MGW_CCU", "2015_Jun", 0);
    dt.Rows.Add("MGW_CCU", "2015_Jul", 0);
    dt.Rows.Add("MGW_CCU", "2015_Aug", 0);
    dt.Rows.Add("MGW_CCU", "2015_Sep", 0);
    dt.Rows.Add("MGW_CCU", "2015_Oct", 0);
    dt.Rows.Add("MGW_CCU", "2015_Nov", 0);
    dt.Rows.Add("MGW_CCU", "2015_Dec", 0);
    dt.Rows.Add("MGW_CCU", "2016_Jan", 0);
    dt.Rows.Add("MGW_CCU", "2016_Feb", 0);
    dt.Rows.Add("MGW_CCU", "2016_Mar", 0);
    dt.Rows.Add("MGW_CCU", "2016_Apr", 0);
    dt.Rows.Add("MGW_CCU", "2016_May", 0);
    dt.Rows.Add("MGW_CCU", "2016_Jun", 0);
    dt.Rows.Add("MGW_CCU", "2016_Jul", 0);
    dt.Rows.Add("MGW_CCU", "2016_Aug", 0);
    dt.Rows.Add("MGW_CCU", "2016_Sep", 0);
    dt.Rows.Add("MGW_CCU", "2016_Oct", 0);
    dt.Rows.Add("MGW_CCU", "2016_Nov", 0);
    dt.Rows.Add("MGW_CCU", "2016_Dec", 0);
    dt.Rows.Add("MGW_CCU", "2017_Jan", 0);
    dt.Rows.Add("MGW_CCU", "2017_Feb", 0);
    dt.Rows.Add("MGW_CCU", "2017_Mar", 0);
    dt.Rows.Add("MGW_CCU", "2017_Apr", 0);
    dt.Rows.Add("MGW_CCU", "2017_May", 0);
    dt.Rows.Add("MGW_CCU", "2017_Jun", 0);
    dt.Rows.Add("MGW_CCU", "2017_Jul", 0);
    dt.Rows.Add("MGW_CCU", "2017_Aug", 0);
    dt.Rows.Add("MGW_CCU", "2017_Sep", 0);
    dt.Rows.Add("MGW_CCU", "2017_Oct", 0);
    dt.Rows.Add("MGW_CCU", "2017_Nov", 0);
    dt.Rows.Add("MGW_CCU", "2017_Dec", 0);
    dt.Rows.Add("MGW_CCU", "2018_Jan", 0);
    dt.Rows.Add("MGW_CCU", "2018_Feb", 0);
    dt.Rows.Add("MGW_CCU", "2018_Mar", 0);
    dt.Rows.Add("MGW_CCU", "2018_Apr", 0);
    dt.Rows.Add("MGW_CCU", "2018_May", 0);
    dt.Rows.Add("MGW_CCU", "2018_Jun", 0);
    dt.Rows.Add("MGW_CCU", "2018_Jul", 0);
    dt.Rows.Add("MGW_CCU", "2018_Aug", 0);
    dt.Rows.Add("MGW_CCU", "2018_Sep", 0);
    dt.Rows.Add("MGW_CCU", "2018_Oct", 0);
    dt.Rows.Add("MGW_CCU", "2018_Nov", 0);
    dt.Rows.Add("MGW_CCU", "2018_Dec", 0);
    dt.Rows.Add("MGW_CCU", "2019_Jan", 0);
    dt.Rows.Add("MGW_CCU", "2019_Feb", 0);
    dt.Rows.Add("MGW_CCU", "2019_Mar", 0);
    dt.Rows.Add("MGW_CCU", "2019_Apr", 0);
    dt.Rows.Add("MGW_CCU", "2019_May", 0);
    dt.Rows.Add("MGW_CCU", "2019_Jun", 0);
    dt.Rows.Add("MGW_CCU", "2019_Jul", 0);
    dt.Rows.Add("MGW_CCU", "2019_Aug", 0);
    dt.Rows.Add("MGW_CCU", "2019_Sep", 0);
    dt.Rows.Add("MGW_CCU", "2019_Oct", 0);
    dt.Rows.Add("MGW_CCU", "2019_Nov", 0);
    dt.Rows.Add("MGW_CCU", "2019_Dec", 0);
    dt.Rows.Add("MGW_CCU", "2020_Jan", 0);
    dt.Rows.Add("MGW_MANE", "2018_Oct", 1);
    dt.Rows.Add("MGW_MANE", "2018_Nov", 0);
    dt.Rows.Add("MGW_MANE", "2018_Dec", 0);
    dt.Rows.Add("MGW_MANE", "2019_Jan", 0);
    dt.Rows.Add("MGW_MANE", "2019_Feb", 0);
    dt.Rows.Add("MGW_MANE", "2019_Mar", 0);
    dt.Rows.Add("MGW_MANE", "2019_Apr", 1);
    dt.Rows.Add("MGW_MANE", "2019_May", 0);
    dt.Rows.Add("MGW_MANE", "2019_Jun", 0);
    dt.Rows.Add("MGW_MANE", "2019_Jul", 0);
    dt.Rows.Add("MGW_MANE", "2019_Aug", 0);
    dt.Rows.Add("MGW_MANE", "2019_Sep", 0);
    dt.Rows.Add("MGW_MANE", "2019_Oct", 0);
    dt.Rows.Add("MGW_MANE", "2019_Nov", 0);
    dt.Rows.Add("MGW_MANE", "2019_Dec", 0);
    dt.Rows.Add("MGW_MANE", "2020_Jan", 0);

    gvInt.DataSource = dt;
    gvInt.DataBind();

    DataTable dtInt = new DataTable("dtInts");
    foreach (TableCell cell in gvInt.HeaderRow.Cells)
    {
        dtInt.Columns.Add(cell.Text.Trim());
    }
    foreach (GridViewRow row in gvInt.Rows)
    {
        dtInt.Rows.Add();
        for (int i = 0; i < row.Cells.Count; i++)
        {
            dtInt.Rows[row.RowIndex][i] = row.Cells[i].Text.Trim();
        }
    }


    List<string> departments = (from p in dtInt.AsEnumerable()
                                select p.Field<string>("Department")).Distinct().ToList();
    if (RateChart.Series.Count() == 1)
    {
        RateChart.Series.Remove(RateChart.Series[0]);
    }
    foreach (string department in departments.ToList())
    {
        string[] x = (from p in dtInt.AsEnumerable()
                        where p.Field<string>("Department") == department
                        orderby p.Field<string>("Period_Shown")
                        select p.Field<string>("Period_Shown")).ToArray();

        decimal[] y = (from p in dtInt.AsEnumerable()
                        where p.Field<string>("Department") == department
                        orderby p.Field<string>("Period_Shown")
                        select Convert.ToDecimal(p.Field<string>("Num_Int"))).ToArray();

        RateChart.Series.Add(new Series(department));
        RateChart.Series[department].IsValueShownAsLabel = false;
        RateChart.Series[department].BorderWidth = 3;
        RateChart.Series[department].ChartType = SeriesChartType.Line;
        RateChart.Series[department].Points.DataBindXY(x, y);
        RateChart.Series[department].MarkerStyle = MarkerStyle.Star10;
    }
    RateChart.Legends.Add("Default");
    RateChart.Legends[0].Docking = Docking.Bottom;
    RateChart.Legends[0].IsTextAutoFit = true;
    RateChart.Legends[0].Alignment = System.Drawing.StringAlignment.Center;
    RateChart.Legends[0].Enabled = true;
    RateChart.ChartAreas[0].AxisX.Interval = 1;
}

VB.Net

Protected Sub OnGenerate(ByVal sender As Object, ByVal e As EventArgs)
    Dim dt As DataTable = New DataTable()
    dt.Columns.Add("Department")
    dt.Columns.Add("Period_Shown")
    dt.Columns.Add("Num_Int")
    dt.Rows.Add("DMG", "2015_Jan", 0)
    dt.Rows.Add("DMG", "2015_Feb", 0)
    dt.Rows.Add("DMG", "2015_Mar", 0)
    dt.Rows.Add("DMG", "2015_Apr", 0)
    dt.Rows.Add("DMG", "2015_May", 0)
    dt.Rows.Add("DMG", "2015_Jun", 0)
    dt.Rows.Add("DMG", "2015_Jul", 9)
    dt.Rows.Add("DMG", "2015_Aug", 13)
    dt.Rows.Add("DMG", "2015_Sep", 12)
    dt.Rows.Add("DMG", "2015_Oct", 6)
    dt.Rows.Add("DMG", "2015_Nov", 6)
    dt.Rows.Add("DMG", "2015_Dec", 7)
    dt.Rows.Add("DMG", "2016_Jan", 5)
    dt.Rows.Add("DMG", "2016_Feb", 6)
    dt.Rows.Add("DMG", "2016_Mar", 7)
    dt.Rows.Add("DMG", "2016_Apr", 3)
    dt.Rows.Add("DMG", "2016_May", 7)
    dt.Rows.Add("DMG", "2016_Jun", 6)
    dt.Rows.Add("DMG", "2016_Jul", 4)
    dt.Rows.Add("DMG", "2016_Aug", 11)
    dt.Rows.Add("DMG", "2016_Sep", 10)
    dt.Rows.Add("DMG", "2016_Oct", 10)
    dt.Rows.Add("DMG", "2016_Nov", 14)
    dt.Rows.Add("DMG", "2016_Dec", 7)
    dt.Rows.Add("DMG", "2017_Jan", 9)
    dt.Rows.Add("DMG", "2017_Feb", 5)
    dt.Rows.Add("DMG", "2017_Mar", 7)
    dt.Rows.Add("DMG", "2017_Apr", 10)
    dt.Rows.Add("DMG", "2017_May", 14)
    dt.Rows.Add("DMG", "2017_Jun", 11)
    dt.Rows.Add("DMG", "2017_Jul", 8)
    dt.Rows.Add("DMG", "2017_Aug", 8)
    dt.Rows.Add("DMG", "2017_Sep", 6)
    dt.Rows.Add("DMG", "2017_Oct", 6)
    dt.Rows.Add("DMG", "2017_Nov", 5)
    dt.Rows.Add("DMG", "2017_Dec", 8)
    dt.Rows.Add("DMG", "2018_Jan", 11)
    dt.Rows.Add("DMG", "2018_Feb", 7)
    dt.Rows.Add("DMG", "2018_Mar", 10)
    dt.Rows.Add("DMG", "2018_Apr", 13)
    dt.Rows.Add("DMG", "2018_May", 11)
    dt.Rows.Add("DMG", "2018_Jun", 11)
    dt.Rows.Add("DMG", "2018_Jul", 12)
    dt.Rows.Add("DMG", "2018_Aug", 15)
    dt.Rows.Add("DMG", "2018_Sep", 7)
    dt.Rows.Add("DMG", "2018_Oct", 9)
    dt.Rows.Add("DMG", "2018_Nov", 13)
    dt.Rows.Add("DMG", "2018_Dec", 7)
    dt.Rows.Add("DMG", "2019_Jan", 10)
    dt.Rows.Add("DMG", "2019_Feb", 7)
    dt.Rows.Add("DMG", "2019_Mar", 4)
    dt.Rows.Add("DMG", "2019_Apr", 17)
    dt.Rows.Add("DMG", "2019_May", 11)
    dt.Rows.Add("DMG", "2019_Jun", 6)
    dt.Rows.Add("DMG", "2019_Jul", 8)
    dt.Rows.Add("DMG", "2019_Aug", 13)
    dt.Rows.Add("DMG", "2019_Sep", 10)
    dt.Rows.Add("DMG", "2019_Oct", 13)
    dt.Rows.Add("DMG", "2019_Nov", 11)
    dt.Rows.Add("DMG", "2019_Dec", 10)
    dt.Rows.Add("DMG", "2020_Jan", 12)
    dt.Rows.Add("MGW_11A", "2015_Jan", 0)
    dt.Rows.Add("MGW_11A", "2015_Feb", 0)
    dt.Rows.Add("MGW_11A", "2015_Mar", 0)
    dt.Rows.Add("MGW_11A", "2015_Apr", 0)
    dt.Rows.Add("MGW_11A", "2015_May", 0)
    dt.Rows.Add("MGW_11A", "2015_Jun", 0)
    dt.Rows.Add("MGW_11A", "2015_Jul", 1)
    dt.Rows.Add("MGW_11A", "2015_Aug", 2)
    dt.Rows.Add("MGW_11A", "2015_Sep", 3)
    dt.Rows.Add("MGW_11A", "2015_Oct", 0)
    dt.Rows.Add("MGW_11A", "2015_Nov", 1)
    dt.Rows.Add("MGW_11A", "2015_Dec", 2)
    dt.Rows.Add("MGW_11A", "2016_Jan", 0)
    dt.Rows.Add("MGW_11A", "2016_Feb", 0)
    dt.Rows.Add("MGW_11A", "2016_Mar", 0)
    dt.Rows.Add("MGW_11A", "2016_Apr", 0)
    dt.Rows.Add("MGW_11A", "2016_May", 0)
    dt.Rows.Add("MGW_11A", "2016_Jun", 0)
    dt.Rows.Add("MGW_11A", "2016_Jul", 1)
    dt.Rows.Add("MGW_11A", "2016_Aug", 0)
    dt.Rows.Add("MGW_11A", "2016_Sep", 1)
    dt.Rows.Add("MGW_11A", "2016_Oct", 1)
    dt.Rows.Add("MGW_11A", "2016_Nov", 2)
    dt.Rows.Add("MGW_11A", "2016_Dec", 0)
    dt.Rows.Add("MGW_11A", "2017_Jan", 1)
    dt.Rows.Add("MGW_11A", "2017_Feb", 0)
    dt.Rows.Add("MGW_11A", "2017_Mar", 0)
    dt.Rows.Add("MGW_11A", "2017_Apr", 0)
    dt.Rows.Add("MGW_11A", "2017_May", 0)
    dt.Rows.Add("MGW_11A", "2017_Jun", 1)
    dt.Rows.Add("MGW_11A", "2017_Jul", 0)
    dt.Rows.Add("MGW_11A", "2017_Aug", 0)
    dt.Rows.Add("MGW_11A", "2017_Sep", 1)
    dt.Rows.Add("MGW_11A", "2017_Oct", 1)
    dt.Rows.Add("MGW_11A", "2017_Nov", 0)
    dt.Rows.Add("MGW_11A", "2017_Dec", 1)
    dt.Rows.Add("MGW_11A", "2018_Jan", 2)
    dt.Rows.Add("MGW_11A", "2018_Feb", 1)
    dt.Rows.Add("MGW_11A", "2018_Mar", 1)
    dt.Rows.Add("MGW_11A", "2018_Apr", 0)
    dt.Rows.Add("MGW_11A", "2018_May", 1)
    dt.Rows.Add("MGW_11A", "2018_Jun", 2)
    dt.Rows.Add("MGW_11A", "2018_Jul", 2)
    dt.Rows.Add("MGW_11A", "2018_Aug", 2)
    dt.Rows.Add("MGW_11A", "2018_Sep", 0)
    dt.Rows.Add("MGW_11A", "2018_Oct", 0)
    dt.Rows.Add("MGW_11A", "2018_Nov", 0)
    dt.Rows.Add("MGW_11A", "2018_Dec", 0)
    dt.Rows.Add("MGW_11A", "2019_Jan", 0)
    dt.Rows.Add("MGW_11A", "2019_Feb", 0)
    dt.Rows.Add("MGW_11A", "2019_Mar", 1)
    dt.Rows.Add("MGW_11A", "2019_Apr", 1)
    dt.Rows.Add("MGW_11A", "2019_May", 1)
    dt.Rows.Add("MGW_11A", "2019_Jun", 1)
    dt.Rows.Add("MGW_11A", "2019_Sep", 0)
    dt.Rows.Add("MGW_11A", "2019_Oct", 3)
    dt.Rows.Add("MGW_11A", "2019_Nov", 0)
    dt.Rows.Add("MGW_11A", "2019_Dec", 0)
    dt.Rows.Add("MGW_11A", "2020_Jan", 2)
    dt.Rows.Add("MGW_11B", "2015_Jan", 0)
    dt.Rows.Add("MGW_11B", "2015_Feb", 0)
    dt.Rows.Add("MGW_11B", "2015_Mar", 0)
    dt.Rows.Add("MGW_11B", "2015_Apr", 0)
    dt.Rows.Add("MGW_11B", "2015_May", 0)
    dt.Rows.Add("MGW_11B", "2015_Jun", 0)
    dt.Rows.Add("MGW_11B", "2015_Jul", 0)
    dt.Rows.Add("MGW_11B", "2015_Aug", 0)
    dt.Rows.Add("MGW_11B", "2015_Sep", 0)
    dt.Rows.Add("MGW_11B", "2015_Oct", 0)
    dt.Rows.Add("MGW_11B", "2015_Nov", 0)
    dt.Rows.Add("MGW_11B", "2015_Dec", 0)
    dt.Rows.Add("MGW_11B", "2016_Jan", 0)
    dt.Rows.Add("MGW_11B", "2016_Feb", 0)
    dt.Rows.Add("MGW_11B", "2016_Mar", 0)
    dt.Rows.Add("MGW_11B", "2016_Apr", 0)
    dt.Rows.Add("MGW_11B", "2016_May", 0)
    dt.Rows.Add("MGW_11B", "2016_Jun", 0)
    dt.Rows.Add("MGW_11B", "2016_Jul", 0)
    dt.Rows.Add("MGW_11B", "2016_Aug", 1)
    dt.Rows.Add("MGW_11B", "2016_Sep", 0)
    dt.Rows.Add("MGW_11B", "2016_Oct", 0)
    dt.Rows.Add("MGW_11B", "2016_Nov", 1)
    dt.Rows.Add("MGW_11B", "2016_Dec", 0)
    dt.Rows.Add("MGW_11B", "2017_Jan", 0)
    dt.Rows.Add("MGW_11B", "2017_Feb", 0)
    dt.Rows.Add("MGW_11B", "2017_Mar", 0)
    dt.Rows.Add("MGW_11B", "2017_Apr", 1)
    dt.Rows.Add("MGW_11B", "2017_May", 1)
    dt.Rows.Add("MGW_11B", "2017_Jun", 0)
    dt.Rows.Add("MGW_11B", "2017_Jul", 0)
    dt.Rows.Add("MGW_11B", "2017_Aug", 0)
    dt.Rows.Add("MGW_11B", "2017_Sep", 0)
    dt.Rows.Add("MGW_11B", "2017_Oct", 0)
    dt.Rows.Add("MGW_11B", "2017_Nov", 0)
    dt.Rows.Add("MGW_11B", "2017_Dec", 0)
    dt.Rows.Add("MGW_11B", "2018_Jan", 0)
    dt.Rows.Add("MGW_11B", "2018_Feb", 1)
    dt.Rows.Add("MGW_11B", "2018_Mar", 0)
    dt.Rows.Add("MGW_11B", "2018_Apr", 0)
    dt.Rows.Add("MGW_11B", "2018_May", 0)
    dt.Rows.Add("MGW_11B", "2018_Jun", 1)
    dt.Rows.Add("MGW_11B", "2018_Jul", 1)
    dt.Rows.Add("MGW_11B", "2018_Aug", 0)
    dt.Rows.Add("MGW_11B", "2018_Sep", 1)
    dt.Rows.Add("MGW_11B", "2018_Oct", 0)
    dt.Rows.Add("MGW_11B", "2018_Nov", 0)
    dt.Rows.Add("MGW_11B", "2018_Dec", 0)
    dt.Rows.Add("MGW_11B", "2019_Jan", 0)
    dt.Rows.Add("MGW_11B", "2019_Feb", 2)
    dt.Rows.Add("MGW_11B", "2019_Mar", 0)
    dt.Rows.Add("MGW_11B", "2019_Apr", 1)
    dt.Rows.Add("MGW_11B", "2019_May", 1)
    dt.Rows.Add("MGW_11B", "2019_Jun", 0)
    dt.Rows.Add("MGW_11B", "2019_Jul", 0)
    dt.Rows.Add("MGW_11B", "2019_Aug", 2)
    dt.Rows.Add("MGW_11B", "2019_Sep", 0)
    dt.Rows.Add("MGW_11B", "2019_Oct", 1)
    dt.Rows.Add("MGW_11B", "2019_Nov", 2)
    dt.Rows.Add("MGW_11B", "2019_Dec", 1)
    dt.Rows.Add("MGW_11B", "2020_Jan", 0)
    dt.Rows.Add("MGW_12A", "2015_Jan", 0)
    dt.Rows.Add("MGW_12A", "2015_Feb", 0)
    dt.Rows.Add("MGW_12A", "2015_Mar", 0)
    dt.Rows.Add("MGW_12A", "2015_Apr", 0)
    dt.Rows.Add("MGW_12A", "2015_May", 0)
    dt.Rows.Add("MGW_12A", "2015_Jun", 0)
    dt.Rows.Add("MGW_12A", "2015_Jul", 1)
    dt.Rows.Add("MGW_12A", "2015_Aug", 0)
    dt.Rows.Add("MGW_12A", "2015_Sep", 0)
    dt.Rows.Add("MGW_12A", "2015_Oct", 0)
    dt.Rows.Add("MGW_12A", "2015_Nov", 2)
    dt.Rows.Add("MGW_12A", "2015_Dec", 0)
    dt.Rows.Add("MGW_12A", "2016_Jan", 0)
    dt.Rows.Add("MGW_12A", "2016_Feb", 0)
    dt.Rows.Add("MGW_12A", "2016_Mar", 0)
    dt.Rows.Add("MGW_12A", "2016_Apr", 0)
    dt.Rows.Add("MGW_12A", "2016_May", 0)
    dt.Rows.Add("MGW_12A", "2016_Jun", 0)
    dt.Rows.Add("MGW_12A", "2016_Jul", 0)
    dt.Rows.Add("MGW_12A", "2016_Aug", 0)
    dt.Rows.Add("MGW_12A", "2016_Sep", 1)
    dt.Rows.Add("MGW_12A", "2016_Oct", 1)
    dt.Rows.Add("MGW_12A", "2016_Nov", 0)
    dt.Rows.Add("MGW_12A", "2016_Dec", 1)
    dt.Rows.Add("MGW_12A", "2017_Jan", 1)
    dt.Rows.Add("MGW_12A", "2017_Feb", 1)
    dt.Rows.Add("MGW_12A", "2017_Mar", 1)
    dt.Rows.Add("MGW_12A", "2017_Apr", 1)
    dt.Rows.Add("MGW_12A", "2017_May", 1)
    dt.Rows.Add("MGW_12A", "2017_Jun", 0)
    dt.Rows.Add("MGW_12A", "2017_Jul", 2)
    dt.Rows.Add("MGW_12A", "2017_Aug", 1)
    dt.Rows.Add("MGW_12A", "2017_Sep", 0)
    dt.Rows.Add("MGW_12A", "2017_Oct", 2)
    dt.Rows.Add("MGW_12A", "2017_Nov", 1)
    dt.Rows.Add("MGW_12A", "2017_Dec", 0)
    dt.Rows.Add("MGW_12A", "2018_Jan", 0)
    dt.Rows.Add("MGW_12A", "2018_Feb", 1)
    dt.Rows.Add("MGW_12A", "2018_Mar", 2)
    dt.Rows.Add("MGW_12A", "2018_Apr", 1)
    dt.Rows.Add("MGW_12A", "2018_May", 2)
    dt.Rows.Add("MGW_12A", "2018_Jun", 1)
    dt.Rows.Add("MGW_12A", "2018_Jul", 0)
    dt.Rows.Add("MGW_12A", "2018_Aug", 0)
    dt.Rows.Add("MGW_12A", "2018_Sep", 0)
    dt.Rows.Add("MGW_12A", "2018_Oct", 0)
    dt.Rows.Add("MGW_12A", "2018_Nov", 2)
    dt.Rows.Add("MGW_12A", "2018_Dec", 0)
    dt.Rows.Add("MGW_12A", "2019_Jan", 2)
    dt.Rows.Add("MGW_12A", "2019_Feb", 0)
    dt.Rows.Add("MGW_12A", "2019_Mar", 0)
    dt.Rows.Add("MGW_12A", "2019_Apr", 1)
    dt.Rows.Add("MGW_12A", "2019_May", 1)
    dt.Rows.Add("MGW_12A", "2019_Jun", 2)
    dt.Rows.Add("MGW_12A", "2019_Jul", 1)
    dt.Rows.Add("MGW_12A", "2019_Aug", 1)
    dt.Rows.Add("MGW_12A", "2019_Sep", 1)
    dt.Rows.Add("MGW_12A", "2019_Oct", 1)
    dt.Rows.Add("MGW_12A", "2019_Nov", 2)
    dt.Rows.Add("MGW_12A", "2019_Dec", 0)
    dt.Rows.Add("MGW_12A", "2020_Jan", 0)
    dt.Rows.Add("MGW_12B", "2015_Jan", 0)
    dt.Rows.Add("MGW_12B", "2015_Feb", 0)
    dt.Rows.Add("MGW_12B", "2015_Mar", 0)
    dt.Rows.Add("MGW_12B", "2015_Apr", 0)
    dt.Rows.Add("MGW_12B", "2015_May", 0)
    dt.Rows.Add("MGW_12B", "2015_Jun", 0)
    dt.Rows.Add("MGW_12B", "2015_Jul", 2)
    dt.Rows.Add("MGW_12B", "2015_Aug", 1)
    dt.Rows.Add("MGW_12B", "2015_Sep", 1)
    dt.Rows.Add("MGW_12B", "2015_Oct", 0)
    dt.Rows.Add("MGW_12B", "2015_Nov", 0)
    dt.Rows.Add("MGW_12B", "2015_Dec", 1)
    dt.Rows.Add("MGW_12B", "2016_Jan", 1)
    dt.Rows.Add("MGW_12B", "2016_Feb", 0)
    dt.Rows.Add("MGW_12B", "2016_Mar", 3)
    dt.Rows.Add("MGW_12B", "2016_Apr", 0)
    dt.Rows.Add("MGW_12B", "2016_May", 1)
    dt.Rows.Add("MGW_12B", "2016_Jun", 0)
    dt.Rows.Add("MGW_12B", "2016_Jul", 2)
    dt.Rows.Add("MGW_12B", "2016_Aug", 1)
    dt.Rows.Add("MGW_12B", "2016_Sep", 1)
    dt.Rows.Add("MGW_12B", "2016_Oct", 2)
    dt.Rows.Add("MGW_12B", "2016_Nov", 1)
    dt.Rows.Add("MGW_12B", "2016_Dec", 0)
    dt.Rows.Add("MGW_12B", "2017_Jan", 1)
    dt.Rows.Add("MGW_12B", "2017_Feb", 0)
    dt.Rows.Add("MGW_12B", "2017_Mar", 1)
    dt.Rows.Add("MGW_12B", "2017_Apr", 0)
    dt.Rows.Add("MGW_12B", "2017_May", 1)
    dt.Rows.Add("MGW_12B", "2017_Jun", 1)
    dt.Rows.Add("MGW_12B", "2017_Jul", 1)
    dt.Rows.Add("MGW_12B", "2017_Aug", 1)
    dt.Rows.Add("MGW_12B", "2017_Sep", 0)
    dt.Rows.Add("MGW_12B", "2017_Oct", 0)
    dt.Rows.Add("MGW_12B", "2017_Nov", 0)
    dt.Rows.Add("MGW_12B", "2017_Dec", 1)
    dt.Rows.Add("MGW_12B", "2018_Jan", 0)
    dt.Rows.Add("MGW_12B", "2018_Feb", 0)
    dt.Rows.Add("MGW_12B", "2018_Mar", 0)
    dt.Rows.Add("MGW_12B", "2018_Apr", 0)
    dt.Rows.Add("MGW_12B", "2018_May", 0)
    dt.Rows.Add("MGW_12B", "2018_Jun", 1)
    dt.Rows.Add("MGW_12B", "2018_Jul", 1)
    dt.Rows.Add("MGW_12B", "2018_Aug", 0)
    dt.Rows.Add("MGW_12B", "2018_Sep", 1)
    dt.Rows.Add("MGW_12B", "2018_Oct", 0)
    dt.Rows.Add("MGW_12B", "2018_Nov", 0)
    dt.Rows.Add("MGW_12B", "2018_Dec", 0)
    dt.Rows.Add("MGW_12B", "2019_Jan", 1)
    dt.Rows.Add("MGW_12B", "2019_Feb", 0)
    dt.Rows.Add("MGW_12B", "2019_Mar", 0)
    dt.Rows.Add("MGW_12B", "2019_Apr", 0)
    dt.Rows.Add("MGW_12B", "2019_May", 0)
    dt.Rows.Add("MGW_12B", "2019_Jun", 0)
    dt.Rows.Add("MGW_12B", "2019_Jul", 0)
    dt.Rows.Add("MGW_12B", "2019_Aug", 1)
    dt.Rows.Add("MGW_12B", "2019_Sep", 0)
    dt.Rows.Add("MGW_12B", "2019_Oct", 1)
    dt.Rows.Add("MGW_12B", "2019_Nov", 1)
    dt.Rows.Add("MGW_12B", "2019_Dec", 2)
    dt.Rows.Add("MGW_12B", "2020_Jan", 0)
    dt.Rows.Add("MGW_13A", "2015_Jan", 0)
    dt.Rows.Add("MGW_13A", "2015_Feb", 0)
    dt.Rows.Add("MGW_13A", "2015_Mar", 0)
    dt.Rows.Add("MGW_13A", "2015_Apr", 0)
    dt.Rows.Add("MGW_13A", "2015_May", 0)
    dt.Rows.Add("MGW_13A", "2015_Jun", 0)
    dt.Rows.Add("MGW_13A", "2015_Jul", 1)
    dt.Rows.Add("MGW_13A", "2015_Aug", 0)
    dt.Rows.Add("MGW_13A", "2015_Sep", 0)
    dt.Rows.Add("MGW_13A", "2015_Oct", 0)
    dt.Rows.Add("MGW_13A", "2015_Nov", 1)
    dt.Rows.Add("MGW_13A", "2015_Dec", 0)
    dt.Rows.Add("MGW_13A", "2016_Jan", 1)
    dt.Rows.Add("MGW_13A", "2016_Feb", 0)
    dt.Rows.Add("MGW_13A", "2016_Mar", 1)
    dt.Rows.Add("MGW_13A", "2016_Apr", 0)
    dt.Rows.Add("MGW_13A", "2016_May", 1)
    dt.Rows.Add("MGW_13A", "2016_Jun", 0)
    dt.Rows.Add("MGW_13A", "2016_Jul", 0)
    dt.Rows.Add("MGW_13A", "2016_Aug", 0)
    dt.Rows.Add("MGW_13A", "2016_Sep", 0)
    dt.Rows.Add("MGW_13A", "2016_Oct", 0)
    dt.Rows.Add("MGW_13A", "2016_Nov", 1)
    dt.Rows.Add("MGW_13A", "2016_Dec", 0)
    dt.Rows.Add("MGW_13A", "2017_Jan", 0)
    dt.Rows.Add("MGW_13A", "2017_Feb", 0)
    dt.Rows.Add("MGW_13A", "2017_Mar", 1)
    dt.Rows.Add("MGW_13A", "2017_Apr", 1)
    dt.Rows.Add("MGW_13A", "2017_May", 2)
    dt.Rows.Add("MGW_13A", "2017_Jun", 2)
    dt.Rows.Add("MGW_13A", "2017_Jul", 0)
    dt.Rows.Add("MGW_13A", "2017_Aug", 0)
    dt.Rows.Add("MGW_13A", "2017_Sep", 0)
    dt.Rows.Add("MGW_13A", "2017_Oct", 0)
    dt.Rows.Add("MGW_13A", "2017_Nov", 0)
    dt.Rows.Add("MGW_13A", "2017_Dec", 0)
    dt.Rows.Add("MGW_13A", "2018_Jan", 1)
    dt.Rows.Add("MGW_13A", "2018_Feb", 0)
    dt.Rows.Add("MGW_13A", "2018_Mar", 0)
    dt.Rows.Add("MGW_13A", "2018_Apr", 4)
    dt.Rows.Add("MGW_13A", "2018_May", 0)
    dt.Rows.Add("MGW_13A", "2018_Jun", 0)
    dt.Rows.Add("MGW_13A", "2018_Jul", 3)
    dt.Rows.Add("MGW_13A", "2018_Aug", 0)
    dt.Rows.Add("MGW_13A", "2018_Sep", 1)
    dt.Rows.Add("MGW_13A", "2018_Oct", 2)
    dt.Rows.Add("MGW_13A", "2018_Nov", 2)
    dt.Rows.Add("MGW_13A", "2018_Dec", 1)
    dt.Rows.Add("MGW_13A", "2019_Jan", 1)
    dt.Rows.Add("MGW_13A", "2019_Feb", 1)
    dt.Rows.Add("MGW_13A", "2019_Mar", 0)
    dt.Rows.Add("MGW_13A", "2019_Apr", 2)
    dt.Rows.Add("MGW_13A", "2019_May", 0)
    dt.Rows.Add("MGW_13A", "2019_Jun", 1)
    dt.Rows.Add("MGW_13A", "2019_Jul", 1)
    dt.Rows.Add("MGW_13A", "2019_Aug", 2)
    dt.Rows.Add("MGW_13A", "2019_Sep", 1)
    dt.Rows.Add("MGW_13A", "2019_Oct", 1)
    dt.Rows.Add("MGW_13A", "2019_Nov", 0)
    dt.Rows.Add("MGW_13A", "2019_Dec", 0)
    dt.Rows.Add("MGW_13A", "2020_Jan", 1)
    dt.Rows.Add("MGW_13B", "2020_Jan", 0)
    dt.Rows.Add("MGW_14B", "2019_Jan", 0)
    dt.Rows.Add("MGW_14B", "2019_Feb", 0)
    dt.Rows.Add("MGW_14B", "2019_Mar", 0)
    dt.Rows.Add("MGW_14B", "2019_Apr", 2)
    dt.Rows.Add("MGW_14B", "2019_May", 1)
    dt.Rows.Add("MGW_14B", "2019_Jun", 0)
    dt.Rows.Add("MGW_14B", "2019_Jul", 0)
    dt.Rows.Add("MGW_14B", "2019_Aug", 0)
    dt.Rows.Add("MGW_14B", "2019_Sep", 1)
    dt.Rows.Add("MGW_14B", "2019_Oct", 0)
    dt.Rows.Add("MGW_14B", "2019_Nov", 1)
    dt.Rows.Add("MGW_14B", "2019_Dec", 0)
    dt.Rows.Add("MGW_14B", "2020_Jan", 0)
    dt.Rows.Add("MGW_2C", "2015_Jan", 0)
    dt.Rows.Add("MGW_2C", "2015_Feb", 0)
    dt.Rows.Add("MGW_2C", "2015_Mar", 0)
    dt.Rows.Add("MGW_2C", "2015_Apr", 0)
    dt.Rows.Add("MGW_2C", "2015_May", 0)
    dt.Rows.Add("MGW_2C", "2015_Jun", 0)
    dt.Rows.Add("MGW_2C", "2015_Jul", 0)
    dt.Rows.Add("MGW_2C", "2015_Aug", 1)
    dt.Rows.Add("MGW_2C", "2015_Sep", 1)
    dt.Rows.Add("MGW_2C", "2015_Oct", 1)
    dt.Rows.Add("MGW_2C", "2015_Nov", 1)
    dt.Rows.Add("MGW_2C", "2015_Dec", 0)
    dt.Rows.Add("MGW_2C", "2016_Jan", 0)
    dt.Rows.Add("MGW_2C", "2016_Feb", 2)
    dt.Rows.Add("MGW_2C", "2016_Mar", 0)
    dt.Rows.Add("MGW_2C", "2016_Apr", 0)
    dt.Rows.Add("MGW_2C", "2016_May", 1)
    dt.Rows.Add("MGW_2C", "2016_Jun", 0)
    dt.Rows.Add("MGW_2C", "2016_Jul", 0)
    dt.Rows.Add("MGW_2C", "2016_Aug", 1)
    dt.Rows.Add("MGW_2C", "2016_Sep", 1)
    dt.Rows.Add("MGW_2C", "2016_Oct", 3)
    dt.Rows.Add("MGW_2C", "2016_Nov", 1)
    dt.Rows.Add("MGW_2C", "2016_Dec", 0)
    dt.Rows.Add("MGW_2C", "2017_Jan", 0)
    dt.Rows.Add("MGW_2C", "2017_Feb", 0)
    dt.Rows.Add("MGW_2C", "2017_Mar", 0)
    dt.Rows.Add("MGW_2C", "2017_Apr", 0)
    dt.Rows.Add("MGW_2C", "2017_May", 1)
    dt.Rows.Add("MGW_2C", "2017_Jun", 0)
    dt.Rows.Add("MGW_2C", "2017_Jul", 1)
    dt.Rows.Add("MGW_2C", "2017_Aug", 2)
    dt.Rows.Add("MGW_2C", "2017_Sep", 2)
    dt.Rows.Add("MGW_2C", "2017_Oct", 0)
    dt.Rows.Add("MGW_2C", "2017_Nov", 2)
    dt.Rows.Add("MGW_2C", "2017_Dec", 1)
    dt.Rows.Add("MGW_2C", "2018_Jan", 1)
    dt.Rows.Add("MGW_2C", "2018_Feb", 0)
    dt.Rows.Add("MGW_2C", "2018_Mar", 3)
    dt.Rows.Add("MGW_2C", "2018_Apr", 3)
    dt.Rows.Add("MGW_2C", "2018_May", 1)
    dt.Rows.Add("MGW_2C", "2018_Jun", 0)
    dt.Rows.Add("MGW_2C", "2018_Jul", 1)
    dt.Rows.Add("MGW_2C", "2018_Aug", 1)
    dt.Rows.Add("MGW_2C", "2018_Sep", 0)
    dt.Rows.Add("MGW_2C", "2018_Oct", 1)
    dt.Rows.Add("MGW_2C", "2018_Nov", 0)
    dt.Rows.Add("MGW_2C", "2018_Dec", 0)
    dt.Rows.Add("MGW_2C", "2019_Jan", 0)
    dt.Rows.Add("MGW_2C", "2019_Feb", 0)
    dt.Rows.Add("MGW_2C", "2019_Mar", 0)
    dt.Rows.Add("MGW_2C", "2019_Apr", 1)
    dt.Rows.Add("MGW_2C", "2019_May", 0)
    dt.Rows.Add("MGW_2C", "2019_Jun", 0)
    dt.Rows.Add("MGW_2C", "2019_Jul", 0)
    dt.Rows.Add("MGW_2C", "2019_Aug", 1)
    dt.Rows.Add("MGW_2C", "2019_Sep", 1)
    dt.Rows.Add("MGW_2C", "2019_Oct", 0)
    dt.Rows.Add("MGW_2C", "2019_Nov", 0)
    dt.Rows.Add("MGW_2C", "2019_Dec", 2)
    dt.Rows.Add("MGW_2C", "2020_Jan", 1)
    dt.Rows.Add("MGW_2D", "2015_Jan", 0)
    dt.Rows.Add("MGW_2D", "2015_Feb", 0)
    dt.Rows.Add("MGW_2D", "2015_Mar", 0)
    dt.Rows.Add("MGW_2D", "2015_Apr", 0)
    dt.Rows.Add("MGW_2D", "2015_May", 0)
    dt.Rows.Add("MGW_2D", "2015_Jun", 0)
    dt.Rows.Add("MGW_2D", "2015_Jul", 0)
    dt.Rows.Add("MGW_2D", "2015_Aug", 1)
    dt.Rows.Add("MGW_2D", "2015_Sep", 2)
    dt.Rows.Add("MGW_2D", "2015_Oct", 1)
    dt.Rows.Add("MGW_2D", "2015_Nov", 0)
    dt.Rows.Add("MGW_2D", "2015_Dec", 0)
    dt.Rows.Add("MGW_2D", "2016_Jan", 0)
    dt.Rows.Add("MGW_2D", "2016_Feb", 2)
    dt.Rows.Add("MGW_2D", "2016_Mar", 0)
    dt.Rows.Add("MGW_2D", "2016_Apr", 0)
    dt.Rows.Add("MGW_2D", "2016_May", 0)
    dt.Rows.Add("MGW_2D", "2016_Jun", 1)
    dt.Rows.Add("MGW_2D", "2016_Jul", 0)
    dt.Rows.Add("MGW_2D", "2016_Aug", 2)
    dt.Rows.Add("MGW_2D", "2016_Sep", 0)
    dt.Rows.Add("MGW_2D", "2016_Oct", 0)
    dt.Rows.Add("MGW_2D", "2016_Nov", 2)
    dt.Rows.Add("MGW_2D", "2016_Dec", 0)
    dt.Rows.Add("MGW_2D", "2017_Jan", 2)
    dt.Rows.Add("MGW_2D", "2017_Feb", 1)
    dt.Rows.Add("MGW_2D", "2017_Mar", 0)
    dt.Rows.Add("MGW_2D", "2017_Apr", 1)
    dt.Rows.Add("MGW_2D", "2017_May", 3)
    dt.Rows.Add("MGW_2D", "2017_Jun", 0)
    dt.Rows.Add("MGW_2D", "2017_Jul", 0)
    dt.Rows.Add("MGW_2D", "2017_Aug", 0)
    dt.Rows.Add("MGW_2D", "2017_Sep", 0)
    dt.Rows.Add("MGW_2D", "2017_Oct", 1)
    dt.Rows.Add("MGW_2D", "2017_Nov", 1)
    dt.Rows.Add("MGW_2D", "2017_Dec", 0)
    dt.Rows.Add("MGW_2D", "2018_Jan", 2)
    dt.Rows.Add("MGW_2D", "2018_Feb", 1)
    dt.Rows.Add("MGW_2D", "2018_Mar", 2)
    dt.Rows.Add("MGW_2D", "2018_Apr", 0)
    dt.Rows.Add("MGW_2D", "2018_May", 2)
    dt.Rows.Add("MGW_2D", "2018_Jun", 2)
    dt.Rows.Add("MGW_2D", "2018_Jul", 2)
    dt.Rows.Add("MGW_2D", "2018_Aug", 1)
    dt.Rows.Add("MGW_2D", "2018_Sep", 2)
    dt.Rows.Add("MGW_2D", "2018_Oct", 1)
    dt.Rows.Add("MGW_2D", "2018_Nov", 1)
    dt.Rows.Add("MGW_2D", "2018_Dec", 0)
    dt.Rows.Add("MGW_2D", "2019_Jan", 2)
    dt.Rows.Add("MGW_2D", "2019_Feb", 0)
    dt.Rows.Add("MGW_2D", "2019_Mar", 0)
    dt.Rows.Add("MGW_2D", "2019_Apr", 2)
    dt.Rows.Add("MGW_2D", "2019_May", 0)
    dt.Rows.Add("MGW_2D", "2019_Jun", 0)
    dt.Rows.Add("MGW_2D", "2019_Jul", 1)
    dt.Rows.Add("MGW_2D", "2019_Aug", 1)
    dt.Rows.Add("MGW_2D", "2019_Sep", 1)
    dt.Rows.Add("MGW_2D", "2019_Oct", 0)
    dt.Rows.Add("MGW_2D", "2019_Nov", 0)
    dt.Rows.Add("MGW_2D", "2019_Dec", 1)
    dt.Rows.Add("MGW_2D", "2020_Jan", 1)
    dt.Rows.Add("MGW_5AM", "2020_Jan", 0)
    dt.Rows.Add("MGW_5B", "2015_Jan", 0)
    dt.Rows.Add("MGW_5B", "2015_Feb", 0)
    dt.Rows.Add("MGW_5B", "2015_Mar", 0)
    dt.Rows.Add("MGW_5B", "2015_Apr", 0)
    dt.Rows.Add("MGW_5B", "2015_May", 0)
    dt.Rows.Add("MGW_5B", "2015_Jun", 0)
    dt.Rows.Add("MGW_5B", "2015_Jul", 0)
    dt.Rows.Add("MGW_5B", "2015_Aug", 2)
    dt.Rows.Add("MGW_5B", "2015_Sep", 0)
    dt.Rows.Add("MGW_5B", "2015_Oct", 0)
    dt.Rows.Add("MGW_5B", "2015_Nov", 0)
    dt.Rows.Add("MGW_5B", "2015_Dec", 2)
    dt.Rows.Add("MGW_5B", "2016_Jan", 0)
    dt.Rows.Add("MGW_5B", "2016_Feb", 0)
    dt.Rows.Add("MGW_5B", "2016_Mar", 1)
    dt.Rows.Add("MGW_5B", "2016_Apr", 0)
    dt.Rows.Add("MGW_5B", "2016_May", 0)
    dt.Rows.Add("MGW_5B", "2016_Jun", 0)
    dt.Rows.Add("MGW_5B", "2016_Jul", 0)
    dt.Rows.Add("MGW_5B", "2016_Aug", 1)
    dt.Rows.Add("MGW_5B", "2016_Sep", 2)
    dt.Rows.Add("MGW_5B", "2016_Oct", 0)
    dt.Rows.Add("MGW_5B", "2016_Nov", 0)
    dt.Rows.Add("MGW_5B", "2016_Dec", 0)
    dt.Rows.Add("MGW_5B", "2017_Jan", 0)
    dt.Rows.Add("MGW_5B", "2017_Feb", 0)
    dt.Rows.Add("MGW_5B", "2017_Mar", 0)
    dt.Rows.Add("MGW_5B", "2017_Apr", 0)
    dt.Rows.Add("MGW_5B", "2017_May", 0)
    dt.Rows.Add("MGW_5B", "2017_Jun", 0)
    dt.Rows.Add("MGW_5B", "2017_Jul", 1)
    dt.Rows.Add("MGW_5B", "2017_Aug", 0)
    dt.Rows.Add("MGW_5B", "2017_Sep", 1)
    dt.Rows.Add("MGW_5B", "2017_Oct", 1)
    dt.Rows.Add("MGW_5B", "2017_Nov", 0)
    dt.Rows.Add("MGW_5B", "2017_Dec", 3)
    dt.Rows.Add("MGW_5B", "2018_Jan", 1)
    dt.Rows.Add("MGW_5B", "2018_Feb", 2)
    dt.Rows.Add("MGW_5B", "2018_Mar", 1)
    dt.Rows.Add("MGW_5B", "2018_Apr", 0)
    dt.Rows.Add("MGW_5B", "2018_May", 0)
    dt.Rows.Add("MGW_5B", "2018_Jun", 0)
    dt.Rows.Add("MGW_5B", "2018_Jul", 0)
    dt.Rows.Add("MGW_5B", "2018_Aug", 2)
    dt.Rows.Add("MGW_5B", "2018_Sep", 0)
    dt.Rows.Add("MGW_5B", "2018_Oct", 0)
    dt.Rows.Add("MGW_5B", "2018_Nov", 0)
    dt.Rows.Add("MGW_5B", "2018_Dec", 1)
    dt.Rows.Add("MGW_5B", "2019_Jan", 1)
    dt.Rows.Add("MGW_5B", "2019_Feb", 0)
    dt.Rows.Add("MGW_5B", "2019_Mar", 1)
    dt.Rows.Add("MGW_5B", "2019_Apr", 0)
    dt.Rows.Add("MGW_5B", "2019_May", 2)
    dt.Rows.Add("MGW_5B", "2019_Jun", 0)
    dt.Rows.Add("MGW_5B", "2019_Jul", 1)
    dt.Rows.Add("MGW_5B", "2019_Aug", 1)
    dt.Rows.Add("MGW_5B", "2019_Sep", 0)
    dt.Rows.Add("MGW_5B", "2019_Oct", 0)
    dt.Rows.Add("MGW_5B", "2019_Nov", 1)
    dt.Rows.Add("MGW_5B", "2019_Dec", 0)
    dt.Rows.Add("MGW_5B", "2020_Jan", 4)
    dt.Rows.Add("MGW_5D", "2015_Jan", 0)
    dt.Rows.Add("MGW_5D", "2015_Feb", 0)
    dt.Rows.Add("MGW_5D", "2015_Mar", 0)
    dt.Rows.Add("MGW_5D", "2015_Apr", 0)
    dt.Rows.Add("MGW_5D", "2015_May", 0)
    dt.Rows.Add("MGW_5D", "2015_Jun", 0)
    dt.Rows.Add("MGW_5D", "2015_Jul", 0)
    dt.Rows.Add("MGW_5D", "2015_Aug", 0)
    dt.Rows.Add("MGW_5D", "2015_Sep", 0)
    dt.Rows.Add("MGW_5D", "2015_Oct", 0)
    dt.Rows.Add("MGW_5D", "2015_Nov", 0)
    dt.Rows.Add("MGW_5D", "2015_Dec", 0)
    dt.Rows.Add("MGW_5D", "2016_Jan", 0)
    dt.Rows.Add("MGW_5D", "2016_Feb", 0)
    dt.Rows.Add("MGW_5D", "2016_Mar", 0)
    dt.Rows.Add("MGW_5D", "2016_Apr", 0)
    dt.Rows.Add("MGW_5D", "2016_May", 0)
    dt.Rows.Add("MGW_5D", "2016_Jun", 0)
    dt.Rows.Add("MGW_5D", "2016_Jul", 0)
    dt.Rows.Add("MGW_5D", "2016_Aug", 0)
    dt.Rows.Add("MGW_5D", "2016_Sep", 0)
    dt.Rows.Add("MGW_5D", "2016_Oct", 0)
    dt.Rows.Add("MGW_5D", "2016_Nov", 2)
    dt.Rows.Add("MGW_5D", "2016_Dec", 0)
    dt.Rows.Add("MGW_5D", "2017_Jan", 0)
    dt.Rows.Add("MGW_5D", "2017_Feb", 1)
    dt.Rows.Add("MGW_5D", "2017_Mar", 0)
    dt.Rows.Add("MGW_5D", "2017_Apr", 0)
    dt.Rows.Add("MGW_5D", "2017_May", 1)
    dt.Rows.Add("MGW_5D", "2017_Jun", 4)
    dt.Rows.Add("MGW_5D", "2017_Jul", 0)
    dt.Rows.Add("MGW_5D", "2017_Aug", 0)
    dt.Rows.Add("MGW_5D", "2017_Sep", 2)
    dt.Rows.Add("MGW_5D", "2017_Oct", 0)
    dt.Rows.Add("MGW_5D", "2017_Nov", 0)
    dt.Rows.Add("MGW_5D", "2017_Dec", 2)
    dt.Rows.Add("MGW_5D", "2018_Jan", 1)
    dt.Rows.Add("MGW_5D", "2018_Feb", 1)
    dt.Rows.Add("MGW_5D", "2018_Mar", 0)
    dt.Rows.Add("MGW_5D", "2018_Apr", 1)
    dt.Rows.Add("MGW_5D", "2018_May", 0)
    dt.Rows.Add("MGW_5D", "2018_Jun", 1)
    dt.Rows.Add("MGW_5D", "2018_Jul", 0)
    dt.Rows.Add("MGW_5D", "2018_Aug", 2)
    dt.Rows.Add("MGW_5D", "2018_Sep", 0)
    dt.Rows.Add("MGW_5D", "2018_Oct", 1)
    dt.Rows.Add("MGW_5D", "2018_Nov", 0)
    dt.Rows.Add("MGW_5D", "2018_Dec", 0)
    dt.Rows.Add("MGW_5D", "2019_Jan", 0)
    dt.Rows.Add("MGW_5D", "2019_Feb", 0)
    dt.Rows.Add("MGW_5D", "2019_Mar", 0)
    dt.Rows.Add("MGW_5D", "2019_Apr", 0)
    dt.Rows.Add("MGW_5D", "2019_May", 0)
    dt.Rows.Add("MGW_5D", "2019_Jun", 0)
    dt.Rows.Add("MGW_5D", "2019_Jul", 1)
    dt.Rows.Add("MGW_5D", "2019_Aug", 0)
    dt.Rows.Add("MGW_5D", "2019_Sep", 1)
    dt.Rows.Add("MGW_5D", "2019_Oct", 1)
    dt.Rows.Add("MGW_5D", "2019_Nov", 1)
    dt.Rows.Add("MGW_5D", "2019_Dec", 1)
    dt.Rows.Add("MGW_5D", "2020_Jan", 0)
    dt.Rows.Add("MGW_6A", "2015_Jan", 0)
    dt.Rows.Add("MGW_6A", "2015_Feb", 0)
    dt.Rows.Add("MGW_6A", "2015_Mar", 0)
    dt.Rows.Add("MGW_6A", "2015_Apr", 0)
    dt.Rows.Add("MGW_6A", "2015_May", 0)
    dt.Rows.Add("MGW_6A", "2015_Jun", 0)
    dt.Rows.Add("MGW_6A", "2015_Jul", 0)
    dt.Rows.Add("MGW_6A", "2015_Aug", 2)
    dt.Rows.Add("MGW_6A", "2015_Sep", 1)
    dt.Rows.Add("MGW_6A", "2015_Oct", 0)
    dt.Rows.Add("MGW_6A", "2015_Nov", 0)
    dt.Rows.Add("MGW_6A", "2015_Dec", 0)
    dt.Rows.Add("MGW_6A", "2016_Jan", 2)
    dt.Rows.Add("MGW_6A", "2016_Feb", 0)
    dt.Rows.Add("MGW_6A", "2016_Mar", 2)
    dt.Rows.Add("MGW_6A", "2016_Apr", 0)
    dt.Rows.Add("MGW_6A", "2016_May", 1)
    dt.Rows.Add("MGW_6A", "2016_Jun", 2)
    dt.Rows.Add("MGW_6A", "2016_Jul", 0)
    dt.Rows.Add("MGW_6A", "2016_Aug", 2)
    dt.Rows.Add("MGW_6A", "2016_Sep", 2)
    dt.Rows.Add("MGW_6A", "2016_Oct", 1)
    dt.Rows.Add("MGW_6A", "2016_Nov", 1)
    dt.Rows.Add("MGW_6A", "2016_Dec", 2)
    dt.Rows.Add("MGW_6A", "2017_Jan", 3)
    dt.Rows.Add("MGW_6A", "2017_Feb", 1)
    dt.Rows.Add("MGW_6A", "2017_Mar", 1)
    dt.Rows.Add("MGW_6A", "2017_Apr", 2)
    dt.Rows.Add("MGW_6A", "2017_May", 1)
    dt.Rows.Add("MGW_6A", "2017_Jun", 0)
    dt.Rows.Add("MGW_6A", "2017_Jul", 0)
    dt.Rows.Add("MGW_6A", "2017_Aug", 1)
    dt.Rows.Add("MGW_6A", "2017_Sep", 0)
    dt.Rows.Add("MGW_6A", "2017_Oct", 0)
    dt.Rows.Add("MGW_6A", "2017_Nov", 0)
    dt.Rows.Add("MGW_6A", "2017_Dec", 0)
    dt.Rows.Add("MGW_6A", "2018_Jan", 0)
    dt.Rows.Add("MGW_6A", "2018_Feb", 0)
    dt.Rows.Add("MGW_6A", "2018_Mar", 0)
    dt.Rows.Add("MGW_6A", "2018_Apr", 0)
    dt.Rows.Add("MGW_6A", "2018_May", 1)
    dt.Rows.Add("MGW_6A", "2018_Jun", 0)
    dt.Rows.Add("MGW_6A", "2018_Jul", 1)
    dt.Rows.Add("MGW_6A", "2018_Aug", 1)
    dt.Rows.Add("MGW_6A", "2018_Sep", 0)
    dt.Rows.Add("MGW_6A", "2018_Oct", 0)
    dt.Rows.Add("MGW_6A", "2018_Nov", 1)
    dt.Rows.Add("MGW_6A", "2018_Dec", 0)
    dt.Rows.Add("MGW_6A", "2019_Jan", 0)
    dt.Rows.Add("MGW_6A", "2019_Feb", 1)
    dt.Rows.Add("MGW_6A", "2019_Mar", 0)
    dt.Rows.Add("MGW_6A", "2019_Apr", 1)
    dt.Rows.Add("MGW_6A", "2019_May", 0)
    dt.Rows.Add("MGW_6A", "2019_Jun", 0)
    dt.Rows.Add("MGW_6A", "2019_Jul", 0)
    dt.Rows.Add("MGW_6A", "2019_Aug", 0)
    dt.Rows.Add("MGW_6A", "2019_Sep", 0)
    dt.Rows.Add("MGW_6A", "2019_Oct", 1)
    dt.Rows.Add("MGW_6A", "2019_Nov", 0)
    dt.Rows.Add("MGW_6A", "2019_Dec", 0)
    dt.Rows.Add("MGW_6A", "2020_Jan", 1)
    dt.Rows.Add("MGW_6B", "2015_Jan", 0)
    dt.Rows.Add("MGW_6B", "2015_Feb", 0)
    dt.Rows.Add("MGW_6B", "2015_Mar", 0)
    dt.Rows.Add("MGW_6B", "2015_Apr", 0)
    dt.Rows.Add("MGW_6B", "2015_May", 0)
    dt.Rows.Add("MGW_6B", "2015_Jun", 0)
    dt.Rows.Add("MGW_6B", "2015_Jul", 2)
    dt.Rows.Add("MGW_6B", "2015_Aug", 2)
    dt.Rows.Add("MGW_6B", "2015_Sep", 2)
    dt.Rows.Add("MGW_6B", "2015_Oct", 1)
    dt.Rows.Add("MGW_6B", "2015_Nov", 0)
    dt.Rows.Add("MGW_6B", "2015_Dec", 0)
    dt.Rows.Add("MGW_6B", "2016_Jan", 0)
    dt.Rows.Add("MGW_6B", "2016_Feb", 0)
    dt.Rows.Add("MGW_6B", "2016_Mar", 0)
    dt.Rows.Add("MGW_6B", "2016_Apr", 0)
    dt.Rows.Add("MGW_6B", "2016_May", 0)
    dt.Rows.Add("MGW_6B", "2016_Jun", 2)
    dt.Rows.Add("MGW_6B", "2016_Jul", 0)
    dt.Rows.Add("MGW_6B", "2016_Aug", 1)
    dt.Rows.Add("MGW_6B", "2016_Sep", 2)
    dt.Rows.Add("MGW_6B", "2016_Oct", 1)
    dt.Rows.Add("MGW_6B", "2016_Nov", 1)
    dt.Rows.Add("MGW_6B", "2016_Dec", 3)
    dt.Rows.Add("MGW_6B", "2017_Jan", 0)
    dt.Rows.Add("MGW_6B", "2017_Feb", 1)
    dt.Rows.Add("MGW_6B", "2017_Mar", 1)
    dt.Rows.Add("MGW_6B", "2017_Apr", 1)
    dt.Rows.Add("MGW_6B", "2017_May", 0)
    dt.Rows.Add("MGW_6B", "2017_Jun", 3)
    dt.Rows.Add("MGW_6B", "2017_Jul", 1)
    dt.Rows.Add("MGW_6B", "2017_Aug", 2)
    dt.Rows.Add("MGW_6B", "2017_Sep", 0)
    dt.Rows.Add("MGW_6B", "2017_Oct", 1)
    dt.Rows.Add("MGW_6B", "2017_Nov", 1)
    dt.Rows.Add("MGW_6B", "2017_Dec", 0)
    dt.Rows.Add("MGW_6B", "2018_Jan", 1)
    dt.Rows.Add("MGW_6B", "2018_Feb", 0)
    dt.Rows.Add("MGW_6B", "2018_Mar", 0)
    dt.Rows.Add("MGW_6B", "2018_Apr", 2)
    dt.Rows.Add("MGW_6B", "2018_May", 3)
    dt.Rows.Add("MGW_6B", "2018_Jun", 2)
    dt.Rows.Add("MGW_6B", "2018_Jul", 1)
    dt.Rows.Add("MGW_6B", "2018_Aug", 4)
    dt.Rows.Add("MGW_6B", "2018_Sep", 1)
    dt.Rows.Add("MGW_6B", "2018_Oct", 1)
    dt.Rows.Add("MGW_6B", "2018_Nov", 3)
    dt.Rows.Add("MGW_6B", "2018_Dec", 1)
    dt.Rows.Add("MGW_6B", "2019_Jan", 2)
    dt.Rows.Add("MGW_6B", "2019_Feb", 1)
    dt.Rows.Add("MGW_6B", "2019_Mar", 0)
    dt.Rows.Add("MGW_6B", "2019_Apr", 4)
    dt.Rows.Add("MGW_6B", "2019_May", 1)
    dt.Rows.Add("MGW_6B", "2019_Jun", 0)
    dt.Rows.Add("MGW_6B", "2019_Jul", 1)
    dt.Rows.Add("MGW_6B", "2019_Aug", 3)
    dt.Rows.Add("MGW_6B", "2019_Sep", 3)
    dt.Rows.Add("MGW_6B", "2019_Oct", 4)
    dt.Rows.Add("MGW_6B", "2019_Nov", 2)
    dt.Rows.Add("MGW_6B", "2019_Dec", 2)
    dt.Rows.Add("MGW_6B", "2020_Jan", 0)
    dt.Rows.Add("MGW_9B", "2015_Jan", 0)
    dt.Rows.Add("MGW_9B", "2015_Feb", 0)
    dt.Rows.Add("MGW_9B", "2015_Mar", 0)
    dt.Rows.Add("MGW_9B", "2015_Apr", 0)
    dt.Rows.Add("MGW_9B", "2015_May", 0)
    dt.Rows.Add("MGW_9B", "2015_Jun", 0)
    dt.Rows.Add("MGW_9B", "2015_Jul", 2)
    dt.Rows.Add("MGW_9B", "2015_Aug", 2)
    dt.Rows.Add("MGW_9B", "2015_Sep", 2)
    dt.Rows.Add("MGW_9B", "2015_Oct", 3)
    dt.Rows.Add("MGW_9B", "2015_Nov", 1)
    dt.Rows.Add("MGW_9B", "2015_Dec", 2)
    dt.Rows.Add("MGW_9B", "2016_Jan", 1)
    dt.Rows.Add("MGW_9B", "2016_Feb", 2)
    dt.Rows.Add("MGW_9B", "2016_Mar", 0)
    dt.Rows.Add("MGW_9B", "2016_Apr", 3)
    dt.Rows.Add("MGW_9B", "2016_May", 3)
    dt.Rows.Add("MGW_9B", "2016_Jun", 1)
    dt.Rows.Add("MGW_9B", "2016_Jul", 1)
    dt.Rows.Add("MGW_9B", "2016_Aug", 2)
    dt.Rows.Add("MGW_9B", "2016_Sep", 0)
    dt.Rows.Add("MGW_9B", "2016_Oct", 1)
    dt.Rows.Add("MGW_9B", "2016_Nov", 2)
    dt.Rows.Add("MGW_9B", "2016_Dec", 1)
    dt.Rows.Add("MGW_9B", "2017_Jan", 1)
    dt.Rows.Add("MGW_9B", "2017_Feb", 0)
    dt.Rows.Add("MGW_9B", "2017_Mar", 2)
    dt.Rows.Add("MGW_9B", "2017_Apr", 3)
    dt.Rows.Add("MGW_9B", "2017_May", 3)
    dt.Rows.Add("MGW_9B", "2017_Jun", 0)
    dt.Rows.Add("MGW_9B", "2017_Jul", 2)
    dt.Rows.Add("MGW_9B", "2017_Aug", 1)
    dt.Rows.Add("MGW_9B", "2017_Sep", 0)
    dt.Rows.Add("MGW_9B", "2017_Oct", 0)
    dt.Rows.Add("MGW_9B", "2017_Nov", 0)
    dt.Rows.Add("MGW_9B", "2017_Dec", 0)
    dt.Rows.Add("MGW_9B", "2018_Jan", 2)
    dt.Rows.Add("MGW_9B", "2018_Feb", 0)
    dt.Rows.Add("MGW_9B", "2018_Mar", 1)
    dt.Rows.Add("MGW_9B", "2018_Apr", 2)
    dt.Rows.Add("MGW_9B", "2018_May", 1)
    dt.Rows.Add("MGW_9B", "2018_Jun", 1)
    dt.Rows.Add("MGW_9B", "2018_Jul", 0)
    dt.Rows.Add("MGW_9B", "2018_Aug", 2)
    dt.Rows.Add("MGW_9B", "2018_Sep", 1)
    dt.Rows.Add("MGW_9B", "2018_Oct", 2)
    dt.Rows.Add("MGW_9B", "2018_Nov", 4)
    dt.Rows.Add("MGW_9B", "2018_Dec", 4)
    dt.Rows.Add("MGW_9B", "2019_Jan", 1)
    dt.Rows.Add("MGW_9B", "2019_Feb", 2)
    dt.Rows.Add("MGW_9B", "2019_Mar", 2)
    dt.Rows.Add("MGW_9B", "2019_Apr", 1)
    dt.Rows.Add("MGW_9B", "2019_May", 4)
    dt.Rows.Add("MGW_9B", "2019_Jun", 2)
    dt.Rows.Add("MGW_9B", "2019_Jul", 2)
    dt.Rows.Add("MGW_9B", "2019_Aug", 1)
    dt.Rows.Add("MGW_9B", "2019_Sep", 1)
    dt.Rows.Add("MGW_9B", "2019_Oct", 0)
    dt.Rows.Add("MGW_9B", "2019_Nov", 1)
    dt.Rows.Add("MGW_9B", "2019_Dec", 1)
    dt.Rows.Add("MGW_9B", "2020_Jan", 2)
    dt.Rows.Add("MGW_CCU", "2015_Jan", 0)
    dt.Rows.Add("MGW_CCU", "2015_Feb", 0)
    dt.Rows.Add("MGW_CCU", "2015_Mar", 0)
    dt.Rows.Add("MGW_CCU", "2015_Apr", 0)
    dt.Rows.Add("MGW_CCU", "2015_May", 0)
    dt.Rows.Add("MGW_CCU", "2015_Jun", 0)
    dt.Rows.Add("MGW_CCU", "2015_Jul", 0)
    dt.Rows.Add("MGW_CCU", "2015_Aug", 0)
    dt.Rows.Add("MGW_CCU", "2015_Sep", 0)
    dt.Rows.Add("MGW_CCU", "2015_Oct", 0)
    dt.Rows.Add("MGW_CCU", "2015_Nov", 0)
    dt.Rows.Add("MGW_CCU", "2015_Dec", 0)
    dt.Rows.Add("MGW_CCU", "2016_Jan", 0)
    dt.Rows.Add("MGW_CCU", "2016_Feb", 0)
    dt.Rows.Add("MGW_CCU", "2016_Mar", 0)
    dt.Rows.Add("MGW_CCU", "2016_Apr", 0)
    dt.Rows.Add("MGW_CCU", "2016_May", 0)
    dt.Rows.Add("MGW_CCU", "2016_Jun", 0)
    dt.Rows.Add("MGW_CCU", "2016_Jul", 0)
    dt.Rows.Add("MGW_CCU", "2016_Aug", 0)
    dt.Rows.Add("MGW_CCU", "2016_Sep", 0)
    dt.Rows.Add("MGW_CCU", "2016_Oct", 0)
    dt.Rows.Add("MGW_CCU", "2016_Nov", 0)
    dt.Rows.Add("MGW_CCU", "2016_Dec", 0)
    dt.Rows.Add("MGW_CCU", "2017_Jan", 0)
    dt.Rows.Add("MGW_CCU", "2017_Feb", 0)
    dt.Rows.Add("MGW_CCU", "2017_Mar", 0)
    dt.Rows.Add("MGW_CCU", "2017_Apr", 0)
    dt.Rows.Add("MGW_CCU", "2017_May", 0)
    dt.Rows.Add("MGW_CCU", "2017_Jun", 0)
    dt.Rows.Add("MGW_CCU", "2017_Jul", 0)
    dt.Rows.Add("MGW_CCU", "2017_Aug", 0)
    dt.Rows.Add("MGW_CCU", "2017_Sep", 0)
    dt.Rows.Add("MGW_CCU", "2017_Oct", 0)
    dt.Rows.Add("MGW_CCU", "2017_Nov", 0)
    dt.Rows.Add("MGW_CCU", "2017_Dec", 0)
    dt.Rows.Add("MGW_CCU", "2018_Jan", 0)
    dt.Rows.Add("MGW_CCU", "2018_Feb", 0)
    dt.Rows.Add("MGW_CCU", "2018_Mar", 0)
    dt.Rows.Add("MGW_CCU", "2018_Apr", 0)
    dt.Rows.Add("MGW_CCU", "2018_May", 0)
    dt.Rows.Add("MGW_CCU", "2018_Jun", 0)
    dt.Rows.Add("MGW_CCU", "2018_Jul", 0)
    dt.Rows.Add("MGW_CCU", "2018_Aug", 0)
    dt.Rows.Add("MGW_CCU", "2018_Sep", 0)
    dt.Rows.Add("MGW_CCU", "2018_Oct", 0)
    dt.Rows.Add("MGW_CCU", "2018_Nov", 0)
    dt.Rows.Add("MGW_CCU", "2018_Dec", 0)
    dt.Rows.Add("MGW_CCU", "2019_Jan", 0)
    dt.Rows.Add("MGW_CCU", "2019_Feb", 0)
    dt.Rows.Add("MGW_CCU", "2019_Mar", 0)
    dt.Rows.Add("MGW_CCU", "2019_Apr", 0)
    dt.Rows.Add("MGW_CCU", "2019_May", 0)
    dt.Rows.Add("MGW_CCU", "2019_Jun", 0)
    dt.Rows.Add("MGW_CCU", "2019_Jul", 0)
    dt.Rows.Add("MGW_CCU", "2019_Aug", 0)
    dt.Rows.Add("MGW_CCU", "2019_Sep", 0)
    dt.Rows.Add("MGW_CCU", "2019_Oct", 0)
    dt.Rows.Add("MGW_CCU", "2019_Nov", 0)
    dt.Rows.Add("MGW_CCU", "2019_Dec", 0)
    dt.Rows.Add("MGW_CCU", "2020_Jan", 0)
    dt.Rows.Add("MGW_MANE", "2018_Oct", 1)
    dt.Rows.Add("MGW_MANE", "2018_Nov", 0)
    dt.Rows.Add("MGW_MANE", "2018_Dec", 0)
    dt.Rows.Add("MGW_MANE", "2019_Jan", 0)
    dt.Rows.Add("MGW_MANE", "2019_Feb", 0)
    dt.Rows.Add("MGW_MANE", "2019_Mar", 0)
    dt.Rows.Add("MGW_MANE", "2019_Apr", 1)
    dt.Rows.Add("MGW_MANE", "2019_May", 0)
    dt.Rows.Add("MGW_MANE", "2019_Jun", 0)
    dt.Rows.Add("MGW_MANE", "2019_Jul", 0)
    dt.Rows.Add("MGW_MANE", "2019_Aug", 0)
    dt.Rows.Add("MGW_MANE", "2019_Sep", 0)
    dt.Rows.Add("MGW_MANE", "2019_Oct", 0)
    dt.Rows.Add("MGW_MANE", "2019_Nov", 0)
    dt.Rows.Add("MGW_MANE", "2019_Dec", 0)
    dt.Rows.Add("MGW_MANE", "2020_Jan", 0)


    gvInt.DataSource = dt
    gvInt.DataBind()

    Dim dtInt As DataTable = New DataTable("dtInts")
    For Each cell As TableCell In gvInt.HeaderRow.Cells
        dtInt.Columns.Add(cell.Text.Trim())
    Next
    For Each row As GridViewRow In gvInt.Rows
        dtInt.Rows.Add()
        For i As Integer = 0 To row.Cells.Count - 1
            dtInt.Rows(row.RowIndex)(i) = row.Cells(i).Text.Trim()
        Next
    Next

    Dim departments As List(Of String) = New List(Of String)()
    departments = (From p In dtInt.AsEnumerable()
                    Select p.Field(Of String)("Department")).Distinct().ToList()

    If RateChart.Series.Count() = 1 Then
        RateChart.Series.Remove(RateChart.Series(0))
    End If

    For Each department As String In departments.ToList()
        Dim department1 As String = department
        Dim x As String()
        x = (From p In dtInt.AsEnumerable()
                Where p.Field(Of String)("Department") = department1
                Order By p.Field(Of String)("Period_Shown")
                Select p.Field(Of String)("Period_Shown")).ToArray()

        Dim y As Decimal()
        y = (From p In dtInt.AsEnumerable()
                Where p.Field(Of String)("Department") = department1
                Order By p.Field(Of String)("Period_Shown")
                Select Convert.ToDecimal(p.Field(Of String)("Num_Int"))).ToArray()

        RateChart.Series.Add(New Series(department1))
        RateChart.Series(department1).IsValueShownAsLabel = False
        RateChart.Series(department1).BorderWidth = 3
        RateChart.Series(department1).ChartType = SeriesChartType.Line
        RateChart.Series(department1).Points.DataBindXY(x, y)
        RateChart.Series(department1).MarkerStyle = MarkerStyle.Star10
    Next

    RateChart.Legends.Add("Default")
    RateChart.Legends(0).Docking = Docking.Bottom
    RateChart.Legends(0).IsTextAutoFit = True
    RateChart.Legends(0).Alignment = Drawing.StringAlignment.Center
    RateChart.Legends(0).Enabled = True
    RateChart.ChartAreas(0).AxisX.Interval = 1
End Sub

Screenshot

Create multi-series line Chart with huge (large) data using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us