The XML

The shared string table XML for this example looks like this:

<sst … count="35" uniqueCount="22">
  <si>
    <t>United States</t>
  </si>
  <si>
    <t>Seattle</t>
  </si>
  <si>
    <t>Denver</t>
  </si>
  <si>
    <t>New York</t>
  </si>
  <si>
    <t>Philadelphia</t>
  </si>
  <si>
   <t>Houton</t>
  </si>
  <si>
    <t>San Diego</t>
  </si>
  <si>
    <t>San Francisco</t>
  </si>
  <si>
    <t>Argentina</t>
  </si>
  <si>
    <t>Buenos Aires</t>
  </si>
  <si>
   <t>San Juan</t>
  </si>
  <si>
    <t>Salta</t>
  </si>
  <si>
    <t>Rosario</t>
  </si>
  <si>
    <t>La Plata</t>
  </si>
  <si>
    <t>Japan</t>
  </si>
  <si>
    <t>Tokyo</t>
  </si>
  <si>
    <t>Nagoya</t>
  </si>
  <si>
    <t>Yokohama</t>
  </si>
  <si>
    <t>Sendai</t>
  </si>
  <si>
    <t>Country</t>
  </si>
  <si>
    <t>City</t>
  </si>
  <si>
    <t>Data</t>
  </si>
</sst>

The cell table for this example looks like this:

<sheetData>
  <row r="2" spans="2:4" customFormat="1">
    <c r="B2" s="1" t="s">
      <v>19</v>
    </c>
    <c r="C2" s="1" t="s">
      <v>20</v>
    </c>
    <c r="D2" s="1" t="s">
      <v>21</v>
    </c>
  </row>
  <row r="3" spans="2:4" customFormat="1">
    <c r="B3" t="s">
      <v>0</v>
    </c>
    <c r="C3" t="s">
      <v>1</v>
    </c>
    <c r="D3">
      <f t="shared" ref="D3:D18" ca="1" si="0">ROUND(()*1000,2)</f>
      <v>374.9</v>
    </c>
  </row>
  <row r="4" spans="2:4" customFormat="1">
    <c r="B4" t="s">
      <v>0</v>
    </c>
    <c r="C4" t="s">
      <v>2</v>
    </c>
    <c r="D4">
      <f t="shared" ca="1" si="0"/>
      <v>452.82</v>
    </c>
  </row>
  <row r="5" spans="2:4" customFormat="1">
    <c r="B5" t="s">
      <v>0</v>
    </c>
    <c r="C5" t="s">
      <v>3</v>
    </c>
    <c r="D5">
      <f t="shared" ca="1" si="0"/>
      <v>632.1</v>
    </c>
  </row>
  <row r="6" spans="2:4" customFormat="1">
    <c r="B6" t="s">
      <v>0</v>
    </c>
    <c r="C6" t="s">
      <v>4</v>
    </c>
    <c r="D6">
      <f t="shared" ca="1" si="0"/>
      <v>886.37</v>
    </c>
  </row>
  <row r="7" spans="2:4" customFormat="1">
    <c r="B7" t="s">
      <v>0</v>
    </c>
    <c r="C7" t="s">
      <v>5</v>
    </c>
    <c r="D7">
      <f t="shared" ca="1" si="0"/>
      <v>291.14</v>
    </c>
  </row>
  <row r="8" spans="2:4" customFormat="1">
    <c r="B8" t="s">
      <v>0</v>
    </c>
    <c r="C8" t="s">
      <v>6</v>
    </c>
    <c r="D8">
      <f t="shared" ca="1" si="0"/>
      <v>114.97</v>
    </c>
  </row>
  <row r="9" spans="2:4" customFormat="1">
    <c r="B9" t="s">
      <v>0</v>
    </c>
    <c r="C9" t="s">
      <v>7</v>
    </c>
    <c r="D9">
      <f t="shared" ca="1" si="0"/>
      <v>291.99</v>
    </c>
  </row>
  <row r="10" spans="2:4" customFormat="1">
    <c r="B10" t="s">
      <v>8</v>
    </c>
    <c r="C10" t="s">
      <v>9</v>
    </c>
    <c r="D10">
      <f t="shared" ca="1" si="0"/>
      <v>335.42</v>
    </c>
  </row>
  <row r="11" spans="2:4" customFormat="1">
    <c r="B11" t="s">
      <v>8</v>
    </c>
    <c r="C11" t="s">
      <v>10</v>
    </c>
    <c r="D11">
      <f t="shared" ca="1" si="0"/>
      <v>664.72</v>
    </c>
  </row>
  <row r="12" spans="2:4" customFormat="1">
    <c r="B12" t="s">
      <v>8</v>
    </c>
    <c r="C12" t="s">
      <v>11</v>
    </c>
    <c r="D12">
      <f t="shared" ca="1" si="0"/>
      <v>992.62</v>
    </c>
  </row>
  <row r="13" spans="2:4" customFormat="1">
    <c r="B13" t="s">
      <v>8</v>
    </c>
    <c r="C13" t="s">
      <v>12</v>
    </c>
    <c r="D13">
      <f t="shared" ca="1" si="0"/>
      <v>148.5</v>
    </c>
  </row>
  <row r="14" spans="2:4" customFormat="1">
    <c r="B14" t="s">
      <v>8</v>
    </c>
    <c r="C14" t="s">
      <v>13</v>
    </c>
    <c r="D14">
      <f t="shared" ca="1" si="0"/>
      <v>193.53</v>
    </c>
  </row>
  <row r="15" spans="2:4" customFormat="1">
    <c r="B15" t="s">
      <v>14</v>
    </c>
    <c r="C15" t="s">
      <v>15</v>
    </c>
    <c r="D15">
      <f t="shared" ca="1" si="0"/>
      <v>849.36</v>
    </c>
  </row>
  <row r="16" spans="2:4" customFormat="1">
    <c r="B16" t="s">
    <v>14</v>
    </c>
    <c r="C16" t="s">
      <v>16</v>
    </c>
    <c r="D16">
      <f t="shared" ca="1" si="0"/>
      <v>765.46</v>
    </c>
  </row>
  <row r="17" spans="2:4" customFormat="1">
    <c r="B17" t="s">
      <v>14</v>
    </c>
    <c r="C17" t="s">
      <v>17</v>
    </c>
    <c r="D17">
      <f t="shared" ca="1" si="0"/>
      <v>350.26</v>
    </c>
  </row>
  <row r="18" spans="2:4" customFormat="1">
    <c r="B18" t="s">
      <v>14</v>
    </c>
    <c r="C18" t="s">
      <v>18</v>
    </c>
    <c r="D18">
      <f t="shared" ca="1" si="0"/>
      <v>979.22</v>
    </c>
  </row>
</sheetData>