1. Upload .CSV to server.
Input data must be in the format below. Note the 'eof' (end-of-file) marker, this must be present in the last +1 row, in the first column.
Key:A is oocyte name/number, B is x coordinate, C is y coordinate, D is z coordinate & E is the radius size. Note the eof marker in column A. This must be present.



2. Process uploaded .CSV datafile into database.
After the data file is uploaded to the server, run the parser to transfer a copy of the data to the database server.



3. Calculate results.
Run the Calculation program using the database built in step 2, then log into the database to retreive your results.

The logic applied is:

function pyg_2_points_3d($p1_x, $p1_y, $p1_z, $p2_x, $p2_y, $p2_z){
   $distance = sqrt( (($p1_x - $p2_x)*($p1_x - $p2_x)) + (($p1_y - $p2_y)*($p1_y - $p2_y)) + (($p1_z - $p2_z)*($p1_z - $p2_z)) );
   return $distance;
}

...&

function pyg_2_points_3d_minus_radius($p1_x, $p1_y, $p1_z, $p2_x, $p2_y, $p2_z, $p1_r, $p2_r){
   $distance = sqrt( (($p1_x - $p2_x)*($p1_x - $p2_x)) + (($p1_y - $p2_y)*($p1_y - $p2_y)) + (($p1_z - $p2_z)*($p1_z - $p2_z)) ) - ($p1_r + $p2_r);
   return $distance;
}