Is there any way for SUM() function NOT to "round" the sum of some numbers?

Databases
1

Can anyone tell me how to achieve this (if there is any?)

Cause this is causing kinda big declination from the sum results i was expecting…

I have a table , in each cell there are different numbers , which are pulled from a table.Not all the cells of the table are pulled from the mysql table.Some are calculated with php.

I need to calculate the precise sum of 7 cells. I will give the examle of the 1st the idea is the same

I use this query to make the sum of this mathematical formula within the SUM brackets

SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)*1.005)
From `kiniseis`
WHERE `date` BETWEEN '$_GET[date1]' AND '$_GET[date2]'

Ok the problem is that after 20-25 records , the sum is correct , but after that there is a high declination of the actual sum. (i tested that by hand to see the accuracy of the sum , and also with excel).

So after i tried many things , i end up to the conclusion that the sum funcion rounds the ratio (kinisis_1c / kinisis_1b) , and causes the above problem of declination from the actual sum of those numbers.

All the fields of the database table are DECIMAL(11,0)

Thats why i search a way to bypass this problem if there is any way ofcourse.

Thanks in advance

2

i’m sorry, the php is no good for me, i don’t do php (remember, this is the mysql forum, not the php forum)

dealing with the precision of intermediate results is ~not~ best solved by creating a temporary table

earlier on in this thread you changed all your columns from DECIMAL(11,0) to INTEGER, but i see that you have changed them back – i suggest you change them back to INTEGER

meanwhile, you are experiencing a foreign key error, yes? do you have any trouble understanding what this error message is telling you?

3

Hello r937 , i tried to sum a variable but it didnt gaved me precise results again.
Its a bug of the sum function when it has a formula with a division inside it.

Yet again i learn that it doesnt have a problem when it doesnt include a division inside it.

So i thought to make a 2nd table which will hold the division part multiplied with a number, and to be connected with a foreign key with the 1st table.
Here are the 2 tables dump

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.41


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema gas_station
--

CREATE DATABASE IF NOT EXISTS gas_station;
USE gas_station;

--
-- Definition of table `kiniseis`
--

DROP TABLE IF EXISTS `kiniseis`;
CREATE TABLE `kiniseis` (
  `id_kiniseon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kinisis_1a` decimal(11,0) NOT NULL,
  `100a` decimal(11,0) NOT NULL,
  `super_1a` decimal(11,0) NOT NULL,
  `95_1a` decimal(11,0) NOT NULL,
  `95_2a` decimal(11,0) NOT NULL,
  `super_2a` decimal(11,0) NOT NULL,
  `kinisis_2a` decimal(11,0) NOT NULL,
  `kinisis_1b` decimal(11,0) NOT NULL,
  `100b` decimal(11,0) NOT NULL,
  `super_1b` decimal(11,0) NOT NULL,
  `95_1b` decimal(11,0) NOT NULL,
  `95_2b` decimal(11,0) NOT NULL,
  `super_2b` decimal(11,0) NOT NULL,
  `kinisis_2b` decimal(11,0) NOT NULL,
  `kinisis_1c` decimal(11,0) NOT NULL,
  `100c` decimal(11,0) NOT NULL,
  `super_1c` decimal(11,0) NOT NULL,
  `95_1c` decimal(11,0) NOT NULL,
  `95_2c` decimal(11,0) NOT NULL,
  `super_2c` decimal(11,0) NOT NULL,
  `kinisis_2c` decimal(11,0) NOT NULL,
  `kinisis_1d` decimal(11,0) NOT NULL,
  `100d` decimal(11,0) NOT NULL,
  `super_1d` decimal(11,0) NOT NULL,
  `95_1d` decimal(11,0) NOT NULL,
  `95_2d` decimal(11,0) NOT NULL,
  `super_2d` decimal(11,0) NOT NULL,
  `kinisis_2d` decimal(11,0) NOT NULL,
  `kinisis_1e` decimal(11,0) NOT NULL,
  `100e` decimal(11,0) NOT NULL,
  `super_1e` decimal(11,0) NOT NULL,
  `95_1e` decimal(11,0) NOT NULL,
  `95_2e` decimal(11,0) NOT NULL,
  `super_2e` decimal(11,0) NOT NULL,
  `kinisis_2e` decimal(11,0) NOT NULL,
  `kinisis_a` decimal(11,0) NOT NULL,
  `100_a` decimal(11,0) NOT NULL,
  `95_a` decimal(11,0) NOT NULL,
  `super_a` decimal(11,0) NOT NULL,
  `kinisis_b` decimal(11,2) NOT NULL,
  `100_b` decimal(11,2) NOT NULL,
  `95_b` decimal(11,2) NOT NULL,
  `super_b` decimal(11,2) NOT NULL,
  `date` date NOT NULL,
  `fpa` decimal(11,2) NOT NULL,
  `poliseon_ID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_kiniseon`),
  KEY `FK_kiniseis` (`poliseon_ID`),
  CONSTRAINT `FK_kiniseis` FOREIGN KEY (`poliseon_ID`) REFERENCES `poliseis` (`id_poliseon`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kiniseis`
--

/*!40000 ALTER TABLE `kiniseis` DISABLE KEYS */;
/*!40000 ALTER TABLE `kiniseis` ENABLE KEYS */;


--
-- Definition of table `poliseis`
--

DROP TABLE IF EXISTS `poliseis`;
CREATE TABLE `poliseis` (
  `id_poliseon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kinisis_1` decimal(11,4) NOT NULL,
  `100ara` decimal(11,4) NOT NULL,
  `super_1` decimal(11,4) NOT NULL,
  `95_1` decimal(11,4) NOT NULL,
  `95_2` decimal(11,4) NOT NULL,
  `super_2` decimal(11,4) NOT NULL,
  `kinisis_2` decimal(11,4) NOT NULL,
  PRIMARY KEY (`id_poliseon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `poliseis`
--

/*!40000 ALTER TABLE `poliseis` DISABLE KEYS */;
/*!40000 ALTER TABLE `poliseis` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

And below is the insert record page which while the insertion i want to calculate the division number i stated above :

<?php require_once('../Connections/gas_connection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insert_form")) {
  $insertSQL = sprintf("INSERT INTO kiniseis (kinisis_1a, `100a`, super_1a, `95_1a`, `95_2a`, super_2a, kinisis_2a, kinisis_1b, `100b`, super_1b, `95_1b`, `95_2b`, super_2b, kinisis_2b, kinisis_1c, `100c`, super_1c, `95_1c`, `95_2c`, super_2c, kinisis_2c, kinisis_1d, `100d`, super_1d, `95_1d`, `95_2d`, super_2d, kinisis_2d, kinisis_1e, `100e`, super_1e, `95_1e`, `95_2e`, super_2e, kinisis_2e, kinisis_a, `100_a`, `95_a`, super_a, kinisis_b, `100_b`, `95_b`, super_b, `date`, fpa) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['1'], "double"),
                       GetSQLValueString($_POST['2'], "double"),
                       GetSQLValueString($_POST['3'], "double"),
                       GetSQLValueString($_POST['4'], "double"),
                       GetSQLValueString($_POST['5'], "double"),
                       GetSQLValueString($_POST['6'], "double"),
                       GetSQLValueString($_POST['7'], "double"),
                       GetSQLValueString($_POST['8'], "double"),
                       GetSQLValueString($_POST['9'], "double"),
                       GetSQLValueString($_POST['10'], "double"),
                       GetSQLValueString($_POST['11'], "double"),
                       GetSQLValueString($_POST['12'], "double"),
                       GetSQLValueString($_POST['13'], "double"),
                       GetSQLValueString($_POST['14'], "double"),
                       GetSQLValueString($_POST['15'], "double"),
                       GetSQLValueString($_POST['16'], "double"),
                       GetSQLValueString($_POST['17'], "double"),
                       GetSQLValueString($_POST['18'], "double"),
                       GetSQLValueString($_POST['19'], "double"),
                       GetSQLValueString($_POST['20'], "double"),
                       GetSQLValueString($_POST['21'], "double"),
                       GetSQLValueString($_POST['22'], "double"),
                       GetSQLValueString($_POST['23'], "double"),
                       GetSQLValueString($_POST['24'], "double"),
                       GetSQLValueString($_POST['25'], "double"),
                       GetSQLValueString($_POST['26'], "double"),
                       GetSQLValueString($_POST['27'], "double"),
                       GetSQLValueString($_POST['28'], "double"),
                       GetSQLValueString($_POST['29'], "double"),
                       GetSQLValueString($_POST['30'], "double"),
                       GetSQLValueString($_POST['31'], "double"),
                       GetSQLValueString($_POST['32'], "double"),
                       GetSQLValueString($_POST['33'], "double"),
                       GetSQLValueString($_POST['34'], "double"),
                       GetSQLValueString($_POST['35'], "double"),
                       GetSQLValueString($_POST['36'], "double"),
                       GetSQLValueString($_POST['37'], "double"),
                       GetSQLValueString($_POST['38'], "double"),
                       GetSQLValueString($_POST['39'], "double"),
                       GetSQLValueString($_POST['40'], "double"),
                       GetSQLValueString($_POST['41'], "double"),
                       GetSQLValueString($_POST['42'], "double"),
                       GetSQLValueString($_POST['43'], "double"),
                       GetSQLValueString($_POST['date'], "date"),
                       GetSQLValueString($_POST['select_fpa'], "double"));

  mysql_select_db($database_gas_connection, $gas_connection);
  $Result1 = mysql_query($insertSQL, $gas_connection) or die(mysql_error());

  $insertGoTo = "../confirmation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

$venzini_kinisis_1 = @($row_KINISEIS['kinisis_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['kinisis_1a'];
$venzini_100ara = @($row_KINISEIS['100c']/$row_KINISEIS['100b']) * $row_KINISEIS['100a'];
$venzini_super_1 = @($row_KINISEIS['super_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['super_1a'];
$venzini_95_1 = @($row_KINISEIS['95_1c']/$row_KINISEIS['95_1b']) * $row_KINISEIS['95_1a'];
$venzini_95_2 = @($row_KINISEIS['95_2c']/$row_KINISEIS['95_2b']) * $row_KINISEIS['95_2a'];
$venzini_super_2 = @($row_KINISEIS['super_2c']/$row_KINISEIS['super_2b']) * $row_KINISEIS['super_2a'];
$venzini_kinisis_2 = @($row_KINISEIS['kinisis_2c']/$row_KINISEIS['kinisis_2b']) * $row_KINISEIS['kinisis_2a'];

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insert_form")) {
  $insertSQL = sprintf("INSERT INTO poliseis (kinisis_1, `100ara`, super_1, `95_1`, `95_2`, super_2, kinisis_2) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['$venzini_kinisis_1'], "double"),
                       GetSQLValueString($_POST['$venzini_100ara'], "double"),
                       GetSQLValueString($_POST['$venzini_super_1'], "double"),
                       GetSQLValueString($_POST['$venzini_95_1'], "double"),
                       GetSQLValueString($_POST['$venzini_95_2'], "double"),
                       GetSQLValueString($_POST['$venzini_super_2'], "double"),
                       GetSQLValueString($_POST['$venzini_kinisis_2'], "double"));

  mysql_select_db($database_gas_connection, $gas_connection);
  $Result1 = mysql_query($insertSQL, $gas_connection) or die(mysql_error());

  $insertGoTo = "../confirmation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_gas_connection, $gas_connection);
$query_KINISEIS = "SELECT * FROM kiniseis";
$KINISEIS = mysql_query($query_KINISEIS, $gas_connection) or die(mysql_error());
$row_KINISEIS = mysql_fetch_assoc($KINISEIS);
$totalRows_KINISEIS = mysql_num_rows($KINISEIS);
?>

The values that will be posted in the poliseis table (the 2nd one) is those that are calculated with their declared variable :

$venzini_kinisis_1 = @($row_KINISEIS['kinisis_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['kinisis_1a'];
$venzini_100ara = @($row_KINISEIS['100c']/$row_KINISEIS['100b']) * $row_KINISEIS['100a'];
$venzini_super_1 = @($row_KINISEIS['super_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['super_1a'];
$venzini_95_1 = @($row_KINISEIS['95_1c']/$row_KINISEIS['95_1b']) * $row_KINISEIS['95_1a'];
$venzini_95_2 = @($row_KINISEIS['95_2c']/$row_KINISEIS['95_2b']) * $row_KINISEIS['95_2a'];
$venzini_super_2 = @($row_KINISEIS['super_2c']/$row_KINISEIS['super_2b']) * $row_KINISEIS['super_2a'];
$venzini_kinisis_2 = @($row_KINISEIS['kinisis_2c']/$row_KINISEIS['kinisis_2b']) * $row_KINISEIS['kinisis_2a'];

I run the whole thing but i receive the following error :

Cannot add or update a child row: a foreign key constraint fails (`gas_station`.`kiniseis`, CONSTRAINT `FK_kiniseis` FOREIGN KEY (`poliseon_ID`) REFERENCES `poliseis` (`id_poliseon`) ON DELETE CASCADE ON UPDATE CASCADE)

Something is wrong but i can not see it :frowning:
Any suggestions to this problem?

Thanks again :slight_smile:

4

i am sorry, i have no idea what you are doing

perhaps you could flag your thread and ask a moderator to move it to the php forum if that’s where you’re going to do the sum

5

r937 thank you very much i appreciate it :slight_smile:

I had small mistake in my query (i want to de-tax a number basicly, column fpa is the added tax value)

Was my mistake that i didnt told you a small but important detail.
The values i calculated from excel was from an other page i have that has 1 table , and in a cell adds 3 values. The number that is computed by the sum of those 3 values (with tax value included) , on an other cell is computed like below
((sum of 3 values)/(1+fpa)) * 1.005

Ok now with repeat region of the table i got the amount of this formula stated above for each record.

The totals that are correct ,which are the below ones (57 records, bewtween 2 dates)
7,102.56
4,247.54
5,240.10
5,671.92
6,406.82
2,153.26
4,448.42
4,673.18
4,671.98
5,158.61
5,987.77
5,585.56
4,745.54
5,378.74
4,992.81
5,382.46
6,929.17
4,289.44
4,034.80
6,120.87
5,093.98
5,230.31
6,212.02
6,117.57
4,318.29
6,048.58
5,207.88
4,402.67
5,735.78
5,803.50
6,056.55
7,045.01
6,263.73
5,513.73
5,213.03
5,981.59
6,335.09
5,876.68
5,415.44
5,427.29
5,963.86
5,994.41
4,762.65
5,911.36
5,430.57
5,027.80
4,538.96
5,317.29
4,869.89
5,553.88
5,816.56
5,602.75
3,981.29
6,727.43
5,152.47
5,487.49
4,427.71

Total sum = 307,086.64

Now after i searched carefully on google i came up to this piece of information from Microsoft that says that there is a precision problem with SUM() function
http://support.microsoft.com/kb/281341

From the 3 work arrounds they propose i can use only the 2nd one since the column fpa is not integer but double 0.19 , 0.21 ect.

“Store the sum in a variable first, and use the variable in the formula”

When i read this i understand that i should make a query without the sum inside it , and after to use the SUM() function within the page it self using the recordset created by dreamweaver.

So i created this :

SELECT (((kinisis_1c + kinisis_1e + ((kinisis_1c / kinisis_1b) * kinisis_1a))/(1 + fpa)) * 1.005) AS kinisis_1_total, (((100c + 100e + ((100c / 100b)* 100a)) / (1 + fpa)) *1.005) AS 100ara_total, (((super_1c  + super_1e + ((super_1c / super_1b)* super_1a)) / (1 + fpa)) *1.005) AS super_1_total, (((95_1c + 95_1e + ((95_1c / 95_1b)* 95_1a)) / (1 + fpa)) *1.005) AS 95_1_total, (((95_2c + 95_2e + ((95_2c / 95_2b)*  95_2a)) / (1 + fpa)) *1.005) AS 95_2_total, (((super_2c + super_2e + ((super_2c / super_2b) * super_2a)) / (1 + fpa)) *1.005) AS super_2_total, (((kinisis_2c + kinisis_2e + ((kinisis_2c / kinisis_2b) * kinisis_2a)) / (1 + fpa)) *1.005) AS kinisis_2_total
FROM kiniseis
WHERE `date` BETWEEN '$_GET[date1]' AND '$_GET[date2]'

The problem i have now is that i know only in mysql how to type the correct syntax for the sum function in php


<?php 
$i1 = 'SUM($row_i_totals[kinisis_1_total])';
?>

And because this is a string i dont know how to output it correctly :frowning:

I excpect between the dates 2006-10-30 and 2006-12-05 (the 1st 57 records) to give me a result
$i1 = 93665.11 .

Any suggestions , modifications ? :slight_smile:

Thank you very much again :slight_smile:

6

okay, that’s great

i ran this query to examine the data –

SELECT kinisis_1a , kinisis_1b , kinisis_1c , kinisis_1e , fpa
     , (kinisis_1c / kinisis_1b) as d
     , (kinisis_1c / kinisis_1b) * kinisis_1a as e
     , (kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa) as f
     , (kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)* 1.005 as g
  FROM kiniseis
 WHERE id_kiniseon < 21

this produced the following…

kinisis_1a   kinisis_1b   kinisis_1c   kinisis_1e      fpa       d        e              f              g
         0         2100         1888         1527     0.19    0.90        0        2766.15     2779.98075
         0          979          876          768     0.19    0.89        0        1331.64      1338.2982
        53         3334         1185         1178     0.19    0.36    18.84    1929.288563    1938.935006
         0         1696         1518          804     0.19    0.90        0        1880.82      1890.2241
         0         2863         2562            0     0.19    0.89        0        2075.22      2085.5961
         0          227          203            0     0.19    0.89        0         164.43      165.25215
        22          613          548          297     0.19    0.89    19.67    700.3804405    703.8823427
         0         1099          983          330     0.19    0.89        0        1063.53     1068.84765
         0         1214         1087          454     0.19    0.90        0        1248.21     1254.45105
         0         1706         1527          693     0.19    0.90        0         1798.2       1807.191
         0          770          689          965     0.19    0.89        0        1339.74      1346.4387
         0          306          274           41     0.19    0.90        0         255.15      256.42575
         0         1272         1138          200     0.19    0.89        0        1083.78      1089.1989
         0         2321         2077            0     0.19    0.89        0        1682.37     1690.78185
        23         2193         1962            0     0.19    0.89    20.58    1605.887606    1613.917044
         0         2385         2134            0     0.19    0.89        0        1728.54      1737.1827
         0         3475         3110            0     0.19    0.89        0         2519.1      2531.6955
        56         1117         1000            0     0.19    0.90    50.13    850.6087735    854.8618174
         0         1350         1208            0     0.19    0.89        0         978.48       983.3724
         0         3497         3130            0     0.19    0.90        0         2535.3      2547.9765

i also pasted these results into excel and i got the following number for the sum of the last column: 29684.50951

then i ran this query:

SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a)  * (1-fpa)*1.005) AS x
  FROM kiniseis
 WHERE id_kiniseon < 21

and here’s the result from this query: 29684.50951018

my conclusion is that you don’t gots a problem

:cool:

7

[QUOTE=r937;4632844]extra column? no

why don’t you dump the table and give us the CREATE TABLE statement as well as a few INSERT statements so that we can try to reproduce the results and perhaps see what’s causing it or how to fix it[/QUOTE]

Create table statement

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.41


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema gas_station
--

CREATE DATABASE IF NOT EXISTS gas_station;
USE gas_station;

--
-- Definition of table `kiniseis`
--

DROP TABLE IF EXISTS `kiniseis`;
CREATE TABLE `kiniseis` (
  `id_kiniseon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kinisis_1a` int(10) unsigned NOT NULL,
  `100a` int(10) unsigned NOT NULL,
  `super_1a` int(10) unsigned NOT NULL,
  `95_1a` int(10) unsigned NOT NULL,
  `95_2a` int(10) unsigned NOT NULL,
  `super_2a` int(10) unsigned NOT NULL,
  `kinisis_2a` int(10) unsigned NOT NULL,
  `kinisis_1b` int(10) unsigned NOT NULL,
  `100b` int(10) unsigned NOT NULL,
  `super_1b` int(10) unsigned NOT NULL,
  `95_1b` int(10) unsigned NOT NULL,
  `95_2b` int(10) unsigned NOT NULL,
  `super_2b` int(10) unsigned NOT NULL,
  `kinisis_2b` int(10) unsigned NOT NULL,
  `kinisis_1c` int(10) unsigned NOT NULL,
  `100c` int(10) unsigned NOT NULL,
  `super_1c` int(10) unsigned NOT NULL,
  `95_1c` int(10) unsigned NOT NULL,
  `95_2c` int(10) unsigned NOT NULL,
  `super_2c` int(10) unsigned NOT NULL,
  `kinisis_2c` int(10) unsigned NOT NULL,
  `kinisis_1d` int(10) unsigned NOT NULL,
  `100d` int(10) unsigned NOT NULL,
  `super_1d` int(10) unsigned NOT NULL,
  `95_1d` int(10) unsigned NOT NULL,
  `95_2d` int(10) unsigned NOT NULL,
  `super_2d` int(10) unsigned NOT NULL,
  `kinisis_2d` int(10) unsigned NOT NULL,
  `kinisis_1e` int(10) unsigned NOT NULL,
  `100e` int(10) unsigned NOT NULL,
  `super_1e` int(10) unsigned NOT NULL,
  `95_1e` int(10) unsigned NOT NULL,
  `95_2e` int(10) unsigned NOT NULL,
  `super_2e` int(10) unsigned NOT NULL,
  `kinisis_2e` int(10) unsigned NOT NULL,
  `kinisis_a` int(10) unsigned DEFAULT NULL,
  `100_a` int(10) unsigned DEFAULT NULL,
  `95_a` int(10) unsigned DEFAULT NULL,
  `super_a` int(10) unsigned DEFAULT NULL,
  `kinisis_b` decimal(11,2) DEFAULT NULL,
  `100_b` decimal(11,2) DEFAULT NULL,
  `95_b` decimal(11,2) DEFAULT NULL,
  `super_b` decimal(11,2) DEFAULT NULL,
  `date` date NOT NULL,
  `fpa` double NOT NULL,
  PRIMARY KEY (`id_kiniseon`)
) ENGINE=InnoDB AUTO_INCREMENT=409 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kiniseis`
--

/*!40000 ALTER TABLE `kiniseis` DISABLE KEYS */;
INSERT INTO `kiniseis` (`id_kiniseon`,`kinisis_1a`,`100a`,`super_1a`,`95_1a`,`95_2a`,`super_2a`,`kinisis_2a`,`kinisis_1b`,`100b`,`super_1b`,`95_1b`,`95_2b`,`super_2b`,`kinisis_2b`,`kinisis_1c`,`100c`,`super_1c`,`95_1c`,`95_2c`,`super_2c`,`kinisis_2c`,`kinisis_1d`,`100d`,`super_1d`,`95_1d`,`95_2d`,`super_2d`,`kinisis_2d`,`kinisis_1e`,`100e`,`super_1e`,`95_1e`,`95_2e`,`super_2e`,`kinisis_2e`,`kinisis_a`,`100_a`,`95_a`,`super_a`,`kinisis_b`,`100_b`,`95_b`,`super_b`,`date`,`fpa`) VALUES 
 (1,0,0,0,0,0,0,0,2100,218,333,804,849,144,1039,1888,231,319,728,769,138,930,1706,60,84,754,493,122,548,1527,64,80,683,446,117,490,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-03',0.19),
 (2,0,0,0,0,38,0,0,979,52,65,1077,563,42,779,876,55,62,975,510,40,697,859,74,0,480,422,0,131,768,79,434,382,0,117,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-04',0.19),
 (3,53,0,0,33,11,0,0,3334,49,213,927,740,126,691,1185,52,204,840,670,120,618,1313,92,46,425,522,15,295,1178,98,44,385,473,15,264,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-05',0.19),
 (4,0,0,0,0,0,0,0,1696,69,284,825,553,70,714,1518,73,272,747,501,67,639,899,115,156,912,615,15,478,804,122,149,826,557,14,427,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-06',0.19),
 (5,0,119,34,153,321,0,218,2863,359,204,1533,1663,49,808,2562,381,195,1389,1506,47,723,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-07',0.19),
 (6,0,0,5,33,0,0,0,227,143,56,1022,490,35,787,203,152,53,926,444,33,704,725,56,55,476,311,2,378,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-09',0.19),
 (7,22,0,0,0,47,0,0,613,250,189,965,557,96,968,548,265,181,874,505,92,866,332,66,63,647,489,41,422,297,70,60,586,443,40,378,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-10',0.19),
 (8,0,0,0,28,95,0,0,1099,197,104,1003,649,24,693,983,209,99,908,588,23,620,369,169,15,566,522,33,504,330,180,14,513,473,31,451,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-11',0.19),
 (9,0,0,0,0,0,0,0,1214,120,112,917,614,108,868,1087,127,107,830,556,103,777,508,75,88,600,515,58,293,454,80,84,543,467,55,262,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-12',0.19),
 (10,0,0,0,11,27,0,40,1706,111,122,530,576,55,517,1527,118,116,480,521,53,463,774,112,24,929,622,9,574,693,119,23,841,563,8,513,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-13',0.19),
 (11,0,0,0,0,0,0,0,770,333,71,1030,729,32,533,689,353,68,933,660,31,477,1078,173,142,1219,1009,41,601,965,184,136,1104,914,39,537,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-14',0.19),
 (12,0,0,0,99,85,0,56,306,323,135,1089,1101,144,411,274,343,129,986,997,138,368,46,321,70,1236,1291,34,437,41,341,67,1120,1170,32,391,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-15',0.19),
 (13,0,0,0,55,61,0,0,1272,121,145,916,733,75,820,1138,128,139,830,664,72,734,224,119,52,631,624,9,321,200,126,50,572,565,9,287,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-16',0.19),
 (14,0,0,34,39,0,0,0,2321,254,230,1721,1035,141,1231,2077,270,220,1559,938,135,1102,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-17',0.19),
 (15,23,0,0,66,11,0,52,2193,243,308,1352,999,84,1173,1962,258,295,1225,905,80,1050,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-18',0.19),
 (16,0,0,0,0,0,0,45,2385,138,232,1556,1242,210,1224,2134,146,222,1410,1125,201,1095,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-19',0.19),
 (17,0,0,0,33,80,0,45,3475,433,291,1763,1513,73,1313,3110,459,279,1597,1371,70,1176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-20',0.19),
 (18,56,0,0,0,55,0,94,1117,476,257,1228,1223,53,976,1000,505,246,1112,1108,51,873,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-21',0.19),
 (19,0,0,31,53,22,0,0,1350,268,246,1315,1023,171,751,1208,285,235,1191,926,163,672,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-23',0.19),
 (20,0,0,11,0,13,0,45,3497,238,406,1504,1013,58,1206,3130,252,388,1362,918,55,1080,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-24',0.19),
 (21,86,0,0,45,22,0,0,2344,70,268,1545,1207,83,998,2098,74,256,1400,1093,80,893,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-25',0.19),
 (22,0,0,20,0,6,0,23,1618,320,112,1721,1479,110,160,1448,340,107,1559,1340,105,1110,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-26',0.19),
 (23,0,0,0,11,22,0,32,3041,270,277,1882,1391,183,989,2721,286,265,1705,1260,175,885,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-27',0.19),
 (24,332,0,0,0,22,0,0,556,365,223,1456,983,48,727,497,387,213,1319,890,46,650,78,74,84,1316,1213,31,420,70,79,80,1192,1099,29,376,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-29',0.19),
 (25,223,0,0,31,0,0,22,909,165,83,803,667,40,978,813,175,79,727,604,38,875,780,113,50,248,219,35,261,698,120,48,224,198,34,233,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-30',0.19),
 (26,0,0,0,0,0,0,0,2387,85,223,1049,735,11,966,2136,90,213,950,666,10,865,908,0,84,528,495,28,432,812,0,80,478,449,27,386,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-31',0.19),
 (27,0,0,42,33,0,0,23,1136,107,195,894,766,136,932,1016,113,186,810,694,130,834,1363,88,35,334,445,10,259,1220,93,33,302,403,10,232,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-01',0.19),
 (28,0,46,0,124,139,0,44,4442,101,143,668,449,82,353,1290,107,136,605,406,78,316,794,67,21,582,389,32,262,710,71,20,532,352,30,234,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-02',0.19),
 (29,0,0,0,22,107,0,49,1363,127,150,908,611,70,810,1220,135,143,822,553,67,725,989,94,53,989,741,31,407,855,100,51,896,671,29,364,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-03',0.19),
 (30,34,32,9,50,111,0,28,2184,160,198,1070,737,49,514,1954,170,189,969,667,47,460,241,180,42,624,652,73,560,215,191,40,565,590,70,501,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-04',0.19),
 (31,825,29,0,65,92,0,33,1825,218,63,1156,623,67,758,1633,231,60,1044,564,64,678,332,105,65,525,499,0,626,297,111,62,475,452,0,560,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-06',0.19),
 (32,0,0,0,44,0,0,0,3093,138,159,901,794,81,926,2768,146,152,816,719,77,829,1295,50,175,582,461,96,425,1159,53,167,527,417,92,380,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-07',0.19),
 (33,512,38,27,199,268,10,133,1631,175,190,776,626,126,883,1460,185,181,703,567,120,790,779,171,83,624,416,0,486,697,181,80,565,377,0,435,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-08',0.19),
 (34,0,0,21,0,66,0,67,1609,46,124,1013,654,146,676,1440,49,118,918,592,139,605,714,221,110,831,403,13,470,639,234,105,752,365,13,420,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-09',0.19),
 (35,0,0,0,115,11,0,4,1590,136,129,697,875,35,741,1423,144,123,631,792,34,663,506,88,106,716,596,2,456,453,93,101,648,540,2,408,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-10',0.19),
 (36,0,42,0,94,88,0,17,1643,127,107,772,904,53,546,1470,135,102,699,819,51,488,999,389,87,769,634,56,425,894,413,83,697,574,53,380,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-11',0.19),
 (37,129,0,0,22,99,0,0,2118,52,219,1381,896,20,1014,1898,55,210,1251,812,19,907,750,60,100,538,562,31,300,671,64,95,487,509,30,268,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-13',0.19),
 (38,0,19,8,71,77,0,33,1505,152,224,960,396,127,1010,1347,161,214,870,359,121,904,1397,105,37,443,491,10,603,1250,111,35,401,445,10,539,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-14',0.19),
 (39,0,0,0,11,106,0,44,999,231,127,768,678,76,776,894,245,121,696,614,73,694,1377,144,91,506,573,46,489,1232,153,87,458,519,44,437,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-15',0.19),
 (40,11,0,0,0,16,0,0,1367,42,278,875,704,31,546,1223,44,266,792,638,30,488,1160,85,34,734,568,1,649,1038,90,32,665,515,1,580,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-16',0.19),
 (41,0,0,0,17,89,0,22,1008,204,63,937,593,72,753,902,216,60,849,537,69,674,1505,159,99,853,730,53,609,1347,169,95,772,661,50,545,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-17',0.19),
 (42,0,0,0,44,74,0,0,1440,285,141,914,973,47,752,1289,302,135,828,881,45,673,726,136,75,831,821,89,437,650,144,71,753,744,85,391,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-18',0.19),
 (43,0,0,10,0,34,0,0,250,289,158,1226,924,51,383,223,307,151,1110,837,49,342,0,129,36,1377,607,72,607,0,137,34,1247,550,69,543,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-19',0.19),
 (44,335,0,15,383,185,0,115,923,100,110,872,570,73,792,826,106,105,790,516,70,709,1348,66,82,623,491,73,575,1206,70,78,564,444,70,514,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-20',0.19),
 (45,631,0,0,11,79,21,56,657,104,71,585,497,38,627,588,110,68,530,450,36,561,1004,135,149,500,893,31,1001,898,143,142,453,809,30,896,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-21',0.19),
 (46,0,0,0,45,0,0,23,1685,38,118,795,687,42,671,1508,40,113,720,622,40,600,738,132,34,514,422,33,601,660,140,32,465,382,32,538,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-22',0.19),
 (47,0,0,0,91,53,0,0,1519,147,180,671,757,34,804,1359,156,172,608,686,32,719,112,123,0,651,249,54,465,100,130,0,590,225,51,416,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-23',0.19),
 (48,0,0,0,89,22,0,80,1502,163,128,830,722,107,793,1344,173,122,752,654,102,709,598,47,26,840,715,10,269,535,50,25,761,647,10,240,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-24',0.19),
 (49,0,0,0,28,22,0,28,998,115,105,803,809,77,779,893,122,100,727,733,73,697,347,82,50,918,758,87,342,310,87,48,831,686,83,306,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-25',0.19),
 (50,17,116,52,393,370,42,58,1199,122,147,835,821,97,571,1073,129,140,756,743,93,511,548,19,42,734,329,63,657,490,20,40,665,298,60,588,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-27',0.19),
 (51,111,0,0,45,67,0,78,1491,176,193,913,776,143,988,1333,187,185,826,702,137,883,784,78,73,642,431,95,501,701,83,70,581,390,91,448,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-28',0.19),
 (52,0,0,21,59,49,0,45,1857,148,152,678,826,0,817,1662,157,145,614,748,0,731,717,18,58,660,581,52,593,641,19,55,598,526,50,530,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-29',0.19),
 (53,0,0,0,0,22,0,45,1240,0,73,830,581,26,549,1110,0,70,752,526,25,491,129,111,21,598,456,18,510,115,118,20,541,413,17,456,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-30',0.19),
 (54,0,0,0,209,22,0,22,1926,269,185,951,556,0,1284,1723,285,177,861,503,0,1149,787,218,65,912,818,48,480,704,231,62,826,741,46,429,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-01',0.19),
 (55,0,28,21,423,244,35,89,873,70,166,915,953,108,675,871,74,159,829,863,103,604,336,192,21,562,440,50,394,300,204,20,509,398,48,352,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-02',0.19),
 (56,0,14,0,22,87,0,0,1100,111,101,950,766,97,1193,984,118,96,860,694,93,1067,639,38,56,828,497,46,294,572,40,53,750,450,44,563,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-04',0.19),
 (57,0,0,0,0,22,0,11,1100,0,155,795,696,86,1000,993,0,148,720,630,82,895,112,150,89,563,465,86,434,100,159,85,510,421,82,388,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-05',0.19),
 (58,0,0,0,55,44,0,67,1036,67,138,1035,655,59,925,927,71,123,937,593,56,828,914,95,57,654,560,21,363,818,101,54,592,507,20,325,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-06',0.19),
 (59,0,57,0,44,22,0,67,1930,63,49,838,685,36,901,1727,67,47,759,260,34,806,430,256,45,772,439,10,485,385,272,43,699,397,10,434,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-07',0.19),
 (60,0,77,0,180,60,10,23,3432,103,73,701,453,39,744,1281,109,70,635,410,37,666,855,190,94,1027,735,43,726,765,201,90,930,666,41,650,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-08',0.19),
 (61,0,46,0,87,34,0,0,903,171,117,1202,908,125,683,808,181,112,1089,822,119,611,47,139,147,690,472,5,449,42,147,140,625,427,5,402,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-09',0.19),
 (62,0,0,0,66,106,0,0,84,89,105,1176,624,9,580,75,94,100,1065,565,9,519,293,84,31,1137,943,52,562,262,89,29,1030,854,50,503,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-10',0.19),
 (63,0,0,0,11,22,24,67,1440,47,143,747,710,56,706,1289,50,137,676,643,53,632,646,28,21,535,510,73,533,578,30,20,484,462,70,477,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-11',0.19),
 (64,0,0,0,78,17,0,45,1992,19,123,709,585,93,970,1783,20,188,642,530,89,868,112,57,42,577,332,92,367,100,60,40,522,300,88,328,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-12',0.19),
 (65,0,0,0,74,94,0,0,1306,201,35,845,986,45,785,1169,213,33,765,893,44,702,660,29,16,579,586,28,621,590,30,15,524,531,27,555,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-13',0.19),
 (66,0,18,0,162,206,25,86,1276,94,21,800,478,23,730,1142,100,20,725,433,22,653,1252,103,11,1143,486,16,485,1120,109,10,1035,440,15,434,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-14',0.19),
 (67,0,0,0,16,27,0,0,1427,144,111,1043,670,99,830,1277,153,106,945,607,89,743,503,94,89,803,531,37,401,450,100,85,727,481,35,359,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-15',0.19),
 (68,0,49,26,39,33,0,0,494,178,61,1097,725,60,400,442,189,58,994,656,57,358,984,41,109,777,646,64,480,880,43,104,704,585,585,430,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-16',0.19),
 (69,0,0,42,78,158,0,106,988,96,133,1100,636,79,572,884,102,127,996,576,75,673,760,117,40,658,601,21,707,680,124,38,596,544,20,632,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-18',0.19),
 (70,0,14,16,0,49,0,0,843,62,136,996,674,74,829,754,66,145,902,610,71,742,166,76,96,694,628,41,527,150,81,93,635,575,40,477,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-19',0.19),
 (71,0,14,20,466,159,0,162,1011,107,118,697,688,51,711,915,114,115,638,630,50,643,491,87,41,375,403,67,288,444,93,40,343,369,65,260,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-20',0.19),
 (72,0,0,0,24,49,0,0,1561,212,79,1232,715,130,786,1412,227,77,1128,655,127,711,811,237,45,576,566,13,572,734,254,44,527,518,12,517,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-21',0.19),
 (73,0,19,0,20,11,0,78,3205,205,154,1031,1008,8,1031,1995,219,150,944,923,8,933,538,284,65,700,501,25,699,487,304,54,641,459,24,632,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-22',0.19),
 (74,0,0,0,99,93,0,35,1776,343,117,1279,1108,143,426,1607,367,114,1171,1015,139,385,331,66,41,780,537,54,442,300,70,40,714,492,52,400,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-23',0.19),
 (75,0,0,0,22,28,0,0,133,326,179,1339,736,114,670,120,349,174,1226,674,110,606,144,88,20,967,810,138,394,130,94,20,885,742,134,356,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-24',0.19),
 (76,0,0,0,476,594,0,203,0,196,104,1125,1001,73,462,0,210,101,1030,917,71,418,99,194,100,1292,885,71,407,90,208,97,1183,810,69,368,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-26',0.19),
 (77,332,0,0,44,65,0,77,579,143,98,1009,739,26,781,524,153,95,924,677,25,707,637,117,103,791,580,37,250,576,125,100,724,531,36,226,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-27',0.19),
 (78,587,0,0,91,55,0,0,587,150,169,1000,811,52,718,531,160,165,916,742,50,650,1002,67,138,728,468,20,365,907,72,134,666,428,20,330,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-28',0.19),
 (79,352,46,0,44,44,0,44,425,102,138,1246,865,59,807,384,109,134,1141,792,57,730,644,162,0,848,581,9,583,583,173,0,776,532,9,527,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-29',0.19),
 (80,11,0,0,91,0,0,83,1411,69,114,1064,915,56,515,1277,74,111,974,838,54,466,0,425,40,693,654,30,483,0,455,39,634,599,30,437,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-30',0.19),
 (81,0,37,51,597,502,0,236,1109,56,126,864,673,75,689,1003,60,123,791,616,73,623,458,134,61,581,330,24,214,414,143,59,532,302,23,193,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-02',0.19),
 (82,0,0,0,0,0,0,0,1009,115,148,985,863,41,443,913,123,144,902,790,40,401,451,47,47,625,337,21,547,408,50,46,572,308,20,495,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-03',0.19),
 (83,0,0,0,22,10,0,22,1718,92,92,901,585,134,601,1554,98,89,825,535,130,544,699,14,79,444,617,21,265,632,15,77,406,565,20,240,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-04',0.19),
 (84,0,0,0,0,0,0,0,1705,104,121,880,482,30,438,1543,111,118,806,441,29,396,626,284,67,904,762,0,512,566,304,65,828,698,0,463,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-05',0.19),
 (85,0,0,0,0,42,0,0,0,141,31,1708,896,86,360,0,151,30,1564,820,84,325,0,175,151,1563,1162,21,521,0,187,147,1431,1064,20,471,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-06',0.19),
 (86,0,106,0,524,462,0,93,878,121,97,1145,778,38,1039,794,129,94,1049,712,37,940,576,52,21,762,363,20,363,521,55,20,698,360,19,328,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-08',0.19),
 (87,0,0,0,91,10,0,38,889,93,226,743,743,90,636,804,100,220,680,680,88,575,1044,23,107,674,591,89,314,945,24,104,617,541,87,284,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-09',0.19),
 (88,0,28,0,16,38,0,50,830,42,158,650,943,65,635,751,45,154,595,864,63,574,652,90,68,572,624,31,265,590,96,66,524,571,30,240,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-10',0.19),
 (89,0,59,86,11,41,0,66,226,38,86,560,565,82,1212,204,40,84,513,517,80,1096,690,44,46,519,493,35,206,624,47,45,475,451,34,186,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-11',0.19),
 (90,115,0,0,0,56,21,0,1516,129,88,564,753,42,497,1357,137,85,511,682,40,444,285,59,52,673,744,27,481,255,62,50,609,674,26,430,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-12',0.19),
 (91,0,0,0,204,327,0,46,430,269,127,953,608,66,648,385,285,122,863,550,63,580,553,237,98,869,885,94,223,495,251,94,787,801,91,199,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-13',0.19),
 (92,0,0,0,44,121,0,67,1921,67,167,781,882,61,678,1569,71,159,699,790,58,606,777,33,21,560,693,23,327,695,35,20,501,621,22,292,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-15',0.19),
 (93,0,0,10,0,0,0,0,489,134,158,711,947,123,183,437,142,151,637,848,117,93,502,66,26,691,506,26,462,449,70,25,619,453,25,413,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-16',0.19),
 (94,0,0,21,23,29,0,0,984,161,108,1035,589,22,529,851,171,103,899,512,21,457,445,47,126,912,480,9,614,385,50,122,792,417,8,531,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-17',0.19),
 (95,0,0,0,52,12,0,0,564,308,239,1083,917,16,842,488,324,223,941,885,15,728,475,49,32,640,296,11,318,410,51,30,556,257,10,275,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-18',0.19),
 (96,34,21,11,85,98,0,69,1391,112,177,958,780,146,1092,1203,118,165,832,678,136,944,1259,173,129,695,480,21,287,1089,182,120,604,417,19,248,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-19',0.19),
 (97,0,0,0,0,52,0,41,940,22,122,866,847,33,730,813,23,114,752,736,31,631,420,164,43,886,678,20,259,363,172,40,770,589,19,224,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-20',0.19),
 (98,0,0,0,81,33,0,24,58,184,89,1341,930,9,313,50,193,83,1165,808,8,270,0,72,53,882,692,45,458,0,75,50,768,601,42,396,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-21',0.19),
 (99,0,14,16,23,71,0,23,719,47,69,928,772,47,713,622,49,64,806,670,44,616,1598,46,43,786,545,8,427,1382,48,40,683,473,8,369,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-22',0.19),
 (100,0,0,0,49,23,0,0,321,165,172,1244,721,52,651,277,170,157,1068,619,47,563,458,29,33,605,586,61,368,396,30,30,519,503,56,318,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-23',0.19),
 (101,0,0,0,12,12,0,0,1348,138,78,744,590,11,601,1166,142,71,639,507,10,520,752,136,55,358,534,36,379,650,140,50,823,458,33,328,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-24',0.19),
 (102,0,7,0,162,125,0,0,682,54,58,990,788,25,690,590,56,53,850,677,23,597,849,133,22,1106,521,33,346,734,137,20,950,447,30,299,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-25',0.19),
 (103,94,0,22,46,117,26,46,770,150,85,1039,439,46,738,666,155,78,903,381,42,638,1112,70,102,559,792,81,410,962,72,93,485,688,74,354,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-26',0.19),
 (104,0,0,0,17,11,0,0,202,163,159,1008,708,22,466,174,168,145,876,615,20,403,231,153,0,1027,849,0,326,200,158,0,892,737,0,282,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-27',0.19),
 (105,0,8,0,12,83,0,27,1139,58,27,823,919,77,496,985,60,24,715,798,70,429,712,100,11,601,335,1,252,616,105,10,534,298,1,218,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-29',0.19),
 (106,0,0,0,0,0,0,11,416,77,127,672,539,42,851,360,81,118,597,479,39,736,840,55,118,764,455,0,254,726,58,110,679,404,0,220,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-30',0.19),
 (107,23,0,10,101,115,0,41,1849,97,64,768,519,28,420,1599,102,60,682,461,26,363,1028,19,54,762,374,69,489,889,20,50,677,332,65,423,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-31',0.19),
 (108,0,0,16,0,0,0,0,722,106,69,1198,716,16,739,624,111,68,1065,636,15,639,1467,47,22,537,576,82,282,1269,50,20,472,512,77,244,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-01',0.19),
 (109,0,0,0,0,0,0,0,1047,19,217,763,686,43,668,905,20,203,678,610,40,578,1375,185,65,1012,870,32,313,1189,194,61,899,773,30,270,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-02',0.19),
 (110,0,38,0,22,95,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,158,16,715,533,22,503,0,166,15,635,474,20,435,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-03',0.19),
 (111,0,38,0,22,95,0,0,1700,151,110,1032,720,76,1142,1504,162,105,928,647,72,1010,1278,40,85,614,622,21,287,1131,43,81,552,559,20,254,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-05',0.19),
 (112,214,37,0,255,181,18,204,1102,56,173,680,584,81,557,975,60,165,611,525,77,493,644,82,47,627,572,23,405,570,88,45,563,514,22,358,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-06',0.19),
 (113,0,0,0,75,67,0,28,1112,28,186,1234,432,38,711,984,30,178,1109,388,36,629,1727,74,72,995,594,0,276,1528,79,69,894,534,0,244,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-07',0.19),
 (114,23,0,0,45,89,0,136,520,65,47,970,605,47,625,460,700,45,870,544,45,553,692,47,0,749,675,15,502,612,50,0,673,607,15,444,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-08',0.19),
 (115,0,0,0,0,0,0,0,914,18,84,934,710,63,702,809,19,80,839,638,60,621,792,19,44,813,599,23,338,701,20,42,731,538,22,299,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-09',0.19),
 (116,0,47,0,22,28,0,0,601,97,138,988,872,45,481,532,104,132,888,784,43,425,221,242,42,696,568,39,321,195,259,40,625,510,37,284,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-10',0.19),
 (117,0,70,0,84,42,0,0,0,115,70,896,654,111,405,0,123,67,805,588,106,358,226,237,47,1016,806,41,269,200,254,45,913,724,39,238,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-11',0.19),
 (118,23,81,0,152,39,11,56,1459,58,63,923,841,0,552,1291,62,60,830,756,0,488,0,19,31,710,612,0,487,0,20,30,638,550,0,431,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-12',0.19),
 (119,0,0,0,0,67,0,45,462,114,116,1025,739,15,942,409,122,111,921,664,14,833,933,62,57,840,341,61,550,826,66,54,755,306,58,487,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-13',0.19),
 (120,0,0,11,35,23,0,0,1556,161,50,928,1009,102,925,1377,172,48,834,907,97,818,1027,87,67,1052,887,27,826,909,83,64,945,797,26,731,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-14',0.19),
 (121,0,0,0,19,33,0,34,389,78,20,1149,657,139,493,344,83,19,1033,590,133,436,1405,97,21,814,534,10,373,1243,104,20,731,480,10,330,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-15',0.19),
 (122,0,0,0,0,0,0,0,615,267,40,777,770,52,409,544,286,38,698,692,50,362,1825,110,86,956,885,83,706,1615,118,82,859,795,79,624,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-16',0.19),
 (123,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,793,221,38,1025,839,21,558,693,237,36,921,754,20,494,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-17',0.19),
 (124,1009,142,16,804,440,21,134,1813,115,138,1350,918,124,825,1604,123,132,1214,825,118,730,630,67,62,1078,562,20,676,557,72,59,969,505,20,598,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-20',0.19),
 (125,0,28,0,17,16,0,47,1245,61,56,856,818,74,536,1102,65,54,769,735,71,474,1616,84,99,1039,718,63,284,1430,90,95,934,645,60,251,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-21',0.19),
 (126,0,0,0,61,61,0,0,730,158,195,709,613,52,714,646,169,186,637,551,50,632,932,65,59,682,551,33,367,825,69,56,613,495,31,235,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-22',0.19),
 (127,0,0,0,16,0,0,17,754,177,88,903,611,77,700,667,190,84,812,549,74,619,2184,56,63,872,667,15,638,1933,60,60,801,613,15,564,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-23',0.19),
 (128,69,0,0,234,183,0,96,200,140,152,1052,951,53,640,177,150,145,966,874,50,566,0,69,11,549,514,0,324,0,74,10,504,472,0,287,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-24',0.19),
 (129,0,0,0,27,0,0,0,249,170,77,1071,753,81,419,220,182,74,984,692,77,371,0,267,94,1321,1014,36,336,0,286,90,1214,932,34,297,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-25',0.19),
 (130,0,0,26,21,22,10,0,1465,95,137,1021,694,116,720,1296,102,131,938,638,111,637,1010,80,10,653,504,87,440,694,86,10,600,463,83,389,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-26',0.19),
 (131,0,0,0,33,0,0,0,804,37,82,810,519,68,498,711,40,78,744,477,65,441,440,108,61,508,800,42,491,389,115,58,467,735,40,434,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-27',0.19),
 (132,226,19,0,52,11,0,0,1123,18,126,700,499,21,609,994,20,120,643,458,20,539,708,19,0,973,430,62,142,626,20,0,894,395,59,125,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-28',0.19),
 (133,0,0,0,22,22,0,0,900,73,105,826,638,23,340,814,80,102,747,577,22,307,1010,84,94,908,409,38,465,914,92,92,852,384,37,421,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-01',0.19),
 (134,0,0,21,201,96,0,72,1460,115,115,1109,844,99,580,1321,125,112,1041,792,96,525,438,95,20,655,753,37,357,400,104,19,621,714,36,326,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-02',0.19),
 (135,0,28,0,0,37,0,0,1041,153,90,870,539,30,568,952,167,88,825,511,30,520,33,301,263,1959,1492,88,925,30,330,250,1857,1415,85,845,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-03',0.19),
 (136,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,595,23,36,549,563,2,556,544,25,35,521,534,2,509,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-05',0.19),
 (137,0,0,0,15,21,0,11,851,227,245,768,796,20,900,778,248,239,728,755,20,824,867,98,5,767,302,5,309,793,107,5,728,286,5,283,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-06',0.19),
 (138,0,0,0,0,21,0,0,960,26,115,938,860,32,513,878,28,112,890,816,31,469,1348,156,30,680,470,41,438,1233,170,29,645,446,40,400,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-07',0.19),
 (139,0,3,30,280,121,0,85,1027,52,141,980,562,40,862,940,56,138,930,533,39,788,232,68,93,927,927,46,408,212,74,91,880,575,45,373,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-08',0.19),
 (140,109,0,0,52,32,5,54,1480,232,77,1000,808,38,436,1354,253,75,949,766,37,399,601,189,33,955,695,4,429,550,206,32,906,659,4,392,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-09',0.19),
 (141,110,0,45,33,0,0,0,1502,32,92,931,586,107,447,1374,35,90,883,556,104,409,573,46,21,1046,505,41,244,524,50,20,989,479,40,223,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-10',0.19),
 (142,11,0,0,100,37,0,55,421,96,142,1027,737,142,690,385,105,138,974,699,138,631,2135,282,57,640,531,8,347,1953,308,55,620,514,8,317,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-12',0.19),
 (143,164,0,0,21,10,0,0,1254,50,225,738,720,11,745,1147,55,219,715,697,10,681,357,51,72,810,622,0,583,326,55,70,785,603,0,533,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-13',0.19),
 (144,0,0,0,92,191,0,0,1576,122,104,830,495,31,409,1442,133,101,804,480,30,374,903,186,41,459,498,33,566,826,203,40,445,482,32,518,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-14',0.19),
 (145,0,0,0,0,31,0,0,1149,103,72,868,1001,71,833,1051,112,70,841,970,69,762,207,6,62,676,489,31,238,189,6,60,655,474,30,218,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-15',0.19),
 (146,0,0,0,0,0,0,0,1320,112,35,941,657,65,827,1195,122,34,912,636,63,748,914,83,0,744,756,43,397,827,90,0,721,732,42,359,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-16',0.19),
 (147,0,0,0,31,21,0,0,1083,27,70,662,524,75,353,980,30,68,641,508,73,319,0,196,102,653,603,4,276,0,214,100,632,584,4,250,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-17',0.19),
 (148,0,0,0,31,0,0,0,82,110,21,962,1096,65,564,75,120,20,932,1062,63,510,0,84,9,900,1080,0,755,0,92,9,872,1048,0,683,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-18',0.19),
 (149,0,0,0,0,0,0,0,1103,115,176,1072,585,67,601,998,125,172,1039,567,65,544,1166,34,30,701,533,57,240,1055,37,29,679,516,55,217,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-19',0.19),
 (150,582,43,51,214,323,16,248,1957,55,226,971,615,55,1054,1771,60,220,941,596,53,954,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-20',0.19),
 (151,221,49,62,379,165,4,340,464,168,41,642,590,9,687,420,183,40,622,572,9,622,442,26,34,496,402,0,256,400,28,33,480,389,0,231,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-21',0.19),
 (152,0,0,0,21,0,6,11,1446,20,101,607,599,83,831,1309,22,98,588,580,81,752,911,65,26,390,439,57,203,824,71,25,374,421,55,184,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-22',0.19),
 (153,220,9,0,0,43,0,99,612,240,172,1097,943,61,744,554,262,168,1052,904,59,673,133,91,66,629,565,49,301,120,99,65,603,542,48,272,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-23',0.19),
 (154,0,0,0,99,14,0,0,924,203,165,1156,623,90,868,836,221,161,1108,601,88,785,28,156,87,719,592,9,549,25,170,85,689,568,9,497,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-24',0.19),
 (155,22,30,0,670,458,99,209,1194,193,111,1186,865,47,562,1080,210,108,1137,829,46,508,1283,51,20,489,441,31,589,1161,55,20,469,423,30,533,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-26',0.19),
 (156,56,0,0,85,93,0,33,889,32,212,972,576,63,863,804,35,207,932,552,61,781,546,18,20,972,628,15,450,500,20,20,942,608,15,411,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-27',0.19),
 (157,0,0,0,8,21,0,0,1177,138,46,618,650,104,567,1077,150,45,599,630,101,519,1428,115,79,626,318,10,326,1306,125,77,606,308,10,298,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-28',0.19),
 (158,0,0,0,0,26,0,36,992,95,120,744,736,26,555,908,104,117,721,713,25,508,954,115,55,634,307,5,456,873,130,55,633,306,5,417,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-29',0.19),
 (159,0,0,4,75,124,0,55,795,47,107,698,743,39,932,727,53,107,698,743,39,853,749,88,20,578,748,62,355,685,99,20,578,748,62,325,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-30',0.19),
 (160,0,0,0,33,0,0,33,999,167,52,941,723,63,851,914,189,52,940,722,63,778,567,162,110,842,707,20,466,524,183,110,841,706,20,431,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-31',0.19),
 (161,214,104,0,440,371,63,193,1997,103,148,783,848,63,641,1107,116,149,782,847,63,593,605,17,75,730,627,22,301,559,19,75,729,626,22,278,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-02',0.19),
 (162,0,0,0,55,75,0,0,1732,167,203,858,926,10,937,1602,189,204,857,925,10,866,676,110,136,799,649,27,552,625,124,137,798,648,27,510,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-03',0.19),
 (163,0,0,0,63,30,0,87,806,182,166,793,662,77,545,745,206,166,792,661,77,504,378,133,22,739,694,48,469,350,150,22,738,693,48,434,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-04',0.19),
 (164,0,0,0,80,130,0,133,1237,186,88,868,823,109,729,1144,210,88,867,822,109,674,560,207,107,924,760,2,397,529,238,110,923,759,2,375,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-05',0.19),
 (165,21,0,0,101,71,10,0,349,17,42,1162,928,58,481,330,20,43,1161,927,59,454,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-06',0.19),
 (166,0,193,39,1297,726,49,287,125,362,140,1171,1174,26,334,118,417,143,1170,1173,26,315,106,181,35,757,947,16,440,100,208,36,756,946,16,416,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-07',0.19),
 (167,53,406,98,1788,1279,20,720,1884,180,185,894,675,33,933,1780,207,190,893,674,34,881,821,55,73,881,738,84,318,776,63,75,880,737,86,300,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-10',0.19),
 (168,0,0,0,33,20,0,0,1276,84,160,782,502,96,749,1206,97,164,781,501,98,708,496,0,78,520,527,0,198,469,0,80,519,526,0,187,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-11',0.19),
 (169,0,0,0,10,100,0,0,893,43,100,756,806,85,682,844,49,102,755,805,90,644,1090,105,68,933,553,22,337,1030,121,70,932,552,22,318,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-12',0.19),
 (170,0,54,0,243,160,0,65,245,82,47,658,547,147,610,231,94,48,668,555,151,576,167,97,63,663,814,34,375,158,112,64,673,826,35,354,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-13',0.19),
 (171,0,0,0,41,29,0,32,1762,189,104,1053,526,58,502,1665,218,107,1069,534,59,474,351,194,74,766,682,59,336,331,223,75,777,692,60,317,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-14',0.19),
 (172,0,18,0,54,108,24,32,0,165,141,820,891,44,647,0,190,145,832,904,45,611,126,70,78,967,651,13,492,119,80,80,982,661,13,465,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-16',0.19),
 (173,0,0,56,10,49,0,35,0,136,105,745,549,64,1098,0,156,107,756,557,65,1037,362,175,128,576,797,102,604,342,201,131,584,809,105,571,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-17',0.19),
 (174,0,0,0,30,29,0,32,1595,103,137,732,794,25,520,1507,119,140,743,806,26,491,584,43,19,726,383,59,188,552,50,20,737,389,61,177,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-18',0.19),
 (175,0,8,0,79,120,24,128,1210,100,20,631,768,42,535,1143,115,20,640,779,44,505,254,210,53,509,550,39,271,240,242,55,516,558,40,256,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-19',0.19),
 (176,0,0,9,34,19,0,35,379,78,194,746,813,90,576,358,90,201,757,825,93,544,1381,104,39,833,819,20,564,1305,120,40,845,831,21,533,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-20',0.19),
 (177,32,0,43,90,54,0,72,1590,170,96,716,548,43,591,1502,196,99,726,556,45,558,487,121,88,1017,723,32,630,460,139,91,1032,734,33,595,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-21',0.19),
 (178,0,0,0,20,0,0,0,60,226,64,1062,841,70,253,57,260,66,1078,853,72,239,0,174,196,897,799,39,470,0,200,203,910,811,40,444,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-22',0.19),
 (179,0,0,0,111,69,0,0,1041,101,53,813,662,35,460,984,116,55,825,672,36,435,1016,50,109,670,346,29,262,960,58,113,680,351,30,247,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-23',0.19),
 (180,0,0,0,61,61,0,16,830,49,196,864,920,80,883,784,56,203,877,934,83,834,914,152,124,766,543,24,377,854,175,128,777,551,25,356,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-24',0.19),
 (181,0,87,0,139,168,0,210,1604,78,105,750,515,51,784,1515,90,109,761,523,53,741,1314,68,0,494,525,47,335,1241,78,0,501,533,48,316,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-25',0.19),
 (182,0,0,0,39,39,0,11,1062,170,127,689,770,32,388,1003,196,131,699,781,33,366,370,86,48,1052,347,50,428,350,99,50,1067,352,52,404,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-26',0.19),
 (183,212,0,0,20,92,0,52,1374,34,85,849,621,28,861,1298,70,90,887,649,30,813,1019,256,75,578,715,86,443,963,305,80,604,747,91,418,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-27',0.19),
 (184,0,0,0,0,0,22,32,1741,82,63,995,1052,30,535,1645,98,67,1040,1099,32,505,37,88,45,497,433,62,292,35,105,48,519,452,66,276,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-28',0.19),
 (185,53,0,0,34,15,0,128,435,282,185,780,890,86,950,411,336,196,815,930,92,898,799,16,54,1166,850,87,760,755,19,57,1218,888,92,718,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-30',0.19),
 (186,0,213,0,451,477,12,50,724,25,111,834,758,47,528,684,30,118,872,792,50,499,1078,88,57,647,445,19,390,1019,105,60,676,465,20,368,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-02',0.19),
 (187,0,0,9,14,0,0,0,868,138,61,719,427,49,574,820,164,65,751,446,52,540,719,179,59,689,772,31,540,679,213,63,720,807,33,510,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-03',0.19),
 (188,0,0,0,30,0,0,58,466,52,149,1186,834,90,830,440,63,161,1263,888,97,784,2111,97,19,702,507,57,511,1995,117,20,748,540,62,483,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-04',0.19),
 (189,0,0,0,6,19,8,74,1572,154,169,749,722,51,554,1485,187,183,797,769,55,523,530,137,56,804,807,32,552,501,166,60,856,859,35,522,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-05',0.19),
 (190,0,8,0,144,101,0,21,0,8,56,862,800,31,334,0,10,60,918,852,34,315,0,101,42,1191,783,109,357,0,122,45,1268,834,118,337,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-06',0.19),
 (191,0,0,0,284,231,14,90,1141,66,51,663,669,23,552,1362,80,55,706,712,25,521,476,201,56,804,404,74,363,450,243,60,856,80,80,343,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-07',0.19),
 (192,0,0,0,29,83,0,0,575,16,192,941,697,102,895,543,20,208,1002,742,110,846,1048,62,46,485,493,38,717,990,75,50,516,525,41,677,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-08',0.19),
 (193,0,0,0,0,0,0,0,666,33,109,703,711,40,346,629,40,118,748,757,43,327,530,106,187,652,582,74,450,501,128,116,694,620,80,425,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-09',0.19),
 (194,0,0,0,28,0,0,18,848,76,37,558,614,40,740,801,92,40,594,654,43,699,956,80,186,754,520,29,440,903,97,201,803,554,31,416,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-10',0.19),
 (195,0,0,0,47,19,0,0,1538,47,101,684,675,14,490,1453,57,109,728,719,15,463,1547,134,39,1053,879,3,706,1462,162,42,1121,936,4,667,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-11',0.19),
 (196,0,33,10,71,24,0,53,866,116,153,978,783,76,529,818,140,165,1042,834,82,500,370,120,66,788,1095,48,454,350,145,71,839,1166,52,429,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-12',0.19),
 (197,22,8,0,216,174,0,85,771,25,166,873,901,89,714,728,30,180,930,959,96,675,834,74,56,761,511,28,440,788,90,61,810,544,30,416,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-14',0.19),
 (198,0,0,0,9,103,0,0,1148,157,160,968,659,160,748,1085,190,173,1031,702,173,707,978,120,74,617,489,45,726,924,145,80,657,521,49,686,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-15',0.19),
 (199,32,0,4,71,0,26,0,2280,200,162,699,627,107,655,2154,242,175,744,667,116,619,503,53,0,703,751,0,492,475,64,0,748,800,0,465,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-16',0.19),
 (200,0,0,0,0,0,0,104,984,124,34,783,718,64,799,930,150,37,834,765,69,755,1386,160,102,803,795,29,562,1310,194,110,855,846,32,531,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-17',0.19);
 
/*!40000 ALTER TABLE `kiniseis` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Insert record statement

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insert_form")) {
  $insertSQL = sprintf("INSERT INTO kiniseis (kinisis_1a, `100a`, super_1a, `95_1a`, `95_2a`, super_2a, kinisis_2a, kinisis_1b, `100b`, super_1b, `95_1b`, `95_2b`, super_2b, kinisis_2b, kinisis_1c, `100c`, super_1c, `95_1c`, `95_2c`, super_2c, kinisis_2c, kinisis_1d, `100d`, super_1d, `95_1d`, `95_2d`, super_2d, kinisis_2d, kinisis_1e, `100e`, super_1e, `95_1e`, `95_2e`, super_2e, kinisis_2e, kinisis_a, `100_a`, `95_a`, super_a, kinisis_b, `100_b`, `95_b`, super_b, `date`, fpa) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['1'], "double"),
                       GetSQLValueString($_POST['2'], "double"),
                       GetSQLValueString($_POST['3'], "double"),
                       GetSQLValueString($_POST['4'], "double"),
                       GetSQLValueString($_POST['5'], "double"),
                       GetSQLValueString($_POST['6'], "double"),
                       GetSQLValueString($_POST['7'], "double"),
                       GetSQLValueString($_POST['8'], "double"),
                       GetSQLValueString($_POST['9'], "double"),
                       GetSQLValueString($_POST['10'], "double"),
                       GetSQLValueString($_POST['11'], "double"),
                       GetSQLValueString($_POST['12'], "double"),
                       GetSQLValueString($_POST['13'], "double"),
                       GetSQLValueString($_POST['14'], "double"),
                       GetSQLValueString($_POST['15'], "double"),
                       GetSQLValueString($_POST['16'], "double"),
                       GetSQLValueString($_POST['17'], "double"),
                       GetSQLValueString($_POST['18'], "double"),
                       GetSQLValueString($_POST['19'], "double"),
                       GetSQLValueString($_POST['20'], "double"),
                       GetSQLValueString($_POST['21'], "double"),
                       GetSQLValueString($_POST['22'], "double"),
                       GetSQLValueString($_POST['23'], "double"),
                       GetSQLValueString($_POST['24'], "double"),
                       GetSQLValueString($_POST['25'], "double"),
                       GetSQLValueString($_POST['26'], "double"),
                       GetSQLValueString($_POST['27'], "double"),
                       GetSQLValueString($_POST['28'], "double"),
                       GetSQLValueString($_POST['29'], "double"),
                       GetSQLValueString($_POST['30'], "double"),
                       GetSQLValueString($_POST['31'], "double"),
                       GetSQLValueString($_POST['32'], "double"),
                       GetSQLValueString($_POST['33'], "double"),
                       GetSQLValueString($_POST['34'], "double"),
                       GetSQLValueString($_POST['35'], "double"),
                       GetSQLValueString($_POST['36'], "double"),
                       GetSQLValueString($_POST['37'], "double"),
                       GetSQLValueString($_POST['38'], "double"),
                       GetSQLValueString($_POST['39'], "double"),
                       GetSQLValueString($_POST['40'], "double"),
                       GetSQLValueString($_POST['41'], "double"),
                       GetSQLValueString($_POST['42'], "double"),
                       GetSQLValueString($_POST['43'], "double"),
                       GetSQLValueString($_POST['date'], "date"),
                       GetSQLValueString($_POST['select_fpa'], "double"));

If is there anything else you might need, tell me :slight_smile:

Thank you again :slight_smile:

8

I think i should try to put one more column in the database table that will contain the ( kinisis_1c / kinisis_1b ) * kinisis_1a result, so the sum not be simplified and not make roundings cause i think there is the problem.

What you think?

9

Ah that explains it.

10

extra column? no

why don’t you dump the table and give us the CREATE TABLE statement as well as a few INSERT statements so that we can try to reproduce the results and perhaps see what’s causing it or how to fix it

11

It didnt worked :frowning:

12

Thanks for your responce :slight_smile:

Basicly in the insert data page, all the the values to be inserted are integers,i changed the fields to INT(10) , (except date column,fpa column i changed it to double since its always 0.21) but still no change :frowning:

You think the problem is in the field types?

I show you the complete mysql code in case i have a mistake i don’t see there

SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)*1.005),SUM((100c + 100e + (100c / 100b)* 100a) * (1-fpa)*1.005),SUM((super_1c  + super_1e + (super_1c / super_1b)* super_1a) * (1-fpa)*1.005),SUM((95_1c + 95_1e + (95_1c / 95_1b)* 95_1a) * (1-fpa)*1.005),SUM((95_2c + 95_2e + (95_2c / 95_2b)*  95_2a) * (1-fpa)*1.005),SUM((super_2c + super_2e + (super_2c / super_2b)* super_2a) * (1-fpa)*1.005),SUM((kinisis_2c + kinisis_2e + (kinisis_2c / kinisis_2b)*  kinisis_2a) * (1-fpa)*1.005)
FROM kiniseis
WHERE `date` BETWEEN '$_GET[date1]' AND '$_GET[date2]'
13

perhaps you can try ( kinisis_1c * 1.000 / kinisis_1b ) instead

:slight_smile:

14

since the numbers themselves are DECIMAL(11,0), it’s not surprising that a calculation involving them would also not have any decimal places

perhaps you can try ( kinisis_1c * 1.000 / kinisis_1b ) instead