Spreadsheet: 274428d1383119010-how-to-sum-value-base-on-different-dates-example
Sheet: 2

PROCUREMENT CHART DATA
Info. |  | Time in Months
Tanajib Accommodation & Maintenance+Workshop Building |  | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00
 | Planned Periodic
 | Actual Periodic
 | Planned Cumulative
 | Actual Cumulative
PROCUREMENT PROGRESS CALCULATION-MONTHLY
Info. |  | 2013-08-01 00:00:00 |  | 2013-09-01 00:00:00 |  | 2013-10-01 00:00:00 |  | 2013-11-01 00:00:00 |  | 2013-12-01 00:00:00 |  | 2014-01-01 00:00:00 |  | 2014-02-01 00:00:00 |  | 2014-03-01 00:00:00 |  | 2014-04-01 00:00:00 |  | 2014-05-01 00:00:00 |  | 2014-06-01 00:00:00 |  | 2014-07-01 00:00:00 |  | 2014-08-01 00:00:00 |  | 2014-09-01 00:00:00 |  | 2014-10-01 00:00:00 |  | 2014-11-01 00:00:00 |  | 2014-12-01 00:00:00 |  | 2015-01-01 00:00:00 |  | 2015-02-01 00:00:00 |  | 2015-03-01 00:00:00 |  | 2015-04-01 00:00:00
 |  | Wt. per Month | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt. | Nos. | Total Wt.
Tanajib Accommodation & Maintenance+Workshop Building | No. of RFQ | 5.5889 |  | 4.3417 |  | 5.1589 |  | 4.8471 |  | 3.5855 |  | 27.7344 |  | 21.9265 |  | 23.739 |  | 3.4772 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of T/C Evaluation | 2.6457 |  | 5.8535 |  | 4.6061 |  | 4.3653 |  | 2.466 |  | 11.9192 |  | 22.0198 |  | 26 |  | 20.456 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of PO | 0 |  | 5.0267 |  | 3.4725 |  | 4.6061 |  | 4.3653 |  | 2.466 |  | 8.3475 |  | 25.533 |  | 23.6868 |  | 20.456 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of NM-1 | 0 |  | 0 |  | 5.8205 |  | 3.77 |  | 4.3085 |  | 5.6975 |  | 1.8708 |  | 19.7832 |  | 28.0209 |  | 25.9925 |  | 5.1353 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of NM-2 | 0 |  | 0 |  | 5.0267 |  | 4.0016 |  | 4.6061 |  | 4.1669 |  | 1.8707 |  | 13.4338 |  | 28.177 |  | 31.5622 |  | 7.2896 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of DLV | 0 |  | 0 |  | 0 |  | 2.9102 |  | 2.9103 |  | 3.1747 |  | 2.2818 |  | 5.003 |  | 1.5306 |  | 13.0391 |  | 37.8403 |  | 31.7092 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of MNL | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.5292 |  | 5.2913 |  | 5.1589 |  | 4.5069 |  | 2.3243 |  | 2.2449 |  | 10.7942 |  | 69.5495 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | % Progress