Spreadsheet: 274481d1383132266-how-to-sum-value-base-on-different-dates-original-sheet
Sheet: Procurement Material List (Rev)

 | PROJECT: | CONSTRUCTION OF TANAJIB ACCOMMODATION AND [NAME]
 | CONTRACT NO: | 6600031328
 | DOCUMENT: | MATERIALS' PO LIST
[NAME]. | List of Materials | Wt./MR (%) | RFQ/PR Issued (10%) | T/C Evaluation (15%) | Issue of PO (15%) | NMR-1 (10%) | NMR-2 (10%) | Dlv. Lead Time (Days) | Delivery at Site (30%) | ALL NMR's (10%)
 |  |  | 21 | 30 | 14 | 7 |  |  |  | 50
MR-001 | Miscellaneous Steel Structures | 2.380952380952
DPO-001 | [NAME] |  |  |  |  |  |  | 84 | 2014-07-01 00:00:00
DPO-002 | Railing for Balcony |  |  |  |  |  |  | 84 | 2014-07-01 00:00:00
DPO-038 | Structural Steel for Parking |  |  |  | 2014-02-20 00:00:00 |  |  | 112
DPO-039 | Roof Access ladder |  |  |  |  |  |  | 112 | 2014-07-01 00:00:00
DPO-041 | Shaded net for parking |  |  |  | 2014-02-20 00:00:00 |  |  | 112
DPO-040 | Steel Grating for trenches |  |  |  |  |  |  | 112 | 2014-07-01 00:00:00
[NAME] | Sanitary Manhole & Angles |  |  |  |  |  |  | 84 | 2014-03-03 00:00:00
MR-002 | Fence | 2.380952380952
DPO-003 | Chainlink PVC Fence with Gates |  |  |  | 2014-03-18 00:00:00 |  |  | 70
DPO-004 | Fence with Gates |  |  |  | 2014-03-18 00:00:00 |  |  | 70
MR-003 | Doors & Windows | 2.380952380952
DPO-005 | [NAME] |  |  |  | 2014-03-01 00:00:00 |  |  | 70
DPO-006 | Hollow Metal frames & Doors |  |  |  | 2014-03-01 00:00:00 |  |  | 70
DPO-007 | Door Hardware |  |  |  | 2014-03-01 00:00:00 |  |  | 70
DPO-008 | Windows |  |  |  | 2014-03-01 00:00:00 |  |  | 70
MR-004 | Furniture | 2.380952380952
DPO-015 | Furniture |  |  |  | 2014-02-25 00:00:00 |  |  | 56
MR-005 | Ceilings & Wall Panels | 2.380952380952
DPO-021 | Gypboard Wall Panel |  |  |  | 2014-03-31 00:00:00 |  |  | 56
DPO-022 | Acoustic Ceiling |  |  |  | 2014-03-31 00:00:00 |  |  | 56
DPO-023 | [NAME] |  |  |  | 2014-03-31 00:00:00 |  |  | 56
DPO-024 | Cubicle Partition |  |  |  | 2014-03-31 00:00:00 |  |  | 56
DPO-025 | Wood cladding |  |  |  | 2014-03-31 00:00:00 |  |  | 56
DPO-026 | Aluminum Ceiling |  |  |  | 2014-03-31 00:00:00 |  |  | 56
MR-006 | [NAME] | 2.380952380952
DPO-027 | Paint |  |  |  | 2014-04-25 00:00:00 |  |  | 42
DPO-028 | Epoxy Paint |  |  |  | 2014-04-25 00:00:00 |  |  | 42
DPO-029 | Acid resistance painting |  |  |  | 2014-04-25 00:00:00 |  |  | 42
DPO-031 | [NAME] |  |  |  | 2014-04-25 00:00:00 |  |  | 42
DPO-030 | Carpet |  |  |  | 2014-04-25 00:00:00 |  |  | 42
DPO-142 | Fire Retardant Paint |  |  |  | 2014-04-25 00:00:00 |  |  | 42
DPO-011 | Ceramic Tiles |  |  |  | 2014-04-25 00:00:00 |  |  | 28
MR-007 | Precast Concrete Building,Car Parking shade and miscellaneous | 2.380952380952
DPO-034 | Precast Wall Panel |  |  |  |  |  |  | 98 | 2014-02-15 00:00:00
DPO-035 | Hollow Core Slab |  |  |  |  |  |  | 98 | 2014-03-11 00:00:00
DPO-012 | Concrete wheel stop |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
DPO-036 | Hollow Core for Parking Shed |  |  |  |  |  |  | 98 | 2014-07-05 00:00:00
DPO-143 | Concrete trash bins |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
DPO-144 | Concrete Benches |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
DPO-145 | Concrete gutter |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
DPO-146 | Concrete splash blocks |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
MR-008 | Pre-Engineered Structure | 2.380952380952
DPO-037 | Structural Steel |  |  |  |  |  |  | 112 | 2014-03-10 00:00:00
DPO-032 | Sandwich Wall Panel with Accessories |  |  |  |  |  |  | 112 | 2014-03-10 00:00:00
DPO-033 | Sandwich Roof Panel with Accessories |  |  |  |  |  |  | 112 | 2014-03-10 00:00:00
MR-009 | Irrigation & Landscaping | 2.380952380952
DPO-141 | Irrigation System |  |  |  | 2014-04-06 00:00:00 |  |  | 70
DPO-045 | Landscaping |  |  |  | 2014-04-06 00:00:00 |  |  | 70
MR-010 | Cranes | 2.380952380952
DPO-046 | Overhead Crane |  |  |  | 2013-12-24 00:00:00 |  |  | 154
DPO-047 | Jib Cranes |  |  |  | 2013-12-24 00:00:00 |  |  | 154
[NAME] | Chain hoists |  |  |  | 2013-12-24 00:00:00 |  |  | 154
MR-011 | Tools & Equipments-A | 2.380952380952
DPO-049 | [NAME] station Air Plasma Cutting Torch |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-050 | Arbor Press & Drill Press |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-051 | [NAME] |  |  |  |  |  |  | 32 | 2014-06-28 00:00:00
MR-012 | Tools & Equipments-B | 2.380952380952
DPO-052 | Pneumatic Hydrotest System |  |  |  |  |  |  | 32 | 2014-06-28 00:00:00
DPO-068 | Threading Machine |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-069 | Pneumatic Gas Booster |  |  |  |  |  |  | 42 | 2014-06-28 00:00:00
DPO-060 | Circular Lapping Machine |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
DPO-055 | Pedestal Grinder & Surface grinder |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-056 | Bevelling Machine |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-057 | Travel Cutter |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-058 | Center Lathe Machine |  |  |  |  |  |  | 112 | 2014-06-28 00:00:00
[NAME] | Tools & Equipments-C | 2.380952380952
DPO-048 | Fork Lift and Lifters |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
DPO-053 | Battery Load Tester & Signal Generator |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-067 | Sheet guillotine |  |  |  |  |  |  | 42 | 2014-06-28 00:00:00
DPO-070 | Poly Cylinder Hand Truck |  |  |  |  |  |  | 14 | 2014-06-28 00:00:00
DPO-154 | Band Saw |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
[NAME] | [NAME] |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
MR-014 | Tools & Equipments-D | 2.380952380952
DPO-074 | Generator Set |  |  |  |  |  |  | 98 | 2014-06-28 00:00:00
DPO-054 | Bearing Heater & Electrode Heater |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
MR-015 | Tools & Equipments-E | 2.380952380952
DPO-061 | Puller set & Hydraulic Ram |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
DPO-062 | Hysdralic valve test unit |  |  |  |  |  |  | 32 | 2014-06-28 00:00:00
DPO-063 | Relief Valve Test Bench |  |  |  |  |  |  | 84 | 2014-06-28 00:00:00
DPO-059 | Universal Milling Machine |  |  |  |  |  |  | 112 | 2014-06-28 00:00:00
DPO-064 | [NAME] tight machine |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
DPO-066 | Saw blade welder & Thermoplastic Welding Machine |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
MR-016 | Tools & Equipments-F | 2.381
DPO-065 | Sand Blasting Machine |  |  |  |  |  |  | 84 | 2014-06-28 00:00:00
DPO-071 | Dust Extraction Sytstem |  |  |  |  |  |  | 154 | 2014-06-28 00:00:00
DPO-073 | Air Compressor System |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
DPO-153 | Paint Spray System |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
MR-017 | Dry Type Transformer | 2.380952380952
DPO-075 | Dry Type Transformer |  |  |  | 2014-03-15 00:00:00 |  |  | 84
MR-018 | Oil type Transformers | 2.380952380952
DPO-076 | Oil type Transformers |  |  |  | 2014-03-15 00:00:00 |  |  | 52
MR-019 | Distribution Panel Board, Power Panel Boards,Lighting Control Panel,Switch boards & Motor Control center | 2.380952380952
DPO-077 | Distribution Panel Boards |  |  |  | 2014-04-01 00:00:00 |  |  | 56
DPO-081 | Power Panel Board |  |  |  | 2014-04-01 00:00:00 |  |  | 56
DPO-082 | Lighting Panel |  |  |  | 2014-04-01 00:00:00 |  |  | 56
DPO-083 | Lighting Control Panel |  |  |  | 2014-04-01 00:00:00 |  |  | 56
DPO-148 | Motor Control center |  |  |  | 2014-04-01 00:00:00 |  |  | 56
DPO-149 | [NAME] |  |  |  | 2014-04-01 00:00:00 |  |  | 56
MR-020 | Lighting System | 2.380952380952
DPO-084 | Lighting Poles & Lighting Fixtures |  |  |  | 2014-04-20 00:00:00 |  |  | 56
MR-021 | Fire Alarm System | 2.380952380952
[NAME] | Fire Alarm Panel |  |  |  |  |  |  | 56 | 2014-07-02 00:00:00
DPO-090 | Fire Detection System |  |  |  |  |  |  | 56 | 2014-06-15 00:00:00
MR-022 | Telecommunication System | 2.380952380952
DPO-092 | Communication Equipments |  |  |  |  |  |  | 28 | 2014-07-12 00:00:00
DPO-091 | Communication Cable |  |  |  |  |  |  | 28 | 2014-07-10 00:00:00
DPO-093 | Communication - Cable tray |  |  |  |  |  |  | 28 | 2014-07-10 00:00:00
MR-023 | Split & Other AC Units | 2.380952380952
[NAME] | AC units for Telecom Rooms |  |  |  | 2014-05-02 00:00:00 |  |  | 42
MR-024 | HVAC & Its Components | 2.380952380952
[NAME] | Exhaust Fans |  |  |  |  |  |  | 42 | 2014-07-10 00:00:00
DPO-098 | AHU |  |  |  | 2014-02-11 00:00:00 |  |  | 126
DPO-099 | FCU |  |  |  | 2014-03-13 00:00:00 |  |  | 84
DPO-100 | FAHU |  |  |  |  |  |  | 126 | 2014-07-10 00:00:00
DPO-101 | HVAC Duct Works |  |  |  |  |  |  | 70 | 2014-06-12 00:00:00
DPO-102 | Volume Dampers |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
DPO-103 | VAV |  |  |  |  |  |  | 42 | 2014-07-10 00:00:00
DPO-104 | Sand Trap Louvers |  |  |  | 2014-05-15 00:00:00 |  |  | 28
DPO-105 | Fire Dampers |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
DPO-106 | Bleed Fans |  |  |  |  |  |  | 42 | 2014-07-02 00:00:00
DPO-107 | Air Seperators |  |  |  |  |  |  | 21 | 2014-07-10 00:00:00
DPO-108 | Inertial Sand Filters |  |  |  |  |  |  | 32 | 2014-07-10 00:00:00
DPO-109 | Sound Attenuators |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
DPO-110 | Smoke Dampers |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
MR-025 | Chilled Water System | 2.380952380952
DPO-111 | Chillers |  |  |  | 2014-03-13 00:00:00 |  |  | 91
DPO-112 | Chilled Water Pumps |  |  |  | 2014-03-20 00:00:00 |  |  | 84
DPO-113 | Chilled Water Pipe |  |  |  |  |  |  | 42 | 2014-07-12 00:00:00
DPO-114 | Expansion Tank |  |  |  | 2014-04-13 00:00:00 |  |  | 42
MR-026 | Drinking Water System | 2.380952380952
DPO-115 | Drinking Water - PVC Pipe |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
DPO-116 | Cold Water  - CPVC Pipe |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
DPO-117 | Hot Water - CPVC Pipe |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
DPO-150 | [NAME] or Tap |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
MR-027 | Raw Water System | 2.380952380952
DPO-123 | Plumbing Valves |  |  |  |  |  |  | 56 | 2014-07-06 00:00:00
DPO-120 | UPVC Pipes - Site Networks |  |  |  |  |  |  | 32 | 2014-04-03 00:00:00
MR-028 | Sewage & Vent Systems | 2.380952380952
DPO-122 | Cleanouts, Drains, Ventcowl |  |  |  |  |  |  | 56 | 2014-07-09 00:00:00
DPO-121 | Compressed Air piping |  |  |  |  |  |  | 42 | 2014-07-09 00:00:00
[NAME] | Sewer water - PVC Pipe |  |  |  |  |  |  | 32 | 2014-07-09 00:00:00
MR-029 | Oily Water Systems | 2.380952380952
DPO-094 | Chemical Dosing Tank |  |  |  | 2013-12-05 00:00:00 |  |  | 42
DPO-125 | Submersible Pumps |  |  |  |  |  |  | 91 | 2014-03-14 00:00:00
DPO-119 | Oily Water RTR Pipe |  |  |  |  |  |  | 56 | 2014-01-22 00:00:00
MR-030 | Plumbing Fixtures & Accessories | 2.380952380952
DPO-140 | Toilet Cabinets |  |  |  |  |  |  | 70 | 2014-05-30 00:00:00
[NAME] | Sanitary Fixtures & Accessories |  |  |  |  |  |  | 70 | 2014-05-30 00:00:00
MR-031 | Fire Protection System | 2.380952380952
DPO-128 | [NAME] |  |  |  |  |  |  | 70 | 2014-07-12 00:00:00
DPO-130 | Sprinklers |  |  |  |  |  |  | 56 | 2014-07-12 00:00:00
DPO-131 | Firefighting Valves |  |  |  |  |  |  | 56 | 2014-07-03 00:00:00
DPO-132 | [NAME] |  |  |  |  |  |  | 91 | 2014-05-05 00:00:00
DPO-133 | [NAME] |  |  |  |  |  |  | 42 | 2014-07-12 00:00:00
DPO-095 | Carbon Steel pipe |  |  |  |  |  |  | 56 | 2014-07-02 00:00:00
DPO-129 | Underground RTR pipe |  |  |  |  |  |  | 56 | 2014-04-05 00:00:00
MR-032 | MV/LV Cables | 2.380952380952
[NAME] | Cables for relocation |  | 2013-08-19 00:00:00 | 2013-09-09 00:00:00 | 2013-09-29 00:00:00 | 2013-10-07 00:00:00 | 2013-10-12 00:00:00 | 30 | 2013-11-30 00:00:00 | 2014-02-09 00:00:00
MR-033 | Grounding System | 2.380952380952
[NAME] | Grounding cable |  |  |  | 2014-04-15 00:00:00 |  |  | 42
DPO-151 | Grounding Rods |  |  |  | 2014-04-15 00:00:00 |  |  | 42
MR-034 | Safety Package | 2.380952380952
DPO-139 | First Aid Kit |  |  |  |  |  |  | 25 | 2014-02-04 00:00:00
DPO-072 | Emergency Eye shower and [NAME] |  |  |  |  |  |  | 84 | 2014-07-03 00:00:00
MR-035 | Markings & Signage | 2.380952380952
DPO-136 | Building Signs & Markings |  |  |  |  |  |  | 25 | 2014-01-12 00:00:00
DPO-137 | Road Signs & Markings |  |  |  |  |  |  | 25 | 2014-01-12 00:00:00
MR-036 | Concrete & Asphalt | 2.380952380952
DPO-139 | [NAME] |  |  |  |  |  |  | 28 | 2014-03-01 00:00:00
DPO-042 | Asphalt Paving |  |  |  |  |  |  | 28 | 2014-07-03 00:00:00
MR-037 | Lightning Protection System | 2.380952380952
DPO-135 | Lightning Protection System |  |  |  |  |  |  | 84 | 2014-07-03 00:00:00
MR-038 | CCTV/CATV System | 2.380952380952
DPO-138 | CCTV/CATV System |  |  |  |  |  |  | 84 | 2014-07-03 00:00:00
MR-039 | Electrical Appliances & Accessories | 2.380952380952
DPO-134 | Kitchen Appliances & Accessories |  |  |  |  |  |  | 56 | 2014-06-30 00:00:00
DPO-126 | Water Heaters |  |  |  |  |  |  | 84 | 2014-06-30 00:00:00
MR-040 | Reinforcement | 2.380952380952
DPO-019 | Rebars |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
DPO-020 | Rebars - Epoxy Coated |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
[NAME] | Welded Wire Fabric( FBE COATED & GALVANIZED) |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
Bulk Items
MR-041 | Civil/Architectural Bulk Items | 2.380952380952
[NAME] | Bituminous Coating |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
DPO-017 | Water Stop |  |  |  |  |  |  | 56 | 2013-12-29 00:00:00
DPO-018 | Roof Water Proofing System |  |  |  |  |  |  | 56 | 2014-05-26 00:00:00
DPO-043 | Backfill Material |  |  |  |  |  |  | 28 | 2013-11-28 00:00:00
DPO-044 | Anti-Termite Treatment |  |  |  |  |  |  | 28 | 2013-11-30 00:00:00
DPO-009 | CMU Block |  |  |  |  |  |  | 28 | 2014-05-23 00:00:00
[NAME] | Block & Plaster Accessories |  |  |  |  |  |  | 28 | 2014-05-23 00:00:00
[NAME] | Paver for side walk |  |  |  |  |  |  | 28 | 2014-07-12 00:00:00
DPO-014 | Interlocking Tiles for Coutyard |  |  |  |  |  |  | 28 | 2014-07-12 00:00:00
MR-042 | Electrical Bulk Items | 2.380952380952
DPO-085 | Wires |  |  |  |  |  |  | 21 | 2014-05-08 00:00:00
DPO-086 | Conduits & Fittings |  |  |  |  |  |  | 21 | 2014-05-08 00:00:00
DPO-087 | Boxes & Fittings |  |  |  |  |  |  | 21 | 2014-05-08 00:00:00
DPO-088 | Switches & Receptacles |  |  |  |  |  |  | 56 | 2014-05-19 00:00:00
[NAME] | Cables |  |  |  |  |  |  | 42 | 2014-05-08 00:00:00
 |  |  |  |  |  |  | 2.380952380952381