<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<?application progid="SMath Studio Desktop" version="0.97.5346.24640"?>
<regions>
  <settings>
    <identity>
      <id>622fd594-3509-4b25-913a-becf0b9aac0a</id>
      <revision>11</revision>
    </identity>
    <metadata lang="eng">
      <author>Davide Carpi</author>
      <description>Data Exchange plugin: importing data examples</description>
    </metadata>
    <calculation>
      <precision>4</precision>
      <exponentialThreshold>5</exponentialThreshold>
      <fractions>decimal</fractions>
    </calculation>
    <pageModel active="true" printAreas="true" simpleEqualsOnly="false" printBackgroundImages="true">
      <paper id="9" orientation="Portrait" width="827" height="1169" />
      <margins left="39" right="39" top="39" bottom="39" />
      <header alignment="Center" color="#a9a9a9">&amp;[DATE] &amp;[TIME] - &amp;[FILENAME]</header>
      <footer alignment="Center" color="#a9a9a9">&amp;[PAGENUM] / &amp;[COUNT]</footer>
      <backgrounds />
    </pageModel>
    <dependences>
      <assembly name="SMath Studio Desktop" version="0.97.5346.24640" guid="a37cba83-b69c-4c71-9992-55ff666763bd" />
      <assembly name="Text Region" version="1.10.5346.31409" guid="485d28c5-349a-48b6-93be-12a35a1c1e39" />
      <assembly name="XLSX Import/Export" version="1.0.5544.24508" guid="621b8a62-bd79-47fc-948b-d4c4ab3b8588" />
      <assembly name="Math Region" version="0.97.5346.24640" guid="02f1ab51-215b-466e-a74d-5d8b1cf85e8d" />
      <assembly name="Special Functions" version="1.11.5346.31403" guid="2814e667-4e12-48b1-8d51-194e480eabc5" />
    </dependences>
  </settings>
  <region id="0" left="18" top="18" width="314" height="24" color="#0000ff" bgColor="#ffffff" fontSize="10">
    <text lang="ita">
      <p italic="true">importa una cella singola (file nella stessa cartella di questo foglio SMath;
usa un percorso relativo/assoluto altrimenti)</p>
    </text>
    <text lang="eng">
      <p italic="true">Let's commence import / export (XLSX)</p>
    </text>
  </region>
  <region id="1" left="18" top="54" width="258" height="24" color="#000000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true" italic="true">Lets import input spreadsheet:</p>
    </text>
  </region>
  <region id="2" left="18" top="108" width="617" height="33" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand" style="string">IceLoads-input.xlsx</e>
        <e type="operand" style="string">SMath Studio Data</e>
        <e type="function" preserve="true" args="2">importData.XLSX</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="3" left="18" top="162" width="319" height="116" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
      </input>
      <result action="numeric">
        <e type="operand" style="string">α</e>
        <e type="operand">70</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">β</e>
        <e type="operand">65</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">θf</e>
        <e type="operand">6</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">p</e>
        <e type="operand">500</e>
        <e type="operand" style="string">kPa</e>
        <e type="operand" style="string">t</e>
        <e type="operand">7000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand" style="string">w</e>
        <e type="operand">4000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand">6</e>
        <e type="operand">3</e>
        <e type="function" preserve="true" args="20">mat</e>
      </result>
    </math>
  </region>
  <region id="4" left="18" top="288" width="396" height="24" color="#000000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true" italic="true">Now we will change values of input spreadsheet:</p>
    </text>
  </region>
  <region id="5" left="18" top="324" width="187" height="40" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand">1</e>
        <e type="operand">2</e>
        <e type="function" preserve="true" args="3">el</e>
        <e type="operand">70</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="6" left="216" top="324" width="187" height="40" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand">2</e>
        <e type="operand">2</e>
        <e type="function" preserve="true" args="3">el</e>
        <e type="operand">75</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="7" left="18" top="378" width="196" height="40" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand">4</e>
        <e type="operand">2</e>
        <e type="function" preserve="true" args="3">el</e>
        <e type="operand">500</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="8" left="216" top="378" width="204" height="40" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand">5</e>
        <e type="operand">2</e>
        <e type="function" preserve="true" args="3">el</e>
        <e type="operand">7000</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="9" left="423" top="378" width="204" height="40" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand">6</e>
        <e type="operand">2</e>
        <e type="function" preserve="true" args="3">el</e>
        <e type="operand">4000</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="10" left="18" top="441" width="319" height="116" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.inputX</e>
      </input>
      <result action="numeric">
        <e type="operand" style="string">α</e>
        <e type="operand">70</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">β</e>
        <e type="operand">75</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">θf</e>
        <e type="operand">6</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">p</e>
        <e type="operand">500</e>
        <e type="operand" style="string">kPa</e>
        <e type="operand" style="string">t</e>
        <e type="operand">7000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand" style="string">w</e>
        <e type="operand">4000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand">6</e>
        <e type="operand">3</e>
        <e type="function" preserve="true" args="20">mat</e>
      </result>
    </math>
  </region>
  <region id="11" left="18" top="576" width="299" height="24" color="#000000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true" italic="true">...And export modified spreadsheet:</p>
    </text>
  </region>
  <region id="12" left="18" top="612" width="437" height="34" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <description active="true" position="Right" lang="ita">
        <p>stessa directory del foglio SMath</p>
      </description>
      <description active="true" position="Right" lang="eng">
        <p>same directory of the current sm sheet</p>
      </description>
      <input>
        <e type="operand">IceLoads.inputX</e>
        <e type="operand" style="string">IceLoads-input</e>
        <e type="function" preserve="true" args="2">exportData.XLSX</e>
      </input>
      <result action="numeric">
        <e type="operand">1</e>
      </result>
    </math>
  </region>
  <region id="13" left="18" top="666" width="504" height="24" color="#000000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true" italic="true">Now lets read exported input file to check succesful export:</p>
    </text>
  </region>
  <region id="14" left="18" top="711" width="699" height="33" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceloadsInput_DataIn.xlsx</e>
        <e type="operand" style="string">IceLoads-input.xlsx</e>
        <e type="operand" style="string">SMath Studio Data</e>
        <e type="function" preserve="true" args="2">importData.XLSX</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="15" left="18" top="765" width="401" height="116" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceloadsInput_DataIn.xlsx</e>
      </input>
      <result action="numeric">
        <e type="operand" style="string">α</e>
        <e type="operand">70</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">β</e>
        <e type="operand">75</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">θf</e>
        <e type="operand">6</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">p</e>
        <e type="operand">500</e>
        <e type="operand" style="string">kPa</e>
        <e type="operand" style="string">t</e>
        <e type="operand">7000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand" style="string">w</e>
        <e type="operand">4000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand">6</e>
        <e type="operand">3</e>
        <e type="function" preserve="true" args="20">mat</e>
      </result>
    </math>
  </region>
  <region id="16" left="18" top="1116" width="708" height="24" color="#000000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true" italic="true">It is about time we confirmed that linked "IceLoads.xlsx" spreadsheet uses new input:</p>
    </text>
  </region>
  <region id="17" left="18" top="1152" width="249" height="24" color="#ff0000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true">NEED TO RUN VBS FILE BY HAND!</p>
    </text>
  </region>
  <region id="18" left="18" top="1206" width="624" height="33" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads_DataIn.xlsx</e>
        <e type="operand" style="string">IceLoads.xlsx</e>
        <e type="operand" style="string">IceLoad</e>
        <e type="operand" style="string">A3</e>
        <e type="operand" style="string">C8</e>
        <e type="function" preserve="true" args="4">importData.XLSX</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="19" left="18" top="1260" width="360" height="116" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads_DataIn.xlsx</e>
      </input>
      <result action="numeric">
        <e type="operand" style="string">α</e>
        <e type="operand">70</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">β</e>
        <e type="operand">65</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">θf</e>
        <e type="operand">6</e>
        <e type="operand" style="string">Degrees</e>
        <e type="operand" style="string">p</e>
        <e type="operand">500</e>
        <e type="operand" style="string">kPa</e>
        <e type="operand" style="string">t</e>
        <e type="operand">7000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand" style="string">w</e>
        <e type="operand">4000</e>
        <e type="operand" style="string">mm</e>
        <e type="operand">6</e>
        <e type="operand">3</e>
        <e type="function" preserve="true" args="20">mat</e>
      </result>
    </math>
  </region>
  <region id="20" left="18" top="1404" width="644" height="80" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceloadsInput_DataIn.xlsx</e>
        <e type="operand">IceLoads_DataIn.xlsx</e>
        <e type="operator" args="2">≡</e>
        <e type="operand" style="string">Input Link Successfull!!!</e>
        <e type="operand" style="string">Input not Linked - NG!!!</e>
        <e type="function" preserve="true" args="3">if</e>
      </input>
      <result action="numeric">
        <e type="operand" style="string">Input not Linked - NG!!!</e>
      </result>
    </math>
  </region>
  <region id="21" left="18" top="1503" width="356" height="24" color="#000000" bgColor="#ffffff" fontSize="10">
    <text lang="eng">
      <p bold="true" italic="true">Now lets get the output of the excel file:</p>
    </text>
  </region>
  <region id="22" left="18" top="1557" width="582" height="33" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.xlsx</e>
        <e type="operand" style="string">IceLoads.xlsx</e>
        <e type="operand" style="string">IceLoad</e>
        <e type="operand" style="string">A27</e>
        <e type="operand" style="string">C30</e>
        <e type="function" preserve="true" args="4">importData.XLSX</e>
        <e type="operator" args="2">:</e>
      </input>
    </math>
  </region>
  <region id="23" left="18" top="1611" width="409" height="80" color="#000000" bgColor="#ffffff" fontSize="10">
    <math>
      <input>
        <e type="operand">IceLoads.xlsx</e>
      </input>
      <result action="numeric">
        <e type="operand">0</e>
        <e type="operand" style="string">Long. F.</e>
        <e type="operand" style="string">Transv. F.</e>
        <e type="operand">0</e>
        <e type="operand" style="string">kN</e>
        <e type="operand" style="string">kN</e>
        <e type="operand" style="string">Case 1</e>
        <e type="operand">43714.986</e>
        <e type="operand">6557.2479</e>
        <e type="operand" style="string">Case 2</e>
        <e type="operand">21857.493</e>
        <e type="operand">27478.6347</e>
        <e type="operand">4</e>
        <e type="operand">3</e>
        <e type="function" preserve="true" args="14">mat</e>
      </result>
    </math>
  </region>
</regions>