Spreadsheet: 143037d1330139613-error-handling-in-excel-iserror
Sheet: MAH

 |  |  | ITEM | Average TAT for Site breakdown (from site location to !dea W/H) | Average TAT for Site [NAME] side (from site location to !dea W/H) | Average TAT for Handover to vendor (from idea W/H to vendor location) | Average TAT for repair/relacement(despatch from vendor loction to idea W/H) | Average TAT for Repaired material despatch | STATE | Item Code | Description | UOM | Capex/Opex | Aging | QTY | Value | Material Type | Logic | Month |  |  |  |  |  | State | Item Code | Description | Site Id | Broad category | Capex/Opex | Month | MO transact date | Date of faulty intimassion from NW | Site return date at W/H | R&R issue to vendor date | Receipt from vendor date | Repaired material despatch | Site Id
 |  |  |  |  |  |  |  |  | KOL | IF008446 | 2 CORE 16 SQ MM CU ARMOURD | EA | Capex | 23 | 1 | 606.55 | New Stock | 0<90 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | IF008446 | 2 CORE 16 SQ MM CU ARMOURD |  | PDH Antenna | Capex | Jan | 2011-09-12 00:00:00 | 2012-01-18 00:00:00 | 2012-01-23 00:00:00 | 2012-02-02 00:00:00 | 2012-04-04 00:00:00 | 2012-04-14 00:00:00
 |  |  |  |  |  |  |  |  | KOL | MW021075 | Ceragon - 18 GHz Single Polarization Antenna - 1.2 m | EA | Capex | 45 |  |  | Used stock in repairable condition | >180 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | MW021075 | Ceragon - 18 GHz Single Polarization Antenna - 1.2 m |  | Microwave Hop | Capex | Jan | 2011-09-22 00:00:00 | 2012-01-19 00:00:00 | 2012-01-25 00:00:00 | 2012-02-12 00:00:00 | 2012-04-14 00:00:00 | 2012-04-24 00:00:00
 |  |  |  |  |  |  |  |  | KOL | AC002008 | AIR CONDITIONER 4T X 1 PH (ROTARY COMPRESSOR) | EA | Capex | 432 | 1 |  | New Stock | 0<90 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | AC002008 | AIR CONDITIONER 4T X 1 PH (ROTARY COMPRESSOR) |  | Indoor BTS | Capex | Feb | 2011-09-27 00:00:00 | 2012-01-23 00:00:00 | 2012-01-28 00:00:00 | 2012-02-14 00:00:00 | 2012-04-12 00:00:00 | 2012-05-14 00:00:00
 |  | 2011-09-01 00:00:00 | PDH Antenna | 132 | 0 | 9 | 62 | 10 | KOL | MW077010 | CERAGON IP-10 R1 | EA | Capex | 170 | 30 | 1750330.8 | Used stock in Non Working Condition/Non-repairable Condition | 0<90 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | MW077010 | CERAGON IP-10 R1 |  | Outdoor BTS | Capex | Jan | 2011-09-27 00:00:00 | 2012-01-23 00:00:00 | 2012-01-29 00:00:00 | 2012-02-16 00:00:00 | 2012-04-20 00:00:00 | 2012-04-27 00:00:00
 |  | 2011-09-01 00:00:00 | Microwave Hop | 119 | 125 | 18 | 62 | 10 | KOL | N/A | Second Supporting Road For 1.8 MW Antenna | PCS | Capex | 56 | 2 | 16886.52 | New Stock | >180 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.8 MW Antenna |  | PDH Antenna | Capex | Jan | 2011-09-27 00:00:00 | 2012-02-06 00:00:00 | 2012-02-15 00:00:00 | 2012-02-18 00:00:00 | 2012-04-22 00:00:00 | 2012-04-30 00:00:00
 |  | 2011-09-01 00:00:00 | Indoor BTS | 118 | 123 | 17 | 58 | 32 | KOL | N/A | Second Supporting Road For 1.2 MW Antenna | PCS | Capex | 67 | 35 | 65669.8 | Non- Working Stock | 90<180 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.2 MW Antenna |  | PDH Antenna | Capex | sep | 2011-09-27 00:00:00 | 2012-02-06 00:00:00 | 2012-02-22 00:00:00 | 2012-03-02 00:00:00 | 2012-04-25 00:00:00 | 2012-05-10 00:00:00
 |  | 2011-09-01 00:00:00 | Outdoor BTS | 118 | 124 | 18 | 64 | 7 | KOL | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m | EA | Capex | 91 | 2 | 138892.83428 | Repaired stock | 0<90 | 2012-01-01 00:00:00 |  |  |  |  |  | Assam | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m |  | PDH [NAME] accessories | Capex | Jan | 2011-09-22 00:00:00 | 2012-02-14 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-09-01 00:00:00 | PDH [NAME] accessories | 145 | 151 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PDH [NAME] accessories |  |  | 2011-09-22 00:00:00 | 2012-02-14 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-09-01 00:00:00 | Microwave Hop accessories | 145 | 151 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Microwave Hop accessories |  |  | 2011-09-22 00:00:00 | 2012-02-14 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-09-01 00:00:00 | Indoor BTS accessories | 145 | 151 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indoor BTS accessories |  |  | 2011-09-22 00:00:00 | 2012-02-14 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-09-01 00:00:00 | Outdoor BTS accessories | 145 | 151 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outdoor BTS accessories |  |  | 2011-09-22 00:00:00 | 2012-02-14 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | PDH Antenna | 111 | 119 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | MW077010 | CERAGON IP-10 R1 |  | Indoor BTS | Capex | Jan | 2011-10-22 00:00:00 | 2012-02-08 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | Microwave Hop | 111 | 116 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.8 MW Antenna |  | PDH Antenna | Capex | Jan | 2011-10-24 00:00:00 | 2012-02-12 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | Indoor BTS | 110 | 117.5 | 9 | 59 | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.2 MW Antenna |  | Microwave Hop | Capex | Jan | 2011-10-27 00:00:00 | 2012-02-15 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | Outdoor BTS | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m |  | Indoor BTS | Capex | Jan | 2011-10-29 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | PDH [NAME] accessories | 109 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PDH [NAME] accessories |  |  | 2011-10-22 00:00:00 | 2012-02-08 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | Microwave Hop accessories | 111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Microwave Hop accessories |  |  | 2011-10-24 00:00:00 | 2012-02-12 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | Indoor BTS accessories | 111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indoor BTS accessories |  |  | 2011-10-27 00:00:00 | 2012-02-15 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-10-01 00:00:00 | Outdoor BTS accessories | 111 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outdoor BTS accessories |  |  | 2011-10-29 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | PDH Antenna | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | AC002008 | AIR CONDITIONER 4T X 1 PH (ROTARY COMPRESSOR) |  | Indoor BTS | Capex | Jan | 2012-02-04 00:00:00 | 2012-02-18 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | Microwave Hop | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | MW077010 | CERAGON IP-10 R1 |  | Outdoor BTS | Capex | Jan | 2012-02-05 00:00:00 | 2012-02-13 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | Indoor BTS | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.8 MW Antenna |  | PDH Antenna | Capex | Jan | 2012-02-06 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | Outdoor BTS | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.2 MW Antenna |  | Microwave Hop | Capex | Jan | 2012-02-07 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | PDH [NAME] accessories | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PDH [NAME] accessories |  |  | 2012-02-07 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | Microwave Hop accessories | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Microwave Hop accessories |  |  | 2012-02-07 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | Indoor BTS accessories | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indoor BTS accessories |  |  | 2012-02-07 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2011-11-01 00:00:00 | Outdoor BTS accessories | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outdoor BTS accessories |  |  | 2012-02-07 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | PDH Antenna | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m |  | Indoor BTS | Capex | Jan | 2012-02-08 00:00:00 | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | Microwave Hop | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | AC002008 | AIR CONDITIONER 4T X 1 PH (ROTARY COMPRESSOR) |  | Indoor BTS | Capex | Jan | 2012-02-09 00:00:00 | 2012-02-11 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | Indoor BTS | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | MW077010 | CERAGON IP-10 R1 |  | Outdoor BTS | Capex | Jan | 2012-02-10 00:00:00 | 2012-02-18 00:00:00 | 2012-02-20 00:00:00 | 2012-02-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | Outdoor BTS | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.8 MW Antenna |  | PDH Antenna | Capex | Jan | 2012-03-11 00:00:00 | 2012-03-17 00:00:00 | 2012-03-20 00:00:00 | 2012-03-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | PDH [NAME] accessories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | N/A | Second Supporting Road For 1.2 MW Antenna |  | Microwave Hop | Capex | Jan | 2012-03-12 00:00:00 | 2012-03-17 00:00:00 | 2012-03-20 00:00:00 | 2012-03-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | Microwave Hop accessories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assam | MW021077 | Ceragon - 18 GHz Single Polarization Antenna - 1.8 m |  | Indoor BTS | Capex | Jan | 2012-03-13 00:00:00 | 2012-03-17 00:00:00 | 2012-03-20 00:00:00 | 2012-03-29 00:00:00 | 2012-04-28 00:00:00 | 2012-05-16 00:00:00
 |  | 2012-12-01 00:00:00 | Indoor BTS accessories
 |  | 2012-12-01 00:00:00 | Outdoor BTS accessories