<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2025.2" RunE2="T">
  <Nodes>
    <Node ToolID="4">
      <GuiSettings Plugin="AlteryxConnectorGui.Download.Download">
        <Position x="234" y="186" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <URLField>url</URLField>
          <OutputMode>String</OutputMode>
          <CodePage>65001</CodePage>
          <EncodeURLs value="True" />
          <Headers>
            <NameValues />
            <Fields orderChanged="False">
              <Field name="codEstacao" selected="False" />
              <Field name="tipoDados" selected="False" />
              <Field name="url" selected="False" />
              <Field name="*Unknown" selected="False" />
            </Fields>
          </Headers>
          <Payload>
            <HTTPAction>GET</HTTPAction>
            <QueryStringBodyMode>Compose</QueryStringBodyMode>
            <ComposeNameValues />
            <ComposeFields orderChanged="False">
              <Field name="codEstacao" selected="False" />
              <Field name="tipoDados" selected="False" />
              <Field name="url" selected="False" />
              <Field name="*Unknown" selected="False" />
            </ComposeFields>
          </Payload>
          <numConnections>1</numConnections>
          <Timeout>600</Timeout>
          <EnableRPM value="False" />
          <DcmAdvancedAuth value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
            <Field name="DownloadData" size="1073741823" source="Download" type="V_WString" />
            <Field name="DownloadHeaders" size="2147483647" source="Download" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxConnectorEngine.dll" EngineDllEntryPoint="AlteryxDownload" />
    </Node>
    <Node ToolID="6">
      <GuiSettings Plugin="AlteryxBasePluginsGui.XMLParse.XMLParse">
        <Position x="318" y="186" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <XMLField>DownloadData</XMLField>
          <XMLElement />
          <ChildValues value="True" />
          <OuterXML value="False" />
          <ParseRoot value="False" />
          <IgnoreErrors value="False" />
          <IncludeInOutput value="True" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
            <Field name="DownloadData" size="1073741823" source="Download" type="V_WString" />
            <Field name="DownloadHeaders" size="2147483647" source="Download" type="V_String" />
            <Field name="SerieHistorica" size="709" type="V_String" />
            <Field name="diffgr:id" size="16" type="V_String" />
            <Field name="msdata:rowOrder" size="2" type="V_String" />
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="NivelConsistencia" size="1" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="MediaDiaria" size="1" type="V_String" />
            <Field name="MetodoObtencaoVazoes" size="1" type="V_String" />
            <Field name="Maxima" size="7" type="V_String" />
            <Field name="Minima" size="7" type="V_String" />
            <Field name="Media" size="7" type="V_String" />
            <Field name="DiaMaxima" size="2" type="V_String" />
            <Field name="DiaMinima" size="2" type="V_String" />
            <Field name="MaximaStatus" size="1" type="V_String" />
            <Field name="MinimaStatus" size="1" type="V_String" />
            <Field name="MediaStatus" size="1" type="V_String" />
            <Field name="MediaAnual" size="7" type="V_String" />
            <Field name="MediaAnualStatus" size="1" type="V_String" />
            <Field name="Vazao01" size="7" type="V_String" />
            <Field name="Vazao02" size="7" type="V_String" />
            <Field name="Vazao03" size="7" type="V_String" />
            <Field name="Vazao04" size="7" type="V_String" />
            <Field name="Vazao05" size="7" type="V_String" />
            <Field name="Vazao06" size="7" type="V_String" />
            <Field name="Vazao07" size="7" type="V_String" />
            <Field name="Vazao08" size="7" type="V_String" />
            <Field name="Vazao09" size="7" type="V_String" />
            <Field name="Vazao10" size="7" type="V_String" />
            <Field name="Vazao11" size="7" type="V_String" />
            <Field name="Vazao12" size="7" type="V_String" />
            <Field name="Vazao13" size="7" type="V_String" />
            <Field name="Vazao14" size="7" type="V_String" />
            <Field name="Vazao15" size="7" type="V_String" />
            <Field name="Vazao16" size="7" type="V_String" />
            <Field name="Vazao17" size="7" type="V_String" />
            <Field name="Vazao18" size="7" type="V_String" />
            <Field name="Vazao19" size="7" type="V_String" />
            <Field name="Vazao20" size="7" type="V_String" />
            <Field name="Vazao21" size="7" type="V_String" />
            <Field name="Vazao22" size="7" type="V_String" />
            <Field name="Vazao23" size="7" type="V_String" />
            <Field name="Vazao24" size="7" type="V_String" />
            <Field name="Vazao25" size="7" type="V_String" />
            <Field name="Vazao26" size="7" type="V_String" />
            <Field name="Vazao27" size="7" type="V_String" />
            <Field name="Vazao28" size="7" type="V_String" />
            <Field name="Vazao29" size="7" type="V_String" />
            <Field name="Vazao30" size="7" type="V_String" />
            <Field name="Vazao31" size="7" type="V_String" />
            <Field name="Vazao01Status" size="1" type="V_String" />
            <Field name="Vazao02Status" size="1" type="V_String" />
            <Field name="Vazao03Status" size="1" type="V_String" />
            <Field name="Vazao04Status" size="1" type="V_String" />
            <Field name="Vazao05Status" size="1" type="V_String" />
            <Field name="Vazao06Status" size="1" type="V_String" />
            <Field name="Vazao07Status" size="1" type="V_String" />
            <Field name="Vazao08Status" size="1" type="V_String" />
            <Field name="Vazao09Status" size="1" type="V_String" />
            <Field name="Vazao10Status" size="1" type="V_String" />
            <Field name="Vazao11Status" size="1" type="V_String" />
            <Field name="Vazao12Status" size="1" type="V_String" />
            <Field name="Vazao13Status" size="1" type="V_String" />
            <Field name="Vazao14Status" size="1" type="V_String" />
            <Field name="Vazao15Status" size="1" type="V_String" />
            <Field name="Vazao16Status" size="1" type="V_String" />
            <Field name="Vazao17Status" size="1" type="V_String" />
            <Field name="Vazao18Status" size="1" type="V_String" />
            <Field name="Vazao19Status" size="1" type="V_String" />
            <Field name="Vazao20Status" size="1" type="V_String" />
            <Field name="Vazao21Status" size="1" type="V_String" />
            <Field name="Vazao22Status" size="1" type="V_String" />
            <Field name="Vazao23Status" size="1" type="V_String" />
            <Field name="Vazao24Status" size="1" type="V_String" />
            <Field name="Vazao25Status" size="1" type="V_String" />
            <Field name="Vazao26Status" size="1" type="V_String" />
            <Field name="Vazao27Status" size="1" type="V_String" />
            <Field name="Vazao28Status" size="1" type="V_String" />
            <Field name="Vazao29Status" size="1" type="V_String" />
            <Field name="Vazao30Status" size="1" type="V_String" />
            <Field name="Vazao31Status" size="1" type="V_String" />
            <Field name="DataIns" size="19" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxXMLParse" />
    </Node>
    <Node ToolID="8">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
        <Position x="474" y="66" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <ErrorWarn>Warn</ErrorWarn>
          <KeyFields>
            <Field field="EstacaoCodigo" />
            <Field field="DataHora" />
          </KeyFields>
          <DataFields>
            <Field field="codEstacao" selected="False" />
            <Field field="loc_des" selected="False" />
            <Field field="tipoDados" selected="False" />
            <Field field="Field4" selected="False" />
            <Field field="url" selected="False" />
            <Field field="DownloadData" selected="False" />
            <Field field="DownloadHeaders" selected="False" />
            <Field field="SerieHistorica" selected="False" />
            <Field field="diffgr:id" selected="False" />
            <Field field="msdata:rowOrder" selected="False" />
            <Field field="EstacaoCodigo" selected="False" />
            <Field field="NivelConsistencia" selected="False" />
            <Field field="DataHora" selected="False" />
            <Field field="MediaDiaria" selected="False" />
            <Field field="MetodoObtencaoVazoes" selected="False" />
            <Field field="Maxima" selected="False" />
            <Field field="Minima" selected="False" />
            <Field field="Media" selected="False" />
            <Field field="DiaMaxima" selected="False" />
            <Field field="DiaMinima" selected="False" />
            <Field field="MaximaStatus" selected="False" />
            <Field field="MinimaStatus" selected="False" />
            <Field field="MediaStatus" selected="False" />
            <Field field="MediaAnual" selected="False" />
            <Field field="MediaAnualStatus" selected="False" />
            <Field field="Vazao01" selected="True" />
            <Field field="Vazao02" selected="True" />
            <Field field="Vazao03" selected="True" />
            <Field field="Vazao04" selected="True" />
            <Field field="Vazao05" selected="True" />
            <Field field="Vazao06" selected="True" />
            <Field field="Vazao07" selected="True" />
            <Field field="Vazao08" selected="True" />
            <Field field="Vazao09" selected="True" />
            <Field field="Vazao10" selected="True" />
            <Field field="Vazao11" selected="True" />
            <Field field="Vazao12" selected="True" />
            <Field field="Vazao13" selected="True" />
            <Field field="Vazao14" selected="True" />
            <Field field="Vazao15" selected="True" />
            <Field field="Vazao16" selected="True" />
            <Field field="Vazao17" selected="True" />
            <Field field="Vazao18" selected="True" />
            <Field field="Vazao19" selected="True" />
            <Field field="Vazao20" selected="True" />
            <Field field="Vazao21" selected="True" />
            <Field field="Vazao22" selected="True" />
            <Field field="Vazao23" selected="True" />
            <Field field="Vazao24" selected="True" />
            <Field field="Vazao25" selected="True" />
            <Field field="Vazao26" selected="True" />
            <Field field="Vazao27" selected="True" />
            <Field field="Vazao28" selected="True" />
            <Field field="Vazao29" selected="True" />
            <Field field="Vazao30" selected="True" />
            <Field field="Vazao31" selected="True" />
            <Field field="Vazao01Status" selected="False" />
            <Field field="Vazao02Status" selected="False" />
            <Field field="Vazao03Status" selected="False" />
            <Field field="Vazao04Status" selected="False" />
            <Field field="Vazao05Status" selected="False" />
            <Field field="Vazao06Status" selected="False" />
            <Field field="Vazao07Status" selected="False" />
            <Field field="Vazao08Status" selected="False" />
            <Field field="Vazao09Status" selected="False" />
            <Field field="Vazao10Status" selected="False" />
            <Field field="Vazao11Status" selected="False" />
            <Field field="Vazao12Status" selected="False" />
            <Field field="Vazao13Status" selected="False" />
            <Field field="Vazao14Status" selected="False" />
            <Field field="Vazao15Status" selected="False" />
            <Field field="Vazao16Status" selected="False" />
            <Field field="Vazao17Status" selected="False" />
            <Field field="Vazao18Status" selected="False" />
            <Field field="Vazao19Status" selected="False" />
            <Field field="Vazao20Status" selected="False" />
            <Field field="Vazao21Status" selected="False" />
            <Field field="Vazao22Status" selected="False" />
            <Field field="Vazao23Status" selected="False" />
            <Field field="Vazao24Status" selected="False" />
            <Field field="Vazao25Status" selected="False" />
            <Field field="Vazao26Status" selected="False" />
            <Field field="Vazao27Status" selected="False" />
            <Field field="Vazao28Status" selected="False" />
            <Field field="Vazao29Status" selected="False" />
            <Field field="Vazao30Status" selected="False" />
            <Field field="Vazao31Status" selected="False" />
            <Field field="DataIns" selected="False" />
            <Field field="TipoMedicaoCotas" selected="False" />
            <Field field="Cota01" selected="False" />
            <Field field="Cota04" selected="False" />
            <Field field="Cota05" selected="False" />
            <Field field="Cota06" selected="False" />
            <Field field="Cota07" selected="False" />
            <Field field="Cota08" selected="False" />
            <Field field="Cota11" selected="False" />
            <Field field="Cota12" selected="False" />
            <Field field="Cota13" selected="False" />
            <Field field="Cota14" selected="False" />
            <Field field="Cota15" selected="False" />
            <Field field="Cota18" selected="False" />
            <Field field="Cota19" selected="False" />
            <Field field="Cota20" selected="False" />
            <Field field="Cota21" selected="False" />
            <Field field="Cota22" selected="False" />
            <Field field="Cota25" selected="False" />
            <Field field="Cota26" selected="False" />
            <Field field="Cota27" selected="False" />
            <Field field="Cota28" selected="False" />
            <Field field="Cota29" selected="False" />
            <Field field="Cota01Status" selected="False" />
            <Field field="Cota02Status" selected="False" />
            <Field field="Cota03Status" selected="False" />
            <Field field="Cota04Status" selected="False" />
            <Field field="Cota05Status" selected="False" />
            <Field field="Cota06Status" selected="False" />
            <Field field="Cota07Status" selected="False" />
            <Field field="Cota08Status" selected="False" />
            <Field field="Cota09Status" selected="False" />
            <Field field="Cota10Status" selected="False" />
            <Field field="Cota11Status" selected="False" />
            <Field field="Cota12Status" selected="False" />
            <Field field="Cota13Status" selected="False" />
            <Field field="Cota14Status" selected="False" />
            <Field field="Cota15Status" selected="False" />
            <Field field="Cota16Status" selected="False" />
            <Field field="Cota17Status" selected="False" />
            <Field field="Cota18Status" selected="False" />
            <Field field="Cota19Status" selected="False" />
            <Field field="Cota20Status" selected="False" />
            <Field field="Cota21Status" selected="False" />
            <Field field="Cota22Status" selected="False" />
            <Field field="Cota23Status" selected="False" />
            <Field field="Cota24Status" selected="False" />
            <Field field="Cota25Status" selected="False" />
            <Field field="Cota26Status" selected="False" />
            <Field field="Cota27Status" selected="False" />
            <Field field="Cota28Status" selected="False" />
            <Field field="Cota29Status" selected="False" />
            <Field field="Cota30Status" selected="False" />
            <Field field="Cota31Status" selected="False" />
            <Field field="Cota02" selected="False" />
            <Field field="Cota03" selected="False" />
            <Field field="Cota09" selected="False" />
            <Field field="Cota10" selected="False" />
            <Field field="Cota16" selected="False" />
            <Field field="Cota17" selected="False" />
            <Field field="Cota23" selected="False" />
            <Field field="Cota24" selected="False" />
            <Field field="Cota30" selected="False" />
            <Field field="Cota31" selected="False" />
            <Field field="*Unknown" selected="False" />
          </DataFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="7" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
    </Node>
    <Node ToolID="9">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="678" y="54" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="RIGHT([Name],2)&#xA;&#xA;" field="Dia" size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" field="sample_date" size="10" type="Date" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Dia = RIGHT([Name],2)


sample_date = DateTimeParse(
DateTimeFormat([DataHora],"...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="7" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: RIGHT([Name],2)&#xA;&#xA;" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="11">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="570" y="66" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber(RIGHT([Name],2)) &lt;=
ToNumber(DateTimeFormat(
    DateTimeAdd(
        DateTimeAdd(DateTimeTrim([DataHora], "month"), 1, "months"),
        -1,
        "days"
    ),
    "%d"
))</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber(RIGHT([Name],2)) &lt;=
ToNumber...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="True">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="7" type="V_String" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="False">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="7" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="13">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
        <Position x="462" y="294" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <ErrorWarn>Warn</ErrorWarn>
          <KeyFields>
            <Field field="EstacaoCodigo" />
            <Field field="DataHora" />
          </KeyFields>
          <DataFields>
            <Field field="codEstacao" selected="False" />
            <Field field="dataInicio" selected="False" />
            <Field field="dataFim" selected="False" />
            <Field field="tipoDados" selected="False" />
            <Field field="nivelConsistencia" selected="False" />
            <Field field="url" selected="False" />
            <Field field="DownloadData" selected="False" />
            <Field field="DownloadHeaders" selected="False" />
            <Field field="SerieHistorica" selected="False" />
            <Field field="diffgr:id" selected="False" />
            <Field field="msdata:rowOrder" selected="False" />
            <Field field="EstacaoCodigo" selected="False" />
            <Field field="NivelConsistencia2" selected="False" />
            <Field field="DataHora" selected="False" />
            <Field field="MediaDiaria" selected="False" />
            <Field field="MetodoObtencaoVazoes" selected="False" />
            <Field field="Maxima" selected="False" />
            <Field field="Minima" selected="False" />
            <Field field="Media" selected="False" />
            <Field field="DiaMaxima" selected="False" />
            <Field field="DiaMinima" selected="False" />
            <Field field="MaximaStatus" selected="False" />
            <Field field="MinimaStatus" selected="False" />
            <Field field="MediaStatus" selected="False" />
            <Field field="MediaAnual" selected="False" />
            <Field field="MediaAnualStatus" selected="False" />
            <Field field="Vazao01" selected="False" />
            <Field field="Vazao02" selected="False" />
            <Field field="Vazao03" selected="False" />
            <Field field="Vazao04" selected="False" />
            <Field field="Vazao05" selected="False" />
            <Field field="Vazao06" selected="False" />
            <Field field="Vazao07" selected="False" />
            <Field field="Vazao08" selected="False" />
            <Field field="Vazao09" selected="False" />
            <Field field="Vazao10" selected="False" />
            <Field field="Vazao11" selected="False" />
            <Field field="Vazao12" selected="False" />
            <Field field="Vazao13" selected="False" />
            <Field field="Vazao14" selected="False" />
            <Field field="Vazao15" selected="False" />
            <Field field="Vazao16" selected="False" />
            <Field field="Vazao17" selected="False" />
            <Field field="Vazao18" selected="False" />
            <Field field="Vazao19" selected="False" />
            <Field field="Vazao20" selected="False" />
            <Field field="Vazao21" selected="False" />
            <Field field="Vazao22" selected="False" />
            <Field field="Vazao23" selected="False" />
            <Field field="Vazao24" selected="False" />
            <Field field="Vazao25" selected="False" />
            <Field field="Vazao26" selected="False" />
            <Field field="Vazao27" selected="False" />
            <Field field="Vazao28" selected="False" />
            <Field field="Vazao29" selected="False" />
            <Field field="Vazao30" selected="False" />
            <Field field="Vazao31" selected="False" />
            <Field field="Vazao01Status" selected="True" />
            <Field field="Vazao02Status" selected="True" />
            <Field field="Vazao03Status" selected="True" />
            <Field field="Vazao04Status" selected="True" />
            <Field field="Vazao05Status" selected="True" />
            <Field field="Vazao06Status" selected="True" />
            <Field field="Vazao07Status" selected="True" />
            <Field field="Vazao08Status" selected="True" />
            <Field field="Vazao09Status" selected="True" />
            <Field field="Vazao10Status" selected="True" />
            <Field field="Vazao11Status" selected="True" />
            <Field field="Vazao12Status" selected="True" />
            <Field field="Vazao13Status" selected="True" />
            <Field field="Vazao14Status" selected="True" />
            <Field field="Vazao15Status" selected="True" />
            <Field field="Vazao16Status" selected="True" />
            <Field field="Vazao17Status" selected="True" />
            <Field field="Vazao18Status" selected="True" />
            <Field field="Vazao19Status" selected="True" />
            <Field field="Vazao20Status" selected="True" />
            <Field field="Vazao21Status" selected="True" />
            <Field field="Vazao22Status" selected="True" />
            <Field field="Vazao23Status" selected="True" />
            <Field field="Vazao24Status" selected="True" />
            <Field field="Vazao25Status" selected="True" />
            <Field field="Vazao26Status" selected="True" />
            <Field field="Vazao27Status" selected="True" />
            <Field field="Vazao28Status" selected="True" />
            <Field field="Vazao29Status" selected="True" />
            <Field field="Vazao30Status" selected="True" />
            <Field field="Vazao31Status" selected="True" />
            <Field field="DataIns" selected="False" />
            <Field field="*Unknown" selected="False" />
          </DataFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="13" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
    </Node>
    <Node ToolID="14">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="558" y="294" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" field="Dia" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText><![CDATA[Dia = REGEX_Replace([Name], "Vazao|Status", "")
]]></DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="13" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="16">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
        <Position x="918" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration joinByRecordPos="False">
          <JoinInfo connection="Left">
            <Field field="EstacaoCodigo" />
            <Field field="sample_date" />
          </JoinInfo>
          <JoinInfo connection="Right">
            <Field field="EstacaoCodigo" />
            <Field field="sample_date" />
          </JoinInfo>
          <SelectConfiguration>
            <Configuration outputConnection="Join">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="Right_EstacaoCodigo" selected="True" rename="Right_EstacaoCodigo" input="Right_" />
                <SelectField field="Right_DataHora" selected="True" rename="Right_DataHora" input="Right_" />
                <SelectField field="Right_Name" selected="True" rename="Right_Name" input="Right_" />
                <SelectField field="Right_Value" selected="True" rename="Right_Value" input="Right_" />
                <SelectField field="Right_Dia" selected="True" rename="Right_Dia" input="Right_" />
                <SelectField field="Right_sample_date" selected="True" rename="Right_sample_date" input="Right_" />
                <SelectField field="*Unknown" selected="True" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Left">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="7" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: RIGHT([Name],2)&#xA;&#xA;" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="Join">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="7" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: RIGHT([Name],2)&#xA;&#xA;" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="Right_EstacaoCodigo" size="8" type="V_String" />
            <Field name="Right_DataHora" size="19" type="V_String" />
            <Field name="Right_Name" size="13" source="Transpose:" type="String" />
            <Field name="Right_Value" size="1" type="V_String" />
            <Field name="Right_Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="Right_sample_date" source="Formula: DateTimeParse(&#xA;    DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;    &quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="Right">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="13" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;    DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;    &quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
    </Node>
    <Node ToolID="17">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="798" y="282" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="DateTimeParse(&#xA;    DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;    &quot;%Y-%m-%d&quot;&#xA;)" field="sample_date" size="10" type="Date" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>sample_date = DateTimeParse(
    DateTimeFormat([DataHora], "%Y-%m-") + [Dia],
 ...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="13" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;    DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;    &quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="19">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="678" y="294" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber([Dia]) &lt;=
ToNumber(DateTimeFormat(
    DateTimeAdd(
        DateTimeAdd(DateTimeTrim([DataHora], "month"), 1, "months"),
        -1,
        "days"
    ),
    "%d"
))</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber([Dia]) &lt;=
ToNumber(DateTimeF...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="True">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="13" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="False">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="13" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="31">
      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
        <Position x="66" y="186" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <NumRows value="3" />
          <Fields>
            <Field name="codEstacao" />
            <Field name="tipoDados" />
          </Fields>
          <Data>
            <r>
              <c>40740000</c>
              <c>3</c>
            </r>
            <r>
              <c>41199998</c>
              <c>3</c>
            </r>
            <r>
              <c>56335000</c>
              <c>3</c>
            </r>
          </Data>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
    </Node>
    <Node ToolID="32">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="150" y="186" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="&quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" field="url" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>url = "https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codE...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="65">
      <GuiSettings Plugin="AlteryxGuiToolkit.Questions.Tab.Tab">
        <Position x="0" y="0" width="59" height="59" />
      </GuiSettings>
      <Properties>
        <Configuration />
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
    </Node>
    <Node ToolID="80">
      <GuiSettings Plugin="AlteryxBasePluginsGui.JoinMultiple.JoinMultiple">
        <Position x="1566" y="522" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <JoinByRecPos value="False" />
          <JoinFields>
            <JoinInfo connection="#1">
              <Field field="loc_name" />
              <Field field="sample_date_time" />
            </JoinInfo>
            <JoinInfo connection="#2">
              <Field field="loc_name" />
              <Field field="sample_date_time" />
            </JoinInfo>
            <JoinInfo connection="#3">
              <Field field="loc_name" />
              <Field field="sample_date_time" />
            </JoinInfo>
          </JoinFields>
          <CartesianMode>Error</CartesianMode>
          <OutputJoinOnly value="False" />
          <SelectConfiguration>
            <Configuration outputConnection="Output">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="Input_#1_loc_name" selected="True" />
                <SelectField field="Input_#1_Vazão" selected="True" />
                <SelectField field="Input_#1_sample_date_time" selected="True" />
                <SelectField field="Input_#1_loc_des" selected="True" />
                <SelectField field="Input_#1_periodo_sazonal_2" selected="True" />
                <SelectField field="Input_#2_loc_name" selected="False" rename="Input_#2_loc_name" />
                <SelectField field="Input_#2_sample_date_time" selected="False" rename="Input_#2_sample_date_time" />
                <SelectField field="Input_#2_Nível" selected="True" />
                <SelectField field="Input_#2_loc_des" selected="False" rename="Input_#2_loc_des" />
                <SelectField field="Input_#2_Ano_Mes " selected="False" rename="Input_#2_Ano_Mes " />
                <SelectField field="Input_#2_periodo_sazonal_2" selected="False" rename="Input_#2_periodo_sazonal_2" />
                <SelectField field="Input_#3_loc_name" selected="False" rename="Input_#3_loc_name" />
                <SelectField field="Input_#3_sample_date_time" selected="False" rename="Input_#3_sample_date_time" />
                <SelectField field="Input_#3_Chuva" selected="True" />
                <SelectField field="Input_#3_loc_des" selected="False" rename="Input_#3_loc_des" />
                <SelectField field="Input_#3_Ano_Mes " selected="False" rename="Input_#3_Ano_Mes " />
                <SelectField field="Input_#3_periodo_sazonal_2" selected="False" rename="Input_#3_periodo_sazonal_2" />
                <SelectField field="*Unknown" selected="False" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" source="Summarize: GroupBy - loc_name" type="V_String" />
            <Field name="Vazão" source="Summarize: Avg - Vazão" type="Double" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Nível" source="Summarize: Avg - Nível" type="Double" />
            <Field name="Chuva" source="Summarize: Sum - Chuva" type="Double" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoinMultiple" />
    </Node>
    <Node ToolID="82">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="1278" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="loc_name" action="GroupBy" rename="loc_name" />
            <SummarizeField field="Vazão" action="Avg" rename="Vazão" />
            <SummarizeField field="sample_date_time" action="GroupBy" rename="sample_date_time" />
            <SummarizeField field="loc_des" action="First" rename="loc_des" />
            <SummarizeField field="Ano_Mes " action="First" rename="Ano_Mes " />
            <SummarizeField field="periodo_sazonal_2" action="First" rename="periodo_sazonal_2" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" source="Summarize: GroupBy - loc_name" type="V_String" />
            <Field name="Vazão" source="Summarize: Avg - Vazão" type="Double" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Ano_Mes " size="1073741823" source="Formula: DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="83">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="1278" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="loc_name" action="GroupBy" rename="loc_name" />
            <SummarizeField field="sample_date_time" action="GroupBy" rename="sample_date_time" />
            <SummarizeField field="Nível" action="Avg" rename="Nível" />
            <SummarizeField field="loc_des" action="First" rename="loc_des" />
            <SummarizeField field="Ano_Mes " action="First" rename="Ano_Mes " />
            <SummarizeField field="periodo_sazonal_2" action="First" rename="periodo_sazonal_2" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" source="Summarize: GroupBy - loc_name" type="V_String" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="Nível" source="Summarize: Avg - Nível" type="Double" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Ano_Mes " size="1073741823" source="Formula: DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="84">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="1002" y="990" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="loc_name" action="GroupBy" rename="loc_name" />
            <SummarizeField field="sample_date_time" action="GroupBy" rename="sample_date_time" />
            <SummarizeField field="Chuva" action="Sum" rename="Chuva" />
            <SummarizeField field="loc_pluviometrico" action="First" rename="pluviometrico" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="2147483647" source="Summarize: GroupBy - loc_name" type="V_String" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="Chuva" source="Summarize: Sum - Chuva" type="Double" />
            <Field name="pluviometrico" size="2147483647" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="85">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="1662" y="522" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>!IsNull([Vazão])
AND !IsNull([Nível])</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>!IsNull([Vazão])
AND !IsNull([Nível])</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="True">
          <RecordInfo>
            <Field name="loc_name" size="8" source="Summarize: GroupBy - loc_name" type="V_String" />
            <Field name="Vazão" source="Summarize: Avg - Vazão" type="Double" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Nível" source="Summarize: Avg - Nível" type="Double" />
            <Field name="Chuva" source="Summarize: Sum - Chuva" type="Double" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="False">
          <RecordInfo>
            <Field name="loc_name" size="8" source="Summarize: GroupBy - loc_name" type="V_String" />
            <Field name="Vazão" source="Summarize: Avg - Vazão" type="Double" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Nível" source="Summarize: Avg - Nível" type="Double" />
            <Field name="Chuva" source="Summarize: Sum - Chuva" type="Double" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="86">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="1770" y="510" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="IF IsNull([Chuva]) THEN 0 ELSE [Chuva] ENDIF" field="loc_name" size="8" type="V_String" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText><![CDATA[loc_name = IF IsNull([Chuva]) THEN 0 ELSE [Chuva] ENDIF
]]></DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" source="Formula: IF IsNull([Chuva]) THEN 0 ELSE [Chuva] ENDIF" type="V_String" />
            <Field name="Vazão" source="Summarize: Avg - Vazão" type="Double" />
            <Field name="sample_date_time" source="Summarize: GroupBy - sample_date_time" type="Date" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Nível" source="Summarize: Avg - Nível" type="Double" />
            <Field name="Chuva" source="Summarize: Sum - Chuva" type="Double" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="20">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
        <Position x="1026" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <OrderChanged value="False" />
          <CommaDecimal value="False" />
          <SelectFields>
            <SelectField field="EstacaoCodigo" selected="True" rename="loc_name" />
            <SelectField field="Value" selected="True" rename="Vazão" type="Double" size="8" />
            <SelectField field="sample_date" selected="True" rename="sample_date_time" />
            <SelectField field="Right_Value" selected="True" rename="VazaoStatus" />
            <SelectField field="*Unknown" selected="False" />
          </SelectFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" type="V_String" />
            <Field name="Vazão" type="Double" />
            <Field name="sample_date_time" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="VazaoStatus" size="1" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
    </Node>
    <Node ToolID="22">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="1134" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" field="loc_des" size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" field="Ano_Mes " size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" field="periodo_sazonal_2" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>loc_des = IF ToString([loc_name]) = "40740000" THEN "Alberto Flores"
ELSEIF ToSt...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" type="V_String" />
            <Field name="Vazão" type="Double" />
            <Field name="sample_date_time" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="VazaoStatus" size="1" type="V_String" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Ano_Mes " size="1073741823" source="Formula: DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="34">
      <GuiSettings Plugin="AlteryxConnectorGui.Download.Download">
        <Position x="258" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <URLField>url</URLField>
          <OutputMode>String</OutputMode>
          <CodePage>65001</CodePage>
          <EncodeURLs value="True" />
          <Headers>
            <NameValues />
            <Fields orderChanged="False">
              <Field name="codEstacao" selected="False" />
              <Field name="tipoDados" selected="False" />
              <Field name="url" selected="False" />
              <Field name="*Unknown" selected="False" />
            </Fields>
          </Headers>
          <Payload>
            <HTTPAction>GET</HTTPAction>
            <QueryStringBodyMode>Compose</QueryStringBodyMode>
            <ComposeNameValues />
            <ComposeFields orderChanged="False">
              <Field name="codEstacao" selected="False" />
              <Field name="tipoDados" selected="False" />
              <Field name="url" selected="False" />
              <Field name="*Unknown" selected="False" />
            </ComposeFields>
          </Payload>
          <numConnections>1</numConnections>
          <Timeout>600</Timeout>
          <EnableRPM value="False" />
          <DcmAdvancedAuth value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
            <Field name="DownloadData" size="1073741823" source="Download" type="V_WString" />
            <Field name="DownloadHeaders" size="2147483647" source="Download" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxConnectorEngine.dll" EngineDllEntryPoint="AlteryxDownload" />
    </Node>
    <Node ToolID="35">
      <GuiSettings Plugin="AlteryxBasePluginsGui.XMLParse.XMLParse">
        <Position x="354" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <XMLField>DownloadData</XMLField>
          <XMLElement />
          <ChildValues value="True" />
          <OuterXML value="False" />
          <ParseRoot value="False" />
          <IgnoreErrors value="False" />
          <IncludeInOutput value="True" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
            <Field name="DownloadData" size="1073741823" source="Download" type="V_WString" />
            <Field name="DownloadHeaders" size="2147483647" source="Download" type="V_String" />
            <Field name="SerieHistorica" size="700" type="V_String" />
            <Field name="diffgr:id" size="16" type="V_String" />
            <Field name="msdata:rowOrder" size="2" type="V_String" />
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="NivelConsistencia" size="1" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="MediaDiaria" size="1" type="V_String" />
            <Field name="TipoMedicaoCotas" size="1" type="V_String" />
            <Field name="MaximaStatus" size="1" type="V_String" />
            <Field name="MinimaStatus" size="1" type="V_String" />
            <Field name="MediaStatus" size="1" type="V_String" />
            <Field name="MediaAnualStatus" size="1" type="V_String" />
            <Field name="Cota01" size="5" type="V_String" />
            <Field name="Cota04" size="5" type="V_String" />
            <Field name="Cota05" size="5" type="V_String" />
            <Field name="Cota06" size="5" type="V_String" />
            <Field name="Cota07" size="5" type="V_String" />
            <Field name="Cota08" size="5" type="V_String" />
            <Field name="Cota11" size="5" type="V_String" />
            <Field name="Cota12" size="5" type="V_String" />
            <Field name="Cota13" size="5" type="V_String" />
            <Field name="Cota14" size="5" type="V_String" />
            <Field name="Cota15" size="5" type="V_String" />
            <Field name="Cota18" size="5" type="V_String" />
            <Field name="Cota19" size="5" type="V_String" />
            <Field name="Cota20" size="5" type="V_String" />
            <Field name="Cota21" size="5" type="V_String" />
            <Field name="Cota22" size="5" type="V_String" />
            <Field name="Cota25" size="5" type="V_String" />
            <Field name="Cota26" size="5" type="V_String" />
            <Field name="Cota27" size="5" type="V_String" />
            <Field name="Cota28" size="5" type="V_String" />
            <Field name="Cota29" size="5" type="V_String" />
            <Field name="Cota01Status" size="1" type="V_String" />
            <Field name="Cota02Status" size="1" type="V_String" />
            <Field name="Cota03Status" size="1" type="V_String" />
            <Field name="Cota04Status" size="1" type="V_String" />
            <Field name="Cota05Status" size="1" type="V_String" />
            <Field name="Cota06Status" size="1" type="V_String" />
            <Field name="Cota07Status" size="1" type="V_String" />
            <Field name="Cota08Status" size="1" type="V_String" />
            <Field name="Cota09Status" size="1" type="V_String" />
            <Field name="Cota10Status" size="1" type="V_String" />
            <Field name="Cota11Status" size="1" type="V_String" />
            <Field name="Cota12Status" size="1" type="V_String" />
            <Field name="Cota13Status" size="1" type="V_String" />
            <Field name="Cota14Status" size="1" type="V_String" />
            <Field name="Cota15Status" size="1" type="V_String" />
            <Field name="Cota16Status" size="1" type="V_String" />
            <Field name="Cota17Status" size="1" type="V_String" />
            <Field name="Cota18Status" size="1" type="V_String" />
            <Field name="Cota19Status" size="1" type="V_String" />
            <Field name="Cota20Status" size="1" type="V_String" />
            <Field name="Cota21Status" size="1" type="V_String" />
            <Field name="Cota22Status" size="1" type="V_String" />
            <Field name="Cota23Status" size="1" type="V_String" />
            <Field name="Cota24Status" size="1" type="V_String" />
            <Field name="Cota25Status" size="1" type="V_String" />
            <Field name="Cota26Status" size="1" type="V_String" />
            <Field name="Cota27Status" size="1" type="V_String" />
            <Field name="Cota28Status" size="1" type="V_String" />
            <Field name="Cota29Status" size="1" type="V_String" />
            <Field name="Cota30Status" size="1" type="V_String" />
            <Field name="Cota31Status" size="1" type="V_String" />
            <Field name="DataIns" size="19" type="V_String" />
            <Field name="Cota02" size="5" type="V_String" />
            <Field name="Cota03" size="5" type="V_String" />
            <Field name="Cota09" size="5" type="V_String" />
            <Field name="Cota10" size="5" type="V_String" />
            <Field name="Cota16" size="5" type="V_String" />
            <Field name="Cota17" size="5" type="V_String" />
            <Field name="Cota23" size="5" type="V_String" />
            <Field name="Cota24" size="5" type="V_String" />
            <Field name="Cota30" size="5" type="V_String" />
            <Field name="Cota31" size="5" type="V_String" />
            <Field name="Maxima" size="3" type="V_String" />
            <Field name="Minima" size="3" type="V_String" />
            <Field name="Media" size="3" type="V_String" />
            <Field name="DiaMaxima" size="2" type="V_String" />
            <Field name="DiaMinima" size="2" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxXMLParse" />
    </Node>
    <Node ToolID="36">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
        <Position x="474" y="570" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <ErrorWarn>Warn</ErrorWarn>
          <KeyFields>
            <Field field="EstacaoCodigo" />
            <Field field="DataHora" />
          </KeyFields>
          <DataFields>
            <Field field="codEstacao" selected="False" />
            <Field field="tipoDados" selected="False" />
            <Field field="url" selected="False" />
            <Field field="DownloadData" selected="False" />
            <Field field="DownloadHeaders" selected="False" />
            <Field field="SerieHistorica" selected="False" />
            <Field field="diffgr:id" selected="False" />
            <Field field="msdata:rowOrder" selected="False" />
            <Field field="EstacaoCodigo" selected="False" />
            <Field field="NivelConsistencia" selected="False" />
            <Field field="DataHora" selected="False" />
            <Field field="MediaDiaria" selected="False" />
            <Field field="TipoMedicaoCotas" selected="False" />
            <Field field="MaximaStatus" selected="False" />
            <Field field="MinimaStatus" selected="False" />
            <Field field="MediaStatus" selected="False" />
            <Field field="MediaAnualStatus" selected="False" />
            <Field field="Cota01" selected="True" />
            <Field field="Cota04" selected="True" />
            <Field field="Cota05" selected="True" />
            <Field field="Cota06" selected="True" />
            <Field field="Cota07" selected="True" />
            <Field field="Cota08" selected="True" />
            <Field field="Cota11" selected="True" />
            <Field field="Cota12" selected="True" />
            <Field field="Cota13" selected="True" />
            <Field field="Cota14" selected="True" />
            <Field field="Cota15" selected="True" />
            <Field field="Cota18" selected="True" />
            <Field field="Cota19" selected="True" />
            <Field field="Cota20" selected="True" />
            <Field field="Cota21" selected="True" />
            <Field field="Cota22" selected="True" />
            <Field field="Cota25" selected="True" />
            <Field field="Cota26" selected="True" />
            <Field field="Cota27" selected="True" />
            <Field field="Cota28" selected="True" />
            <Field field="Cota29" selected="True" />
            <Field field="Cota01Status" selected="False" />
            <Field field="Cota02Status" selected="False" />
            <Field field="Cota03Status" selected="False" />
            <Field field="Cota04Status" selected="False" />
            <Field field="Cota05Status" selected="False" />
            <Field field="Cota06Status" selected="False" />
            <Field field="Cota07Status" selected="False" />
            <Field field="Cota08Status" selected="False" />
            <Field field="Cota09Status" selected="False" />
            <Field field="Cota10Status" selected="False" />
            <Field field="Cota11Status" selected="False" />
            <Field field="Cota12Status" selected="False" />
            <Field field="Cota13Status" selected="False" />
            <Field field="Cota14Status" selected="False" />
            <Field field="Cota15Status" selected="False" />
            <Field field="Cota16Status" selected="False" />
            <Field field="Cota17Status" selected="False" />
            <Field field="Cota18Status" selected="False" />
            <Field field="Cota19Status" selected="False" />
            <Field field="Cota20Status" selected="False" />
            <Field field="Cota21Status" selected="False" />
            <Field field="Cota22Status" selected="False" />
            <Field field="Cota23Status" selected="False" />
            <Field field="Cota24Status" selected="False" />
            <Field field="Cota25Status" selected="False" />
            <Field field="Cota26Status" selected="False" />
            <Field field="Cota27Status" selected="False" />
            <Field field="Cota28Status" selected="False" />
            <Field field="Cota29Status" selected="False" />
            <Field field="Cota30Status" selected="False" />
            <Field field="Cota31Status" selected="False" />
            <Field field="DataIns" selected="False" />
            <Field field="Cota02" selected="True" />
            <Field field="Cota03" selected="True" />
            <Field field="Cota09" selected="True" />
            <Field field="Cota10" selected="True" />
            <Field field="Cota16" selected="True" />
            <Field field="Cota17" selected="True" />
            <Field field="Cota23" selected="True" />
            <Field field="Cota24" selected="True" />
            <Field field="Cota30" selected="True" />
            <Field field="Cota31" selected="True" />
            <Field field="Maxima" selected="False" />
            <Field field="Minima" selected="False" />
            <Field field="Media" selected="False" />
            <Field field="DiaMaxima" selected="False" />
            <Field field="DiaMinima" selected="False" />
            <Field field="*Unknown" selected="False" />
          </DataFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="6" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
    </Node>
    <Node ToolID="37">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="678" y="558" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="RIGHT([Name],2)&#xA;&#xA;" field="Dia" size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" field="sample_date" size="10" type="Date" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Dia = RIGHT([Name],2)


sample_date = DateTimeParse(
DateTimeFormat([DataHora],"...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="6" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: RIGHT([Name],2)&#xA;&#xA;" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="38">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="558" y="570" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber(RIGHT([Name],2)) &lt;=
ToNumber(DateTimeFormat(
    DateTimeAdd(
        DateTimeAdd(DateTimeTrim([DataHora], "month"), 1, "months"),
        -1,
        "days"
    ),
    "%d"
))</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber(RIGHT([Name],2)) &lt;=
ToNumber...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="True">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="6" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="False">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="6" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="39">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
        <Position x="474" y="750" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <ErrorWarn>Warn</ErrorWarn>
          <KeyFields>
            <Field field="EstacaoCodigo" />
            <Field field="DataHora" />
          </KeyFields>
          <DataFields>
            <Field field="codEstacao" selected="False" />
            <Field field="tipoDados" selected="False" />
            <Field field="url" selected="False" />
            <Field field="DownloadData" selected="False" />
            <Field field="DownloadHeaders" selected="False" />
            <Field field="SerieHistorica" selected="False" />
            <Field field="diffgr:id" selected="False" />
            <Field field="msdata:rowOrder" selected="False" />
            <Field field="EstacaoCodigo" selected="False" />
            <Field field="NivelConsistencia" selected="False" />
            <Field field="DataHora" selected="False" />
            <Field field="MediaDiaria" selected="False" />
            <Field field="TipoMedicaoCotas" selected="False" />
            <Field field="MaximaStatus" selected="False" />
            <Field field="MinimaStatus" selected="False" />
            <Field field="MediaStatus" selected="False" />
            <Field field="MediaAnualStatus" selected="False" />
            <Field field="Cota01" selected="False" />
            <Field field="Cota04" selected="False" />
            <Field field="Cota05" selected="False" />
            <Field field="Cota06" selected="False" />
            <Field field="Cota07" selected="False" />
            <Field field="Cota08" selected="False" />
            <Field field="Cota11" selected="False" />
            <Field field="Cota12" selected="False" />
            <Field field="Cota13" selected="False" />
            <Field field="Cota14" selected="False" />
            <Field field="Cota15" selected="False" />
            <Field field="Cota18" selected="False" />
            <Field field="Cota19" selected="False" />
            <Field field="Cota20" selected="False" />
            <Field field="Cota21" selected="False" />
            <Field field="Cota22" selected="False" />
            <Field field="Cota25" selected="False" />
            <Field field="Cota26" selected="False" />
            <Field field="Cota27" selected="False" />
            <Field field="Cota28" selected="False" />
            <Field field="Cota29" selected="False" />
            <Field field="Cota01Status" selected="True" />
            <Field field="Cota02Status" selected="True" />
            <Field field="Cota03Status" selected="True" />
            <Field field="Cota04Status" selected="True" />
            <Field field="Cota05Status" selected="True" />
            <Field field="Cota06Status" selected="True" />
            <Field field="Cota07Status" selected="True" />
            <Field field="Cota08Status" selected="True" />
            <Field field="Cota09Status" selected="True" />
            <Field field="Cota10Status" selected="True" />
            <Field field="Cota11Status" selected="True" />
            <Field field="Cota12Status" selected="True" />
            <Field field="Cota13Status" selected="True" />
            <Field field="Cota14Status" selected="True" />
            <Field field="Cota15Status" selected="True" />
            <Field field="Cota16Status" selected="True" />
            <Field field="Cota17Status" selected="True" />
            <Field field="Cota18Status" selected="True" />
            <Field field="Cota19Status" selected="True" />
            <Field field="Cota20Status" selected="True" />
            <Field field="Cota21Status" selected="True" />
            <Field field="Cota22Status" selected="True" />
            <Field field="Cota23Status" selected="True" />
            <Field field="Cota24Status" selected="True" />
            <Field field="Cota25Status" selected="True" />
            <Field field="Cota26Status" selected="True" />
            <Field field="Cota27Status" selected="True" />
            <Field field="Cota28Status" selected="True" />
            <Field field="Cota29Status" selected="True" />
            <Field field="Cota30Status" selected="True" />
            <Field field="Cota31Status" selected="True" />
            <Field field="DataIns" selected="False" />
            <Field field="Cota02" selected="False" />
            <Field field="Cota03" selected="False" />
            <Field field="Cota09" selected="False" />
            <Field field="Cota10" selected="False" />
            <Field field="Cota16" selected="False" />
            <Field field="Cota17" selected="False" />
            <Field field="Cota23" selected="False" />
            <Field field="Cota24" selected="False" />
            <Field field="Cota30" selected="False" />
            <Field field="Cota31" selected="False" />
            <Field field="Maxima" selected="False" />
            <Field field="Minima" selected="False" />
            <Field field="Media" selected="False" />
            <Field field="DiaMaxima" selected="False" />
            <Field field="DiaMinima" selected="False" />
            <Field field="*Unknown" selected="False" />
          </DataFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="12" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
    </Node>
    <Node ToolID="40">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="558" y="750" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" field="Dia" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText><![CDATA[Dia = REGEX_Replace([Name], "[^0-9]", "")
]]></DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="12" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="41">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Join.Join">
        <Position x="978" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration joinByRecordPos="False">
          <JoinInfo connection="Left">
            <Field field="EstacaoCodigo" />
            <Field field="sample_date" />
          </JoinInfo>
          <JoinInfo connection="Right">
            <Field field="EstacaoCodigo" />
            <Field field="sample_date" />
          </JoinInfo>
          <SelectConfiguration>
            <Configuration outputConnection="Join">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="Right_EstacaoCodigo" selected="True" rename="Right_EstacaoCodigo" input="Right_" />
                <SelectField field="Right_DataHora" selected="True" rename="Right_DataHora" input="Right_" />
                <SelectField field="Right_Name" selected="True" rename="Right_Name" input="Right_" />
                <SelectField field="Right_Value" selected="True" rename="Right_Value" input="Right_" />
                <SelectField field="Right_Dia" selected="True" rename="Right_Dia" input="Right_" />
                <SelectField field="Right_sample_date" selected="True" rename="Right_sample_date" input="Right_" />
                <SelectField field="*Unknown" selected="True" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Left">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="6" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: RIGHT([Name],2)&#xA;&#xA;" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="Join">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="6" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: RIGHT([Name],2)&#xA;&#xA;" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="Right_EstacaoCodigo" size="8" type="V_String" />
            <Field name="Right_DataHora" size="19" type="V_String" />
            <Field name="Right_Name" size="12" source="Transpose:" type="String" />
            <Field name="Right_Value" size="1" type="V_String" />
            <Field name="Right_Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="Right_sample_date" source="Formula: DateTimeParse(&#xA;    DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;    &quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="Right">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="12" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;Vazao|Status&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;    DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;    &quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxJoin" />
    </Node>
    <Node ToolID="42">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="822" y="738" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="DateTimeParse(&#xA;DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" field="sample_date" size="10" type="Date" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>sample_date = DateTimeParse(
DateTimeFormat([DataHora], "%Y-%m-") + [Dia],
"%Y-%...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="12" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="43">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="690" y="750" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber([Dia]) &lt;=
ToNumber(DateTimeFormat(
    DateTimeAdd(
        DateTimeAdd(DateTimeTrim([DataHora], "month"), 1, "months"),
        -1,
        "days"
    ),
    "%d"
))</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber([Dia]) &lt;=
ToNumber(DateTimeF...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="True">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="12" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="False">
          <RecordInfo>
            <Field name="EstacaoCodigo" size="8" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="12" source="Transpose:" type="String" />
            <Field name="Value" size="1" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="51">
      <GuiSettings Plugin="AlteryxBasePluginsGui.TextInput.TextInput">
        <Position x="66" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <NumRows value="3" />
          <Fields>
            <Field name="codEstacao" />
            <Field name="tipoDados" />
          </Fields>
          <Data>
            <r>
              <c>40740000</c>
              <c>1</c>
            </r>
            <r>
              <c>41199998</c>
              <c>1</c>
            </r>
            <r>
              <c>56335000</c>
              <c>1</c>
            </r>
          </Data>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTextInput" />
    </Node>
    <Node ToolID="52">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="162" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="&quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" field="url" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>url = "https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codE...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="codEstacao" source="TextInput:" type="Int32" />
            <Field name="tipoDados" source="TextInput:" type="Int32" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([codEstacao])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=&quot; + ToString([tipoDados])&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="54">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
        <Position x="1086" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <OrderChanged value="False" />
          <CommaDecimal value="False" />
          <SelectFields>
            <SelectField field="EstacaoCodigo" selected="True" rename="loc_name" />
            <SelectField field="Value" selected="True" rename="Nível" type="Double" size="8" />
            <SelectField field="sample_date" selected="True" rename="sample_date_time" />
            <SelectField field="Right_Value" selected="True" rename="NívelStatus" />
            <SelectField field="*Unknown" selected="False" />
          </SelectFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" type="V_String" />
            <Field name="Nível" type="Double" />
            <Field name="sample_date_time" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="NívelStatus" size="1" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
    </Node>
    <Node ToolID="55">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="1182" y="642" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" field="loc_des" size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" field="Ano_Mes " size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" field="periodo_sazonal_2" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>loc_des = IF ToString([loc_name]) = "40740000" THEN "Alberto Flores"
ELSEIF ToSt...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_name" size="8" type="V_String" />
            <Field name="Nível" type="Double" />
            <Field name="sample_date_time" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora],&quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="NívelStatus" size="1" type="V_String" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Ano_Mes " size="1073741823" source="Formula: DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="68">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="54" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`</File>
          <FormatSpecificOptions>
            <FirstRowData>False</FirstRowData>
            <ImportLine>1</ImportLine>
          </FormatSpecificOptions>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>EntradaChuva.xlsx
Query=`EntradaChuva$`</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Selecionar" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="Tipo Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="69">
      <GuiSettings Plugin="AlteryxConnectorGui.Download.Download">
        <Position x="234" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <URLField>url</URLField>
          <OutputMode>String</OutputMode>
          <CodePage>65001</CodePage>
          <EncodeURLs value="True" />
          <Headers>
            <NameValues />
            <Fields orderChanged="False">
              <Field name="Selecionar" selected="False" />
              <Field name="CodPluviometrico" selected="False" />
              <Field name="Nome Estação" selected="False" />
              <Field name="Tipo Estação" selected="False" />
              <Field name="CodEstacao" selected="False" />
              <Field name="Nome" selected="False" />
              <Field name="url" selected="False" />
              <Field name="*Unknown" selected="False" />
            </Fields>
          </Headers>
          <Payload>
            <HTTPAction>GET</HTTPAction>
            <QueryStringBodyMode>Compose</QueryStringBodyMode>
            <ComposeNameValues />
            <ComposeFields orderChanged="False">
              <Field name="Selecionar" selected="False" />
              <Field name="CodPluviometrico" selected="False" />
              <Field name="Nome Estação" selected="False" />
              <Field name="Tipo Estação" selected="False" />
              <Field name="CodEstacao" selected="False" />
              <Field name="Nome" selected="False" />
              <Field name="url" selected="False" />
              <Field name="*Unknown" selected="False" />
            </ComposeFields>
          </Payload>
          <numConnections>1</numConnections>
          <Timeout>600</Timeout>
          <EnableRPM value="False" />
          <DcmAdvancedAuth value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Selecionar" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="Tipo Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_WString" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([CodPluviometrico])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=2&quot;&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
            <Field name="DownloadData" size="1073741823" source="Download" type="V_WString" />
            <Field name="DownloadHeaders" size="2147483647" source="Download" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxConnectorEngine.dll" EngineDllEntryPoint="AlteryxDownload" />
    </Node>
    <Node ToolID="70">
      <GuiSettings Plugin="AlteryxBasePluginsGui.XMLParse.XMLParse">
        <Position x="330" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <XMLField>DownloadData</XMLField>
          <XMLElement />
          <ChildValues value="True" />
          <OuterXML value="False" />
          <ParseRoot value="False" />
          <IgnoreErrors value="False" />
          <IncludeInOutput value="True" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Selecionar" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="Tipo Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_WString" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([CodPluviometrico])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=2&quot;&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
            <Field name="DownloadData" size="1073741823" source="Download" type="V_WString" />
            <Field name="DownloadHeaders" size="2147483647" source="Download" type="V_String" />
            <Field name="SerieHistorica" size="691" type="V_String" />
            <Field name="diffgr:id" size="16" type="V_String" />
            <Field name="msdata:rowOrder" size="2" type="V_String" />
            <Field name="EstacaoCodigo" size="7" type="V_String" />
            <Field name="NivelConsistencia" size="1" type="V_String" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="TipoMedicaoChuvas" size="1" type="V_String" />
            <Field name="Maxima" size="5" type="V_String" />
            <Field name="Total" size="6" type="V_String" />
            <Field name="DiaMaxima" size="2" type="V_String" />
            <Field name="NumDiasDeChuva" size="2" type="V_String" />
            <Field name="MaximaStatus" size="1" type="V_String" />
            <Field name="TotalStatus" size="1" type="V_String" />
            <Field name="NumDiasDeChuvaStatus" size="1" type="V_String" />
            <Field name="TotalAnual" size="1" type="V_String" />
            <Field name="TotalAnualStatus" size="1" type="V_String" />
            <Field name="Chuva01" size="4" type="V_String" />
            <Field name="Chuva02" size="4" type="V_String" />
            <Field name="Chuva03" size="4" type="V_String" />
            <Field name="Chuva04" size="4" type="V_String" />
            <Field name="Chuva05" size="4" type="V_String" />
            <Field name="Chuva06" size="4" type="V_String" />
            <Field name="Chuva07" size="4" type="V_String" />
            <Field name="Chuva08" size="4" type="V_String" />
            <Field name="Chuva09" size="4" type="V_String" />
            <Field name="Chuva10" size="5" type="V_String" />
            <Field name="Chuva11" size="5" type="V_String" />
            <Field name="Chuva12" size="4" type="V_String" />
            <Field name="Chuva13" size="4" type="V_String" />
            <Field name="Chuva14" size="5" type="V_String" />
            <Field name="Chuva15" size="5" type="V_String" />
            <Field name="Chuva16" size="4" type="V_String" />
            <Field name="Chuva17" size="4" type="V_String" />
            <Field name="Chuva18" size="4" type="V_String" />
            <Field name="Chuva19" size="4" type="V_String" />
            <Field name="Chuva20" size="4" type="V_String" />
            <Field name="Chuva21" size="5" type="V_String" />
            <Field name="Chuva22" size="5" type="V_String" />
            <Field name="Chuva23" size="4" type="V_String" />
            <Field name="Chuva24" size="4" type="V_String" />
            <Field name="Chuva25" size="4" type="V_String" />
            <Field name="Chuva26" size="4" type="V_String" />
            <Field name="Chuva27" size="5" type="V_String" />
            <Field name="Chuva28" size="5" type="V_String" />
            <Field name="Chuva29" size="4" type="V_String" />
            <Field name="Chuva30" size="4" type="V_String" />
            <Field name="Chuva31" size="4" type="V_String" />
            <Field name="Chuva01Status" size="1" type="V_String" />
            <Field name="Chuva02Status" size="1" type="V_String" />
            <Field name="Chuva03Status" size="1" type="V_String" />
            <Field name="Chuva04Status" size="1" type="V_String" />
            <Field name="Chuva05Status" size="1" type="V_String" />
            <Field name="Chuva06Status" size="1" type="V_String" />
            <Field name="Chuva07Status" size="1" type="V_String" />
            <Field name="Chuva08Status" size="1" type="V_String" />
            <Field name="Chuva09Status" size="1" type="V_String" />
            <Field name="Chuva10Status" size="1" type="V_String" />
            <Field name="Chuva11Status" size="1" type="V_String" />
            <Field name="Chuva12Status" size="1" type="V_String" />
            <Field name="Chuva13Status" size="1" type="V_String" />
            <Field name="Chuva14Status" size="1" type="V_String" />
            <Field name="Chuva15Status" size="1" type="V_String" />
            <Field name="Chuva16Status" size="1" type="V_String" />
            <Field name="Chuva17Status" size="1" type="V_String" />
            <Field name="Chuva18Status" size="1" type="V_String" />
            <Field name="Chuva19Status" size="1" type="V_String" />
            <Field name="Chuva20Status" size="1" type="V_String" />
            <Field name="Chuva21Status" size="1" type="V_String" />
            <Field name="Chuva22Status" size="1" type="V_String" />
            <Field name="Chuva23Status" size="1" type="V_String" />
            <Field name="Chuva24Status" size="1" type="V_String" />
            <Field name="Chuva25Status" size="1" type="V_String" />
            <Field name="Chuva26Status" size="1" type="V_String" />
            <Field name="Chuva27Status" size="1" type="V_String" />
            <Field name="Chuva28Status" size="1" type="V_String" />
            <Field name="Chuva29Status" size="1" type="V_String" />
            <Field name="Chuva30Status" size="1" type="V_String" />
            <Field name="Chuva31Status" size="1" type="V_String" />
            <Field name="DataIns" size="19" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxXMLParse" />
    </Node>
    <Node ToolID="71">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="150" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="&quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([CodPluviometrico])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=2&quot;&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" field="url" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>url = "https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codE...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Selecionar" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="Tipo Estação" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="Nome" size="255" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_WString" />
            <Field name="url" size="1073741823" source="Formula: &quot;https://telemetriaws1.ana.gov.br/serviceana.asmx/HidroSerieHistorica?codEstacao=&quot;&#xA;+ ToString([CodPluviometrico])&#xA;+ &quot;&amp;dataInicio=01/01/2023&quot;&#xA;+ &quot;&amp;dataFim=31/12/2025&quot;&#xA;+ &quot;&amp;tipoDados=2&quot;&#xA;+ &quot;&amp;nivelConsistencia=1&quot;" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="73">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Transpose.Transpose">
        <Position x="426" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <ErrorWarn>Warn</ErrorWarn>
          <KeyFields>
            <Field field="CodPluviometrico" />
            <Field field="CodEstacao" />
            <Field field="DataHora" />
          </KeyFields>
          <DataFields>
            <Field field="Selecionar" selected="False" />
            <Field field="CodPluviometrico" selected="False" />
            <Field field="Nome Estação" selected="False" />
            <Field field="Tipo Estação" selected="False" />
            <Field field="CodEstacao" selected="False" />
            <Field field="Nome" selected="False" />
            <Field field="url" selected="False" />
            <Field field="DownloadData" selected="False" />
            <Field field="DownloadHeaders" selected="False" />
            <Field field="SerieHistorica" selected="False" />
            <Field field="diffgr:id" selected="False" />
            <Field field="msdata:rowOrder" selected="False" />
            <Field field="EstacaoCodigo" selected="False" />
            <Field field="NivelConsistencia" selected="False" />
            <Field field="DataHora" selected="False" />
            <Field field="TipoMedicaoChuvas" selected="False" />
            <Field field="Maxima" selected="False" />
            <Field field="Total" selected="False" />
            <Field field="DiaMaxima" selected="False" />
            <Field field="NumDiasDeChuva" selected="False" />
            <Field field="MaximaStatus" selected="False" />
            <Field field="TotalStatus" selected="False" />
            <Field field="NumDiasDeChuvaStatus" selected="False" />
            <Field field="TotalAnual" selected="False" />
            <Field field="TotalAnualStatus" selected="False" />
            <Field field="Chuva01" selected="True" />
            <Field field="Chuva02" selected="True" />
            <Field field="Chuva03" selected="True" />
            <Field field="Chuva04" selected="True" />
            <Field field="Chuva05" selected="True" />
            <Field field="Chuva06" selected="True" />
            <Field field="Chuva07" selected="True" />
            <Field field="Chuva08" selected="True" />
            <Field field="Chuva09" selected="True" />
            <Field field="Chuva10" selected="True" />
            <Field field="Chuva11" selected="True" />
            <Field field="Chuva12" selected="True" />
            <Field field="Chuva13" selected="True" />
            <Field field="Chuva14" selected="True" />
            <Field field="Chuva15" selected="True" />
            <Field field="Chuva16" selected="True" />
            <Field field="Chuva17" selected="True" />
            <Field field="Chuva18" selected="True" />
            <Field field="Chuva19" selected="True" />
            <Field field="Chuva20" selected="True" />
            <Field field="Chuva21" selected="True" />
            <Field field="Chuva22" selected="True" />
            <Field field="Chuva23" selected="True" />
            <Field field="Chuva24" selected="True" />
            <Field field="Chuva25" selected="True" />
            <Field field="Chuva26" selected="True" />
            <Field field="Chuva27" selected="True" />
            <Field field="Chuva28" selected="True" />
            <Field field="Chuva29" selected="True" />
            <Field field="Chuva30" selected="True" />
            <Field field="Chuva31" selected="True" />
            <Field field="Chuva01Status" selected="False" />
            <Field field="Chuva02Status" selected="False" />
            <Field field="Chuva03Status" selected="False" />
            <Field field="Chuva04Status" selected="False" />
            <Field field="Chuva05Status" selected="False" />
            <Field field="Chuva06Status" selected="False" />
            <Field field="Chuva07Status" selected="False" />
            <Field field="Chuva08Status" selected="False" />
            <Field field="Chuva09Status" selected="False" />
            <Field field="Chuva10Status" selected="False" />
            <Field field="Chuva11Status" selected="False" />
            <Field field="Chuva12Status" selected="False" />
            <Field field="Chuva13Status" selected="False" />
            <Field field="Chuva14Status" selected="False" />
            <Field field="Chuva15Status" selected="False" />
            <Field field="Chuva16Status" selected="False" />
            <Field field="Chuva17Status" selected="False" />
            <Field field="Chuva18Status" selected="False" />
            <Field field="Chuva19Status" selected="False" />
            <Field field="Chuva20Status" selected="False" />
            <Field field="Chuva21Status" selected="False" />
            <Field field="Chuva22Status" selected="False" />
            <Field field="Chuva23Status" selected="False" />
            <Field field="Chuva24Status" selected="False" />
            <Field field="Chuva25Status" selected="False" />
            <Field field="Chuva26Status" selected="False" />
            <Field field="Chuva27Status" selected="False" />
            <Field field="Chuva28Status" selected="False" />
            <Field field="Chuva29Status" selected="False" />
            <Field field="Chuva30Status" selected="False" />
            <Field field="Chuva31Status" selected="False" />
            <Field field="DataIns" selected="False" />
            <Field field="*Unknown" selected="False" />
          </DataFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxTranspose" />
    </Node>
    <Node ToolID="74">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="522" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" field="Dia" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText><![CDATA[Dia = REGEX_Replace([Name], "[^0-9]", "")
]]></DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="75">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="606" y="1002" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber([Dia]) &lt;=
ToNumber(DateTimeFormat(
    DateTimeAdd(
        DateTimeAdd(DateTimeTrim([DataHora], "month"), 1, "months"),
        -1,
        "days"
    ),
    "%d"
))</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>!IsNull([Value])
AND !IsEmpty([Value])
AND ToNumber([Dia]) &lt;=
ToNumber(DateTimeF...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="True">
          <RecordInfo>
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
        <MetaInfo connection="False">
          <RecordInfo>
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="76">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="702" y="990" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="DateTimeParse(&#xA;DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" field="sample_date" size="10" type="Date" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>sample_date = DateTimeParse(
DateTimeFormat([DataHora], "%Y-%m-") + [Dia],
"%Y-%...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="CodPluviometrico" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="CodEstacao" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="Double" />
            <Field name="DataHora" size="19" type="V_String" />
            <Field name="Name" size="7" source="Transpose:" type="String" />
            <Field name="Value" size="5" type="V_String" />
            <Field name="Dia" size="1073741823" source="Formula: REGEX_Replace([Name], &quot;[^0-9]&quot;, &quot;&quot;)" type="V_WString" />
            <Field name="sample_date" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="77">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AlteryxSelect.AlteryxSelect">
        <Position x="798" y="990" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <OrderChanged value="False" />
          <CommaDecimal value="False" />
          <SelectFields>
            <SelectField field="CodPluviometrico" selected="True" rename="loc_pluviometrico" type="V_String" size="2147483647" />
            <SelectField field="codEstacao" selected="True" rename="loc_name" type="V_String" size="2147483647" />
            <SelectField field="Value" selected="True" rename="Chuva" type="Double" size="8" />
            <SelectField field="sample_date" selected="True" rename="sample_date_time" />
            <SelectField field="Right_Value" selected="False" rename="NívelStatus" />
            <SelectField field="*Unknown" selected="False" />
          </SelectFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_pluviometrico" size="2147483647" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="loc_name" size="2147483647" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="Chuva" type="Double" />
            <Field name="sample_date_time" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxSelect" />
    </Node>
    <Node ToolID="79">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="882" y="990" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" field="loc_des" size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" field="Ano_Mes " size="1073741823" type="V_WString" enabled="true" />
            <FormulaField expression="IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" field="periodo_sazonal_2" size="1073741823" type="V_WString" enabled="true" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>loc_des = IF ToString([loc_name]) = "40740000" THEN "Alberto Flores"
ELSEIF ToSt...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="loc_pluviometrico" size="2147483647" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="loc_name" size="2147483647" source="File: D:\Google Drive\Área de Trabalho\alteryr\EntradaChuva.xlsx|||`EntradaChuva$`" type="V_String" />
            <Field name="Chuva" type="Double" />
            <Field name="sample_date_time" source="Formula: DateTimeParse(&#xA;DateTimeFormat([DataHora], &quot;%Y-%m-&quot;) + [Dia],&#xA;&quot;%Y-%m-%d&quot;&#xA;)" type="Date" />
            <Field name="loc_des" size="1073741823" source="Formula: IF ToString([loc_name]) = &quot;40740000&quot; THEN &quot;Alberto Flores&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;56335000&quot; THEN &quot;Congonhas / Alto Maranhão&quot;&#xA;ELSEIF ToString([loc_name]) = &quot;41199998&quot; THEN &quot;Bela Fama – Rio das Velhas / RMBH&quot;&#xA;ELSE &quot;Não identificado&quot;&#xA;ENDIF" type="V_WString" />
            <Field name="Ano_Mes " size="1073741823" source="Formula: DateTimeFormat([sample_date_time], &quot;%Y-%m&quot;)" type="V_WString" />
            <Field name="periodo_sazonal_2" size="1073741823" source="Formula: IF ToNumber(DateTimeFormat([sample_date_time], &quot;%m&quot;)) IN (10,11,12,1,2,3)&#xA;THEN &quot;Chuva&quot;&#xA;ELSE &quot;Estiagem&quot;&#xA;ENDIF" type="V_WString" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="87">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileOutput.DbFileOutput">
        <Position x="1878" y="510" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <File MaxRecords="" FileFormat="0">E:\Google Drive PC\+PROJETOS\_Projetos de Dados\_PORTFOLIO\Monitoramento Ambiental e Qualidade dos Dados\dados\f_dados_telemetricos.csv</File>
          <Passwords />
          <Disable>False</Disable>
          <FormatSpecificOptions>
            <LineEndStyle>CRLF</LineEndStyle>
            <Delimeter>,</Delimeter>
            <ForceQuotes>False</ForceQuotes>
            <HeaderRow>True</HeaderRow>
            <CodePage>65001</CodePage>
            <WriteBOM>True</WriteBOM>
            <SuppressBlankFile>False</SuppressBlankFile>
          </FormatSpecificOptions>
          <MultiFile value="False" />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>f_dados_telemetricos.csv</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileOutput" />
    </Node>
  </Nodes>
  <Connections>
    <Connection>
      <Origin ToolID="4" Connection="Output" />
      <Destination ToolID="6" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="6" Connection="Output" />
      <Destination ToolID="8" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="6" Connection="Output" />
      <Destination ToolID="13" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="8" Connection="Output" />
      <Destination ToolID="11" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="9" Connection="Output" />
      <Destination ToolID="16" Connection="Left" />
    </Connection>
    <Connection>
      <Origin ToolID="17" Connection="Output" />
      <Destination ToolID="16" Connection="Right" />
    </Connection>
    <Connection>
      <Origin ToolID="11" Connection="True" />
      <Destination ToolID="9" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="13" Connection="Output" />
      <Destination ToolID="14" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="14" Connection="Output" />
      <Destination ToolID="19" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="16" Connection="Join" />
      <Destination ToolID="20" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="19" Connection="True" />
      <Destination ToolID="17" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="31" Connection="Output" />
      <Destination ToolID="32" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="32" Connection="Output" />
      <Destination ToolID="4" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="80" Connection="Output" />
      <Destination ToolID="85" Connection="Input" />
    </Connection>
    <Connection name="#1">
      <Origin ToolID="82" Connection="Output" />
      <Destination ToolID="80" Connection="Input" />
    </Connection>
    <Connection name="#2">
      <Origin ToolID="83" Connection="Output" />
      <Destination ToolID="80" Connection="Input" />
    </Connection>
    <Connection name="#3">
      <Origin ToolID="84" Connection="Output" />
      <Destination ToolID="80" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="85" Connection="True" />
      <Destination ToolID="86" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="86" Connection="Output" />
      <Destination ToolID="87" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="20" Connection="Output" />
      <Destination ToolID="22" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="22" Connection="Output" />
      <Destination ToolID="82" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="34" Connection="Output" />
      <Destination ToolID="35" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="35" Connection="Output" />
      <Destination ToolID="36" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="35" Connection="Output" />
      <Destination ToolID="39" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="36" Connection="Output" />
      <Destination ToolID="38" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="37" Connection="Output" />
      <Destination ToolID="41" Connection="Left" />
    </Connection>
    <Connection>
      <Origin ToolID="42" Connection="Output" />
      <Destination ToolID="41" Connection="Right" />
    </Connection>
    <Connection>
      <Origin ToolID="38" Connection="True" />
      <Destination ToolID="37" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="39" Connection="Output" />
      <Destination ToolID="40" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="40" Connection="Output" />
      <Destination ToolID="43" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="41" Connection="Join" />
      <Destination ToolID="54" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="43" Connection="True" />
      <Destination ToolID="42" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="51" Connection="Output" />
      <Destination ToolID="52" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="52" Connection="Output" />
      <Destination ToolID="34" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="54" Connection="Output" />
      <Destination ToolID="55" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="55" Connection="Output" />
      <Destination ToolID="83" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="68" Connection="Output" />
      <Destination ToolID="71" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="69" Connection="Output" />
      <Destination ToolID="70" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="70" Connection="Output" />
      <Destination ToolID="73" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="71" Connection="Output" />
      <Destination ToolID="69" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="73" Connection="Output" />
      <Destination ToolID="74" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="74" Connection="Output" />
      <Destination ToolID="75" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="75" Connection="True" />
      <Destination ToolID="76" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="76" Connection="Output" />
      <Destination ToolID="77" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="77" Connection="Output" />
      <Destination ToolID="79" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="79" Connection="Output" />
      <Destination ToolID="84" Connection="Input" />
    </Connection>
  </Connections>
  <Properties>
    <Memory default="True" />
    <GlobalRecordLimit value="0" />
    <TempFiles default="True" />
    <Annotation on="True" includeToolName="False" />
    <ConvErrorLimit value="10" />
    <ConvErrorLimit_Stop value="False" />
    <CancelOnError value="False" />
    <DisableBrowse value="False" />
    <EnablePerformanceProfiling value="False" />
    <RunWithE2 value="True" />
    <DefaultTZ value="Local" />
    <PredictiveToolsCodePage value="1252" />
    <DisableAllOutput value="False" />
    <ShowAllMacroMessages value="False" />
    <ShowConnectionStatusIsOn value="True" />
    <ShowConnectionStatusOnlyWhenRunning value="True" />
    <ZoomLevel value="0" />
    <LayoutType>Horizontal</LayoutType>
    <IsTemplate value="False" />
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>DadosANA</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
      <WorkflowId value="737a8e08-f6e2-4fc0-af4a-d0fd35399862" />
      <Telemetry>
        <PreviousWorkflowId value="d5b7b863-e22b-400b-8fa0-09bf1629719e" />
        <OriginWorkflowId value="c68f7c86-1930-4e9d-a989-61c379cd51d6" />
      </Telemetry>
      <PlatformWorkflowId value="" />
    </MetaInfo>
    <Events>
      <Enabled value="True" />
    </Events>
    <RuntimeProperties>
      <Actions />
      <Questions>
        <Question>
          <Type>Tab</Type>
          <Description>Questions</Description>
          <Name>Tab (65)</Name>
          <ToolId value="65" />
          <Questions />
        </Question>
      </Questions>
      <ModuleType>Wizard</ModuleType>
      <MacroCustomHelp value="False" />
      <MacroDynamicOutputFields value="False" />
      <MacroImageStd value="0" />
      <MacroInputs />
      <MacroOutputs />
      <Wiz_CustomHelp value="False" />
      <Wiz_CustomGraphic value="False" />
      <Wiz_ShowOutput value="True" />
      <Wiz_OpenOutputTools>
        <Tool ToolId="87" Selected="True" />
      </Wiz_OpenOutputTools>
      <Wiz_OutputMessage />
      <Wiz_NoOutputFilesMessage />
      <Wiz_ChainRunWizard />
    </RuntimeProperties>
  </Properties>
</AlteryxDocument>