| # Required Input | |
| - BH report | |
| - Daily Report | |
| - Dump file (2G dump) | |
| - Number of last day for the analysis | |
| - Number of days for blocking | |
| - Sddch blocking threshold | |
| - TCH blocking threshold | |
| - Availability threshold | |
| - TCH abis fails threshold | |
| Analyse | |
| DUMP | |
| - Check that mandatory sheet exists in the dump | |
| - Parse 2G databases | |
| - Get number of TRX,TCH,SDCCH,amrSegLoadDepTchRateLower,amrSegLoadDepTchRateUpper from databases | |
| - Add "GPRS" colomn equal to (dedicatedGPRScapacity * number_tch_per_cell)/100 | |
| - Get "Coef HF rate" by mapping "amrSegLoadDepTchRateLower" to 2G analysis_utility "hf_rate_coef" dict | |
| - "TCH Actual HR%" equal to "number of TCH" multiplyed by "Coef HF rate" | |
| - Get "Offered Traffic" by mapping approximate "TCH Actual HR%" to 2G analysis_utility "erlangB" dict | |
| BH DATA | |
| - Pivot KPI in BH report | |
| - Calculate Average and Max of Traffic | |
| - Average of TCH blocking | |
| - Average of SDCCH blocking | |
| - Count number of Days with TCH blocking exceeded TCH blocking threshold | |
| - Count number of Days with SDCCH blocking exceeded Sddch blocking threshold | |
| - Count number of Days with Availability below Availability threshold | |
| - "TCH UTILIZATION (@Max Traffic)" equal to "Max_Trafic" divided by "offered Traffic" | |
| - Add "ErlabngB_value" =MAX TRAFFIC/(1-(MAX TCH call blocking/200)) | |
| - Get "Target FR CHs" by mapping "ERLANG value" to 2G analysis_utility "erlangB" dict | |
| - "Target HR CHs" equal to "Target FR CHs" * 2 | |
| - Get "Signal" and "GPRS" value from databases | |
| - Target TCHs equal to Target HR CHs + Signal + GPRS + SDCCH | |
| - "Target TRXs" equal to roundup(Target TCHs/8) | |
| - "# of required TRXs" equal to difference between "Target TRXs" and "number of TRX" | |
| Daily DATA | |
| - Pivot KPI in Daily Report | |
| - Count number of Days with Availability below Availability threshold | |
| - Count number of Days with abis fails exceeded TCH abis fails threshold | |