﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<?application progid="SMath Solver" version="1.3.0.9126"?>
<worksheet xmlns="http://smath.info/schemas/worksheet/1.0">
  <settings ppi="120">
    <identity>
      <id>09ba4279-0bde-4476-aec1-0caceb179010</id>
      <revision>69</revision>
    </identity>
    <metadata lang="eng">
      <author>Reg Curry</author>
    </metadata>
    <calculation>
      <precision>2</precision>
      <exponentialThreshold>4</exponentialThreshold>
      <trailingZeros>true</trailingZeros>
      <significantDigitsMode>false</significantDigitsMode>
      <mixedNumbers>false</mixedNumbers>
      <roundingMode>0</roundingMode>
      <approximateEqualAccuracy>0</approximateEqualAccuracy>
      <fractions>decimal</fractions>
    </calculation>
    <pageModel active="false" viewMode="2" printGrid="false" printAreas="true" simpleEqualsOnly="false" printBackgroundImages="true" hideElementsHighlightings="false">
      <paper id="3" orientation="Portrait" width="1100" height="1700" />
      <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 Core" version="1.73.9126.0" guid="a37cba83-b69c-4c71-9992-55ff666763bd" />
      <assembly name="MathRegion" version="1.73.9126.0" guid="02f1ab51-215b-466e-a74d-5d8b1cf85e8d" />
      <assembly name="SpecialFunctions" version="1.73.9126.0" guid="2814e667-4e12-48b1-8d51-194e480eabc5" />
      <assembly name="TextRegion" version="1.73.9126.0" guid="485d28c5-349a-48b6-93be-12a35a1c1e39" />
      <assembly name="AreaRegion" version="1.73.9126.0" guid="4974b228-4974-44cf-8274-bf2936b4a766" />
      <assembly name="XlsxImportExport" version="1.3.7845.24796" guid="621b8a62-bd79-47fc-948b-d4c4ab3b8588" />
      <assembly name="ALGLIB® - numerical analysis library" version="1.0.8025.20709" guid="8e40b49c-3681-4332-903d-751303860e7b" />
      <assembly name="X-Y Plot Region (JXCharts)" version="0.3.9106.25707" guid="c12231ec-4873-43c1-a7d0-a167ebd17066" />
    </dependencies>
  </settings>
  <regions type="content">
    <region left="351" top="18" width="285" height="38" border="true" color="#000000" bgColor="#ffff80" fontSize="20">
      <text lang="eng" fontFamily="Arial" fontSize="10">
        <content>
          <p style="font-size: 20px; background-color: #ffff80;">al_nleqsolve TESTING</p>
        </content>
      </text>
    </region>
    <region left="18" top="90" width="631" height="30" color="#000000" fontSize="10">
      <math exponentialThreshold="6">
        <input>
          <e type="operand">Data2</e>
          <e type="operand" style="string">WORLD EMISSION DATA VS DATE.xlsx</e>
          <e type="operand" style="string">Sheet 2</e>
          <e type="operand" style="string">A2:C173</e>
          <e type="function" args="3">importData.XLSX</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="27" top="126" width="284" height="105" color="#000000" fontSize="10">
      <math exponentialThreshold="6" matrixOptions="0,0,3,3">
        <input>
          <e type="operand">Data2</e>
        </input>
        <result action="numeric">
          <e type="operand">1850.00</e>
          <e type="operand">1.97</e>
          <e type="operand">10</e>
          <e type="operand">8</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">2.62</e>
          <e type="operand">10</e>
          <e type="operand">9</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">1851.00</e>
          <e type="operand">1.99</e>
          <e type="operand">10</e>
          <e type="operand">8</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">2.71</e>
          <e type="operand">10</e>
          <e type="operand">9</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">1852.00</e>
          <e type="operand">2.08</e>
          <e type="operand">10</e>
          <e type="operand">8</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">2.76</e>
          <e type="operand">10</e>
          <e type="operand">9</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">3</e>
          <e type="operand">3</e>
          <e type="function" args="11">mat</e>
        </result>
      </math>
    </region>
    <region left="351" top="171" width="139" height="26" color="#000000" fontSize="10">
      <math exponentialThreshold="6">
        <input>
          <e type="operand">X</e>
          <e type="operand">Data2</e>
          <e type="operand">1</e>
          <e type="function" args="2">col</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="549" top="171" width="187" height="34" color="#000000" fontSize="10">
      <math exponentialThreshold="6">
        <input>
          <e type="operand">Y</e>
          <e type="operand">10</e>
          <e type="operand">9</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operand">Data2</e>
          <e type="operand">2</e>
          <e type="function" args="2">col</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="774" top="171" width="219" height="56" border="true" color="#000000" bgColor="#ffff80" fontSize="10">
      <text lang="eng" width="215" fontFamily="Consolas" fontSize="10">
        <content>
          <p style="background-color: #ffff80;">We avoid some numerical issues taking (t-to)/to for the independent variable</p>
        </content>
      </text>
    </region>
    <region left="351" top="207" width="143" height="28" color="#000000" fontSize="10">
      <math decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">to</e>
          <e type="operand">X</e>
          <e type="function" args="1">min</e>
          <e type="function" args="1">eval</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="549" top="234" width="131" height="26" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">X</e>
          <e type="function" args="1">max</e>
        </input>
        <result action="numeric">
          <e type="operand">2021.00</e>
        </result>
      </math>
    </region>
    <region left="351" top="243" width="100" height="24" color="#000000" fontSize="10">
      <math>
        <input>
          <e type="operand">to</e>
        </input>
        <result action="numeric">
          <e type="operand">1850.00</e>
        </result>
      </math>
    </region>
    <region left="0" top="261" width="273" height="89" border="true" color="#000000" bgColor="#ffff80" fontSize="10">
      <math decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">t</e>
          <e type="operand">u</e>
          <e type="function" args="2">fit</e>
          <e type="operand">a</e>
          <e type="operand">b</e>
          <e type="operand">c</e>
          <e type="operand">1</e>
          <e type="operand">3</e>
          <e type="function" args="5">mat</e>
          <e type="operand">u</e>
          <e type="operand">1</e>
          <e type="function" args="2">el</e>
          <e type="operand">u</e>
          <e type="operand">2</e>
          <e type="function" args="2">el</e>
          <e type="operand">u</e>
          <e type="operand">3</e>
          <e type="function" args="2">el</e>
          <e type="operand">1</e>
          <e type="operand">3</e>
          <e type="function" args="5">mat</e>
          <e type="operator" args="2">:</e>
          <e type="operand">a</e>
          <e type="operand">b</e>
          <e type="operand">e</e>
          <e type="operand">c</e>
          <e type="operand">t</e>
          <e type="operand">to</e>
          <e type="operator" args="2">-</e>
          <e type="operand">to</e>
          <e type="operator" args="2">/</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">+</e>
          <e type="function" args="1">vectorize</e>
          <e type="operand">2</e>
          <e type="operand">1</e>
          <e type="function" args="4">line</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="1089" top="288" width="221" height="91" color="#000000" fontSize="10">
      <math decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">abc.Mathcad</e>
          <e type="operand">4.9939</e>
          <e type="operand">10</e>
          <e type="operand">14</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">1.7038</e>
          <e type="operand">10</e>
          <e type="operand">2</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">2.6749</e>
          <e type="operand">10</e>
          <e type="operand">1</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="1">-</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="9" top="387" width="89" height="91" border="true" color="#000000" bgColor="#80ffff" fontSize="10">
      <math>
        <input>
          <e type="operand">a</e>
          <e type="operand">b</e>
          <e type="operand">c</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
          <e type="operand">u</e>
          <e type="operand">1</e>
          <e type="function" args="2">el</e>
          <e type="operand">u</e>
          <e type="operand">2</e>
          <e type="function" args="2">el</e>
          <e type="operand">u</e>
          <e type="operand">3</e>
          <e type="function" args="2">el</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="135" top="387" width="222" height="57" border="true" color="#000000" bgColor="#80ffff" fontSize="10">
      <math evaluate="false">
        <input>
          <e type="operand">t</e>
          <e type="operand">u</e>
          <e type="function" args="2">fit</e>
          <e type="operand">a</e>
          <e type="operand">b</e>
          <e type="operand">e</e>
          <e type="operand">c</e>
          <e type="operand">t</e>
          <e type="operand">to</e>
          <e type="operator" args="2">-</e>
          <e type="operand">to</e>
          <e type="operator" args="2">/</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="2">+</e>
          <e type="function" args="1">vectorize</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="378" top="387" width="484" height="29" border="true" color="#000000" bgColor="#80ffff" fontSize="14">
      <text lang="eng" fontFamily="Arial" fontSize="10">
        <content>
          <p style="font-size: 14px; background-color: #80ffff;">WHY IS THIS NOT AND EQUIVALENT ALTERNATIVE?</p>
        </content>
      </text>
    </region>
    <region left="0" top="531" width="441" height="65" color="#000000" fontSize="10">
      <math decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">u</e>
          <e type="operand">1</e>
          <e type="operator" args="1">-</e>
          <e type="operand">1</e>
          <e type="operand">1</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
          <e type="operand">u</e>
          <e type="function" args="1">φ</e>
          <e type="operand">X</e>
          <e type="operand">u</e>
          <e type="function" args="2">fit</e>
          <e type="operand">Y</e>
          <e type="operator" args="2">-</e>
          <e type="operator" args="2">:</e>
          <e type="function" args="2">al_nleqsolve</e>
          <e type="operator" args="2">:</e>
        </input>
        <result action="numeric">
          <e type="operand">1.9492</e>
          <e type="operator" args="1">-</e>
          <e type="operand">1.3453</e>
          <e type="operand">37.4083</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
        </result>
      </math>
    </region>
    <region left="1089" top="567" width="359" height="24" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Consolas" fontSize="10">
        <content>
          <p>https://en.wikipedia.org/wiki/Logistic_function</p>
        </content>
      </text>
    </region>
    <region left="1071" top="594" width="285" height="24" color="#000000" fontSize="10">
      <text lang="eng" fontFamily="Consolas" fontSize="10">
        <content>
          <p>Mathcad solution gives the same norme</p>
        </content>
      </text>
    </region>
    <region left="1071" top="630" width="339" height="95" color="#000000" fontSize="10">
      <math error="42" errorLocation="27" decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">X</e>
          <e type="operand">to</e>
          <e type="operator" args="2">+</e>
          <e type="operand">4.9939</e>
          <e type="operand">10</e>
          <e type="operand">14</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">1.7038</e>
          <e type="operand">10</e>
          <e type="operand">2</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">to</e>
          <e type="operator" args="2">*</e>
          <e type="operand">2.6749</e>
          <e type="operand">10</e>
          <e type="operand">1</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="1">-</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
          <e type="function" args="2">f.3</e>
          <e type="operand">Y</e>
          <e type="operator" args="2">-</e>
          <e type="function" args="1">norme</e>
        </input>
        <result action="numeric">
          <e type="operand">#</e>
        </result>
      </math>
    </region>
    <region left="9" top="693" width="174" height="49" color="#000000" fontSize="10">
      <math decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">Plot</e>
          <e type="operand">t</e>
          <e type="operand">u</e>
          <e type="function" args="2">fit</e>
          <e type="operand">X</e>
          <e type="operand">Y</e>
          <e type="function" args="2">augment</e>
          <e type="operand">2</e>
          <e type="operand">1</e>
          <e type="function" args="4">sys</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>
    </region>
    <region left="1071" top="747" width="400" height="95" color="#000000" fontSize="10">
      <math error="42" errorLocation="27" decimalPlaces="4" exponentialThreshold="5" trailingZeros="false">
        <input>
          <e type="operand">X</e>
          <e type="operand">to</e>
          <e type="operator" args="2">+</e>
          <e type="operand">4.9939</e>
          <e type="operand">10</e>
          <e type="operand">14</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">1.7038</e>
          <e type="operand">10</e>
          <e type="operand">2</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operand">to</e>
          <e type="operator" args="2">*</e>
          <e type="operand">2.6749</e>
          <e type="operand">10</e>
          <e type="operand">1</e>
          <e type="operator" args="1">-</e>
          <e type="operator" args="2">^</e>
          <e type="operator" args="2">*</e>
          <e type="operator" args="1">-</e>
          <e type="operand">3</e>
          <e type="operand">1</e>
          <e type="function" args="5">mat</e>
          <e type="function" args="2">f.3</e>
          <e type="operand">X</e>
          <e type="operand">u.3</e>
          <e type="function" args="2">f.3</e>
          <e type="operator" args="2">-</e>
          <e type="function" args="1">normi</e>
        </input>
        <result action="numeric">
          <e type="operand">#</e>
        </result>
      </math>
    </region>
    <region left="0" top="756" width="937" height="385" color="#000000" fontSize="8">
      <xyplot width="927" height="377" points="100" name="XYPlot">
        <chartstyle usedefault="false" backcolor="White" bordercolor="Black" />
        <grid gridcolor="LightGray" gridpattern="Dash" gridthickness="1" isxgrid="true" isygrid="true" isy2grid="false" />
        <xaxes xmin="1850" xmax="2212.454" xtick="40" visible="True" decimalplaces="0" numberformat="FixedPoint" />
        <yaxes ymin="-88.15135" ymax="588.1514" ytick="200" visible="True" decimalplaces="3" numberformat="General" />
        <y2axes isy2axis="false" y2min="-1" y2max="1" y2tick="0.5" visible="True" decimalplaces="3" numberformat="General" />
        <title2d title="YEARLY EMISSION DATA" titlefont="Arial, 10pt" titlefontcolor="Black" />
        <xylabel labelfont="Arial, 10pt" labelfontcolor="Black" tickfont="Arial, 8pt" tickfontcolor="Black" xlabel="DATE" ylabel="EMISSION (GT)" y2label="y2" />
        <legend isbordervisible="true" islegendvisible="true" legendbackcolor="White" legendbordercolor="Black" legendfont="Arial, 8pt" legendposition="NorthWest" textcolor="Black" />
        <traces>
          <trace seriesname="EXPONENTIAL FIT" isy2data="false" isvisible="true" plotmethod="Lines" lineantialias="true" linecolor="Blue" linethickness="3" linepattern="Solid" filled="false" hatched="false" fillcolor="64, 0, 0, 255" hatchstyle="Percent20" symbolantialias="true" symbolsize="2" symboltype="None" symbolborderthickness="1" symbolbordercolor="Black" symbolfillcolor="White" />
          <trace seriesname="DATA" isy2data="false" isvisible="true" plotmethod="Lines" lineantialias="true" linecolor="Transparent" linethickness="1" linepattern="Solid" filled="false" hatched="false" fillcolor="64, 255, 0, 0" hatchstyle="Percent20" symbolantialias="true" symbolsize="6" symboltype="Diamond" symbolborderthickness="1" symbolbordercolor="Red" symbolfillcolor="Red" />
        </traces>
        <input>
          <e type="operand">Plot</e>
        </input>
      </xyplot>
    </region>
    <region top="1215" border="true" color="#000000" bgColor="#ff8040">
      <area single="true" collapsed="true">
        <title lang="eng">
          <content>
            <p>SEPARATOR FOR END OF SHEET</p>
          </content>
        </title>
      </area>
    </region>
  </regions>
</worksheet>