membaca file dengan extensi xml, trx, text menggunakan javascript

okey masih sama dengan pembahasan sebelumnya yaitu membaca file dengan extensi xml, trx, text yang sebelumnya menggunakan php,. kali ini saya menggunakan pemrograman javascript sebagai penerjemah, okey langsung saja saya bahas:

buatlah file xml dengan nama filename.xml : scriptnya sebagai berikut,

<?xml version="1.0" encoding="utf-8"?>
<CONFIG>
  <grid version="3">
    <saveoptions create="False" content="True" position="False"/>
    <content>
      <cells cellcount="740">
        <cell1 row="0" text="DATE" column="0"/>
        <cell2 row="1" text="2017-08-05" column="0"/>
        <cell3 row="2" text="2017-08-05" column="0"/>
        <cell4 row="3" text="2017-08-05" column="0"/>
        <cell5 row="4" text="2017-08-05" column="0"/>
        <cell6 row="5" text="2017-08-05" column="0"/>
        <cell7 row="6" text="2017-08-05" column="0"/>
        <cell8 row="7" text="2017-08-05" column="0"/>
        <cell9 row="8" text="2017-08-05" column="0"/>
        <cell10 row="9" text="2017-08-05" column="0"/>
        <cell11 row="10" text="2017-08-05" column="0"/>
        <cell12 row="11" text="2017-08-05" column="0"/>
        <cell13 row="12" text="2017-08-05" column="0"/>
        <cell14 row="13" text="2017-08-05" column="0"/>
        <cell15 row="14" text="2017-08-05" column="0"/>
        <cell16 row="15" text="2017-08-05" column="0"/>
        <cell17 row="16" text="2017-08-05" column="0"/>
        <cell18 row="17" text="2017-08-05" column="0"/>
        <cell19 row="18" text="2017-08-05" column="0"/>
        <cell20 row="19" text="2017-08-05" column="0"/>
        <cell21 row="20" text="2017-08-05" column="0"/>
        <cell22 row="21" text="2017-08-05" column="0"/>
        <cell23 row="22" text="2017-08-05" column="0"/>
        <cell24 row="23" text="2017-08-05" column="0"/>
        <cell25 row="24" text="2017-08-05" column="0"/>
        <cell26 row="25" text="2017-08-05" column="0"/>
        <cell27 row="26" text="2017-08-05" column="0"/>
        <cell28 row="27" text="2017-08-05" column="0"/>
        <cell29 row="28" text="2017-08-05" column="0"/>
        <cell30 row="29" text="2017-08-05" column="0"/>
        <cell31 row="30" text="2017-08-05" column="0"/>
        <cell32 row="31" text="2017-08-05" column="0"/>
        <cell33 row="32" text="2017-08-05" column="0"/>
        <cell34 row="33" text="2017-08-05" column="0"/>
        <cell35 row="34" text="2017-08-05" column="0"/>
        <cell36 row="35" text="2017-08-05" column="0"/>
        <cell37 row="36" text="2017-08-05" column="0"/>
        <cell38 row="37" text="2017-08-05" column="0"/>
        <cell39 row="38" text="2017-08-05" column="0"/>
        <cell40 row="39" text="2017-08-05" column="0"/>
        <cell41 row="40" text="2017-08-05" column="0"/>
        <cell42 row="41" text="2017-08-05" column="0"/>
        <cell43 row="42" text="2017-08-05" column="0"/>
        <cell44 row="43" text="2017-08-05" column="0"/>
        <cell45 row="44" text="2017-08-05" column="0"/>
        <cell46 row="45" text="2017-08-05" column="0"/>
        <cell47 row="46" text="2017-08-05" column="0"/>
        <cell48 row="47" text="2017-08-05" column="0"/>
        <cell49 row="48" text="2017-08-05" column="0"/>
        <cell50 row="49" text="2017-08-05" column="0"/>
        <cell51 row="50" text="2017-08-05" column="0"/>
        <cell52 row="51" text="2017-08-05" column="0"/>
        <cell53 row="52" text="2017-08-05" column="0"/>
        <cell54 row="53" text="2017-08-05" column="0"/>
        <cell55 row="54" text="2017-08-05" column="0"/>
        <cell56 row="55" text="2017-08-05" column="0"/>
        <cell57 row="56" text="2017-08-05" column="0"/>
        <cell58 row="57" text="2017-08-05" column="0"/>
        <cell59 row="58" text="2017-08-05" column="0"/>
        <cell60 row="59" text="2017-08-05" column="0"/>
        <cell61 row="60" text="2017-08-05" column="0"/>
        <cell62 row="61" text="2017-08-05" column="0"/>
        <cell63 row="62" text="2017-08-05" column="0"/>
        <cell64 row="63" text="2017-08-05" column="0"/>
        <cell65 row="64" text="2017-08-05" column="0"/>
        <cell66 row="65" text="2017-08-05" column="0"/>
        <cell67 row="66" text="2017-08-05" column="0"/>
        <cell68 row="67" text="2017-08-05" column="0"/>
        <cell69 row="68" text="2017-08-05" column="0"/>
        <cell70 row="69" text="2017-08-05" column="0"/>
        <cell71 row="70" text="2017-08-05" column="0"/>
        <cell72 row="71" text="2017-08-05" column="0"/>
        <cell73 row="72" text="2017-08-05" column="0"/>
        <cell74 row="73" text="2017-08-05" column="0"/>
        <cell75 row="74" text="2017-08-05" column="0"/>
        <cell76 row="75" text="2017-08-05" column="0"/>
        <cell77 row="76" text="2017-08-05" column="0"/>
        <cell78 row="77" text="2017-08-05" column="0"/>
        <cell79 row="78" text="2017-08-05" column="0"/>
        <cell80 row="79" text="2017-08-05" column="0"/>
        <cell81 row="80" text="2017-08-05" column="0"/>
        <cell82 row="81" text="2017-08-05" column="0"/>
        <cell83 row="82" text="2017-08-05" column="0"/>
        <cell84 row="83" text="2017-08-05" column="0"/>
        <cell85 row="84" text="2017-08-05" column="0"/>
        <cell86 row="85" text="2017-08-05" column="0"/>
        <cell87 row="86" text="2017-08-05" column="0"/>
        <cell88 row="87" text="2017-08-05" column="0"/>
        <cell89 row="88" text="2017-08-05" column="0"/>
        <cell90 row="89" text="2017-08-05" column="0"/>
        <cell91 row="90" text="2017-08-05" column="0"/>
        <cell92 row="91" text="2017-08-05" column="0"/>
        <cell93 row="92" text="2017-08-05" column="0"/>
        <cell94 row="93" text="2017-08-05" column="0"/>
        <cell95 row="94" text="2017-08-05" column="0"/>
        <cell96 row="95" text="2017-08-05" column="0"/>
        <cell97 row="96" text="2017-08-05" column="0"/>
        <cell98 row="97" text="2017-08-05" column="0"/>
        <cell99 row="98" text="2017-08-05" column="0"/>
        <cell100 row="99" text="2017-08-05" column="0"/>
        <cell101 row="100" text="2017-08-05" column="0"/>
        <cell102 row="101" text="2017-08-05" column="0"/>
        <cell103 row="102" text="2017-08-05" column="0"/>
        <cell104 row="103" text="2017-08-05" column="0"/>
        <cell105 row="104" text="2017-08-05" column="0"/>
        <cell106 row="105" text="2017-08-05" column="0"/>
        <cell107 row="106" text="2017-08-05" column="0"/>
        <cell108 row="107" text="2017-08-05" column="0"/>
        <cell109 row="108" text="2017-08-05" column="0"/>
        <cell110 row="109" text="2017-08-05" column="0"/>
        <cell111 row="110" text="2017-08-05" column="0"/>
        <cell112 row="111" text="2017-08-05" column="0"/>
        <cell113 row="112" text="2017-08-05" column="0"/>
        <cell114 row="113" text="2017-08-05" column="0"/>
        <cell115 row="114" text="2017-08-05" column="0"/>
        <cell116 row="115" text="2017-08-05" column="0"/>
        <cell117 row="116" text="2017-08-05" column="0"/>
        <cell118 row="117" text="2017-08-05" column="0"/>
        <cell119 row="118" text="2017-08-05" column="0"/>
        <cell120 row="119" text="2017-08-05" column="0"/>
        <cell121 row="120" text="2017-08-05" column="0"/>
        <cell122 row="121" text="2017-08-05" column="0"/>
        <cell123 row="122" text="2017-08-05" column="0"/>
        <cell124 row="123" text="2017-08-05" column="0"/>
        <cell125 row="124" text="2017-08-05" column="0"/>
        <cell126 row="125" text="2017-08-05" column="0"/>
        <cell127 row="126" text="2017-08-05" column="0"/>
        <cell128 row="127" text="2017-08-05" column="0"/>
        <cell129 row="128" text="2017-08-05" column="0"/>
        <cell130 row="129" text="2017-08-05" column="0"/>
        <cell131 row="130" text="2017-08-05" column="0"/>
        <cell132 row="131" text="2017-08-05" column="0"/>
        <cell133 row="132" text="2017-08-05" column="0"/>
        <cell134 row="133" text="2017-08-05" column="0"/>
        <cell135 row="134" text="2017-08-05" column="0"/>
        <cell136 row="135" text="2017-08-05" column="0"/>
        <cell137 row="136" text="2017-08-05" column="0"/>
        <cell138 row="137" text="2017-08-05" column="0"/>
        <cell139 row="138" text="2017-08-05" column="0"/>
        <cell140 row="139" text="2017-08-05" column="0"/>
        <cell141 row="140" text="2017-08-05" column="0"/>
        <cell142 row="141" text="2017-08-05" column="0"/>
        <cell143 row="142" text="2017-08-05" column="0"/>
        <cell144 row="143" text="2017-08-05" column="0"/>
        <cell145 row="144" text="2017-08-05" column="0"/>
        <cell146 row="145" text="2017-08-05" column="0"/>
        <cell147 row="146" text="2017-08-05" column="0"/>
        <cell148 row="147" text="2017-08-05" column="0"/>
        <cell149 row="148" text="2017-08-05" column="0"/>
        <cell150 row="149" text="2017-08-05" column="0"/>
        <cell151 row="150" text="2017-08-05" column="0"/>
        <cell152 row="151" text="2017-08-05" column="0"/>
        <cell153 row="152" text="2017-08-05" column="0"/>
        <cell154 row="153" text="2017-08-05" column="0"/>
        <cell155 row="154" text="2017-08-05" column="0"/>
        <cell156 row="155" text="2017-08-05" column="0"/>
        <cell157 row="156" text="2017-08-05" column="0"/>
        <cell158 row="157" text="2017-08-05" column="0"/>
        <cell159 row="158" text="2017-08-05" column="0"/>
        <cell160 row="159" text="2017-08-05" column="0"/>
        <cell161 row="160" text="2017-08-05" column="0"/>
        <cell162 row="161" text="2017-08-05" column="0"/>
        <cell163 row="162" text="2017-08-05" column="0"/>
        <cell164 row="163" text="2017-08-05" column="0"/>
        <cell165 row="164" text="2017-08-05" column="0"/>
        <cell166 row="165" text="2017-08-05" column="0"/>
        <cell167 row="166" text="2017-08-05" column="0"/>
        <cell168 row="167" text="2017-08-05" column="0"/>
        <cell169 row="168" text="2017-08-05" column="0"/>
        <cell170 row="169" text="2017-08-05" column="0"/>
        <cell171 row="170" text="2017-08-05" column="0"/>
        <cell172 row="171" text="2017-08-05" column="0"/>
        <cell173 row="172" text="2017-08-05" column="0"/>
        <cell174 row="173" text="2017-08-05" column="0"/>
        <cell175 row="174" text="2017-08-05" column="0"/>
        <cell176 row="175" text="2017-08-05" column="0"/>
        <cell177 row="176" text="2017-08-05" column="0"/>
        <cell178 row="177" text="2017-08-05" column="0"/>
        <cell179 row="178" text="2017-08-05" column="0"/>
        <cell180 row="179" text="2017-08-05" column="0"/>
        <cell181 row="180" text="2017-08-05" column="0"/>
        <cell182 row="181" text="2017-08-05" column="0"/>
        <cell183 row="182" text="2017-08-05" column="0"/>
        <cell184 row="183" text="2017-08-05" column="0"/>
        <cell185 row="184" text="2017-08-05" column="0"/>
        <cell186 row="0" text="TIME" column="1"/>
        <cell187 row="1" text="15:45" column="1"/>
        <cell188 row="2" text="15:45" column="1"/>
        <cell189 row="3" text="15:45" column="1"/>
        <cell190 row="4" text="15:45" column="1"/>
        <cell191 row="5" text="15:45" column="1"/>
        <cell192 row="6" text="15:45" column="1"/>
        <cell193 row="7" text="15:45" column="1"/>
        <cell194 row="8" text="15:45" column="1"/>
        <cell195 row="9" text="15:46" column="1"/>
        <cell196 row="10" text="15:46" column="1"/>
        <cell197 row="11" text="15:46" column="1"/>
        <cell198 row="12" text="15:46" column="1"/>
        <cell199 row="13" text="15:46" column="1"/>
        <cell200 row="14" text="15:46" column="1"/>
        <cell201 row="15" text="15:47" column="1"/>
        <cell202 row="16" text="15:47" column="1"/>
        <cell203 row="17" text="15:47" column="1"/>
        <cell204 row="18" text="15:47" column="1"/>
        <cell205 row="19" text="15:47" column="1"/>
        <cell206 row="20" text="15:47" column="1"/>
        <cell207 row="21" text="15:48" column="1"/>
        <cell208 row="22" text="15:48" column="1"/>
        <cell209 row="23" text="15:48" column="1"/>
        <cell210 row="24" text="15:48" column="1"/>
        <cell211 row="25" text="15:48" column="1"/>
        <cell212 row="26" text="15:48" column="1"/>
        <cell213 row="27" text="15:49" column="1"/>
        <cell214 row="28" text="15:49" column="1"/>
        <cell215 row="29" text="15:49" column="1"/>
        <cell216 row="30" text="15:49" column="1"/>
        <cell217 row="31" text="15:49" column="1"/>
        <cell218 row="32" text="15:49" column="1"/>
        <cell219 row="33" text="15:49" column="1"/>
        <cell220 row="34" text="15:49" column="1"/>
        <cell221 row="35" text="15:50" column="1"/>
        <cell222 row="36" text="15:50" column="1"/>
        <cell223 row="37" text="15:50" column="1"/>
        <cell224 row="38" text="15:50" column="1"/>
        <cell225 row="39" text="15:50" column="1"/>
        <cell226 row="40" text="15:50" column="1"/>
        <cell227 row="41" text="15:51" column="1"/>
        <cell228 row="42" text="15:51" column="1"/>
        <cell229 row="43" text="15:51" column="1"/>
        <cell230 row="44" text="15:51" column="1"/>
        <cell231 row="45" text="15:51" column="1"/>
        <cell232 row="46" text="15:51" column="1"/>
        <cell233 row="47" text="15:52" column="1"/>
        <cell234 row="48" text="15:52" column="1"/>
        <cell235 row="49" text="15:52" column="1"/>
        <cell236 row="50" text="15:52" column="1"/>
        <cell237 row="51" text="15:52" column="1"/>
        <cell238 row="52" text="15:52" column="1"/>
        <cell239 row="53" text="15:53" column="1"/>
        <cell240 row="54" text="15:53" column="1"/>
        <cell241 row="55" text="15:53" column="1"/>
        <cell242 row="56" text="15:53" column="1"/>
        <cell243 row="57" text="15:53" column="1"/>
        <cell244 row="58" text="15:53" column="1"/>
        <cell245 row="59" text="15:53" column="1"/>
        <cell246 row="60" text="15:53" column="1"/>
        <cell247 row="61" text="15:54" column="1"/>
        <cell248 row="62" text="15:54" column="1"/>
        <cell249 row="63" text="15:54" column="1"/>
        <cell250 row="64" text="15:54" column="1"/>
        <cell251 row="65" text="15:54" column="1"/>
        <cell252 row="66" text="15:54" column="1"/>
        <cell253 row="67" text="15:55" column="1"/>
        <cell254 row="68" text="15:55" column="1"/>
        <cell255 row="69" text="15:55" column="1"/>
        <cell256 row="70" text="15:55" column="1"/>
        <cell257 row="71" text="15:55" column="1"/>
        <cell258 row="72" text="15:55" column="1"/>
        <cell259 row="73" text="15:56" column="1"/>
        <cell260 row="74" text="15:56" column="1"/>
        <cell261 row="75" text="15:56" column="1"/>
        <cell262 row="76" text="15:56" column="1"/>
        <cell263 row="77" text="15:56" column="1"/>
        <cell264 row="78" text="15:56" column="1"/>
        <cell265 row="79" text="15:57" column="1"/>
        <cell266 row="80" text="15:57" column="1"/>
        <cell267 row="81" text="15:57" column="1"/>
        <cell268 row="82" text="15:57" column="1"/>
        <cell269 row="83" text="15:57" column="1"/>
        <cell270 row="84" text="15:57" column="1"/>
        <cell271 row="85" text="15:58" column="1"/>
        <cell272 row="86" text="15:58" column="1"/>
        <cell273 row="87" text="15:58" column="1"/>
        <cell274 row="88" text="15:58" column="1"/>
        <cell275 row="89" text="15:58" column="1"/>
        <cell276 row="90" text="15:58" column="1"/>
        <cell277 row="91" text="15:59" column="1"/>
        <cell278 row="92" text="15:59" column="1"/>
        <cell279 row="93" text="15:59" column="1"/>
        <cell280 row="94" text="15:59" column="1"/>
        <cell281 row="95" text="15:59" column="1"/>
        <cell282 row="96" text="15:59" column="1"/>
        <cell283 row="97" text="16:00" column="1"/>
        <cell284 row="98" text="16:00" column="1"/>
        <cell285 row="99" text="16:00" column="1"/>
        <cell286 row="100" text="16:00" column="1"/>
        <cell287 row="101" text="16:00" column="1"/>
        <cell288 row="102" text="16:00" column="1"/>
        <cell289 row="103" text="16:01" column="1"/>
        <cell290 row="104" text="16:01" column="1"/>
        <cell291 row="105" text="16:01" column="1"/>
        <cell292 row="106" text="16:01" column="1"/>
        <cell293 row="107" text="16:01" column="1"/>
        <cell294 row="108" text="16:01" column="1"/>
        <cell295 row="109" text="16:02" column="1"/>
        <cell296 row="110" text="16:02" column="1"/>
        <cell297 row="111" text="16:02" column="1"/>
        <cell298 row="112" text="16:02" column="1"/>
        <cell299 row="113" text="16:02" column="1"/>
        <cell300 row="114" text="16:02" column="1"/>
        <cell301 row="115" text="16:03" column="1"/>
        <cell302 row="116" text="16:03" column="1"/>
        <cell303 row="117" text="16:03" column="1"/>
        <cell304 row="118" text="16:03" column="1"/>
        <cell305 row="119" text="16:03" column="1"/>
        <cell306 row="120" text="16:03" column="1"/>
        <cell307 row="121" text="16:04" column="1"/>
        <cell308 row="122" text="16:04" column="1"/>
        <cell309 row="123" text="16:04" column="1"/>
        <cell310 row="124" text="16:04" column="1"/>
        <cell311 row="125" text="16:04" column="1"/>
        <cell312 row="126" text="16:04" column="1"/>
        <cell313 row="127" text="16:05" column="1"/>
        <cell314 row="128" text="16:05" column="1"/>
        <cell315 row="129" text="16:05" column="1"/>
        <cell316 row="130" text="16:05" column="1"/>
        <cell317 row="131" text="16:05" column="1"/>
        <cell318 row="132" text="16:05" column="1"/>
        <cell319 row="133" text="16:06" column="1"/>
        <cell320 row="134" text="16:06" column="1"/>
        <cell321 row="135" text="16:06" column="1"/>
        <cell322 row="136" text="16:06" column="1"/>
        <cell323 row="137" text="16:06" column="1"/>
        <cell324 row="138" text="16:06" column="1"/>
        <cell325 row="139" text="16:07" column="1"/>
        <cell326 row="140" text="16:07" column="1"/>
        <cell327 row="141" text="16:07" column="1"/>
        <cell328 row="142" text="16:07" column="1"/>
        <cell329 row="143" text="16:07" column="1"/>
        <cell330 row="144" text="16:07" column="1"/>
        <cell331 row="145" text="16:08" column="1"/>
        <cell332 row="146" text="16:08" column="1"/>
        <cell333 row="147" text="16:08" column="1"/>
        <cell334 row="148" text="16:08" column="1"/>
        <cell335 row="149" text="16:09" column="1"/>
        <cell336 row="150" text="16:09" column="1"/>
        <cell337 row="151" text="16:09" column="1"/>
        <cell338 row="152" text="16:09" column="1"/>
        <cell339 row="153" text="16:09" column="1"/>
        <cell340 row="154" text="16:09" column="1"/>
        <cell341 row="155" text="16:10" column="1"/>
        <cell342 row="156" text="16:10" column="1"/>
        <cell343 row="157" text="16:10" column="1"/>
        <cell344 row="158" text="16:10" column="1"/>
        <cell345 row="159" text="16:10" column="1"/>
        <cell346 row="160" text="16:10" column="1"/>
        <cell347 row="161" text="16:11" column="1"/>
        <cell348 row="162" text="16:11" column="1"/>
        <cell349 row="163" text="16:11" column="1"/>
        <cell350 row="164" text="16:11" column="1"/>
        <cell351 row="165" text="16:11" column="1"/>
        <cell352 row="166" text="16:11" column="1"/>
        <cell353 row="167" text="16:12" column="1"/>
        <cell354 row="168" text="16:12" column="1"/>
        <cell355 row="169" text="16:12" column="1"/>
        <cell356 row="170" text="16:12" column="1"/>
        <cell357 row="171" text="16:12" column="1"/>
        <cell358 row="172" text="16:12" column="1"/>
        <cell359 row="173" text="16:13" column="1"/>
        <cell360 row="174" text="16:13" column="1"/>
        <cell361 row="175" text="16:13" column="1"/>
        <cell362 row="176" text="16:13" column="1"/>
        <cell363 row="177" text="16:13" column="1"/>
        <cell364 row="178" text="16:13" column="1"/>
        <cell365 row="179" text="16:14" column="1"/>
        <cell366 row="180" text="16:14" column="1"/>
        <cell367 row="181" text="16:14" column="1"/>
        <cell368 row="182" text="16:14" column="1"/>
        <cell369 row="183" text="16:14" column="1"/>
        <cell370 row="184" text="16:14" column="1"/>
        <cell371 row="0" text="LATITUDE" column="2"/>
        <cell372 row="1" text="-6.52359" column="2"/>
        <cell373 row="2" text="-6.52359" column="2"/>
        <cell374 row="3" text="-6.52298" column="2"/>
        <cell375 row="4" text="-6.52298" column="2"/>
        <cell376 row="5" text="-6.52237" column="2"/>
        <cell377 row="6" text="-6.52237" column="2"/>
        <cell378 row="7" text="-6.52178" column="2"/>
        <cell379 row="8" text="-6.52178" column="2"/>
        <cell380 row="9" text="-6.52117" column="2"/>
        <cell381 row="10" text="-6.52117" column="2"/>
        <cell382 row="11" text="-6.52057" column="2"/>
        <cell383 row="12" text="-6.52057" column="2"/>
        <cell384 row="13" text="-6.52042" column="2"/>
        <cell385 row="14" text="-6.52042" column="2"/>
        <cell386 row="15" text="-6.51981" column="2"/>
        <cell387 row="16" text="-6.51981" column="2"/>
        <cell388 row="17" text="-6.51921" column="2"/>
        <cell389 row="18" text="-6.51921" column="2"/>
        <cell390 row="19" text="-6.51870" column="2"/>
        <cell391 row="20" text="-6.51870" column="2"/>
        <cell392 row="21" text="-6.51810" column="2"/>
        <cell393 row="22" text="-6.51810" column="2"/>
        <cell394 row="23" text="-6.51748" column="2"/>
        <cell395 row="24" text="-6.51748" column="2"/>
        <cell396 row="25" text="-6.51685" column="2"/>
        <cell397 row="26" text="-6.51685" column="2"/>
        <cell398 row="27" text="-6.51625" column="2"/>
        <cell399 row="28" text="-6.51625" column="2"/>
        <cell400 row="29" text="-6.51614" column="2"/>
        <cell401 row="30" text="-6.51614" column="2"/>
        <cell402 row="31" text="-6.51553" column="2"/>
        <cell403 row="32" text="-6.51553" column="2"/>
        <cell404 row="33" text="-6.51490" column="2"/>
        <cell405 row="34" text="-6.51490" column="2"/>
        <cell406 row="35" text="-6.51428" column="2"/>
        <cell407 row="36" text="-6.51428" column="2"/>
        <cell408 row="37" text="-6.51368" column="2"/>
        <cell409 row="38" text="-6.51368" column="2"/>
        <cell410 row="39" text="-6.51343" column="2"/>
        <cell411 row="40" text="-6.51343" column="2"/>
        <cell412 row="41" text="-6.51283" column="2"/>
        <cell413 row="42" text="-6.51283" column="2"/>
        <cell414 row="43" text="-6.51222" column="2"/>
        <cell415 row="44" text="-6.51222" column="2"/>
        <cell416 row="45" text="-6.51169" column="2"/>
        <cell417 row="46" text="-6.51169" column="2"/>
        <cell418 row="47" text="-6.51109" column="2"/>
        <cell419 row="48" text="-6.51109" column="2"/>
        <cell420 row="49" text="-6.51048" column="2"/>
        <cell421 row="50" text="-6.51048" column="2"/>
        <cell422 row="51" text="-6.50987" column="2"/>
        <cell423 row="52" text="-6.50987" column="2"/>
        <cell424 row="53" text="-6.50927" column="2"/>
        <cell425 row="54" text="-6.50927" column="2"/>
        <cell426 row="55" text="-6.50871" column="2"/>
        <cell427 row="56" text="-6.50871" column="2"/>
        <cell428 row="57" text="-6.50868" column="2"/>
        <cell429 row="58" text="-6.50868" column="2"/>
        <cell430 row="59" text="-6.50808" column="2"/>
        <cell431 row="60" text="-6.50808" column="2"/>
        <cell432 row="61" text="-6.50749" column="2"/>
        <cell433 row="62" text="-6.50749" column="2"/>
        <cell434 row="63" text="-6.50690" column="2"/>
        <cell435 row="64" text="-6.50690" column="2"/>
        <cell436 row="65" text="-6.50650" column="2"/>
        <cell437 row="66" text="-6.50650" column="2"/>
        <cell438 row="67" text="-6.50589" column="2"/>
        <cell439 row="68" text="-6.50589" column="2"/>
        <cell440 row="69" text="-6.50529" column="2"/>
        <cell441 row="70" text="-6.50529" column="2"/>
        <cell442 row="71" text="-6.50478" column="2"/>
        <cell443 row="72" text="-6.50478" column="2"/>
        <cell444 row="73" text="-6.50418" column="2"/>
        <cell445 row="74" text="-6.50418" column="2"/>
        <cell446 row="75" text="-6.50356" column="2"/>
        <cell447 row="76" text="-6.50356" column="2"/>
        <cell448 row="77" text="-6.50302" column="2"/>
        <cell449 row="78" text="-6.50302" column="2"/>
        <cell450 row="79" text="-6.50241" column="2"/>
        <cell451 row="80" text="-6.50241" column="2"/>
        <cell452 row="81" text="-6.50182" column="2"/>
        <cell453 row="82" text="-6.50182" column="2"/>
        <cell454 row="83" text="-6.50121" column="2"/>
        <cell455 row="84" text="-6.50121" column="2"/>
        <cell456 row="85" text="-6.50061" column="2"/>
        <cell457 row="86" text="-6.50061" column="2"/>
        <cell458 row="87" text="-6.50002" column="2"/>
        <cell459 row="88" text="-6.50002" column="2"/>
        <cell460 row="89" text="-6.49941" column="2"/>
        <cell461 row="90" text="-6.49941" column="2"/>
        <cell462 row="91" text="-6.49883" column="2"/>
        <cell463 row="92" text="-6.49883" column="2"/>
        <cell464 row="93" text="-6.49825" column="2"/>
        <cell465 row="94" text="-6.49825" column="2"/>
        <cell466 row="95" text="-6.49768" column="2"/>
        <cell467 row="96" text="-6.49768" column="2"/>
        <cell468 row="97" text="-6.49711" column="2"/>
        <cell469 row="98" text="-6.49711" column="2"/>
        <cell470 row="99" text="-6.49650" column="2"/>
        <cell471 row="100" text="-6.49650" column="2"/>
        <cell472 row="101" text="-6.49620" column="2"/>
        <cell473 row="102" text="-6.49620" column="2"/>
        <cell474 row="103" text="-6.49557" column="2"/>
        <cell475 row="104" text="-6.49557" column="2"/>
        <cell476 row="105" text="-6.49493" column="2"/>
        <cell477 row="106" text="-6.49493" column="2"/>
        <cell478 row="107" text="-6.49438" column="2"/>
        <cell479 row="108" text="-6.49438" column="2"/>
        <cell480 row="109" text="-6.49373" column="2"/>
        <cell481 row="110" text="-6.49373" column="2"/>
        <cell482 row="111" text="-6.49310" column="2"/>
        <cell483 row="112" text="-6.49310" column="2"/>
        <cell484 row="113" text="-6.49246" column="2"/>
        <cell485 row="114" text="-6.49246" column="2"/>
        <cell486 row="115" text="-6.49189" column="2"/>
        <cell487 row="116" text="-6.49189" column="2"/>
        <cell488 row="117" text="-6.49134" column="2"/>
        <cell489 row="118" text="-6.49134" column="2"/>
        <cell490 row="119" text="-6.49095" column="2"/>
        <cell491 row="120" text="-6.49095" column="2"/>
        <cell492 row="121" text="-6.49038" column="2"/>
        <cell493 row="122" text="-6.49038" column="2"/>
        <cell494 row="123" text="-6.48980" column="2"/>
        <cell495 row="124" text="-6.48980" column="2"/>
        <cell496 row="125" text="-6.48926" column="2"/>
        <cell497 row="126" text="-6.48926" column="2"/>
        <cell498 row="127" text="-6.48870" column="2"/>
        <cell499 row="128" text="-6.48870" column="2"/>
        <cell500 row="129" text="-6.48811" column="2"/>
        <cell501 row="130" text="-6.48811" column="2"/>
        <cell502 row="131" text="-6.48749" column="2"/>
        <cell503 row="132" text="-6.48749" column="2"/>
        <cell504 row="133" text="-6.48688" column="2"/>
        <cell505 row="134" text="-6.48688" column="2"/>
        <cell506 row="135" text="-6.48625" column="2"/>
        <cell507 row="136" text="-6.48625" column="2"/>
        <cell508 row="137" text="-6.48563" column="2"/>
        <cell509 row="138" text="-6.48563" column="2"/>
        <cell510 row="139" text="-6.48505" column="2"/>
        <cell511 row="140" text="-6.48505" column="2"/>
        <cell512 row="141" text="-6.48452" column="2"/>
        <cell513 row="142" text="-6.48452" column="2"/>
        <cell514 row="143" text="-6.48427" column="2"/>
        <cell515 row="144" text="-6.48427" column="2"/>
        <cell516 row="145" text="-6.48374" column="2"/>
        <cell517 row="146" text="-6.48374" column="2"/>
        <cell518 row="147" text="-6.48281" column="2"/>
        <cell519 row="148" text="-6.48281" column="2"/>
        <cell520 row="149" text="-6.48227" column="2"/>
        <cell521 row="150" text="-6.48227" column="2"/>
        <cell522 row="151" text="-6.48173" column="2"/>
        <cell523 row="152" text="-6.48173" column="2"/>
        <cell524 row="153" text="-6.48125" column="2"/>
        <cell525 row="154" text="-6.48125" column="2"/>
        <cell526 row="155" text="-6.48078" column="2"/>
        <cell527 row="156" text="-6.48078" column="2"/>
        <cell528 row="157" text="-6.48031" column="2"/>
        <cell529 row="158" text="-6.48031" column="2"/>
        <cell530 row="159" text="-6.47984" column="2"/>
        <cell531 row="160" text="-6.47984" column="2"/>
        <cell532 row="161" text="-6.47940" column="2"/>
        <cell533 row="162" text="-6.47940" column="2"/>
        <cell534 row="163" text="-6.47901" column="2"/>
        <cell535 row="164" text="-6.47901" column="2"/>
        <cell536 row="165" text="-6.47867" column="2"/>
        <cell537 row="166" text="-6.47867" column="2"/>
        <cell538 row="167" text="-6.47830" column="2"/>
        <cell539 row="168" text="-6.47830" column="2"/>
        <cell540 row="169" text="-6.47792" column="2"/>
        <cell541 row="170" text="-6.47792" column="2"/>
        <cell542 row="171" text="-6.47773" column="2"/>
        <cell543 row="172" text="-6.47773" column="2"/>
        <cell544 row="173" text="-6.47737" column="2"/>
        <cell545 row="174" text="-6.47737" column="2"/>
        <cell546 row="175" text="-6.47705" column="2"/>
        <cell547 row="176" text="-6.47705" column="2"/>
        <cell548 row="177" text="-6.47671" column="2"/>
        <cell549 row="178" text="-6.47671" column="2"/>
        <cell550 row="179" text="-6.47637" column="2"/>
        <cell551 row="180" text="-6.47637" column="2"/>
        <cell552 row="181" text="-6.47603" column="2"/>
        <cell553 row="182" text="-6.47603" column="2"/>
        <cell554 row="183" text="-6.47571" column="2"/>
        <cell555 row="184" text="-6.47571" column="2"/>
        <cell556 row="0" text="LONGITUDE" column="3"/>
        <cell557 row="1" text="105.62165" column="3"/>
        <cell558 row="2" text="105.62171" column="3"/>
        <cell559 row="3" text="105.62171" column="3"/>
        <cell560 row="4" text="105.62200" column="3"/>
        <cell561 row="5" text="105.62200" column="3"/>
        <cell562 row="6" text="105.62232" column="3"/>
        <cell563 row="7" text="105.62232" column="3"/>
        <cell564 row="8" text="105.62267" column="3"/>
        <cell565 row="9" text="105.62267" column="3"/>
        <cell566 row="10" text="105.62299" column="3"/>
        <cell567 row="11" text="105.62299" column="3"/>
        <cell568 row="12" text="105.62331" column="3"/>
        <cell569 row="13" text="105.62331" column="3"/>
        <cell570 row="14" text="105.62337" column="3"/>
        <cell571 row="15" text="105.62337" column="3"/>
        <cell572 row="16" text="105.62368" column="3"/>
        <cell573 row="17" text="105.62368" column="3"/>
        <cell574 row="18" text="105.62402" column="3"/>
        <cell575 row="19" text="105.62402" column="3"/>
        <cell576 row="20" text="105.62431" column="3"/>
        <cell577 row="21" text="105.62431" column="3"/>
        <cell578 row="22" text="105.62461" column="3"/>
        <cell579 row="23" text="105.62461" column="3"/>
        <cell580 row="24" text="105.62490" column="3"/>
        <cell581 row="25" text="105.62490" column="3"/>
        <cell582 row="26" text="105.62518" column="3"/>
        <cell583 row="27" text="105.62518" column="3"/>
        <cell584 row="28" text="105.62551" column="3"/>
        <cell585 row="29" text="105.62551" column="3"/>
        <cell586 row="30" text="105.62559" column="3"/>
        <cell587 row="31" text="105.62559" column="3"/>
        <cell588 row="32" text="105.62593" column="3"/>
        <cell589 row="33" text="105.62593" column="3"/>
        <cell590 row="34" text="105.62622" column="3"/>
        <cell591 row="35" text="105.62622" column="3"/>
        <cell592 row="36" text="105.62653" column="3"/>
        <cell593 row="37" text="105.62653" column="3"/>
        <cell594 row="38" text="105.62687" column="3"/>
        <cell595 row="39" text="105.62687" column="3"/>
        <cell596 row="40" text="105.62703" column="3"/>
        <cell597 row="41" text="105.62703" column="3"/>
        <cell598 row="42" text="105.62735" column="3"/>
        <cell599 row="43" text="105.62735" column="3"/>
        <cell600 row="44" text="105.62767" column="3"/>
        <cell601 row="45" text="105.62767" column="3"/>
        <cell602 row="46" text="105.62794" column="3"/>
        <cell603 row="47" text="105.62794" column="3"/>
        <cell604 row="48" text="105.62827" column="3"/>
        <cell605 row="49" text="105.62827" column="3"/>
        <cell606 row="50" text="105.62862" column="3"/>
        <cell607 row="51" text="105.62862" column="3"/>
        <cell608 row="52" text="105.62894" column="3"/>
        <cell609 row="53" text="105.62894" column="3"/>
        <cell610 row="54" text="105.62929" column="3"/>
        <cell611 row="55" text="105.62929" column="3"/>
        <cell612 row="56" text="105.62958" column="3"/>
        <cell613 row="57" text="105.62958" column="3"/>
        <cell614 row="58" text="105.62959" column="3"/>
        <cell615 row="59" text="105.62959" column="3"/>
        <cell616 row="60" text="105.62992" column="3"/>
        <cell617 row="61" text="105.62992" column="3"/>
        <cell618 row="62" text="105.63029" column="3"/>
        <cell619 row="63" text="105.63029" column="3"/>
        <cell620 row="64" text="105.63065" column="3"/>
        <cell621 row="65" text="105.63065" column="3"/>
        <cell622 row="66" text="105.63087" column="3"/>
        <cell623 row="67" text="105.63087" column="3"/>
        <cell624 row="68" text="105.63120" column="3"/>
        <cell625 row="69" text="105.63120" column="3"/>
        <cell626 row="70" text="105.63155" column="3"/>
        <cell627 row="71" text="105.63155" column="3"/>
        <cell628 row="72" text="105.63186" column="3"/>
        <cell629 row="73" text="105.63186" column="3"/>
        <cell630 row="74" text="105.63219" column="3"/>
        <cell631 row="75" text="105.63219" column="3"/>
        <cell632 row="76" text="105.63246" column="3"/>
        <cell633 row="77" text="105.63246" column="3"/>
        <cell634 row="78" text="105.63270" column="3"/>
        <cell635 row="79" text="105.63270" column="3"/>
        <cell636 row="80" text="105.63301" column="3"/>
        <cell637 row="81" text="105.63301" column="3"/>
        <cell638 row="82" text="105.63334" column="3"/>
        <cell639 row="83" text="105.63334" column="3"/>
        <cell640 row="84" text="105.63367" column="3"/>
        <cell641 row="85" text="105.63367" column="3"/>
        <cell642 row="86" text="105.63400" column="3"/>
        <cell643 row="87" text="105.63400" column="3"/>
        <cell644 row="88" text="105.63434" column="3"/>
        <cell645 row="89" text="105.63434" column="3"/>
        <cell646 row="90" text="105.63467" column="3"/>
        <cell647 row="91" text="105.63467" column="3"/>
        <cell648 row="92" text="105.63502" column="3"/>
        <cell649 row="93" text="105.63502" column="3"/>
        <cell650 row="94" text="105.63539" column="3"/>
        <cell651 row="95" text="105.63539" column="3"/>
        <cell652 row="96" text="105.63577" column="3"/>
        <cell653 row="97" text="105.63577" column="3"/>
        <cell654 row="98" text="105.63615" column="3"/>
        <cell655 row="99" text="105.63615" column="3"/>
        <cell656 row="100" text="105.63647" column="3"/>
        <cell657 row="101" text="105.63647" column="3"/>
        <cell658 row="102" text="105.63659" column="3"/>
        <cell659 row="103" text="105.63659" column="3"/>
        <cell660 row="104" text="105.63686" column="3"/>
        <cell661 row="105" text="105.63686" column="3"/>
        <cell662 row="106" text="105.63712" column="3"/>
        <cell663 row="107" text="105.63712" column="3"/>
        <cell664 row="108" text="105.63732" column="3"/>
        <cell665 row="109" text="105.63732" column="3"/>
        <cell666 row="110" text="105.63762" column="3"/>
        <cell667 row="111" text="105.63762" column="3"/>
        <cell668 row="112" text="105.63788" column="3"/>
        <cell669 row="113" text="105.63788" column="3"/>
        <cell670 row="114" text="105.63815" column="3"/>
        <cell671 row="115" text="105.63815" column="3"/>
        <cell672 row="116" text="105.63854" column="3"/>
        <cell673 row="117" text="105.63854" column="3"/>
        <cell674 row="118" text="105.63898" column="3"/>
        <cell675 row="119" text="105.63898" column="3"/>
        <cell676 row="120" text="105.63927" column="3"/>
        <cell677 row="121" text="105.63927" column="3"/>
        <cell678 row="122" text="105.63963" column="3"/>
        <cell679 row="123" text="105.63963" column="3"/>
        <cell680 row="124" text="105.63998" column="3"/>
        <cell681 row="125" text="105.63998" column="3"/>
        <cell682 row="126" text="105.64038" column="3"/>
        <cell683 row="127" text="105.64038" column="3"/>
        <cell684 row="128" text="105.64081" column="3"/>
        <cell685 row="129" text="105.64081" column="3"/>
        <cell686 row="130" text="105.64116" column="3"/>
        <cell687 row="131" text="105.64116" column="3"/>
        <cell688 row="132" text="105.64144" column="3"/>
        <cell689 row="133" text="105.64144" column="3"/>
        <cell690 row="134" text="105.64175" column="3"/>
        <cell691 row="135" text="105.64175" column="3"/>
        <cell692 row="136" text="105.64201" column="3"/>
        <cell693 row="137" text="105.64201" column="3"/>
        <cell694 row="138" text="105.64232" column="3"/>
        <cell695 row="139" text="105.64232" column="3"/>
        <cell696 row="140" text="105.64272" column="3"/>
        <cell697 row="141" text="105.64272" column="3"/>
        <cell698 row="142" text="105.64314" column="3"/>
        <cell699 row="143" text="105.64314" column="3"/>
        <cell700 row="144" text="105.64335" column="3"/>
        <cell701 row="145" text="105.64335" column="3"/>
        <cell702 row="146" text="105.64381" column="3"/>
        <cell703 row="147" text="105.64381" column="3"/>
        <cell704 row="148" text="105.64462" column="3"/>
        <cell705 row="149" text="105.64462" column="3"/>
        <cell706 row="150" text="105.64505" column="3"/>
        <cell707 row="151" text="105.64505" column="3"/>
        <cell708 row="152" text="105.64548" column="3"/>
        <cell709 row="153" text="105.64548" column="3"/>
        <cell710 row="154" text="105.64598" column="3"/>
        <cell711 row="155" text="105.64598" column="3"/>
        <cell712 row="156" text="105.64650" column="3"/>
        <cell713 row="157" text="105.64650" column="3"/>
        <cell714 row="158" text="105.64700" column="3"/>
        <cell715 row="159" text="105.64700" column="3"/>
        <cell716 row="160" text="105.64749" column="3"/>
        <cell717 row="161" text="105.64749" column="3"/>
        <cell718 row="162" text="105.64801" column="3"/>
        <cell719 row="163" text="105.64801" column="3"/>
        <cell720 row="164" text="105.64854" column="3"/>
        <cell721 row="165" text="105.64854" column="3"/>
        <cell722 row="166" text="105.64908" column="3"/>
        <cell723 row="167" text="105.64908" column="3"/>
        <cell724 row="168" text="105.64960" column="3"/>
        <cell725 row="169" text="105.64960" column="3"/>
        <cell726 row="170" text="105.65013" column="3"/>
        <cell727 row="171" text="105.65013" column="3"/>
        <cell728 row="172" text="105.65040" column="3"/>
        <cell729 row="173" text="105.65040" column="3"/>
        <cell730 row="174" text="105.65092" column="3"/>
        <cell731 row="175" text="105.65092" column="3"/>
        <cell732 row="176" text="105.65146" column="3"/>
        <cell733 row="177" text="105.65146" column="3"/>
        <cell734 row="178" text="105.65199" column="3"/>
        <cell735 row="179" text="105.65199" column="3"/>
        <cell736 row="180" text="105.65252" column="3"/>
        <cell737 row="181" text="105.65252" column="3"/>
        <cell738 row="182" text="105.65305" column="3"/>
        <cell739 row="183" text="105.65305" column="3"/>
        <cell740 row="184" text="105.65356" column="3"/>
      </cells>
    </content>
  </grid>
</CONFIG>

lumayan panjang,. tetapi ini hanya sebuah contoh, agan bisa kembangkan lagi isi xml.a
sekarang kita buat program penerjemahnya,.  buatlah file dengan nama javascript.html ingat kawan,
exstensinya html, berikut scriptnya

<html>
<head>
<title>Read First Child</title>
<script language="JavaScript">
    if (window.XMLHttpRequest) {// code for IE7+, Firefox, Chrome, Opera, Safari
        xmlhttp = new XMLHttpRequest();
    }
    else {// code for IE6, IE5
        xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
    }
    xmlhttp.open("GET", "11-42.xml", false);
    xmlhttp.send();
    xmlDoc = xmlhttp.responseXML;

    
    var t_date = new Array ();
var t_time = new Array ();
var t_lat  = new Array ();
var t_lng  = new Array ();
var t_imei = new Array ("<td style='width:30%'>IMEI</td>");
    for (i = 1; i < 1100; i++) {
         var y = xmlDoc.getElementsByTagName("cell"+i);
var a;
         for (j = 0; j < y.length; j++) {
            if (y[j].getAttribute("text") == "DATE") {
a = "0";
            }if ( a == '0' && y[j].getAttribute("text") != "TIME"){ t_date.push("<td style='width:30%;'>" + y[j].getAttribute('text') + "</td>");
                                                       t_imei.push("<td style='width:30%'>360003</td>");
                                                     }
if (y[j].getAttribute("text") == "TIME") {
a = "1";
            }if ( a == '1' && y[j].getAttribute("text") != "LATITUDE" ){ t_time.push("<td style='width:30%'>" + y[j].getAttribute('text') + "</td>");}
            if (y[j].getAttribute("text") == "LATITUDE") {
a = "2";
            }if ( a == '2' && y[j].getAttribute("text") != "LONGITUDE" ){ t_lat.push("<td style='width:30%'>" + y[j].getAttribute('text') + "</td>");}
            if (y[j].getAttribute("text") == "LONGITUDE") {
a = "3";
            }if ( a == '3' ){ t_lng.push("<td style='width:30%'>" + y[j].getAttribute('text') + "</td>");}
        }
    }
document.write("<table style='width:500px;border:1px solid #ccc;'>");
for (k = 0; k < t_date.length; k++ ){
 document.write("<tr style='background:#f8f8f8;'>"+t_imei[k]+""+t_date[k]+""+t_time[k]+""+t_lat[k]+""+t_lng[k]+"</tr>");
}
    document.write("</table>");
</script>
</head>
</html>

sekian dari saya semoga bermanfaat,..

konversi file xml, text, trx ke html tabel menggunakan program php

salam, kali ini pembahasan tentang program kecil yang berfungsi untuk merubah atau konversi file xml kedalam tabel html,. untuk agan yang sudah mengenal program php akan lebih mudah mengikuti petunjuk ini, karena konversi ini menggunakan program tersebut, okey kita ke tkp

simpan file ini dengan extensi xml  namefile.xml

<?xml version="1.0" encoding="utf-8"?>
<CONFIG>
  <grid version="3">
    <saveoptions create="False" content="True" position="False"/>
    <content>
      <cells cellcount="724">
        <cell1 row="0" text="DATE" column="0"/>
        <cell2 row="1" text="2017-08-05" column="0"/>
        <cell3 row="2" text="2017-08-05" column="0"/>
        <cell4 row="3" text="2017-08-05" column="0"/>
        <cell5 row="4" text="2017-08-05" column="0"/>
        <cell6 row="5" text="2017-08-05" column="0"/>
        <cell7 row="6" text="2017-08-05" column="0"/>
        <cell8 row="7" text="2017-08-05" column="0"/>
        <cell9 row="8" text="2017-08-05" column="0"/>
        <cell10 row="9" text="2017-08-05" column="0"/>
        <cell11 row="10" text="2017-08-05" column="0"/>
        <cell12 row="11" text="2017-08-05" column="0"/>
        <cell13 row="12" text="2017-08-05" column="0"/>
        <cell14 row="13" text="2017-08-05" column="0"/>
        <cell15 row="14" text="2017-08-05" column="0"/>
        <cell16 row="15" text="2017-08-05" column="0"/>
        <cell17 row="16" text="2017-08-05" column="0"/>
        <cell18 row="17" text="2017-08-05" column="0"/>
        <cell19 row="18" text="2017-08-05" column="0"/>
        <cell20 row="19" text="2017-08-05" column="0"/>
        <cell21 row="20" text="2017-08-05" column="0"/>
        <cell22 row="21" text="2017-08-05" column="0"/>
        <cell23 row="22" text="2017-08-05" column="0"/>
        <cell24 row="23" text="2017-08-05" column="0"/>
        <cell25 row="24" text="2017-08-05" column="0"/>
        <cell26 row="25" text="2017-08-05" column="0"/>
        <cell27 row="26" text="2017-08-05" column="0"/>
        <cell28 row="27" text="2017-08-05" column="0"/>
        <cell29 row="28" text="2017-08-05" column="0"/>
        <cell30 row="29" text="2017-08-05" column="0"/>
        <cell31 row="30" text="2017-08-05" column="0"/>
        <cell32 row="31" text="2017-08-05" column="0"/>
        <cell33 row="32" text="2017-08-05" column="0"/>
        <cell34 row="33" text="2017-08-05" column="0"/>
        <cell35 row="34" text="2017-08-05" column="0"/>
        <cell36 row="35" text="2017-08-05" column="0"/>
        <cell37 row="36" text="2017-08-05" column="0"/>
        <cell38 row="37" text="2017-08-05" column="0"/>
        <cell39 row="38" text="2017-08-05" column="0"/>
        <cell40 row="39" text="2017-08-05" column="0"/>
        <cell41 row="40" text="2017-08-05" column="0"/>
        <cell42 row="41" text="2017-08-05" column="0"/>
        <cell43 row="42" text="2017-08-05" column="0"/>
        <cell44 row="43" text="2017-08-05" column="0"/>
        <cell45 row="44" text="2017-08-05" column="0"/>
        <cell46 row="45" text="2017-08-05" column="0"/>
        <cell47 row="46" text="2017-08-05" column="0"/>
        <cell48 row="47" text="2017-08-05" column="0"/>
        <cell49 row="48" text="2017-08-05" column="0"/>
        <cell50 row="49" text="2017-08-05" column="0"/>
        <cell51 row="50" text="2017-08-05" column="0"/>
        <cell52 row="51" text="2017-08-05" column="0"/>
        <cell53 row="52" text="2017-08-05" column="0"/>
        <cell54 row="53" text="2017-08-05" column="0"/>
        <cell55 row="54" text="2017-08-05" column="0"/>
        <cell56 row="55" text="2017-08-05" column="0"/>
        <cell57 row="56" text="2017-08-05" column="0"/>
        <cell58 row="57" text="2017-08-05" column="0"/>
        <cell59 row="58" text="2017-08-05" column="0"/>
        <cell60 row="59" text="2017-08-05" column="0"/>
        <cell61 row="60" text="2017-08-05" column="0"/>
        <cell62 row="61" text="2017-08-05" column="0"/>
        <cell63 row="62" text="2017-08-05" column="0"/>
        <cell64 row="63" text="2017-08-05" column="0"/>
        <cell65 row="64" text="2017-08-05" column="0"/>
        <cell66 row="65" text="2017-08-05" column="0"/>
        <cell67 row="66" text="2017-08-05" column="0"/>
        <cell68 row="67" text="2017-08-05" column="0"/>
        <cell69 row="68" text="2017-08-05" column="0"/>
        <cell70 row="69" text="2017-08-05" column="0"/>
        <cell71 row="70" text="2017-08-05" column="0"/>
        <cell72 row="71" text="2017-08-05" column="0"/>
        <cell73 row="72" text="2017-08-05" column="0"/>
        <cell74 row="73" text="2017-08-05" column="0"/>
        <cell75 row="74" text="2017-08-05" column="0"/>
        <cell76 row="75" text="2017-08-05" column="0"/>
        <cell77 row="76" text="2017-08-05" column="0"/>
        <cell78 row="77" text="2017-08-05" column="0"/>
        <cell79 row="78" text="2017-08-05" column="0"/>
        <cell80 row="79" text="2017-08-05" column="0"/>
        <cell81 row="80" text="2017-08-05" column="0"/>
        <cell82 row="81" text="2017-08-05" column="0"/>
        <cell83 row="82" text="2017-08-05" column="0"/>
        <cell84 row="83" text="2017-08-05" column="0"/>
        <cell85 row="84" text="2017-08-05" column="0"/>
        <cell86 row="85" text="2017-08-05" column="0"/>
        <cell87 row="86" text="2017-08-05" column="0"/>
        <cell88 row="87" text="2017-08-05" column="0"/>
        <cell89 row="88" text="2017-08-05" column="0"/>
        <cell90 row="89" text="2017-08-05" column="0"/>
        <cell91 row="90" text="2017-08-05" column="0"/>
        <cell92 row="91" text="2017-08-05" column="0"/>
        <cell93 row="92" text="2017-08-05" column="0"/>
        <cell94 row="93" text="2017-08-05" column="0"/>
        <cell95 row="94" text="2017-08-05" column="0"/>
        <cell96 row="95" text="2017-08-05" column="0"/>
        <cell97 row="96" text="2017-08-05" column="0"/>
        <cell98 row="97" text="2017-08-05" column="0"/>
        <cell99 row="98" text="2017-08-05" column="0"/>
        <cell100 row="99" text="2017-08-05" column="0"/>
        <cell101 row="100" text="2017-08-05" column="0"/>
        <cell102 row="101" text="2017-08-05" column="0"/>
        <cell103 row="102" text="2017-08-05" column="0"/>
        <cell104 row="103" text="2017-08-05" column="0"/>
        <cell105 row="104" text="2017-08-05" column="0"/>
        <cell106 row="105" text="2017-08-05" column="0"/>
        <cell107 row="106" text="2017-08-05" column="0"/>
        <cell108 row="107" text="2017-08-05" column="0"/>
        <cell109 row="108" text="2017-08-05" column="0"/>
        <cell110 row="109" text="2017-08-05" column="0"/>
        <cell111 row="110" text="2017-08-05" column="0"/>
        <cell112 row="111" text="2017-08-05" column="0"/>
        <cell113 row="112" text="2017-08-05" column="0"/>
        <cell114 row="113" text="2017-08-05" column="0"/>
        <cell115 row="114" text="2017-08-05" column="0"/>
        <cell116 row="115" text="2017-08-05" column="0"/>
        <cell117 row="116" text="2017-08-05" column="0"/>
        <cell118 row="117" text="2017-08-05" column="0"/>
        <cell119 row="118" text="2017-08-05" column="0"/>
        <cell120 row="119" text="2017-08-05" column="0"/>
        <cell121 row="120" text="2017-08-05" column="0"/>
        <cell122 row="121" text="2017-08-05" column="0"/>
        <cell123 row="122" text="2017-08-05" column="0"/>
        <cell124 row="123" text="2017-08-05" column="0"/>
        <cell125 row="124" text="2017-08-05" column="0"/>
        <cell126 row="125" text="2017-08-05" column="0"/>
        <cell127 row="126" text="2017-08-05" column="0"/>
        <cell128 row="127" text="2017-08-05" column="0"/>
        <cell129 row="128" text="2017-08-05" column="0"/>
        <cell130 row="129" text="2017-08-05" column="0"/>
        <cell131 row="130" text="2017-08-05" column="0"/>
        <cell132 row="131" text="2017-08-05" column="0"/>
        <cell133 row="132" text="2017-08-05" column="0"/>
        <cell134 row="133" text="2017-08-05" column="0"/>
        <cell135 row="134" text="2017-08-05" column="0"/>
        <cell136 row="135" text="2017-08-05" column="0"/>
        <cell137 row="136" text="2017-08-05" column="0"/>
        <cell138 row="137" text="2017-08-05" column="0"/>
        <cell139 row="138" text="2017-08-05" column="0"/>
        <cell140 row="139" text="2017-08-05" column="0"/>
        <cell141 row="140" text="2017-08-05" column="0"/>
        <cell142 row="141" text="2017-08-05" column="0"/>
        <cell143 row="142" text="2017-08-05" column="0"/>
        <cell144 row="143" text="2017-08-05" column="0"/>
        <cell145 row="144" text="2017-08-05" column="0"/>
        <cell146 row="145" text="2017-08-05" column="0"/>
        <cell147 row="146" text="2017-08-05" column="0"/>
        <cell148 row="147" text="2017-08-05" column="0"/>
        <cell149 row="148" text="2017-08-05" column="0"/>
        <cell150 row="149" text="2017-08-05" column="0"/>
        <cell151 row="150" text="2017-08-05" column="0"/>
        <cell152 row="151" text="2017-08-05" column="0"/>
        <cell153 row="152" text="2017-08-05" column="0"/>
        <cell154 row="153" text="2017-08-05" column="0"/>
        <cell155 row="154" text="2017-08-05" column="0"/>
        <cell156 row="155" text="2017-08-05" column="0"/>
        <cell157 row="156" text="2017-08-05" column="0"/>
        <cell158 row="157" text="2017-08-05" column="0"/>
        <cell159 row="158" text="2017-08-05" column="0"/>
        <cell160 row="159" text="2017-08-05" column="0"/>
        <cell161 row="160" text="2017-08-05" column="0"/>
        <cell162 row="161" text="2017-08-05" column="0"/>
        <cell163 row="162" text="2017-08-05" column="0"/>
        <cell164 row="163" text="2017-08-05" column="0"/>
        <cell165 row="164" text="2017-08-05" column="0"/>
        <cell166 row="165" text="2017-08-05" column="0"/>
        <cell167 row="166" text="2017-08-05" column="0"/>
        <cell168 row="167" text="2017-08-05" column="0"/>
        <cell169 row="168" text="2017-08-05" column="0"/>
        <cell170 row="169" text="2017-08-05" column="0"/>
        <cell171 row="170" text="2017-08-05" column="0"/>
        <cell172 row="171" text="2017-08-05" column="0"/>
        <cell173 row="172" text="2017-08-05" column="0"/>
        <cell174 row="173" text="2017-08-05" column="0"/>
        <cell175 row="174" text="2017-08-05" column="0"/>
        <cell176 row="175" text="2017-08-05" column="0"/>
        <cell177 row="176" text="2017-08-05" column="0"/>
        <cell178 row="177" text="2017-08-05" column="0"/>
        <cell179 row="178" text="2017-08-05" column="0"/>
        <cell180 row="179" text="2017-08-05" column="0"/>
        <cell181 row="180" text="2017-08-05" column="0"/>
        <cell182 row="0" text="TIME" column="1"/>
        <cell183 row="1" text="11:12" column="1"/>
        <cell184 row="2" text="11:12" column="1"/>
        <cell185 row="3" text="11:12" column="1"/>
        <cell186 row="4" text="11:12" column="1"/>
        <cell187 row="5" text="11:13" column="1"/>
        <cell188 row="6" text="11:13" column="1"/>
        <cell189 row="7" text="11:13" column="1"/>
        <cell190 row="8" text="11:13" column="1"/>
        <cell191 row="9" text="11:13" column="1"/>
        <cell192 row="10" text="11:13" column="1"/>
        <cell193 row="11" text="11:14" column="1"/>
        <cell194 row="12" text="11:14" column="1"/>
        <cell195 row="13" text="11:14" column="1"/>
        <cell196 row="14" text="11:14" column="1"/>
        <cell197 row="15" text="11:14" column="1"/>
        <cell198 row="16" text="11:14" column="1"/>
        <cell199 row="17" text="11:15" column="1"/>
        <cell200 row="18" text="11:15" column="1"/>
        <cell201 row="19" text="11:15" column="1"/>
        <cell202 row="20" text="11:15" column="1"/>
        <cell203 row="21" text="11:15" column="1"/>
        <cell204 row="22" text="11:15" column="1"/>
        <cell205 row="23" text="11:15" column="1"/>
        <cell206 row="24" text="11:15" column="1"/>
        <cell207 row="25" text="11:16" column="1"/>
        <cell208 row="26" text="11:16" column="1"/>
        <cell209 row="27" text="11:16" column="1"/>
        <cell210 row="28" text="11:16" column="1"/>
        <cell211 row="29" text="11:17" column="1"/>
        <cell212 row="30" text="11:17" column="1"/>
        <cell213 row="31" text="11:17" column="1"/>
        <cell214 row="32" text="11:17" column="1"/>
        <cell215 row="33" text="11:17" column="1"/>
        <cell216 row="34" text="11:17" column="1"/>
        <cell217 row="35" text="11:18" column="1"/>
        <cell218 row="36" text="11:18" column="1"/>
        <cell219 row="37" text="11:18" column="1"/>
        <cell220 row="38" text="11:18" column="1"/>
        <cell221 row="39" text="11:18" column="1"/>
        <cell222 row="40" text="11:18" column="1"/>
        <cell223 row="41" text="11:19" column="1"/>
        <cell224 row="42" text="11:19" column="1"/>
        <cell225 row="43" text="11:19" column="1"/>
        <cell226 row="44" text="11:19" column="1"/>
        <cell227 row="45" text="11:19" column="1"/>
        <cell228 row="46" text="11:19" column="1"/>
        <cell229 row="47" text="11:20" column="1"/>
        <cell230 row="48" text="11:20" column="1"/>
        <cell231 row="49" text="11:20" column="1"/>
        <cell232 row="50" text="11:20" column="1"/>
        <cell233 row="51" text="11:20" column="1"/>
        <cell234 row="52" text="11:20" column="1"/>
        <cell235 row="53" text="11:21" column="1"/>
        <cell236 row="54" text="11:21" column="1"/>
        <cell237 row="55" text="11:21" column="1"/>
        <cell238 row="56" text="11:21" column="1"/>
        <cell239 row="57" text="11:21" column="1"/>
        <cell240 row="58" text="11:21" column="1"/>
        <cell241 row="59" text="11:22" column="1"/>
        <cell242 row="60" text="11:22" column="1"/>
        <cell243 row="61" text="11:22" column="1"/>
        <cell244 row="62" text="11:22" column="1"/>
        <cell245 row="63" text="11:22" column="1"/>
        <cell246 row="64" text="11:22" column="1"/>
        <cell247 row="65" text="11:23" column="1"/>
        <cell248 row="66" text="11:23" column="1"/>
        <cell249 row="67" text="11:23" column="1"/>
        <cell250 row="68" text="11:23" column="1"/>
        <cell251 row="69" text="11:24" column="1"/>
        <cell252 row="70" text="11:24" column="1"/>
        <cell253 row="71" text="11:24" column="1"/>
        <cell254 row="72" text="11:24" column="1"/>
        <cell255 row="73" text="11:24" column="1"/>
        <cell256 row="74" text="11:24" column="1"/>
        <cell257 row="75" text="11:25" column="1"/>
        <cell258 row="76" text="11:25" column="1"/>
        <cell259 row="77" text="11:25" column="1"/>
        <cell260 row="78" text="11:25" column="1"/>
        <cell261 row="79" text="11:25" column="1"/>
        <cell262 row="80" text="11:25" column="1"/>
        <cell263 row="81" text="11:26" column="1"/>
        <cell264 row="82" text="11:26" column="1"/>
        <cell265 row="83" text="11:26" column="1"/>
        <cell266 row="84" text="11:26" column="1"/>
        <cell267 row="85" text="11:26" column="1"/>
        <cell268 row="86" text="11:26" column="1"/>
        <cell269 row="87" text="11:27" column="1"/>
        <cell270 row="88" text="11:27" column="1"/>
        <cell271 row="89" text="11:27" column="1"/>
        <cell272 row="90" text="11:27" column="1"/>
        <cell273 row="91" text="11:27" column="1"/>
        <cell274 row="92" text="11:27" column="1"/>
        <cell275 row="93" text="11:28" column="1"/>
        <cell276 row="94" text="11:28" column="1"/>
        <cell277 row="95" text="11:28" column="1"/>
        <cell278 row="96" text="11:28" column="1"/>
        <cell279 row="97" text="11:28" column="1"/>
        <cell280 row="98" text="11:28" column="1"/>
        <cell281 row="99" text="11:29" column="1"/>
        <cell282 row="100" text="11:29" column="1"/>
        <cell283 row="101" text="11:29" column="1"/>
        <cell284 row="102" text="11:29" column="1"/>
        <cell285 row="103" text="11:29" column="1"/>
        <cell286 row="104" text="11:29" column="1"/>
        <cell287 row="105" text="11:29" column="1"/>
        <cell288 row="106" text="11:29" column="1"/>
        <cell289 row="107" text="11:30" column="1"/>
        <cell290 row="108" text="11:30" column="1"/>
        <cell291 row="109" text="11:30" column="1"/>
        <cell292 row="110" text="11:30" column="1"/>
        <cell293 row="111" text="11:30" column="1"/>
        <cell294 row="112" text="11:30" column="1"/>
        <cell295 row="113" text="11:31" column="1"/>
        <cell296 row="114" text="11:31" column="1"/>
        <cell297 row="115" text="11:31" column="1"/>
        <cell298 row="116" text="11:31" column="1"/>
        <cell299 row="117" text="11:31" column="1"/>
        <cell300 row="118" text="11:31" column="1"/>
        <cell301 row="119" text="11:32" column="1"/>
        <cell302 row="120" text="11:32" column="1"/>
        <cell303 row="121" text="11:32" column="1"/>
        <cell304 row="122" text="11:32" column="1"/>
        <cell305 row="123" text="11:32" column="1"/>
        <cell306 row="124" text="11:32" column="1"/>
        <cell307 row="125" text="11:33" column="1"/>
        <cell308 row="126" text="11:33" column="1"/>
        <cell309 row="127" text="11:33" column="1"/>
        <cell310 row="128" text="11:33" column="1"/>
        <cell311 row="129" text="11:33" column="1"/>
        <cell312 row="130" text="11:33" column="1"/>
        <cell313 row="131" text="11:34" column="1"/>
        <cell314 row="132" text="11:34" column="1"/>
        <cell315 row="133" text="11:34" column="1"/>
        <cell316 row="134" text="11:34" column="1"/>
        <cell317 row="135" text="11:34" column="1"/>
        <cell318 row="136" text="11:34" column="1"/>
        <cell319 row="137" text="11:34" column="1"/>
        <cell320 row="138" text="11:34" column="1"/>
        <cell321 row="139" text="11:35" column="1"/>
        <cell322 row="140" text="11:35" column="1"/>
        <cell323 row="141" text="11:35" column="1"/>
        <cell324 row="142" text="11:35" column="1"/>
        <cell325 row="143" text="11:35" column="1"/>
        <cell326 row="144" text="11:35" column="1"/>
        <cell327 row="145" text="11:36" column="1"/>
        <cell328 row="146" text="11:36" column="1"/>
        <cell329 row="147" text="11:36" column="1"/>
        <cell330 row="148" text="11:36" column="1"/>
        <cell331 row="149" text="11:36" column="1"/>
        <cell332 row="150" text="11:36" column="1"/>
        <cell333 row="151" text="11:37" column="1"/>
        <cell334 row="152" text="11:37" column="1"/>
        <cell335 row="153" text="11:37" column="1"/>
        <cell336 row="154" text="11:37" column="1"/>
        <cell337 row="155" text="11:37" column="1"/>
        <cell338 row="156" text="11:37" column="1"/>
        <cell339 row="157" text="11:38" column="1"/>
        <cell340 row="158" text="11:38" column="1"/>
        <cell341 row="159" text="11:38" column="1"/>
        <cell342 row="160" text="11:38" column="1"/>
        <cell343 row="161" text="11:38" column="1"/>
        <cell344 row="162" text="11:38" column="1"/>
        <cell345 row="163" text="11:39" column="1"/>
        <cell346 row="164" text="11:39" column="1"/>
        <cell347 row="165" text="11:39" column="1"/>
        <cell348 row="166" text="11:39" column="1"/>
        <cell349 row="167" text="11:39" column="1"/>
        <cell350 row="168" text="11:39" column="1"/>
        <cell351 row="169" text="11:40" column="1"/>
        <cell352 row="170" text="11:40" column="1"/>
        <cell353 row="171" text="11:40" column="1"/>
        <cell354 row="172" text="11:40" column="1"/>
        <cell355 row="173" text="11:40" column="1"/>
        <cell356 row="174" text="11:40" column="1"/>
        <cell357 row="175" text="11:41" column="1"/>
        <cell358 row="176" text="11:41" column="1"/>
        <cell359 row="177" text="11:41" column="1"/>
        <cell360 row="178" text="11:41" column="1"/>
        <cell361 row="179" text="11:41" column="1"/>
        <cell362 row="180" text="11:41" column="1"/>
        <cell363 row="0" text="LATITUDE" column="2"/>
        <cell364 row="1" text="-6.45971" column="2"/>
        <cell365 row="2" text="-6.45971" column="2"/>
        <cell366 row="3" text="-6.45994" column="2"/>
        <cell367 row="4" text="-6.45994" column="2"/>
        <cell368 row="5" text="-6.46020" column="2"/>
        <cell369 row="6" text="-6.46020" column="2"/>
        <cell370 row="7" text="-6.46044" column="2"/>
        <cell371 row="8" text="-6.46044" column="2"/>
        <cell372 row="9" text="-6.46066" column="2"/>
        <cell373 row="10" text="-6.46066" column="2"/>
        <cell374 row="11" text="-6.46090" column="2"/>
        <cell375 row="12" text="-6.46090" column="2"/>
        <cell376 row="13" text="-6.46107" column="2"/>
        <cell377 row="14" text="-6.46107" column="2"/>
        <cell378 row="15" text="-6.46125" column="2"/>
        <cell379 row="16" text="-6.46125" column="2"/>
        <cell380 row="17" text="-6.46144" column="2"/>
        <cell381 row="18" text="-6.46144" column="2"/>
        <cell382 row="19" text="-6.46154" column="2"/>
        <cell383 row="20" text="-6.46154" column="2"/>
        <cell384 row="21" text="-6.46176" column="2"/>
        <cell385 row="22" text="-6.46176" column="2"/>
        <cell386 row="23" text="-6.46196" column="2"/>
        <cell387 row="24" text="-6.46196" column="2"/>
        <cell388 row="25" text="-6.46216" column="2"/>
        <cell389 row="26" text="-6.46216" column="2"/>
        <cell390 row="27" text="-6.46237" column="2"/>
        <cell391 row="28" text="-6.46237" column="2"/>
        <cell392 row="29" text="-6.46257" column="2"/>
        <cell393 row="30" text="-6.46257" column="2"/>
        <cell394 row="31" text="-6.46279" column="2"/>
        <cell395 row="32" text="-6.46279" column="2"/>
        <cell396 row="33" text="-6.46297" column="2"/>
        <cell397 row="34" text="-6.46297" column="2"/>
        <cell398 row="35" text="-6.46312" column="2"/>
        <cell399 row="36" text="-6.46312" column="2"/>
        <cell400 row="37" text="-6.46328" column="2"/>
        <cell401 row="38" text="-6.46328" column="2"/>
        <cell402 row="39" text="-6.46341" column="2"/>
        <cell403 row="40" text="-6.46341" column="2"/>
        <cell404 row="41" text="-6.46360" column="2"/>
        <cell405 row="42" text="-6.46360" column="2"/>
        <cell406 row="43" text="-6.46387" column="2"/>
        <cell407 row="44" text="-6.46387" column="2"/>
        <cell408 row="45" text="-6.46412" column="2"/>
        <cell409 row="46" text="-6.46412" column="2"/>
        <cell410 row="47" text="-6.46437" column="2"/>
        <cell411 row="48" text="-6.46437" column="2"/>
        <cell412 row="49" text="-6.46452" column="2"/>
        <cell413 row="50" text="-6.46452" column="2"/>
        <cell414 row="51" text="-6.46466" column="2"/>
        <cell415 row="52" text="-6.46466" column="2"/>
        <cell416 row="53" text="-6.46484" column="2"/>
        <cell417 row="54" text="-6.46484" column="2"/>
        <cell418 row="55" text="-6.46495" column="2"/>
        <cell419 row="56" text="-6.46495" column="2"/>
        <cell420 row="57" text="-6.46514" column="2"/>
        <cell421 row="58" text="-6.46514" column="2"/>
        <cell422 row="59" text="-6.46536" column="2"/>
        <cell423 row="60" text="-6.46536" column="2"/>
        <cell424 row="61" text="-6.46560" column="2"/>
        <cell425 row="62" text="-6.46560" column="2"/>
        <cell426 row="63" text="-6.46583" column="2"/>
        <cell427 row="64" text="-6.46583" column="2"/>
        <cell428 row="65" text="-6.46607" column="2"/>
        <cell429 row="66" text="-6.46607" column="2"/>
        <cell430 row="67" text="-6.46625" column="2"/>
        <cell431 row="68" text="-6.46625" column="2"/>
        <cell432 row="69" text="-6.46645" column="2"/>
        <cell433 row="70" text="-6.46645" column="2"/>
        <cell434 row="71" text="-6.46665" column="2"/>
        <cell435 row="72" text="-6.46665" column="2"/>
        <cell436 row="73" text="-6.46686" column="2"/>
        <cell437 row="74" text="-6.46686" column="2"/>
        <cell438 row="75" text="-6.46709" column="2"/>
        <cell439 row="76" text="-6.46709" column="2"/>
        <cell440 row="77" text="-6.46730" column="2"/>
        <cell441 row="78" text="-6.46730" column="2"/>
        <cell442 row="79" text="-6.46751" column="2"/>
        <cell443 row="80" text="-6.46751" column="2"/>
        <cell444 row="81" text="-6.46777" column="2"/>
        <cell445 row="82" text="-6.46777" column="2"/>
        <cell446 row="83" text="-6.46805" column="2"/>
        <cell447 row="84" text="-6.46805" column="2"/>
        <cell448 row="85" text="-6.46827" column="2"/>
        <cell449 row="86" text="-6.46827" column="2"/>
        <cell450 row="87" text="-6.46845" column="2"/>
        <cell451 row="88" text="-6.46845" column="2"/>
        <cell452 row="89" text="-6.46857" column="2"/>
        <cell453 row="90" text="-6.46857" column="2"/>
        <cell454 row="91" text="-6.46880" column="2"/>
        <cell455 row="92" text="-6.46880" column="2"/>
        <cell456 row="93" text="-6.46907" column="2"/>
        <cell457 row="94" text="-6.46907" column="2"/>
        <cell458 row="95" text="-6.46933" column="2"/>
        <cell459 row="96" text="-6.46933" column="2"/>
        <cell460 row="97" text="-6.46960" column="2"/>
        <cell461 row="98" text="-6.46960" column="2"/>
        <cell462 row="99" text="-6.46988" column="2"/>
        <cell463 row="100" text="-6.46988" column="2"/>
        <cell464 row="101" text="-6.46998" column="2"/>
        <cell465 row="102" text="-6.46998" column="2"/>
        <cell466 row="103" text="-6.47029" column="2"/>
        <cell467 row="104" text="-6.47029" column="2"/>
        <cell468 row="105" text="-6.47062" column="2"/>
        <cell469 row="106" text="-6.47062" column="2"/>
        <cell470 row="107" text="-6.47068" column="2"/>
        <cell471 row="108" text="-6.47068" column="2"/>
        <cell472 row="109" text="-6.47102" column="2"/>
        <cell473 row="110" text="-6.47102" column="2"/>
        <cell474 row="111" text="-6.47135" column="2"/>
        <cell475 row="112" text="-6.47135" column="2"/>
        <cell476 row="113" text="-6.47168" column="2"/>
        <cell477 row="114" text="-6.47168" column="2"/>
        <cell478 row="115" text="-6.47200" column="2"/>
        <cell479 row="116" text="-6.47200" column="2"/>
        <cell480 row="117" text="-6.47230" column="2"/>
        <cell481 row="118" text="-6.47230" column="2"/>
        <cell482 row="119" text="-6.47254" column="2"/>
        <cell483 row="120" text="-6.47254" column="2"/>
        <cell484 row="121" text="-6.47276" column="2"/>
        <cell485 row="122" text="-6.47276" column="2"/>
        <cell486 row="123" text="-6.47297" column="2"/>
        <cell487 row="124" text="-6.47297" column="2"/>
        <cell488 row="125" text="-6.47319" column="2"/>
        <cell489 row="126" text="-6.47319" column="2"/>
        <cell490 row="127" text="-6.47336" column="2"/>
        <cell491 row="128" text="-6.47336" column="2"/>
        <cell492 row="129" text="-6.47351" column="2"/>
        <cell493 row="130" text="-6.47351" column="2"/>
        <cell494 row="131" text="-6.47368" column="2"/>
        <cell495 row="132" text="-6.47368" column="2"/>
        <cell496 row="133" text="-6.47373" column="2"/>
        <cell497 row="134" text="-6.47373" column="2"/>
        <cell498 row="135" text="-6.47398" column="2"/>
        <cell499 row="136" text="-6.47398" column="2"/>
        <cell500 row="137" text="-6.47422" column="2"/>
        <cell501 row="138" text="-6.47422" column="2"/>
        <cell502 row="139" text="-6.47444" column="2"/>
        <cell503 row="140" text="-6.47444" column="2"/>
        <cell504 row="141" text="-6.47450" column="2"/>
        <cell505 row="142" text="-6.47450" column="2"/>
        <cell506 row="143" text="-6.47478" column="2"/>
        <cell507 row="144" text="-6.47478" column="2"/>
        <cell508 row="145" text="-6.47509" column="2"/>
        <cell509 row="146" text="-6.47509" column="2"/>
        <cell510 row="147" text="-6.47535" column="2"/>
        <cell511 row="148" text="-6.47535" column="2"/>
        <cell512 row="149" text="-6.47568" column="2"/>
        <cell513 row="150" text="-6.47568" column="2"/>
        <cell514 row="151" text="-6.47611" column="2"/>
        <cell515 row="152" text="-6.47611" column="2"/>
        <cell516 row="153" text="-6.47654" column="2"/>
        <cell517 row="154" text="-6.47654" column="2"/>
        <cell518 row="155" text="-6.47695" column="2"/>
        <cell519 row="156" text="-6.47695" column="2"/>
        <cell520 row="157" text="-6.47739" column="2"/>
        <cell521 row="158" text="-6.47739" column="2"/>
        <cell522 row="159" text="-6.47788" column="2"/>
        <cell523 row="160" text="-6.47788" column="2"/>
        <cell524 row="161" text="-6.47834" column="2"/>
        <cell525 row="162" text="-6.47834" column="2"/>
        <cell526 row="163" text="-6.47890" column="2"/>
        <cell527 row="164" text="-6.47890" column="2"/>
        <cell528 row="165" text="-6.47942" column="2"/>
        <cell529 row="166" text="-6.47942" column="2"/>
        <cell530 row="167" text="-6.47990" column="2"/>
        <cell531 row="168" text="-6.47990" column="2"/>
        <cell532 row="169" text="-6.48040" column="2"/>
        <cell533 row="170" text="-6.48040" column="2"/>
        <cell534 row="171" text="-6.48074" column="2"/>
        <cell535 row="172" text="-6.48074" column="2"/>
        <cell536 row="173" text="-6.48092" column="2"/>
        <cell537 row="174" text="-6.48092" column="2"/>
        <cell538 row="175" text="-6.48112" column="2"/>
        <cell539 row="176" text="-6.48112" column="2"/>
        <cell540 row="177" text="-6.48126" column="2"/>
        <cell541 row="178" text="-6.48126" column="2"/>
        <cell542 row="179" text="-6.48127" column="2"/>
        <cell543 row="180" text="-6.48127" column="2"/>
        <cell544 row="0" text="LONGITUDE" column="3"/>
        <cell545 row="1" text="105.68034" column="3"/>
        <cell546 row="2" text="105.67986" column="3"/>
        <cell547 row="3" text="105.67986" column="3"/>
        <cell548 row="4" text="105.67937" column="3"/>
        <cell549 row="5" text="105.67937" column="3"/>
        <cell550 row="6" text="105.67891" column="3"/>
        <cell551 row="7" text="105.67891" column="3"/>
        <cell552 row="8" text="105.67843" column="3"/>
        <cell553 row="9" text="105.67843" column="3"/>
        <cell554 row="10" text="105.67794" column="3"/>
        <cell555 row="11" text="105.67794" column="3"/>
        <cell556 row="12" text="105.67746" column="3"/>
        <cell557 row="13" text="105.67746" column="3"/>
        <cell558 row="14" text="105.67696" column="3"/>
        <cell559 row="15" text="105.67696" column="3"/>
        <cell560 row="16" text="105.67645" column="3"/>
        <cell561 row="17" text="105.67645" column="3"/>
        <cell562 row="18" text="105.67595" column="3"/>
        <cell563 row="19" text="105.67595" column="3"/>
        <cell564 row="20" text="105.67572" column="3"/>
        <cell565 row="21" text="105.67572" column="3"/>
        <cell566 row="22" text="105.67525" column="3"/>
        <cell567 row="23" text="105.67525" column="3"/>
        <cell568 row="24" text="105.67481" column="3"/>
        <cell569 row="25" text="105.67481" column="3"/>
        <cell570 row="26" text="105.67437" column="3"/>
        <cell571 row="27" text="105.67437" column="3"/>
        <cell572 row="28" text="105.67395" column="3"/>
        <cell573 row="29" text="105.67395" column="3"/>
        <cell574 row="30" text="105.67352" column="3"/>
        <cell575 row="31" text="105.67352" column="3"/>
        <cell576 row="32" text="105.67308" column="3"/>
        <cell577 row="33" text="105.67308" column="3"/>
        <cell578 row="34" text="105.67264" column="3"/>
        <cell579 row="35" text="105.67264" column="3"/>
        <cell580 row="36" text="105.67217" column="3"/>
        <cell581 row="37" text="105.67217" column="3"/>
        <cell582 row="38" text="105.67172" column="3"/>
        <cell583 row="39" text="105.67172" column="3"/>
        <cell584 row="40" text="105.67127" column="3"/>
        <cell585 row="41" text="105.67127" column="3"/>
        <cell586 row="42" text="105.67082" column="3"/>
        <cell587 row="43" text="105.67082" column="3"/>
        <cell588 row="44" text="105.67043" column="3"/>
        <cell589 row="45" text="105.67043" column="3"/>
        <cell590 row="46" text="105.67000" column="3"/>
        <cell591 row="47" text="105.67000" column="3"/>
        <cell592 row="48" text="105.66959" column="3"/>
        <cell593 row="49" text="105.66959" column="3"/>
        <cell594 row="50" text="105.66912" column="3"/>
        <cell595 row="51" text="105.66912" column="3"/>
        <cell596 row="52" text="105.66866" column="3"/>
        <cell597 row="53" text="105.66866" column="3"/>
        <cell598 row="54" text="105.66819" column="3"/>
        <cell599 row="55" text="105.66819" column="3"/>
        <cell600 row="56" text="105.66771" column="3"/>
        <cell601 row="57" text="105.66771" column="3"/>
        <cell602 row="58" text="105.66725" column="3"/>
        <cell603 row="59" text="105.66725" column="3"/>
        <cell604 row="60" text="105.66682" column="3"/>
        <cell605 row="61" text="105.66682" column="3"/>
        <cell606 row="62" text="105.66637" column="3"/>
        <cell607 row="63" text="105.66637" column="3"/>
        <cell608 row="64" text="105.66593" column="3"/>
        <cell609 row="65" text="105.66593" column="3"/>
        <cell610 row="66" text="105.66549" column="3"/>
        <cell611 row="67" text="105.66549" column="3"/>
        <cell612 row="68" text="105.66502" column="3"/>
        <cell613 row="69" text="105.66502" column="3"/>
        <cell614 row="70" text="105.66457" column="3"/>
        <cell615 row="71" text="105.66457" column="3"/>
        <cell616 row="72" text="105.66419" column="3"/>
        <cell617 row="73" text="105.66419" column="3"/>
        <cell618 row="74" text="105.66373" column="3"/>
        <cell619 row="75" text="105.66373" column="3"/>
        <cell620 row="76" text="105.66328" column="3"/>
        <cell621 row="77" text="105.66328" column="3"/>
        <cell622 row="78" text="105.66283" column="3"/>
        <cell623 row="79" text="105.66283" column="3"/>
        <cell624 row="80" text="105.66236" column="3"/>
        <cell625 row="81" text="105.66236" column="3"/>
        <cell626 row="82" text="105.66193" column="3"/>
        <cell627 row="83" text="105.66193" column="3"/>
        <cell628 row="84" text="105.66151" column="3"/>
        <cell629 row="85" text="105.66151" column="3"/>
        <cell630 row="86" text="105.66105" column="3"/>
        <cell631 row="87" text="105.66105" column="3"/>
        <cell632 row="88" text="105.66057" column="3"/>
        <cell633 row="89" text="105.66057" column="3"/>
        <cell634 row="90" text="105.66028" column="3"/>
        <cell635 row="91" text="105.66028" column="3"/>
        <cell636 row="92" text="105.65982" column="3"/>
        <cell637 row="93" text="105.65982" column="3"/>
        <cell638 row="94" text="105.65939" column="3"/>
        <cell639 row="95" text="105.65939" column="3"/>
        <cell640 row="96" text="105.65894" column="3"/>
        <cell641 row="97" text="105.65894" column="3"/>
        <cell642 row="98" text="105.65848" column="3"/>
        <cell643 row="99" text="105.65848" column="3"/>
        <cell644 row="100" text="105.65806" column="3"/>
        <cell645 row="101" text="105.65806" column="3"/>
        <cell646 row="102" text="105.65791" column="3"/>
        <cell647 row="103" text="105.65791" column="3"/>
        <cell648 row="104" text="105.65749" column="3"/>
        <cell649 row="105" text="105.65749" column="3"/>
        <cell650 row="106" text="105.65711" column="3"/>
        <cell651 row="107" text="105.65711" column="3"/>
        <cell652 row="108" text="105.65703" column="3"/>
        <cell653 row="109" text="105.65703" column="3"/>
        <cell654 row="110" text="105.65663" column="3"/>
        <cell655 row="111" text="105.65663" column="3"/>
        <cell656 row="112" text="105.65625" column="3"/>
        <cell657 row="113" text="105.65625" column="3"/>
        <cell658 row="114" text="105.65585" column="3"/>
        <cell659 row="115" text="105.65585" column="3"/>
        <cell660 row="116" text="105.65547" column="3"/>
        <cell661 row="117" text="105.65547" column="3"/>
        <cell662 row="118" text="105.65508" column="3"/>
        <cell663 row="119" text="105.65508" column="3"/>
        <cell664 row="120" text="105.65476" column="3"/>
        <cell665 row="121" text="105.65476" column="3"/>
        <cell666 row="122" text="105.65504" column="3"/>
        <cell667 row="123" text="105.65504" column="3"/>
        <cell668 row="124" text="105.65559" column="3"/>
        <cell669 row="125" text="105.65559" column="3"/>
        <cell670 row="126" text="105.65614" column="3"/>
        <cell671 row="127" text="105.65614" column="3"/>
        <cell672 row="128" text="105.65671" column="3"/>
        <cell673 row="129" text="105.65671" column="3"/>
        <cell674 row="130" text="105.65726" column="3"/>
        <cell675 row="131" text="105.65726" column="3"/>
        <cell676 row="132" text="105.65781" column="3"/>
        <cell677 row="133" text="105.65781" column="3"/>
        <cell678 row="134" text="105.65795" column="3"/>
        <cell679 row="135" text="105.65795" column="3"/>
        <cell680 row="136" text="105.65847" column="3"/>
        <cell681 row="137" text="105.65847" column="3"/>
        <cell682 row="138" text="105.65902" column="3"/>
        <cell683 row="139" text="105.65902" column="3"/>
        <cell684 row="140" text="105.65957" column="3"/>
        <cell685 row="141" text="105.65957" column="3"/>
        <cell686 row="142" text="105.65970" column="3"/>
        <cell687 row="143" text="105.65970" column="3"/>
        <cell688 row="144" text="105.66023" column="3"/>
        <cell689 row="145" text="105.66023" column="3"/>
        <cell690 row="146" text="105.66074" column="3"/>
        <cell691 row="147" text="105.66074" column="3"/>
        <cell692 row="148" text="105.66119" column="3"/>
        <cell693 row="149" text="105.66119" column="3"/>
        <cell694 row="150" text="105.66167" column="3"/>
        <cell695 row="151" text="105.66167" column="3"/>
        <cell696 row="152" text="105.66209" column="3"/>
        <cell697 row="153" text="105.66209" column="3"/>
        <cell698 row="154" text="105.66248" column="3"/>
        <cell699 row="155" text="105.66248" column="3"/>
        <cell700 row="156" text="105.66286" column="3"/>
        <cell701 row="157" text="105.66286" column="3"/>
        <cell702 row="158" text="105.66320" column="3"/>
        <cell703 row="159" text="105.66320" column="3"/>
        <cell704 row="160" text="105.66347" column="3"/>
        <cell705 row="161" text="105.66347" column="3"/>
        <cell706 row="162" text="105.66360" column="3"/>
        <cell707 row="163" text="105.66360" column="3"/>
        <cell708 row="164" text="105.66367" column="3"/>
        <cell709 row="165" text="105.66367" column="3"/>
        <cell710 row="166" text="105.66368" column="3"/>
        <cell711 row="167" text="105.66368" column="3"/>
        <cell712 row="168" text="105.66365" column="3"/>
        <cell713 row="169" text="105.66365" column="3"/>
        <cell714 row="170" text="105.66364" column="3"/>
        <cell715 row="171" text="105.66364" column="3"/>
        <cell716 row="172" text="105.66354" column="3"/>
        <cell717 row="173" text="105.66354" column="3"/>
        <cell718 row="174" text="105.66352" column="3"/>
        <cell719 row="175" text="105.66352" column="3"/>
        <cell720 row="176" text="105.66371" column="3"/>
        <cell721 row="177" text="105.66371" column="3"/>
        <cell722 row="178" text="105.66386" column="3"/>
        <cell723 row="179" text="105.66386" column="3"/>
        <cell724 row="180" text="105.66389" column="3"/>
      </cells>
    </content>
  </grid>
</CONFIG>

setelah itu simpan script berikut pada file index.php

<?php 
$xml = simplexml_load_file("namefile.xml");
$json = json_encode($xml);
// $array = json_decode($json,TRUE);
// var_dump($array);

$jsonIterator = new RecursiveIteratorIterator(
    new RecursiveArrayIterator(json_decode($json, TRUE)),
    RecursiveIteratorIterator::SELF_FIRST);

$date = array();
$time = array();
$latitude = array();
$longitude = array();
$imei = array('<td style="width:30%;">IMEI</td>');
$variable ="";
foreach ($jsonIterator as $key => $val) {
    if(is_array($val)) {
        echo "";
    } else {
if ($key == "text" ){
   array_push($imei, "<td>360003</td>");
if ($val == "DATE" ){ $variable = "0";}
   if ($variable == "0" ){ array_push( $date, "<td style='width:30%;'>$val</td>");}
   if ($val == "TIME" ){ $variable = "1";}
   if ($variable == "1" ){ array_push( $time, "<td style='width:20%;'>$val</td>");}
   if ($val == "LATITUDE" ){ $variable = "2";}
   if ($variable == "2" ){ array_push( $latitude, "<td style='width:30%;'>$val</td>");}
   if ($val == "LONGITUDE" ){ $variable = "3";}
   if ($variable == "3" ){ array_push( $longitude, "<td style='width:30%;'>$val</td>");}
}
    }
}
?>
<table style="width:500px;">
<?php 

    for($i = 0; $i < count($date)-1; $i++ ){ 
      echo "<tr>".$imei[$i]."".$date[$i]."".$time[$i]."".$latitude[$i]."".$longitude[$i]."</tr>";
 }
 
?>
</table>

okey sekian dari saya semoga bermanfaat