<mxfile host="Electron" version="29.6.6" type="device">
  <diagram id="case05-grains" name="Which totals can be joined without multiplication?">
    <mxGraphModel grid="1" gridSize="10" page="0" pageWidth="1160" pageHeight="1000" background="#FFFFFF">
      <root>
        <mxCell id="0" />
        <mxCell id="1" parent="0" />
        <object id="title" label="Which totals can be joined without multiplication?">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=28;fontStyle=1;" vertex="1" parent="1">
            <mxGeometry x="25" y="15" width="1110" height="70" as="geometry" />
          </mxCell>
        </object>
        <object id="subtitle" label="Summarize each many-side independently to the comparison grain before joining; keep other analytical grains separate.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=18;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="87" width="1110" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="n0" label="Issues&#10;&#10;MaterialIssue and lines&#10;Many-side evidence">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="25" y="170" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="summary-0" label="One work-order summary&#10;&#10;Group independently by WorkOrderID&#10;Retain the selected cutoff">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="410" y="170" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="sum-0" label="sum" relationKind="aggregate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=1;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="n0" target="summary-0">
            <mxGeometry relative="1" as="geometry" />
          </mxCell>
        </object>
        <object id="join-0" label="join" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="summary-0" target="cohort">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="765" y="262" />
                <mxPoint x="765" y="580" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="n1" label="Labor&#10;&#10;LaborTimeEntry&#10;Many-side evidence">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="25" y="420" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="summary-1" label="One work-order summary&#10;&#10;Group independently by WorkOrderID&#10;Retain the selected cutoff">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="410" y="420" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="sum-1" label="sum" relationKind="aggregate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=1;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="n1" target="summary-1">
            <mxGeometry relative="1" as="geometry" />
          </mxCell>
        </object>
        <object id="join-1" label="join" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="summary-1" target="cohort">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="765" y="512" />
                <mxPoint x="765" y="580" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="n2" label="Completions&#10;&#10;ProductionCompletion and lines&#10;Many-side evidence">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="25" y="670" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="summary-2" label="One work-order summary&#10;&#10;Group independently by WorkOrderID&#10;Retain the selected cutoff">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="410" y="670" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="sum-2" label="sum" relationKind="aggregate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=1;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="n2" target="summary-2">
            <mxGeometry relative="1" as="geometry" />
          </mxCell>
        </object>
        <object id="join-2" label="join" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="summary-2" target="cohort">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="765" y="762" />
                <mxPoint x="765" y="580" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="close" label="Close&#10;&#10;WorkOrderClose&#10;Many-side evidence">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="25" y="920" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="summary-3" label="One work-order summary&#10;&#10;Group independently by WorkOrderID&#10;Retain the selected cutoff">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="410" y="920" width="330" height="185" as="geometry" />
          </mxCell>
        </object>
        <object id="sum-3" label="sum" relationKind="aggregate">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=1;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="close" target="summary-3">
            <mxGeometry relative="1" as="geometry" />
          </mxCell>
        </object>
        <object id="join-3" label="join" relationKind="reference">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;edgeStyle=orthogonalEdgeStyle;rounded=0;fillColor=none;fontSize=17;labelBackgroundColor=#FFFFFF;startArrow=none;endArrow=block;endFill=1;dashed=0;exitX=1;exitY=0.5;entryX=0;entryY=0.5;" edge="1" parent="1" source="summary-3" target="cohort">
            <mxGeometry relative="1" as="geometry">
              <Array as="points">
                <mxPoint x="765" y="1012" />
                <mxPoint x="765" y="580" />
              </Array>
            </mxGeometry>
          </mxCell>
        </object>
        <object id="cohort" label="Fixed work-order population&#10;&#10;336-order cohort&#10;Join one-row summaries by WorkOrderID">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;rounded=1;arcSize=6;fillColor=#f6f4ee;align=left;verticalAlign=top;spacing=18;" vertex="1" parent="1">
            <mxGeometry x="795" y="480" width="330" height="230" as="geometry" />
          </mxCell>
        </object>
        <object id="capacity" label="Daily work-center capacity remains a separate center/date analysis.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=20;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="1180" width="1080" height="55" as="geometry" />
          </mxCell>
        </object>
        <object id="footer" label="Summarize each many-side independently to the comparison grain before joining; keep other analytical grains separate.">
          <mxCell style="html=0;fontFamily=Arial;fontSize=20;fontColor=#17333e;strokeColor=#196252;strokeWidth=1.5;whiteSpace=wrap;text;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=17;fontStyle=0;" vertex="1" parent="1">
            <mxGeometry x="25" y="1272" width="1110" height="60" as="geometry" />
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>
