UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P8';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P9';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P10';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P11';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P15';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P16';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P17';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P22';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P23';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P28';
UPDATE lattice SET lattice_Z=lattice_Z-54.3 WHERE software_information_id=3 and lattice_num='P29';