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>