// JScript File
String.prototype.trim = function() { return this.replace(/^\s+|\s+$/, ''); };
//-------------------------------------------------------------------------------------------------------------------
//if (document.layers) 
//{ // Netscape
//    document.captureEvents(Event.MOUSEMOVE);
//    document.onmousemove = captureMousePosition;
//} 
//else if (document.all) { // Internet Explorer
//    document.onmousemove = captureMousePosition;
//}
// else if (document.getElementById) { // Netcsape 6
//    document.onmousemove = captureMousePosition;
//}
//// Global variables
// xMousePos = 0; // Horizontal position of the mouse on the screen
// yMousePos = 0; // Vertical position of the mouse on the screen
//function captureMousePosition(e) {
//    if (document.layers)
//    {
//        xMousePos = e.pageX;
//        yMousePos = e.pageY;
//    } else if (document.all) {
//        xMousePos = window.event.x+document.body.scrollLeft;
//        yMousePos = window.event.y+document.body.scrollTop;
//    } else if (document.getElementById) {
//        // Netscape 6 behaves the same as Netscape 4 in this regard 
//        xMousePos = e.pageX;
//        yMousePos = e.pageY;
//    }
//}
//-----------------------------------------function  for port detail button------------------------------------------
function showDetail1() 
    {
     var prdid = document.getElementById('drpPort').value;
     mywindow = window.open("viewDetail.aspx?pstring=" + prdid ,"","menubar=0,resizable=1,width=980,height=620,toolbar=0,location=0,directories=0,status=1,scrollbars=1");     
     mywindow.moveTo(20,40);
    }
//-------------------------------------------------End function-------------------------------------------------------
//---------------------------------------------function for check now pop window -------------------------------------
function fnCheckNowOpen(ctrl)
	{
	 var pid = document.getElementById('drpPort').value;
	 var prdid = document.getElementById('tbl1').rows[ctrl].cells[1].Id ;
	 var orderquantity = formatdigit(document.getElementById('tbl1').rows[ctrl].cells[2].innerHTML);
	 var outctrl ='tbl1';
	 var table=document.getElementById("tbl1");
	 var tblpack = '';
	 for (curr_row = 0; curr_row < table.rows.length ; curr_row++)
      {
        if((table.rows[curr_row].cells[4].innerHTML == 'Y') && (table.rows[curr_row].cells[3].innerHTML == 'Bulk-B' || table.rows[curr_row].cells[3].innerHTML == 'Bulk-T'))
        tblpack = table.rows[curr_row].cells[3].innerHTML;
      }
    window.open('CheckNow.aspx?ctrl=' + ctrl + '&outctrl=' + outctrl + '&portid=' + pid + '&productid=' + prdid + '&orderquantity=' + orderquantity + '&tblpack=' + tblpack,'Check_Now','width=380,height=220');
}
//-----------------------------------------------End function--------------------------------------------------------
//------------------------------function to check numeric value and disallow alphabets------------------------------
//function IsNumeric(strString)
//   //  check for valid numeric strings	
//   {
//    var strValidChars = "0123456789.-";
//    var strChar;
//    var blnResult = true;

//    if (strString.length == 0) return false;

//   //  test strString consists of valid characters listed above
//   for (i = 0; i < strString.length && blnResult == true; i++)
//      {
//      strChar = strString.charAt(i);
//      if (strValidChars.indexOf(strChar) == -1)
//         {
//         blnResult = false;
//         }
//      }
//   return blnResult;
//   }
//   
   
    function DisAllowAlphabets(e){
      if(e.which){
        if ((e.which >= 48 && e.which <= 57)||(e.which==8)){
      		return true;}
     	else if(e.which == 45){
     		return true; }
    	else{ 
			return false; }
        }
      else if(window.event){    
       	if (window.event.keyCode >= 48 && window.event.keyCode <= 57){
      		window.event.returnValue=true;}
     	else if(window.event.keyCode == 45){
     		window.event.returnValue=true; }
    	else{ 
			window.event.returnValue=false; }  
        }
  } 
   //------------------------------------------End function----------------------------------------------------------
   //--------------------------add to order in order list with checking availability----------------------------------
function addtoprodlist(avail)
{
 var mainstr=avail.split("<");
 var mainstr1=mainstr[0].split("&");
 //alert(mainstr[0]);
 var d=document;
 var table = d.getElementById("tbl1");
 if (!table) throw "Table not found";
 if (($F('txtQuantity').trim()).length == 0)
  {
  alert("Quantity can not be blank");
  document.getElementById('txtQuantity').value='';
  document.getElementById('txtQuantity').focus();
  return false;
  }
 var packmode =d.getElementById('drpPack').options[d.getElementById('drpPack').selectedIndex].text;
 var newavail='Y';
 var tblpack='';
 if (packmode == 'Bulk-T' || packmode == 'Bulk-B')
  {
   for (curr_row = 0; curr_row < table.rows.length ; curr_row++)
    {
    if(table.rows[curr_row].cells[4].innerHTML == 'Y')
    tblpack = table.rows[curr_row].cells[3].innerHTML;
    }
  }
 if(tblpack == 'Bulk-T' || tblpack == 'Bulk-B')
   {
   if(tblpack != packmode)
    {
    newavail='N';
    }
   }
 if(newavail == 'N')
   {
   alert('Sorry You have already choose '+ tblpack);
   document.getElementById('txtQuantity').value='';
   document.getElementById('drpPack').focus();
   }
 else
   {
   var i= document.getElementById('tbl1').rows.length;
   var row = table.insertRow(-1); //append at the end
   var cell1 = row.insertCell(-1);
   var cell2 = row.insertCell(-1);
   var cell3 = row.insertCell(-1);
   var cell4 = row.insertCell(-1);
   var cell5 = row.insertCell(-1);
   var cell6 = row.insertCell(-1);
   var cell7 = row.insertCell(-1);
  if (i == 0)
    {
    cell1.innerHTML =  (1) + ".";
    }
  else
    {
    cell1.innerHTML =  (i + 1) + ".";
    }
  cell2.innerHTML = document.getElementById('drpProduct').options[document.getElementById('drpProduct').selectedIndex].text;
  cell2.Id = d.getElementById('drpProduct').value;
  cell3.innerHTML = formatdigit(document.getElementById('txtQuantity').value);
  cell3.Id =cell1.innerHTML;
  cell4.innerHTML = document.getElementById('drpPack').options[document.getElementById('drpPack').selectedIndex].text;
  cell4.Id = document.getElementById('drpPack').value;
  if(mainstr1[0].trim() == "N")
    {
    cell5.className="headline11norred";
    }
  else if(mainstr1[0].trim() == "Y")
   {
   cell5.className="headline11norgreen";
   }
  var valueind = i;
  cell5.innerHTML = mainstr1[0];
  cell6.innerHTML = "<a href=\"JavaScript:fnCheckNowOpen("+ valueind  + ");\" class='b-checknow'>Check now</a>";
  cell7.innerHTML = "<a href='#' class='b-remove' onclick='JavaScript:removepro();'>Remove Item</a>";
  cell7.Id = mainstr1[1];
  cell1.width="12%";
  cell2.width="18%";
  cell3.width="10%";
  cell4.width="14%";
  cell5.width="10%";
  cell6.width="22%";
  cell7.width="15%";
  d.getElementById('txtQuantity').value='';
  d.getElementById('drpProduct').focus();
  CheckExcep();
  }
}
function CheckAvail()
  {
    var strSQL;
	var strvalue='';
	var cond = false;
	//alert('i am in avail');
	var port=document.getElementById('drpPort').value;
	var product=document.getElementById('drpProduct').value;
	var pack=document.getElementById('drpPack').value;
	strvalue=strvalue + "PortId=" + port + " and " ;
	strvalue=strvalue + "ProductId='" + product + "' and " ;
	strvalue=strvalue + "prdDistribution like '%" + pack + "%'" ;
	strSQL='Select portprodId,bulkminbargeGrade,bulkmintruckGrade,spleadtime From tblPortProductRelMaster where ' + strvalue + ' and portprodactive=1' ;
	// URL to get data from server
	var requestUrl = "AvailData.aspx" + "?strSQL=" + encodeURIComponent(strSQL) ;
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp){
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = GetAvail;

		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  false);		
		
		//Sends the request to server
		XmlHttp.send(null);		
    }
   }


function GetAvail(){
	// To make sure receiving response data from server is completed
 	if(XmlHttp.readyState == 4){
 		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		        return true;
		     }      
		else {
		    addtoprodlist((XmlHttp.responseText).trim());
		    return true;
          	 }
		  }
		else{
			alert("There was a problem retrieving data from the server. Please try again!" );
			return false;
		 }
	  }
  }
//---------------------------------End function---------------------------------------------------------------------
//--------------------------------Function for remove button in order list------------------------------------------

function removepro()
   {
   var yesno = confirm("Are you sure to delete this row?");
   if (yesno == true)
     {
     var current = window.event.srcElement;
    //here we will delete the line
    while ( (current = current.parentElement) && current.tagName !="TR");
    current.parentElement.removeChild(current);
    var oRow;
    var curr_row;
     for(curr_row = 0; curr_row < document.getElementById('tbl1').rows.length ; curr_row++)
      {
      oRow = document.getElementById('tbl1').rows[curr_row];
      oRow.cells[0].innerHTML = curr_row + 1 + ".";
      oRow.cells[5].innerHTML = "<a href=\"JavaScript:fnCheckNowOpen("+ curr_row + ");\" class='b-checknow'>Check now</a>";
      }
    CheckExceponDelete();
    addtocalculate()
    }
   }
//---------------------------------End function---------------------------------------------------------------------

//---------------------------------------Function for check Exceptionality--------------------------------------------
function CheckExcep()
  {
    var strSQL;
	var strvalue;
	var product=document.getElementById('drpProduct').value;
	var port=document.getElementById('drpPort').value;
	strSQL="select bulkminbargeGrade,bulkmintruckGrade,spleadtime from tblPortProductRelMaster where PortId=" + port + " and ProductId='" + product + "' and prdDistribution like '%" + document.getElementById('drpPack').value + "%'";
	// URL to get data from server
	var requestUrl = "exception.aspx" + "?strSQL=" + encodeURIComponent(strSQL) ;
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp){
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = GetExcep;

		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  false);		
		
		//Sends the request to server
		XmlHttp.send(null);		
	}
  }

function GetExcep(){
	// To make sure receiving response data from server is completed
	if(XmlHttp.readyState == 4){
		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		        return true;
		     }      
		else {
		    WriteExcep((XmlHttp.responseText).trim());
		    return true;
		  }
		
		 }
		else{
			alert("There was a problem retrieving data from the server. Please try again!" );
			return false;
		 }
	  }
  }
function WriteExcep(str)
  {
  var mainstr=str.trim().split("&");
  var unit;
  if(document.getElementById("Op1").checked == true)
  unit=1;
  else if(document.getElementById("Op2").checked == true)
  unit=3.7852;
  var oRow;
  if(mainstr[1].trim().length > 0)
    {
    oRow = document.getElementById('tbl3').rows[2];
    if(parseInt(changedigit(oRow.cells[4].innerHTML)) < parseInt(mainstr[2]) || oRow.cells[4].innerHTML.trim() == '-')
     {
     oRow.cells[4].innerHTML = mainstr[1];
     }
    }
   if(mainstr[2].trim().length > 0)
    {
     oRow = document.getElementById('tbl3').rows[6];
     if(parseInt(changedigit(oRow.cells[4].innerHTML)) < parseInt(mainstr[2]) || oRow.cells[4].innerHTML.trim() == '-')
      {
      oRow.cells[4].innerHTML = formatdigit(Math.ceil(eval(mainstr[2])/unit));
      }
     }
    if(mainstr[3].trim().length > 0)
     {
     oRow = document.getElementById('tbl3').rows[10];
     if(parseInt(changedigit(oRow.cells[4].innerHTML)) < parseInt(mainstr[2]) || oRow.cells[4].innerHTML.trim() == '-')
      {
      oRow.cells[4].innerHTML = formatdigit(Math.ceil(eval(mainstr[3])/unit));
      }
     }
   }
  //----------------------------------------------End function-------------------------------------------------------
  //-------------------------------------on delete button check exceptionality---------------------------------------
  function CheckExceponDelete()
  {
	var strSQL = document.getElementById('drpPort').value;
	var table = document.getElementById('tbl1');
	for(j= 0;j <table.rows.length;j++)
     {
     strSQL = strSQL + "&" + table.rows[j].cells[1].Id + "&" + table.rows[j].cells[3].Id;
     }
	// URL to get data from server
	var requestUrl = "exception.aspx" + "?strSQL=" + encodeURIComponent(strSQL) ;
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp){
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = GetExceponDelete;

		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  false);		
		
		//Sends the request to server
		XmlHttp.send(null);		
	}
  }

function GetExceponDelete(){
	// To make sure receiving response data from server is completed
	if(XmlHttp.readyState == 4){
		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		        return true;
		     }      
		else {
		    WriteExceponDelete((XmlHttp.responseText).trim());
		    return true;
		  }
		
		 }
		else{
			alert("There was a problem retrieving data from the server. Please try again!" )
			return false;
		 }
	  }
  }
  function WriteExceponDelete(str)
  {
   var mainstr=str.trim().split("&");
   var unit;
   if(document.getElementById("Op1").checked == true)
   unit=1;
   else if(document.getElementById("Op2").checked == true)
   unit=3.7852;
   var oRow;
   if(mainstr[1] != 0)
    {
    oRow = document.getElementById('tbl3').rows[2];
    oRow.cells[4].innerHTML =mainstr[1];
    }
   else
    {
    oRow = document.getElementById('tbl3').rows[2];
    oRow.cells[4].innerHTML = "-";
    }
   if(mainstr[2] != 0)
    {
    oRow = document.getElementById('tbl3').rows[6];
    oRow.cells[4].innerHTML = formatdigit(Math.ceil(eval(mainstr[2])/unit));
    }
   else
    {
    oRow = document.getElementById('tbl3').rows[6];
    oRow.cells[4].innerHTML = "-";
    }
   if(mainstr[3] != 0)
    {
    oRow = document.getElementById('tbl3').rows[10];
    oRow.cells[4].innerHTML = formatdigit(Math.ceil(eval(mainstr[3])/unit));
    }
   else
    {
    oRow = document.getElementById('tbl3').rows[10];
    oRow.cells[4].innerHTML = "-";
    }
  }
//--------------------------------------------------End function----------------------------------------------------
//--------------------------------------------presently not using function------------------------------------------
function addtocalculate1(resultstr)//unused function
 {
  var mainstr1=resultstr.split("<");
  var mainstr=mainstr1[0].trim().split("&");
  var d=document
  //d.getElementById("fd").style.visibility = "hidden";
  //d.getElementById("sd").style.visibility = "visible";
  var table = d.getElementById("tbl4");
  if (table.rows.length > 0)
   { 
   for(var i = table.rows.length; i > 0;i--)
    {
     table.deleteRow(i -1);
    }
   }
  if (!table) throw "Table not found";
  var i= document.getElementById('tbl1').rows.length;

//d.getElementById('tbl4').rows.length = 0;
  for(j= 0;j < d.getElementById('tbl1').rows.length;j++)
   {
   if(document.getElementById('tbl1').rows[j].cells[4].innerHTML.trim() == 'Y')
    {
    var row = table.insertRow(-1); 
    row.height="20";
    //append at the end
    var cell1 = row.insertCell(-1);
    var cell2 = row.insertCell(-1);
    var cell3 = row.insertCell(-1);
    var cell4 = row.insertCell(-1);
    var cell5 = row.insertCell(-1);
    cell1.width="50%";
    cell2.width="15%";
    cell3.width="15%";
    cell4.width="15%";
    cell5.width="15%";
    cell1.align="left";
    cell2.align="left";
    cell3.align="left";
    cell4.align="left";
    cell5.align="left";
    cell1.innerHTML =document.getElementById('tbl1').rows[j].cells[1].innerHTML;
    var quantity = document.getElementById('tbl1').rows[j].cells[2].innerHTML;
    var pack = document.getElementById('tbl1').rows[j].cells[3].innerHTML;
    if(document.getElementById("Op1").checked == true)
     {
     if(pack == 'Drum') result = quantity * 208 + ' Ltr';
     else  if(pack == 'Pail') result = quantity * 20 + ' Ltr';
     else if(pack == 'Cartridge') result =quantity * 12 + ' Ltr';
     else if(pack == 'Bulk-B') result =  quantity + ' Ltr';
     else if(pack == 'Bulk-T') result =  quantity + ' Ltr';
     }
     else if(document.getElementById("Op2").checked == true)
     {
     if(pack == 'Drum') result  = parseInt((quantity * 208)/3.7852) + ' USG';
     else if(pack == 'Pail') result =parseInt ((quantity * 20)/3.7852) + ' USG';
     else if(pack == 'Cartridge') result =parseInt ((quantity * 12)/3.7852) + ' USG'
     else if(pack == 'Bulk-B') result =  quantity + ' USG';
     else if(pack == 'Bulk-T') result =  quantity + ' USG';
     }
     cell2.innerHTML=result;
    }
  }
} 
//---------------------------------------------End function----------------------------------------------------------
//--------------------------------------function for validation button----------------------------------------------
function addtocalculate()
 {
  var d=document
  var unit;
  if(document.getElementById("Op1").checked == true)
  unit=1;
  else if(document.getElementById("Op2").checked == true)
  unit=3.7852;
  var table = d.getElementById("tbl4");
  if (table.rows.length > 0)
   { 
   for(var i = table.rows.length; i > 0;i--)
    {
    table.deleteRow(i -1);
    }
   }
  if (!table) throw "Table not found";
  var i= d.getElementById('tbl1').rows.length;
  for(j= 0;j < d.getElementById('tbl1').rows.length;j++)
   {
   if(d.getElementById('tbl1').rows[j].cells[4].innerHTML.trim() == 'Y')
     {
     var row = table.insertRow(-1); 
     row.height="20";
     //append at the end
     var cell1 = row.insertCell(-1);
     var cell2 = row.insertCell(-1);
     var cell3 = row.insertCell(-1);
     var cell4 = row.insertCell(-1);
     var cell5 = row.insertCell(-1);
     var cell6 = row.insertCell(-1);
     cell1.className="headline11nor";
     cell2.className="headline11nor";
     cell3.className="headline11nor";
     cell4.className="headline11nor";
     cell5.className="headline11nor";
     cell1.width="18%";
     cell2.width="25%";
     cell3.width="12%";
     cell4.width="14%";
     cell5.width="15%";
     cell6.width="14%";
     cell1.align="left";
     cell2.align="center";
     cell3.align="center";
     cell4.align="center";
     cell5.align="center";
     cell6.align="center";
     cell1.innerHTML =document.getElementById('tbl1').rows[j].cells[1].innerHTML;
     var quantity = document.getElementById('tbl1').rows[j].cells[2].innerHTML;
     var pack = document.getElementById('tbl1').rows[j].cells[3].innerHTML;
     if(pack == 'Drum') result = quantity * 208 ;
     else if(pack == 'Pail') result = quantity * 20;
     else if(pack == 'Cartridge') result =quantity * 12 ;
     else if(pack == 'Bulk-B') result =  quantity ;
     else if(pack == 'Bulk-T') result =  quantity ;
     var excep = document.getElementById('tbl1').rows[j].cells[6].Id;
     if(pack == 'Drum' || pack == 'Pail' || pack == 'Cartridge') 
        {
        //alert(excep);
        if(excep.trim() == 'No')
           {
           //alert(excep);
           cell2.innerHTML=formatdigit(Math.ceil(eval(result)/unit));
           cell3.innerHTML="-";
           cell4.innerHTML="-";
           cell5.innerHTML="-";
           cell6.innerHTML="-";
           }
        else 
           {
           //alert(excep);
           cell2.innerHTML=formatdigit(Math.ceil(eval(result)/unit));
           cell3.innerHTML="-";
           cell4.innerHTML="-";
           cell5.innerHTML="-";
           cell6.innerHTML="-";
           }
        }
      else if (pack == 'Bulk-B' || pack == 'Bulk-T') 
        {
          if(excep.trim() == 'No')
           {
           cell2.innerHTML="-";
           cell3.innerHTML=formatdigit(result);
           cell4.innerHTML="-";
           cell5.innerHTML="-";
           cell6.innerHTML="-";
           }
         else
           {
           cell2.innerHTML="-";
           cell3.innerHTML="-";
           cell4.innerHTML=formatdigit(result);
           cell5.innerHTML="-";
           cell6.innerHTML="-";
           }
        }
     }
   }
 if(d.getElementById('tbl4').rows.length > 0)
   {
    findcalculate1();
    findcalculate2();
    CheckLeadTime();
   }
 } 
function findcalculate1()
  {
   var d=document;
   var valanci = 0; 
   var valbulkregular = 0; 
   var valbulkexception =0;
   var table = document.getElementById('tbl5');
   var tbl= document.getElementById('tbl4');
   var bulkreg=0;
   var bulkexcep =0;
   if (!table) throw "Table not found";
   for(var curr_row= 0;curr_row < d.getElementById('tbl4').rows.length;curr_row++)
      {
        if(tbl.rows[curr_row].cells[1].innerHTML.trim() != '-')
        valanci =eval(changedigit(valanci)) + eval(changedigit(tbl.rows[curr_row].cells[1].innerHTML.trim()));
        if(tbl.rows[curr_row].cells[2].innerHTML.trim() != "-")
         {
         if (eval(bulkreg)==0)
          {
          bulkreg = eval(changedigit(tbl.rows[curr_row].cells[2].innerHTML.trim()));
          }
        if (eval(changedigit(bulkreg)) > eval(changedigit(tbl.rows[curr_row].cells[2].innerHTML.trim()))) 
        bulkreg = eval(changedigit(tbl.rows[curr_row].cells[2].innerHTML.trim()));
        valbulkregular = eval(changedigit(valbulkregular)) + eval(changedigit(tbl.rows[curr_row].cells[2].innerHTML.trim()));
       }
   if(tbl.rows[curr_row].cells[3].innerHTML.trim() != "-")
     {
      if(eval(changedigit(bulkexcep))== 0)
       {
        bulkexcep=eval(changedigit(tbl.rows[curr_row].cells[3].innerHTML.trim()));
       }
       if(eval(changedigit(bulkexcep)) < eval(changedigit(tbl.rows[curr_row].cells[3].innerHTML.trim()))) 
       bulkexcep = eval(changedigit(tbl.rows[curr_row].cells[3].innerHTML.trim()));
       valbulkexception =eval(changedigit(valbulkexception)) + eval(changedigit(tbl.rows[curr_row].cells[3].innerHTML.trim()));
    }
  }
 if (valanci == 0)
  table.rows[6].cells[2].innerHTML = '-';
 else
  table.rows[6].cells[2].innerHTML =formatdigit(valanci);
 if (bulkreg == 0)
  table.rows[6].cells[3].innerHTML = '-';
 else
  table.rows[6].cells[3].innerHTML = formatdigit(bulkreg);
 if(bulkexcep == 0)
  table.rows[6].cells[4].innerHTML = '-';
 else
  table.rows[6].cells[4].innerHTML =formatdigit(bulkexcep);
 if((bulkexcep == 0) && (bulkreg == 0))
  table.rows[6].cells[5].innerHTML = '-';
 else
  table.rows[6].cells[5].innerHTML = formatdigit(eval(changedigit(valbulkregular)) +eval(changedigit(valbulkexception)));
}

function findcalculate2()
  {
  var table = document.getElementById('tbl5');
  var tbl=document.getElementById('tbl3');
  var validatepack = '-'; 
  var valdatepackcom ='-'
  var validatebulkregular= '-';
  var validatebulkexc = '-';
  var validateleadtime='-';
  var validatetotbulk ='-';
  var result=''; 
  var curr_row;
  for (curr_row = 0; curr_row < tbl1.rows.length ; curr_row++)
    {
    if((tbl1.rows[curr_row].cells[3].innerHTML == 'Bulk-T' || tbl1.rows[curr_row].cells[3].innerHTML == 'Bulk-B') && (tbl1.rows[curr_row].cells[4].innerHTML == 'Y'))
     result =tbl1.rows[curr_row].cells[3].innerHTML;
    }
    if (result =='Bulk-T')
     {
     var cmppacked =changedigit(tbl.rows[8].cells[1].innerHTML.trim());
     var cmppackedcom =changedigit(tbl.rows[8].cells[1].innerHTML.trim());
     }
    else if(result =='Bulk-B' || result == '')
     {
     var cmppacked =changedigit(tbl.rows[8].cells[1].innerHTML.trim());
     var cmppackedcom =changedigit(tbl.rows[10].cells[1].innerHTML.trim());
     }
   var cmptruckreg =changedigit(tbl.rows[6].cells[3].innerHTML.trim());
   var cmpbargereg =changedigit(tbl.rows[10].cells[3].innerHTML.trim());
   var cmptruckexc =changedigit(tbl.rows[6].cells[4].innerHTML.trim());
   var cmpbargeexc =changedigit(tbl.rows[10].cells[4].innerHTML.trim());
   var cmptottruck =changedigit(tbl.rows[8].cells[3].innerHTML.trim());
   var cmptotbarge =changedigit(tbl.rows[12].cells[3].innerHTML.trim());
   var valpack=changedigit(table.rows[6].cells[2].innerHTML.trim());
   var valbulkreg =changedigit(table.rows[6].cells[3].innerHTML.trim());
   var valbulkexc=changedigit(table.rows[6].cells[4].innerHTML.trim());
   var totbulk=changedigit(table.rows[6].cells[5].innerHTML.trim());
   // pack case
    if(valpack.length == 0)
      {
      validatepack ='N/A';
      }
    else if(eval(valpack) >= eval(cmppacked))
     validatepack = 'Y';
    else
     validatepack = 'N';
   // pack combined
   if(valpack.length  == 0)
     {
     validatepackcom ='N/A';
     }
   else if(eval(valpack) >= eval(cmppackedcom))
     validatepackcom = 'Y';
   else
    validatepackcom = 'N';
  //bulk regular case
  
  if(valbulkreg.length  == 0)
    {
    validatebulkregular = 'N/A';
    }
  else if(result == 'Bulk-T')
    {
  if(eval(valbulkreg) >= eval(cmptruckreg))
   validatebulkregular = 'Y';
  else
   validatebulkregular = 'N';
   }
  else if(result == 'Bulk-B')
   {
   if(eval(valbulkreg) >= eval(cmpbargereg))
     validatebulkregular = 'Y';
   else
     validatebulkregular = 'N';
   }  

  // bulk exception case 
  if(valbulkexc.length  == 0)
    {
    validatebulkexc ='N/A';
    }
  else if(result == 'Bulk-T')
    {
    if(eval(valbulkexc) >= eval(cmptruckexc))
      validatebulkexc = 'Y';
    else
      validatebulkexc = 'N';
     }
  else if(result == 'Bulk-B')
    {
    if(eval(valbulkexc) >= eval(cmpbargeexc))
      validatebulkexc = 'Y';
    else
      validatebulkexc = 'N';
    }
  //totalbulk 
    if(totbulk.length  == 0)
     validatetotbulk ='N/A';
    else if(result == 'Bulk-T')
     {
     if(eval(totbulk) >= eval(cmptottruck))
       validatetotbulk = 'Y';
     else
       validatetotbulk = 'N'; 
     }
    else if(result == 'Bulk-B')
     {
      if(eval(totbulk) >= eval(cmptotbarge))
        validatetotbulk = 'Y';
      else
        validatetotbulk = 'N'; 
      }

    if (validatepack == 'Y')
      table.rows[4].cells[2].className = "headline11norgreenw";
    else if(validatepack == 'N')
      table.rows[4].cells[2].className = "headline11norredw";
    else
     table.rows[4].cells[2].className = "headline11norBlackw";
    table.rows[4].cells[2].innerHTML =  validatepack;
    if (validatepackcom == 'Y')
      table.rows[4].cells[3].className = "headline11norgreenw"; 
    else if (validatepackcom == 'N')
      table.rows[4].cells[3].className = "headline11norredw";
     else
     table.rows[4].cells[3].className = "headline11norblackw"; 
    table.rows[4].cells[3].innerHTML =  validatepackcom;
    if (validatebulkregular == 'Y')
      table.rows[4].cells[4].className = "headline11norgreenw";
    else if(validatebulkregular == 'N')
      table.rows[4].cells[4].className = "headline11norredw";
    else
      table.rows[4].cells[4].className = "headline11norblackw"; 
    table.rows[4].cells[4].innerHTML = validatebulkregular;
 
    if (validatebulkexc == 'Y')
       table.rows[4].cells[5].className = "headline11norgreenw";
    else if (validatebulkexc == 'N')
       table.rows[4].cells[5].className = "headline11norredw";
    else
       table.rows[4].cells[5].className = "headline11norblackw";
    table.rows[4].cells[5].innerHTML = validatebulkexc;
    if (validatetotbulk == 'Y')
      table.rows[4].cells[6].className = "headline11norgreenw";
    else if (validatetotbulk == 'N')
      table.rows[4].cells[6].className = "headline11norredw";
     else 
      table.rows[4].cells[6].className = "headline11norblackw"; 
    table.rows[4].cells[6].innerHTML = validatetotbulk;
 }

 function WriteLeadTime(leadtstr)
   {
    var mainstr=leadtstr.split("<");
    var leadtime=mainstr[0];
    var validateleadtime='';
    var table = document.getElementById('tbl5');
    var tbl=document.getElementById('tbl3');
    var cmpleadtime = tbl.rows[2].cells[3].innerHTML.trim();
    if (tbl.rows[2].cells[4].innerHTML.trim() != '-')
      { 
      if (eval(cmpleadtime) < eval(tbl.rows[2].cells[4].innerHTML.trim()))
        cmpleadtime = tbl.rows[2].cells[4].innerHTML.trim();
      }
    table.rows[6].cells[6].innerHTML =leadtime;
    if(eval(leadtime) >= eval(cmpleadtime))
       validateleadtime = 'Y';
    else
       validateleadtime = 'N';
    if (validateleadtime == 'Y')
       table.rows[4].cells[7].className = "headline11norgreenw";
    else
       table.rows[4].cells[7].className = "headline11norredw";
    table.rows[4].cells[7].innerHTML = validateleadtime;
   }

 function CheckLeadTime()
  {
    var portid = document.getElementById('drpPort').value;
    var deldate= document.getElementById('txtDate').value;
    var valuestr=deldate + "&" + portid;
	// URL to get data from server
	var requestUrl = "checkonport.aspx" + "?strSQL=" + encodeURIComponent(valuestr) ;
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp){
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = GetLeadTime;

		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  true);		
		
		//Sends the request to server
		XmlHttp.send(null);		
	}
  }

  function GetLeadTime(){
	// To make sure receiving response data from server is completed
	if(XmlHttp.readyState == 4){
		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		 WriteLeadTime((XmlHttp.responseText).trim());
		    
		        return true;
		     }      
		else {
		    WriteLeadTime((XmlHttp.responseText).trim());
		    
		    return true;
		  }
		
		 }
		else{
			alert("There was a problem retrieving data from the server. Please try again!" );
			return false;
		 }
	  }
  }

//---------------------------------------------------End function---------------------------------------------------
//-------------------------------------------function for dispaly to show unit--------------------------------------
  function CalculateUnit()
    {
     var result='';
     var d=document;
     var quantity = d.getElementById('txtQuantity').value;
     if(quantity == '')
       quantity = 0;
     var pack = d.getElementById('drpPack').options[d.getElementById('drpPack').selectedIndex].text;
     if(document.getElementById("Op1").checked == true)
      {
      if(pack == 'Drum') result = quantity * 208;
      else  if(pack == 'Pail') result = quantity * 20;
      else if(pack == 'Cartridge') result =quantity * 12;
      else if(pack == 'Bulk-B') result =  quantity;
      else if(pack == 'Bulk-T') result =  quantity;
      d.getElementById('lblCalculate').innerHTML = formatdigit(result) + ' Ltr';
      }
      else if(document.getElementById("Op2").checked == true)
      {
      if(pack == 'Drum') result  = parseInt((quantity * 208)/3.7852);
      else if(pack == 'Pail') result =parseInt ((quantity * 20)/3.7852);
      else if(pack == 'Cartridge') result =parseInt ((quantity * 12)/3.7852);
      else if(pack == 'Bulk-B') result =  quantity;
      else if(pack == 'Bulk-T') result =  quantity;
      d.getElementById('lblCalculate').innerHTML = formatdigit(result) + ' USG';
      }
    }
//----------------------------------------End funtion----------------------------------------------------------------
//----------------------------------------Function change region ---------------------------------------------------- 
  function CheckRegion() 
   {
    var strvalue;
	strvalue="Region&" + document.getElementById('drpRegion').value;
    // URL to get data from server
	var requestUrl = "Data.aspx" + "?strvalue=" + encodeURIComponent(strvalue);
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp)
	{
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = CheckRegionDetail;
		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  false);		
		//Sends the request to server
		XmlHttp.send(null);		
	 }
}

function CheckRegionDetail()
{
// To make sure receiving response data from server is completed
	if(XmlHttp.readyState == 4){
		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		        changeRegiondetail(XmlHttp.responseText);
		        return true;
		         }      
		else {
		    changeRegiondetail(XmlHttp.responseText);
		    return true;
      		 }
		 }
		else
		{
			alert("There was a problem retrieving data from the server. Please try again!" );
			return false;
		}
	  }
}
function changeRegiondetail(strstring)
 {
  var mainstr=strstring.split("<");
  var main=mainstr[0].trim().split("$");
  var mainstr1=main[0].trim().split("%");
  var mainstr2=mainstr1[0].trim().split("&");
  var mainstr3=mainstr1[1].trim().split("&");
  var country = document.getElementById('drpCountry');
  for (var i = country.length - 1; i>=0; i--) 
   {
    country.remove(i);
   }
  for(i=0;i< mainstr3.length-1 ;i++)
   {
   var newOpt = new Option(mainstr3[i], mainstr2[i]);
   var selLength = i;
   country.options[selLength] = newOpt;
   }   
  var port = document.getElementById('drpPort');
  var i;
  for (var i = port.length - 1; i>=0; i--)
   {
    port.remove(i);
   }
  for(var i=0;i<mainstr2.length -1;i++)
   {
     var newOpt = new Option(mainstr3[i+1], mainstr2[i+1]);
     var selLength = i;
     country.options[selLength] = newOpt;
   }
    //country.options[1].selected = mainstr3[0];
  var mainstr4=main[1].trim().split("%");
  var mainstr5=mainstr4[0].trim().split("&");
  var mainstr6=mainstr4[1].trim().split("&");
  var port = document.getElementById('drpPort');
  for (var i = port.length - 1; i>=0; i--)
   {
    port.remove(i);
   }
    for(var i=0;i<mainstr5.length-1 ;i++)
    {
    var newOpt = new Option(mainstr6[i+1], mainstr5[i+1]);
    var selLength = i;
    port.options[selLength] = newOpt;
    }
    //port.options[1].selecteditem = mainstr6[0];
    CheckPortCalculate()
 }
function CheckRegion1(str)
 {
  CheckRegion();
  document.getElementById('drpCountry').value=str;
}
//-----------------------------------End function-----------------------------------------------------------------
//----------------------------------function for change country---------------------------------------------------
function CheckCountry()
 {
   var strvalue;
	strvalue="Country&" + document.getElementById('drpCountry').value;
   // URL to get data from server
	var requestUrl = "Data.aspx" + "?strvalue=" + encodeURIComponent(strvalue);
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp)
	{
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = CheckCountryDetail;
		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  false);		
		//Sends the request to server
		XmlHttp.send(null);		
	 }
}

function CheckCountryDetail()
{
// To make sure receiving response data from server is completed
	if(XmlHttp.readyState == 4){
		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		
		        changeCountrydetail(XmlHttp.responseText);
		        return true;
		         }      
		else {
		
		    changeCountrydetail(XmlHttp.responseText);
		    return true;
      		 }
		 }
		else
		{
			alert("There was a problem retrieving data from the server. Please try again!" );
			return false;
		}
	  }
    }
 function changeCountrydetail(strstring)
  {
   var mainstr=strstring.split("<");
   var mainstr1=mainstr[0].trim().split("%");
   var mainstr2=mainstr1[0].trim().split("&");
   var mainstr3=mainstr1[1].trim().split("&");
   var port = document.getElementById('drpPort');
   for (var i = port.length - 1; i>=0; i--)
    {
    port.remove(i);
    }
   for(var i=0;i<mainstr3.length-1 ;i++)
    {
    var newOpt = new Option(mainstr3[i+1], mainstr2[i+1]);
    var selLength = i;
    port.options[selLength] = newOpt;
    }
    //port.options[1].selected = mainstr3[0];
    CheckPortCalculate()
 }
 
 function CheckCountry1(str)
  {
  CheckCountry();
  document.getElementById('drpPort').value=str;
  }
//---------------------------------------------End function---------------------------------------------------------
//------------------------------------Function for change port------------------------------------------------------
function CheckPortCalculate()
  {
	var strvalue;
	strvalue=document.getElementById('drpPort').value;
	var oRow;
    var curr_row;
    if(document.getElementById('tbl1').rows.length > 0)
    {
    for (curr_row = 0; curr_row < document.getElementById('tbl1').rows.length ; curr_row++)
     {
     oRow = document.getElementById('tbl1').rows[curr_row];
     strvalue = strvalue + '&' + oRow.cells[1].Id ;
     strvalue = strvalue + '&' + oRow.cells[3].Id ;
     }
    }
	// URL to get data from server
	var requestUrl = "checkPortDetail.aspx" + "?strvalue=" + encodeURIComponent(strvalue);
    CreateXmlHttp();	
	// If browser supports XMLHTTPRequest object
	if(XmlHttp)
	{
		//Setting the event handler for the response
		XmlHttp.onreadystatechange = GetPortCalculate;
		//Initializes the request object with GET (METHOD of posting), 
		//Request URL and sets the request as asynchronous.
		XmlHttp.open("GET", requestUrl,  true);		
		//Sends the request to server
		XmlHttp.send(null);		
	 }
}
function GetPortCalculate(){
	// To make sure receiving response data from server is completed
	if(XmlHttp.readyState == 4){
		// To make sure valid response is received from the server, 200 means response received is OK
		if(XmlHttp.status == 200){		
		//Save successfully
		if((((XmlHttp.responseText).trim()).length)==0){
		        return true;
		         }      
		else {
		    WritePortCalculate((XmlHttp.responseText).trim());
		    return true;
      		 }
		 }
		else
		{
			alert("There was a problem retrieving data from the server. Please try again!" );
			return false;
		}
	  }
  }
    function  WritePortCalculate(strstring)
     {
       var mainstr=strstring.split("<");
       var main=mainstr[0].trim().split("~");
       var mainstr1=main[0].trim().split("&");
       var oRow;
       var unit;
       if(document.getElementById("Op1").checked == true)
        unit=1;
       else if(document.getElementById("Op2").checked == true)
        unit=3.7852;
      oRow = document.getElementById('tbl3').rows[2];
      oRow.cells[1].innerHTML = mainstr1[1];
      oRow.cells[3].innerHTML = mainstr1[6];
     
      oRow = document.getElementById('tbl3').rows[4];
      oRow.cells[1].innerHTML = mainstr1[2];
      oRow.cells[3].innerHTML = mainstr1[4];
        
      oRow = document.getElementById('tbl3').rows[6];
      oRow.cells[1].innerHTML = mainstr1[0];
      oRow.cells[3].innerHTML = formatdigit(Math.ceil(eval(mainstr1[9])/unit));
     
      oRow = document.getElementById('tbl3').rows[8];
      oRow.cells[1].innerHTML =formatdigit(Math.ceil(eval(mainstr1[7])/unit));
      oRow.cells[3].innerHTML = formatdigit(Math.ceil(eval(mainstr1[10])/unit));
     
      oRow = document.getElementById('tbl3').rows[10];
      oRow.cells[1].innerHTML = formatdigit(Math.ceil(eval(mainstr1[8])/unit));
      oRow.cells[3].innerHTML = formatdigit(Math.ceil(eval(mainstr1[11])/unit));
     
      oRow = document.getElementById('tbl3').rows[12];
      oRow.cells[1].innerHTML = mainstr1[3];
      oRow.cells[3].innerHTML = formatdigit(Math.ceil(eval(mainstr1[12])/unit));
      for (curr_row = 0; curr_row < document.getElementById('tbl1').rows.length ; curr_row++)
        {
        var main1=main[curr_row + 1].split("&");
        oRow = document.getElementById('tbl1').rows[curr_row];
        if(main1[0].trim() == "N")
          {
          oRow.cells[4].className="headline11norred";
          }
        else if(main1[0].trim() == "Y")
          {
          oRow.cells[4].className="headline11norgreen";
           }
        oRow.cells[4].innerHTML = main1[0];
         }
    addtocalculate();
    CheckExceponDelete();
 }
 //-----------------------------------------End function---------------------------------------------------------
 //--------------------------------------Create XMLHTTP object---------------------------------------------------
//Creating and setting the instance of appropriate XMLHTTP Request object to a “XmlHttp” variable  
function CreateXmlHttp(){
	//Creating object of XMLHTTP in IE
	try{
		XmlHttp = new ActiveXObject("Msxml2.XMLHTTP");
	   }
	catch(e)
	{
		try{
			XmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
		   } 
		catch(oc){
			XmlHttp = null;
		   }
	   }	   
	//Creating object of XMLHTTP in Mozilla and Safari 
	if(!XmlHttp && typeof XMLHttpRequest != "undefined"){
		XmlHttp = new XMLHttpRequest();
	  }
  }
  //-----------------------------------End funtion----------------------------------------------------------------
  //-----------------------------------set the value with ','-----------------------------------------------------

  function changedigit(strval)
   {
     var str=new String(strval);
     var cngstr = str.replace(/\D/g,'');
     return (cngstr);
   }
  function formatdigit(strValue)
			{
				strValue = strValue.toString().replace(/\$|\,/g,'');
				dblValue = parseFloat(strValue);
				dblValue = Math.floor(dblValue*100);
				intCents = dblValue%100;
				strCents = intCents.toString();
				dblValue = Math.floor(dblValue/100).toString();
				strQuot="0";
				if(intCents<10)
					strCents = "0" + strCents;
				for(var i = 0; i < Math.floor((dblValue.length-(1+i))/3); i++)
					dblValue = dblValue.substring(0,dblValue.length-(4*i+3))+','+
					dblValue.substring(dblValue.length-(4*i+3));
					if(dblValue =="0") 
					  return (strQuot);
					else
				      return (dblValue);}
  //-----------------------------------------------function for clear all button----------------------------------
   function clearall()
       {
       var table1 = document.getElementById("tbl1");
       var table2 = document.getElementById("tbl5");
       var table3 = document.getElementById("tbl3");
       var table = document.getElementById("tbl4");
       if (table.rows.length > 0 || table1.rows.length > 0)
       {
        if(confirm('Are you sure to clear all data') == true)
       {
      if (table.rows.length > 0)
        { 
         for(var i = table.rows.length; i > 0;i--)
           {
            table.deleteRow(i -1);
           }
        }
       if (table1.rows.length > 0)
        { 
         for(var i = table1.rows.length; i > 0;i--)
          {
           table1.deleteRow(i -1);
          }
         table2.rows[4].cells[2].innerHTML = '';
         table2.rows[4].cells[3].innerHTML = '';
         table2.rows[4].cells[4].innerHTML = '';
         table2.rows[4].cells[5].innerHTML = '';
         table2.rows[4].cells[6].innerHTML = '';
         table2.rows[4].cells[7].innerHTML = '';
         table2.rows[6].cells[2].innerHTML = '';
         table2.rows[6].cells[3].innerHTML = '';
         table2.rows[6].cells[4].innerHTML = '';
         table2.rows[6].cells[5].innerHTML = '';
         table2.rows[6].cells[6].innerHTML = '';
         table3.rows[2].cells[4].innerHTML = '-';
         table3.rows[6].cells[4].innerHTML = '-';
         table3.rows[10].cells[4].innerHTML = '-';
        }
      }
    }
   }
 //------------------------------------------------End function--------------------------------------------------

  
//-----------------------------------change the value in unit----------------------------------------------------

function changeunitusg()
   {
    var unit;
    unit=3.7852;
    var tbl =document.getElementById('tbl3');
    var tbl1 =document.getElementById('tbl1');
    var tbl2 =document.getElementById('tbl4');
    var tbl3 =document.getElementById('tbl5');
    var curr_row;
    tbl.rows[8].cells[1].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[8].cells[1].innerHTML))/unit));
    tbl.rows[10].cells[1].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[10].cells[1].innerHTML))/unit));
    tbl.rows[6].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[6].cells[3].innerHTML))/unit));
    tbl.rows[8].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[8].cells[3].innerHTML))/unit));
    tbl.rows[10].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[10].cells[3].innerHTML))/unit));
    tbl.rows[12].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[12].cells[3].innerHTML))/unit));
    if(tbl.rows[6].cells[4].innerHTML != '-')
       tbl.rows[6].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[6].cells[4].innerHTML))/unit));
    if(tbl.rows[10].cells[4].innerHTML != '-')
       tbl.rows[10].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[10].cells[4].innerHTML))/unit));
    if (tbl1.rows.length > 0 )
       {
       for (curr_row = 0; curr_row < tbl1.rows.length ; curr_row++)
         {
          if((tbl1.rows[curr_row].cells[3].innerHTML == 'Bulk-T') || (tbl1.rows[curr_row].cells[3].innerHTML == 'Bulk-B'))
            {
              tbl1.rows[curr_row].cells[2].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl1.rows[curr_row].cells[2].innerHTML))/unit));
             }
          }
        }
     if (tbl2.rows.length > 0 )
       {
       for (curr_row = 0; curr_row < tbl2.rows.length ; curr_row++)
         {
          if(tbl2.rows[curr_row].cells[1].innerHTML != '-')
             tbl2.rows[curr_row].cells[1].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[1].innerHTML))/unit));
          if(tbl2.rows[curr_row].cells[2].innerHTML != '-')
             tbl2.rows[curr_row].cells[2].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[2].innerHTML))/unit));
          if(tbl2.rows[curr_row].cells[3].innerHTML != '-')
             tbl2.rows[curr_row].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[3].innerHTML))/unit));
          if(tbl2.rows[curr_row].cells[4].innerHTML != '-')
             tbl2.rows[curr_row].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[4].innerHTML))/unit));
          }
        if(tbl3.rows[6].cells[2].innerHTML != '-')
          tbl3.rows[6].cells[2].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[2].innerHTML))/unit));
        if(tbl3.rows[6].cells[3].innerHTML != '-')
          tbl3.rows[6].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[3].innerHTML))/unit));
        if(tbl3.rows[6].cells[4].innerHTML != '-')
         tbl3.rows[6].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[4].innerHTML))/unit));
        if(tbl3.rows[6].cells[5].innerHTML != '-')
         tbl3.rows[6].cells[5].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[5].innerHTML))/unit));
         }
     CalculateUnit();
   }
  function changeunitltr()
     {
      var unit;
      unit=3.7852;
      var tbl =document.getElementById('tbl3');
      var tbl1 =document.getElementById('tbl1');
      var tbl2 =document.getElementById('tbl4');
      var tbl3 =document.getElementById('tbl5');
      var curr_row;

      tbl.rows[8].cells[1].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[8].cells[1].innerHTML))*unit));
      tbl.rows[10].cells[1].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[10].cells[1].innerHTML))*unit));
      tbl.rows[6].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[6].cells[3].innerHTML))*unit));
      tbl.rows[8].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[8].cells[3].innerHTML))*unit));
      tbl.rows[10].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[10].cells[3].innerHTML))*unit));
      tbl.rows[12].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[12].cells[3].innerHTML))*unit));
      if(tbl.rows[6].cells[4].innerHTML != '-')
        tbl.rows[6].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[6].cells[4].innerHTML))*unit));
      if(tbl.rows[10].cells[4].innerHTML != '-')
        tbl.rows[10].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl.rows[10].cells[4].innerHTML))*unit));
      if (tbl1.rows.length > 0 )
          {
           for (curr_row = 0; curr_row < tbl1.rows.length ; curr_row++)
            {
            if(tbl1.rows[curr_row].cells[3].innerHTML == 'Bulk-T' || tbl1.rows[curr_row].cells[3].innerHTML == 'Bulk-B')
              {
               tbl1.rows[curr_row].cells[2].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl1.rows[curr_row].cells[2].innerHTML))*unit));
              }
             }
           }
      if (tbl2.rows.length > 0 )
          {
          for (curr_row = 0; curr_row < tbl2.rows.length ; curr_row++)
             {
             if(tbl2.rows[curr_row].cells[1].innerHTML != '-')
               tbl2.rows[curr_row].cells[1].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[1].innerHTML))*unit));
             if(tbl2.rows[curr_row].cells[2].innerHTML != '-')
               tbl2.rows[curr_row].cells[2].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[2].innerHTML))*unit));
             if(tbl2.rows[curr_row].cells[3].innerHTML != '-')
               tbl2.rows[curr_row].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[3].innerHTML))*unit));
             if(tbl2.rows[curr_row].cells[4].innerHTML != '-')
               tbl2.rows[curr_row].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl2.rows[curr_row].cells[4].innerHTML))*unit));
              }
          if(tbl3.rows[6].cells[2].innerHTML != '-')
            tbl3.rows[6].cells[2].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[2].innerHTML))*unit));
          if(tbl3.rows[6].cells[3].innerHTML != '-')
            tbl3.rows[6].cells[3].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[3].innerHTML))*unit));
          if(tbl3.rows[6].cells[4].innerHTML != '-')
            tbl3.rows[6].cells[4].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[4].innerHTML))*unit));
          if(tbl3.rows[6].cells[5].innerHTML != '-')
            tbl3.rows[6].cells[5].innerHTML =formatdigit(Math.ceil(eval(changedigit(tbl3.rows[6].cells[5].innerHTML))*unit));
          }
      CalculateUnit();
    }

//-----------------------------------End of section---------------------------------------------------------------