Spreadsheet: 274481d1383132266-how-to-sum-value-base-on-different-dates-original-sheet
Sheet: Progress Calculation

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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Finish
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-08-01 00:00:00
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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of T/C Evaluation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of PO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of NM-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of NM-2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of DLV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | No. of MNL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | % Progress
 |  | SUM
 |  |  |  |  |  |  |  | PROJECT: |  |  |  |  |  |  |  | CONSTRUCTION OF TANAJIB ACCOMMODATION AND [NAME]
 |  |  |  |  |  |  |  | CONTRACT NO: |  |  |  |  |  |  |  | 6600031328
 |  |  |  |  |  |  |  | DOCUMENT: |  |  |  |  |  |  |  | PROCUREMENT PROGRESS CALCULATION