| # LTE CAPACITY REPORT | |
| Based on gsm and wcdma exemple let's build LTE capacity report | |
| ## Required Input | |
| - File : LTE BH report with columns : | |
| - PERIOD_START_TIME | |
| - MRBTS/SBTS name | |
| - LNBTS name | |
| - LNCEL name | |
| - DN | |
| - Cell Avail excl BLU | |
| - E-UTRAN Avg PRB usage per TTI DL | |
| - Number of last day for the analysis | |
| - Number of days for threshold | |
| - Availability threshold | |
| - PRB usage per TTI DL threshold | |
| - Max difference between PRB usage over cells of the same BTS | |
| ### TASK | |
| - Pivot KPI in BH report per KPI (Cell Avail excl BLU, E-UTRAN Avg PRB usage per TTI DL) | |
| - Calculate Average and Max of PRB usage per TTI DL | |
| - Calculate Average and Max of Cell Avail excl BLU | |
| - Count number of Days with Cell Avail excl BLU below Availability threshold | |
| - Count number of Days with PRB usage per TTI DL exceeded PRB usage per TTI DL threshold | |
| - Create separate DF per sector and band based on LNCEL name | |
| - _1_L800: column_name = Sector_1_L800 | |
| - _2_L800: column_name = Sector_2_L800 | |
| - _3_L800: column_name = Sector_3_L800 | |
| - _1_L1800: column_name = Sector_1_L1800 | |
| - _2_L1800: column_name = Sector_2_L1800 | |
| - _3_L1800: column_name = Sector_3_L1800 | |
| - _1_L2300: column_name = Sector_1_L2300 | |
| - _2_L2300: column_name = Sector_2_L2300 | |
| - _3_L2300: column_name = Sector_3_L2300 | |
| - _1_L2600: column_name = Sector_1_L2600 | |
| - _2_L2600: column_name = Sector_2_L2600 | |
| - _3_L2600: column_name = Sector_3_L2600 | |
| - _1S_L1800: column_name = Sector_1S_L1800 | |
| - _2S_L1800: column_name = Sector_2S_L1800 | |
| - _3S_L1800: column_name = Sector_3S_L1800 | |
| - Merge DFs per sector LNBTS name | |
| - Concat dfs per Bands | |