<?php
if ((($_FILES["file"]["type"] == "application/vnd.ms-excel"))
&& ($_FILES["file"]["size"] < 20000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

    if (file_exists("upload/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . $_FILES["file"]["name"]);
	  
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"]. "<br />";
	  
	  ///parsing start
	  
	  $contents = file("upload/".$_FILES["file"]["name"]);
		$string = implode($contents);
		//echo $contents[20]; 
		//echo $string; 
$p = ereg_replace("\r\n?", "\n", $string);
$p = str_replace("\n", ',', $p);
//echo $p;
$dot = explode(",", $p);
for ( $i = 19; $i <= 217; $i += 11) {
//echo $dot[$i]."_dot_";
$c5d=(((1-(pow(10,(-$dot[$i]))))/(1-(pow(10,(-$dot[228]))))))*100;
//echo $c5d."::";
	if ($i == "19")
	{$cmy=7;}
	elseif ($i == "30")
	{$cmy=14;}
	elseif ($i == "41")
	{$cmy=20.9;}
	elseif ($i == "52")
	{$cmy=27.6;}
	elseif ($i == "63")
	{$cmy=34.3;}
	elseif ($i == "74")
	{$cmy=40.7;}
	elseif ($i == "85")
	{$cmy=47;}
	elseif ($i == "96")
	{$cmy=53;}
	elseif ($i == "107")
	{$cmy=58.8;}
	elseif ($i == "118")
	{$cmy=64.3;}
	elseif ($i == "129")
	{$cmy=69.6;}
	elseif ($i == "140")
	{$cmy=74.5;}
	elseif ($i == "151")
	{$cmy=79.1;}
	elseif ($i == "162")
	{$cmy=83.4;}
	elseif ($i == "173")
	{$cmy=87.3;}
	elseif ($i == "184")
	{$cmy=90.7;}
	elseif ($i == "195")
	{$cmy=93.7;}
	elseif ($i == "206")
	{$cmy=96.3;}
	elseif ($i == "217")
	{$cmy=98.4;}
	
	$devi5c=$c5d-$cmy;
	$rounddv=round($devi5c,2);
	echo $rounddv."*";
}//for loop C
echo "<br>";
for ( $i = 251; $i <= 449; $i += 11) {

//echo $dot[$i]."_dot_";
$c5d=(((1-(pow(10,(-$dot[$i]))))/(1-(pow(10,(-$dot[460]))))))*100;

//echo $c5d."::";
	if ($i == "251")
	{$cmy=7;}
	elseif ($i == "262")
	{$cmy=14;}
	elseif ($i == "273")
	{$cmy=20.9;}
	elseif ($i == "284")
	{$cmy=27.6;}
	elseif ($i == "295")
	{$cmy=34.3;}
	elseif ($i == "306")
	{$cmy=40.7;}
	elseif ($i == "317")
	{$cmy=47;}
	elseif ($i == "328")
	{$cmy=53;}
	elseif ($i == "339")
	{$cmy=58.8;}
	elseif ($i == "350")
	{$cmy=64.3;}
	elseif ($i == "361")
	{$cmy=69.6;}
	elseif ($i == "372")
	{$cmy=74.5;}
	elseif ($i == "383")
	{$cmy=79.1;}
	elseif ($i == "394")
	{$cmy=83.4;}
	elseif ($i == "405")
	{$cmy=87.3;}
	elseif ($i == "416")
	{$cmy=90.7;}
	elseif ($i == "427")
	{$cmy=93.7;}
	elseif ($i == "438")
	{$cmy=96.3;}
	elseif ($i == "449")
	{$cmy=98.4;}
	
	$devi5c=$c5d-$cmy;
	$rounddv=round($devi5c,2);
	echo $rounddv."*";	
}//for loop//M
echo "<br>";
for ( $i = 483; $i <= 681; $i += 11) {

//echo $dot[$i]."_dot_";
$c5d=(((1-(pow(10,(-$dot[$i]))))/(1-(pow(10,(-$dot[692]))))))*100;

//echo $c5d."::";
	if ($i == "483")
	{$cmy=7;}
	elseif ($i == "494")
	{$cmy=14;}
	elseif ($i == "505")
	{$cmy=20.9;}
	elseif ($i == "516")
	{$cmy=27.6;}
	elseif ($i == "527")
	{$cmy=34.3;}
	elseif ($i == "538")
	{$cmy=40.7;}
	elseif ($i == "549")
	{$cmy=47;}
	elseif ($i == "560")
	{$cmy=53;}
	elseif ($i == "571")
	{$cmy=58.8;}
	elseif ($i == "582")
	{$cmy=64.3;}
	elseif ($i == "593")
	{$cmy=69.6;}
	elseif ($i == "604")
	{$cmy=74.5;}
	elseif ($i == "615")
	{$cmy=79.1;}
	elseif ($i == "626")
	{$cmy=83.4;}
	elseif ($i == "637")
	{$cmy=87.3;}
	elseif ($i == "648")
	{$cmy=90.7;}
	elseif ($i == "659")
	{$cmy=93.7;}
	elseif ($i == "670")
	{$cmy=96.3;}
	elseif ($i == "681")
	{$cmy=98.4;}
	
	$devi5c=$c5d-$cmy;
	$rounddv=round($devi5c,2);
	echo $rounddv."*";	
}//for loop//Y
echo "<br>";
for ( $i = 711; $i <= 909; $i += 11) {

//echo $dot[$i]."_dot_";
$c5d=(((1-(pow(10,(-$dot[$i]))))/(1-(pow(10,(-$dot[920]))))))*100;

//echo $c5d."::";
	if ($i == "711")
	{$cmy=8;}
	elseif ($i == "722")
	{$cmy=15.6;}
	elseif ($i == "733")
	{$cmy=23.1;}
	elseif ($i == "744")
	{$cmy=30.2;}
	elseif ($i == "755")
	{$cmy=37.1;}
	elseif ($i == "766")
	{$cmy=43.7;}
	elseif ($i == "777")
	{$cmy=50;}
	elseif ($i == "788")
	{$cmy=56;}
	elseif ($i == "799")
	{$cmy=61.7;}
	elseif ($i == "810")
	{$cmy=67;}
	elseif ($i == "821")
	{$cmy=72;}
	elseif ($i == "832")
	{$cmy=76.6;}
	elseif ($i == "843")
	{$cmy=80.9;}
	elseif ($i == "854")
	{$cmy=84.9;}
	elseif ($i == "865")
	{$cmy=88.4;}
	elseif ($i == "876")
	{$cmy=91.5;}
	elseif ($i == "887")
	{$cmy=94.3;}
	elseif ($i == "898")
	{$cmy=96.6;}
	elseif ($i == "909")
	{$cmy=98.5;}
	
	$devi5c=$c5d-$cmy;
	$rounddv=round($devi5c,2);
	echo $rounddv."*";	
}//for loop//K

      }//satrt parsing
    }//upload sucess
  }//upload check ok
else
  {
  echo "Invalid file";
  }
?>