﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<?application progid="SMath Studio Desktop" version="1.0.8348.30405"?>
<worksheet xmlns="http://smath.info/schemas/worksheet/1.0">
  <settings ppi="144">
    <identity>
      <id>4e115444-172d-4f1e-87c9-9c76da3e1553</id>
      <revision>9</revision>
    </identity>
    <metadata lang="eng">
      <author>NDTM Amarasekera</author>
    </metadata>
    <calculation>
      <precision>4</precision>
      <exponentialThreshold>5</exponentialThreshold>
      <trailingZeros>false</trailingZeros>
      <significantDigitsMode>false</significantDigitsMode>
      <roundingMode>0</roundingMode>
      <approximateEqualAccuracy>0</approximateEqualAccuracy>
      <fractions>decimal</fractions>
    </calculation>
    <pageModel active="false" viewMode="2" printGrid="false" printAreas="true" simpleEqualsOnly="false" printBackgroundImages="true">
      <paper id="9" orientation="Portrait" width="827" height="1169" />
      <margins left="39" right="39" top="49" bottom="49" />
      <header alignment="Center" color="#a9a9a9">&amp;[DATE] &amp;[TIME] - &amp;[FILENAME]</header>
      <footer alignment="Center" color="#a9a9a9">&amp;[PAGENUM] / &amp;[COUNT]</footer>
      <backgrounds />
    </pageModel>
    <dependencies>
      <assembly name="SMath Studio Desktop" version="1.0.8348.30405" guid="a37cba83-b69c-4c71-9992-55ff666763bd" />
      <assembly name="MathRegion" version="1.11.8348.30405" guid="02f1ab51-215b-466e-a74d-5d8b1cf85e8d" />
      <assembly name="PictureRegion" version="1.10.8348.30405" guid="06b5df04-393e-4be7-9107-305196fcb861" />
      <assembly name="SpecialFunctions" version="1.12.8348.30405" guid="2814e667-4e12-48b1-8d51-194e480eabc5" />
      <assembly name="TextRegion" version="1.11.8348.30405" guid="485d28c5-349a-48b6-93be-12a35a1c1e39" />
    </dependencies>
  </settings>
  <regions type="content">
    <region left="9" top="9" width="542" height="24" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Consolas" fontSize="10">
        <content>
          <p>I would like to have a function like lookup (vlookup, hlookup) in smath.</p>
        </content>
      </text>
    </region>
    <region left="9" top="72" width="519" height="371" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Table1</e>
          <e type="operand" style="string">bar size</e>
          <e type="operand" style="string">Weight(kg)</e>
          <e type="operand" style="string">bar dia(mm)</e>
          <e type="operand" style="string">bar Area(mm^2)</e>
          <e type="operand">4</e>
          <e type="operand">0.11</e>
          <e type="operand">4.23</e>
          <e type="operand">14.05</e>
          <e type="operand">5</e>
          <e type="operand">0.173</e>
          <e type="operand">5.29</e>
          <e type="operand">21.98</e>
          <e type="operand">6</e>
          <e type="operand">0.249</e>
          <e type="operand">6.35</e>
          <e type="operand">31.67</e>
          <e type="operand">7</e>
          <e type="operand">0.302</e>
          <e type="operand">7.00</e>
          <e type="operand">38.48</e>
          <e type="operand">8</e>
          <e type="operand">0.389</e>
          <e type="operand">7.94</e>
          <e type="operand">49.51</e>
          <e type="operand">10</e>
          <e type="operand">0.560</e>
          <e type="operand">9.53</e>
          <e type="operand">71.33</e>
          <e type="operand">13</e>
          <e type="operand">0.995</e>
          <e type="operand">12.7</e>
          <e type="operand">126.7</e>
          <e type="operand">16</e>
          <e type="operand">1.56</e>
          <e type="operand">15.9</e>
          <e type="operand">198.6</e>
          <e type="operand">19</e>
          <e type="operand">2.25</e>
          <e type="operand">19.1</e>
          <e type="operand">286.5</e>
          <e type="operand">22</e>
          <e type="operand">3.04</e>
          <e type="operand">22.2</e>
          <e type="operand">387.1</e>
          <e type="operand">25</e>
          <e type="operand">3.98</e>
          <e type="operand">25.4</e>
          <e type="operand">506.7</e>
          <e type="operand">29</e>
          <e type="operand">5.04</e>
          <e type="operand">28.6</e>
          <e type="operand">642.4</e>
          <e type="operand">32</e>
          <e type="operand">6.23</e>
          <e type="operand">31.8</e>
          <e type="operand">794.2</e>
          <e type="operand">35</e>
          <e type="operand">7.51</e>
          <e type="operand">34.9</e>
          <e type="operand">956.6</e>
          <e type="operand">38</e>
          <e type="operand">8.95</e>
          <e type="operand">38.1</e>
          <e type="operand">1140</e>
          <e type="operand">41</e>
          <e type="operand">10.5</e>
          <e type="operand">41.3</e>
          <e type="operand">1340</e>
          <e type="operand">43</e>
          <e type="operand">11.4</e>
          <e type="operand">43.0</e>
          <e type="operand">1452</e>
          <e type="operand">51</e>
          <e type="operand">15.9</e>
          <e type="operand">50.8</e>
          <e type="operand">2027</e>
          <e type="operand">57</e>
          <e type="operand">20.3</e>
          <e type="operand">57.3</e>
          <e type="operand">2579</e>
          <e type="operand">20</e>
          <e type="operand">4</e>
          <e type="function" args="82">mat</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="18" top="450" width="110" height="24" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">bar_size</e>
          <e type="operand">16</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="72" top="477" width="406" height="27" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">Table1</e>
          <e type="operand">bar_size</e>
          <e type="operand">1</e>
          <e type="function" args="3">findrows</e>
        </input>
        <result action="numeric">
          <e type="operand">16</e>
          <e type="operand">1.56</e>
          <e type="operand">15.9</e>
          <e type="operand">198.6</e>
          <e type="operand">1</e>
          <e type="operand">4</e>
          <e type="function" args="6">mat</e>
        </result>
      </math>
    </region>
    <region left="423" top="495" width="37" height="67" color="#000000">
      <picture>
        <raw format="png" encoding="base64">iVBORw0KGgoAAAANSUhEUgAAADQAAABkCAYAAADJ9hMcAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAAAThSURBVHhe7Zt/TNRlHMdPfjt0TUBmG3845u9NS+eygGoSJv0wLprMCSIIufkXDuYlmMhaq5nwhxa6lMrWplhtOVtrNAY5aBVLl6yFiBMcmCeHGId3cMjx7vMcj+y8u0y+9zzfvtye1/be7fvw3GfPa3ff557ny/drQoihhIyOEjI6SsjoKCGjo4SMjhIyOkrI6OgqZLfb0d/fz4/koJuQ0+lEfn4+8vLyeIscdBOy2WwwmUyeyEQ3oeHhYURERISOkMvlQmJiImJiYniLHHQTGh0dRUJCAiIjI3mLHJSQVpSQRpSQVpSQRpSQVpSQRpSQVphQfHw8oqKieIscdBNyOhx4LDYWYaGy2masWLcOpjlz+JEcpAvZKQ7KHUoq7VjjkpPRxf4gCalCDRcuINtsRt6OHTDv349jYWH4ir5ye3fuRMWZM3DxfiKRKvR2fT1Wk8CXlGp27vB8Q0lavx7dNFGIRqrQBxcvImvBgimR+7lFeaK4GL28n0ikCh3v6cHrK1f6CVkpz1VV4S/eTyRShY5dvYpXly71E7pBeaaiAjd4P5FIFart6sLLS5YEFHq6vHxmCr2ihIJDCU2HkBM6GmpCH3V24qVFi/yE2O9Qyp49M0/oQxLKXLzYT6iD8nxZGay8n0ikCp2z21FEazZfIba2237iBO8lFiFCvTTwnitX8JvNhu/dbjRPTKCd2t+h1zLaMnjL3KEU0Z5oU0MDmqnPz5Qmes8PLhfO3b6NP+/eZSU1E7TQPUoJLWPq5s7F4TVrkLFlCzYUFmIbbRc27d6NmqSkB4RY2BZie3o6cvftw2u7diEjNxdpmzcjIzUVL2Rn43xHx2RxDQQtxCg9cABfeA14hHLP6/hhcVG8+26lHDp1ileePlQleFooKzIz0eg1MK15MzERn166NFlYA1RFDLkHD+KTAAOcTn6klNJ0/juvqQWqJIaT166hICsLf/gM8lFjozy7bBnqe4Pb9lE1cZym/c9ntKFz+gz2UVJO2VpTg1u8llaomjiuU56ir8z7PoP9r4xTCnNycJ6m7mChimI5TJ/S8VWr/Ab9sPxEOdvWxisEB1UUSyflrYICNPgM+t/CLpikzZuHbwXdMkNVxfNeYyMOBbjaEyhtlI9bWvA3f2+wUFXxdFM2WCyw+Aw+UE5SrIODk28UAFWVQ93ly9hG5xKbjgOJsIngKOWNoiJ005pPFFRdHuWtrShcuNBPxk15l1JcWYlfxsd5bzFIFfra6YRl40Y/IbbBe9Js9qy2RSNViLGXtgnm8PApGfbpVFLSjxzx/FdCNNKF6m7eRFhyMlq5UD/lRZqmz9LvlQykCzGqmpqQs3atR6iZspp+p2Rsvxm6CLHda2l1tUeoISEBn9NCVha6CLH183e1tfiVhPJTUiBukvZHFyG2Tb/e3o4sdovm8uUQO1E/iC5C90lKS4Np9mx+JAfdhMbGxvA4re/CZ83iLXLQTWjE4UBcXFyI3Rozf76612e6KCGtKCGNKCGtKCGNKCGthKQQe34oOjqat8hBNyH2QBRby4XMA1FWq5U2rDP8GTy3240JfhFxYGAAsbGxnludZSJViJ03g/wy78jICCwWC0pKSqYkZSBVaGhoCH19fZ4nJPVC+leO7VTZq17IPUP/B5SQ0VFCRkcJGR0lZHRCTAj4B+zZZsISrSzBAAAAAElFTkSuQmCC</raw>
      </picture>
    </region>
    <region left="18" top="558" width="73" height="24" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Consolas" fontSize="10">
        <content>
          <p style="font-size: 10px;">bar area</p>
        </content>
      </text>
    </region>
    <region left="90" top="558" width="409" height="43" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">As1</e>
          <e type="operand">Table1</e>
          <e type="operand">bar_size</e>
          <e type="operand">1</e>
          <e type="function" args="3">findrows</e>
          <e type="operand">4</e>
          <e type="function" args="2">el</e>
          <e type="operand" style="unit">mm</e>
          <e type="operand">2</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
        </input>
        <contract>
          <e type="operand" style="unit">mm</e>
          <e type="operand">2</e>
          <e type="operator" args="2">^</e>
        </contract>
        <result action="numeric">
          <e type="operand">198.6</e>
        </result>
      </math>
    </region>
  </regions>
</worksheet>