thank you for help.
this is new version of table `page1-1`.
I've update in column `F_SUM` with sum of colums values `F1`, `F2` and `F3`.
But I can not calculate the average dynamic... because in the column `AVERAGE_12_MONTHS` is a line feed, e.g.:
[*]In the record number 12 I've the average of records 1,2,3,4,5,6,7,8,9,10,11 and 12
[*]In the record number 13 I've the average of records 2,3,4,5,6,7,8,9,10,11,12 and 13
[*]In the record number 14 I've the average of records 3,4,5,6,7,8,9,10,11,12,13 and 14
[*].....
-- ----------------------------
-- Table structure for `page1-1`
-- ----------------------------
DROP TABLE IF EXISTS `page1-1`;
CREATE TABLE `page1-1` (
`YEARS` int(11) DEFAULT NULL,
`MONTHS` int(11) DEFAULT NULL,
`F1` decimal(10,4) DEFAULT NULL,
`F2` decimal(10,4) DEFAULT NULL,
`F3` decimal(10,4) DEFAULT NULL,
`F_SUM` varchar(255) DEFAULT NULL,
`AVERAGE_12_MONTHS` varchar(255) DEFAULT NULL,
`VAR` varchar(255) DEFAULT NULL,
`ID` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of page1-1
-- ----------------------------
INSERT INTO `page1-1` VALUES ('2009', '5', '92626.4000', '32796.5600', '59924.6400', '185347.6000', '', '', '1');
INSERT INTO `page1-1` VALUES ('2009', '6', '95008.6400', '31933.6000', '56977.8400', '183920.0800', '', '', '2');
INSERT INTO `page1-1` VALUES ('2009', '7', '111853.1200', '33091.9200', '53262.4000', '198207.4400', '', '', '3');
INSERT INTO `page1-1` VALUES ('2009', '8', '108379.9200', '32500.4800', '60452.6400', '201333.0400', '', '', '4');
INSERT INTO `page1-1` VALUES ('2009', '9', '102605.4400', '34639.3600', '58108.4000', '195353.2000', '', '', '5');
INSERT INTO `page1-1` VALUES ('2009', '10', '83442.5600', '31952.4000', '52181.6000', '167576.5600', '', '', '6');
INSERT INTO `page1-1` VALUES ('2009', '11', '55527.8400', '24864.0000', '47962.8000', '128354.6400', '', '', '7');
INSERT INTO `page1-1` VALUES ('2009', '12', '45067.2800', '21627.2800', '50793.6000', '117488.1600', '', '', '8');
INSERT INTO `page1-1` VALUES ('2010', '1', '50108.6386', '32070.3592', '88992.3954', '171171.3932', '', '', '9');
INSERT INTO `page1-1` VALUES ('2010', '2', '45229.0026', '32119.9970', '57848.0026', '135197.0022', '', '', '10');
INSERT INTO `page1-1` VALUES ('2010', '3', '51329.9947', '34104.9989', '64472.8217', '149907.8153', '', '', '11');
INSERT INTO `page1-1` VALUES ('2010', '4', '47097.9986', '38268.0023', '77124.0064', '162490.0073', '', '', '12');
INSERT INTO `page1-1` VALUES ('2010', '5', '43667.0032', '31968.9999', '108472.0064', '184108.0095', '', '', '13');
INSERT INTO `page1-1` VALUES ('2010', '6', '55458.9969', '32521.0012', '103608.0000', '191587.9981', '', '', '14');
INSERT INTO `page1-1` VALUES ('2010', '7', '99716.0032', '33510.9958', '74126.9942', '207353.9932', '', '', '15');
INSERT INTO `page1-1` VALUES ('2010', '8', '101051.9955', '31377.0024', '67117.9971', '199546.9950', '', '', '16');
INSERT INTO `page1-1` VALUES ('2010', '9', '72834.0026', '35291.0002', '81023.0042', '189148.0070', '', '', '17');
INSERT INTO `page1-1` VALUES ('2010', '10', '42791.0036', '44317.0016', '87538.9998', '174647.0050', '', '', '18');
INSERT INTO `page1-1` VALUES ('2010', '11', '41505.9969', '32237.0001', '66770.9952', '140513.9922', '', '', '19');
INSERT INTO `page1-1` VALUES ('2010', '12', '38599.0050', '27211.9987', '61212.9974', '127024.0011', '', '', '20');
INSERT INTO `page1-1` VALUES ('2011', '1', '55458.9976', '28852.9989', '60279.0048', '144591.0013', '', '', '21');
INSERT INTO `page1-1` VALUES ('2011', '2', '46786.0049', '29952.0022', '58459.0003', '135197.0074', '', '', '22');
INSERT INTO `page1-1` VALUES ('2011', '3', '52550.0057', '32447.0006', '64910.7606', '149907.7669', '', '', '23');
INSERT INTO `page1-1` VALUES ('2011', '4', '39288.9992', '41818.0032', '81383.0011', '162490.0035', '', '', '24');
INSERT INTO `page1-1` VALUES ('2011', '5', '84902.9996', '32890.0020', '66315.9978', '184108.9994', '', '', '25');
INSERT INTO `page1-1` VALUES ('2011', '6', '94883.7325', '35711.4508', '60993.8301', '191589.0134', '', '', '26');
INSERT INTO `page1-1` VALUES ('2011', '7', '113265.9990', '38767.0016', '55319.9899', '207352.9905', '', '', '27');
INSERT INTO `page1-1` VALUES ('2011', '8', '122653.8295', '28179.2513', '48713.9252', '199547.0060', '', '', '28');
INSERT INTO `page1-1` VALUES ('2011', '9', '118939.0022', '25380.0064', '44827.9981', '189147.0067', '', '', '29');
INSERT INTO `page1-1` VALUES ('2011', '10', '72671.0032', '35154.0034', '66821.9968', '174647.0034', '', '', '30');
INSERT INTO `page1-1` VALUES ('2011', '11', '52688.0399', '29032.0638', '58792.8915', '140512.9952', '', '', '31');
INSERT INTO `page1-1` VALUES ('2011', '12', '50778.1824', '24184.4189', '52061.3935', '127023.9948', '', '', '32');
INSERT INTO `page1-1` VALUES ('2012', '1', '67452.0000', '27755.9989', '49381.9981', '144589.9970', '', '', '33');
INSERT INTO `page1-1` VALUES ('2012', '2', '65157.0003', '25064.9984', '44974.9978', '135196.9965', '', '', '34');
INSERT INTO `page1-1` VALUES ('2012', '3', '51895.9998', '35507.9970', '62303.6625', '149707.6593', '', '', '35');
INSERT INTO `page1-1` VALUES ('2012', '4', '59680.0026', '34401.9968', '68407.0042', '162489.0036', '', '', '36');
INSERT INTO `page1-1` VALUES ('2012', '5', '76293.0024', '36553.0013', '71262.9987', '184109.0024', '', '', '37');
INSERT INTO `page1-1` VALUES ('2012', '6', '91630.0031', '36862.0028', '63096.9939', '191588.9998', '', '', '38');
INSERT INTO `page1-1` VALUES ('2012', '7', '121355.0076', '35470.9997', '50525.9990', '207352.0063', '', '', '39');
INSERT INTO `page1-1` VALUES ('2012', '8', '104053.9946', '38849.0009', '56643.0022', '199545.9977', '', '', '40');
INSERT INTO `page1-1` VALUES ('2012', '9', '87243.9999', '38957.9976', '62945.9968', '189147.9943', '', '', '41');
INSERT INTO `page1-1` VALUES ('2012', '10', '75514.0044', '35562.0016', '63570.9984', '174647.0044', '', '', '42');
INSERT INTO `page1-1` VALUES ('2012', '11', '47608.0004', '30661.0043', '62245.0048', '140514.0095', '', '', '43');
INSERT INTO `page1-1` VALUES ('2012', '12', '13527.2000', '10924.0403', '26763.0404', '51214.2807', '', '', '44');
INSERT INTO `page1-1` VALUES ('2013', '1', '15955.4400', '9888.8000', '18707.3600', '44551.6000', '', '', '45');
INSERT INTO `page1-1` VALUES ('2013', '2', '14813.7600', '9452.2400', '17036.0800', '41302.0800', '', '', '46');
INSERT INTO `page1-1` VALUES ('2013', '3', '13567.9200', '9950.6400', '18263.4400', '41782.0000', '', '', '47');
INSERT INTO `page1-1` VALUES ('2013', '4', '12965.6000', '8086.0000', '17543.6000', '38595.2000', '', '', '48');
INSERT INTO `page1-1` VALUES ('2013', '5', '12363.7600', '8034.6400', '16605.0400', '37003.4400', '', '', '49');
INSERT INTO `page1-1` VALUES ('2013', '6', '15822.8800', '8388.8800', '16211.9200', '40423.6800', '', '', '50');
INSERT INTO `page1-1` VALUES ('2013', '7', '21269.0400', '9082.4000', '16352.4800', '46703.9200', '', '', '51');
INSERT INTO `page1-1` VALUES ('2013', '8', '18727.4400', '10274.1600', '18108.9600', '47110.5600', '', '', '52');
INSERT INTO `page1-1` VALUES ('2013', '9', '16470.5600', '8159.7600', '16271.9200', '40902.2400', '', '', '53');