<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2023.1">
  <Nodes>
    <Node ToolID="1">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="30" y="54" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`</File>
          <FormatSpecificOptions>
            <FirstRowData>False</FirstRowData>
            <ImportLine>1</ImportLine>
          </FormatSpecificOptions>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Challenge47_Revenue_Actual.xlsx
Query=`Revenue Actual$`</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Date" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="Date" />
            <Field name="Professional" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="V_String" />
            <Field name="Client" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="V_String" />
            <Field name="Hours" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="Double" />
            <Field name="Rate" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="Double" />
            <Field name="Revenue" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="Double" />
            <Field name="Region" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="V_String" />
            <Field name="Practice" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="V_String" />
            <Field name="Position" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Actual.xlsx|||`Revenue Actual$`" type="V_String" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="2">
      <GuiSettings Plugin="AlteryxBasePluginsGui.DbFileInput.DbFileInput">
        <Position x="30" y="234" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Passwords />
          <File OutputFileName="" RecordLimit="" SearchSubDirs="False" FileFormat="25">C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`</File>
          <FormatSpecificOptions>
            <FirstRowData>False</FirstRowData>
            <ImportLine>1</ImportLine>
          </FormatSpecificOptions>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Challenge47_Revenue_Plan.xlsx
Query=`Revenue Plan$`</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
        <Dependencies>
          <Implicit />
        </Dependencies>
        <MetaInfo connection="Output">
          <RecordInfo>
            <Field name="Date" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`" type="Date" />
            <Field name="Region" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`" type="V_String" />
            <Field name="Practice" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`" type="V_String" />
            <Field name="Position" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`" type="V_String" />
            <Field name="Professional" size="255" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`" type="V_String" />
            <Field name="Plan" source="File: C:\Users\jacks\OneDrive\Documents\ACC 407\TechHub Alteryx Challenges\Challeng47\Challenge47_Revenue_Plan.xlsx|||`Revenue Plan$`" type="Double" />
          </RecordInfo>
        </MetaInfo>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxDbFileInput" />
    </Node>
    <Node ToolID="3">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
        <Position x="186" y="66" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <Expression>[Date]&gt;= "2022-04-01" AND [Date] &lt;="2023-03-31"</Expression>
          <Mode>Custom</Mode>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>[Date]&gt;= "2022-04-01" AND [Date] &lt;="2023-03-31"</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFilter" />
    </Node>
    <Node ToolID="4">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="330" y="54" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="Revenue" action="Sum" rename="Total Rev Actual" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="5">
      <GuiSettings Plugin="AlteryxSpatialPluginsGui.Summarize.Summarize">
        <Position x="330" y="162" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <SummarizeFields>
            <SummarizeField field="Plan" action="Sum" rename="Sum Planned Rev" />
          </SummarizeFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxSpatialPluginsEngine.dll" EngineDllEntryPoint="AlteryxSummarize" />
    </Node>
    <Node ToolID="7">
      <GuiSettings Plugin="AlteryxBasePluginsGui.Formula.Formula">
        <Position x="546" y="114" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <FormulaFields>
            <FormulaField expression="[Total Rev Actual]-[Sum Planned Rev]" field="Actual v Plan" size="4" type="Float" />
            <FormulaField expression="Round(([Actual v Plan]/[Sum Planned Rev])*100, .01)" field="Actual v Plan %" size="4" type="Float" />
          </FormulaFields>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Actual v Plan = [Total Rev Actual]-[Sum Planned Rev]
Actual v Plan % = Round(([A...</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxFormula" />
    </Node>
    <Node ToolID="8">
      <GuiSettings Plugin="PortfolioPluginsGui.ComposerTable.PortfolioComposerTable">
        <Position x="666" y="114" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <TableMode>Basic</TableMode>
          <GroupingFields orderChanged="False" />
          <Width>100%</Width>
          <ShowHeader value="True" />
          <ShowBarGraph value="False" />
          <TableFields orderChanged="False">
            <Field name="Total Rev Actual" selected="True" Alignment="Right" />
            <Field name="Sum Planned Rev" selected="True" Alignment="Right" />
            <Field name="Actual v Plan" selected="True" Alignment="Right" />
            <Field name="Actual v Plan %" selected="True" Alignment="Right" />
            <Field name="*Unknown" selected="True" Alignment="Right" />
          </TableFields>
          <TableStyles>
            <Style Name="Data" Font="Arial" Size="8" TextColor="#000000" BackColor="#ffffff" AltColor="#f0f0f0" RowGroup="1" />
            <Style Name="Header" Font="Arial" Size="10" TextColor="#000000" BackColor="#dbdbdb" />
            <Style Name="Borders" Width="1" DataColor="#000000" HeaderColor="#000000" RowBorder="None" BasicColBorder="Default (Use Per Column Setting)" />
            <Style Name="Table" CellPadding="0" ColumnPadding="0" TableBorder="true" Width="1" BorderColor="#000000" />
          </TableStyles>
          <StyleRules />
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText>Basic Table</DefaultAnnotationText>
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="PortfolioPluginsEngine.dll" EngineDllEntryPoint="AlteryxPortfolioComposerTablePlugin" />
    </Node>
    <Node ToolID="11">
      <GuiSettings Plugin="AlteryxBasePluginsGui.AppendFields.AppendFields">
        <Position x="450" y="102" />
      </GuiSettings>
      <Properties>
        <Configuration>
          <CartesianMode>Error</CartesianMode>
          <SelectConfiguration>
            <Configuration outputConnection="Output">
              <OrderChanged value="False" />
              <CommaDecimal value="False" />
              <SelectFields>
                <SelectField field="*Unknown" selected="True" />
              </SelectFields>
            </Configuration>
          </SelectConfiguration>
        </Configuration>
        <Annotation DisplayMode="0">
          <Name />
          <DefaultAnnotationText />
          <Left value="False" />
        </Annotation>
      </Properties>
      <EngineSettings EngineDll="AlteryxBasePluginsEngine.dll" EngineDllEntryPoint="AlteryxAppendFields" />
    </Node>
  </Nodes>
  <Connections>
    <Connection>
      <Origin ToolID="1" Connection="Output" />
      <Destination ToolID="3" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="2" Connection="Output" />
      <Destination ToolID="5" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="3" Connection="True" />
      <Destination ToolID="4" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="4" Connection="Output" />
      <Destination ToolID="11" Connection="Targets" />
    </Connection>
    <Connection>
      <Origin ToolID="5" Connection="Output" />
      <Destination ToolID="11" Connection="Source" />
    </Connection>
    <Connection>
      <Origin ToolID="7" Connection="Output" />
      <Destination ToolID="8" Connection="Input" />
    </Connection>
    <Connection>
      <Origin ToolID="11" Connection="Output" />
      <Destination ToolID="7" 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" />
    <PredictiveToolsCodePage value="1252" />
    <DisableAllOutput value="False" />
    <ShowAllMacroMessages value="False" />
    <ShowConnectionStatusIsOn value="True" />
    <ShowConnectionStatusOnlyWhenRunning value="True" />
    <ZoomLevel value="0" />
    <LayoutType>Horizontal</LayoutType>
    <MetaInfo>
      <NameIsFileName value="True" />
      <Name>Challenge47</Name>
      <Description />
      <RootToolName />
      <ToolVersion />
      <ToolInDb value="False" />
      <CategoryName />
      <SearchTags />
      <Author />
      <Company />
      <Copyright />
      <DescriptionLink actual="" displayed="" />
      <Example>
        <Description />
        <File />
      </Example>
      <WorkflowId value="e9a54efc-9806-4379-8346-1d81e24bb995" />
      <Telemetry>
        <PreviousWorkflowId value="5b1958b0-19af-4bff-9cb2-5c48ffe368d8" />
        <OriginWorkflowId value="5b1958b0-19af-4bff-9cb2-5c48ffe368d8" />
      </Telemetry>
      <PlatformWorkflowId value="" />
    </MetaInfo>
    <Events>
      <Enabled value="True" />
    </Events>
  </Properties>
</AlteryxDocument>