Give us a little help? Share telecomHall with your friends :) (Thank You!)

Blog Quick Links

Hello, This is a blog for IT & Telecom Tools Developers (from simple Excel macros to complete systems to Network Analysis). And, as we known, the focus of these tools is to improve the productivity of processes such as optimization, design, analysis, KPI, etc. That is, you get to know the best practices in the IT & Telecom area. Here you can learn new things - it all depends on your need or desire and, following the written free content of each tutorial.

Custom Tools for Telecom (MS Access, VBA, Google Earth): Download Presentation

 

 

 

Hunter Kml Plotter (Excel to Google Earth KML/KMZ)
       

Hunter GE CoverTune (Application)

Hunter GE Propagation Analyzer (Application)

Hunter Google Earth Performance KPI Plot (Application)

Hunter GE Network (Application) UPDATED
NEW!!      

Hunter FTP Client (using Access, Excel e VBA)

Hunter Converter - Addresses to KML (Google Earth Coordinates)

Hunter xFilter – Customized Excel Filter based on Cell Typed Value

Hunter Performance - Live Report - KPI Summary (via Email)
       

Hunter Mapbasic Tool - GSM Frequency Plan and Neighbors Analisys

Hunter Updater - Mapinfo Network Cells (Mapbasic Tool)

Hunter Performance - KPI Base Tables

Hunter Performance - KPI Parser and Importer
       

Hunter Audit - Check Parameters (Application)

Hunter GE Network (Application)

Hunter GE Drive Test (Application)

Hunter Parameters (Schema)
       

Folder Structure for Telecom

Engineering Sketch - Croquis

Quick Notes

Hunter GE Operators
       

New Forum

Mapinfo KPI

Hunter KPI (Base Tables)

Hunter GE Drive Test (Best Server)
       

Hunter Interface

Hunter KPI

KPI Intro

Hunter GE Drive Test (signal level)
       

Hunter GE Network (Multi-Tech)

Hunter Mail

Hunter Mapbasic PlotSector (Petals)

Digital Data
       

Drive Test - Mapinfo & Google Earth

Hunter Mapinfo Network VBA Automation

Mapinfo Network

Hunter GE Network (Legend - Folder - Info)
       

Hunter GE Network (Sectors)

Hunter GE Network (Sites)

Hunter Network

Concepts and Definitions
       

Blog

Hunter NePa - Network Parser 

Posted by leopedrini Friday, August 05, 2016 8:31:00 AM Categories: Access Audit Converters Hunter Microsoft Excel Parameters VBA
There's no doubt: the most important part of any mobile or fixed network are its Configuration Parameters. Making an analogy (comparing) of a network with the human body they would be the brain. Of course, in the human body all the organs are important. However, some have more importance, and other less - on a scale, the brain would be the first in the list. And in a network it is no different. There are several mechanisms of management or control, but the most important (as we shall see... read more
 
Comments 

Hunter KML Plotter (Excel to Google Earth Kml/Kmz) 

Posted by leopedrini Tuesday, September 01, 2015 2:21:00 PM Categories: Converters Google Earth Hunter Microsoft Excel
If you work with telecommunications, it is very likely that already has come across the following request: generate a map in Google Earth (kml file) from a table with latitude, longitude and some other basic information. This task may seem simple, but if you've tried to do it, probably realized that it is not as easy as it sounds! Many people don't even know where to start: ask for a friend to help, do a good 'Google Search', among other efforts. What happens is that as this... read more
 
Comments 

Hunter GE CoverTune (Application) 

Posted by leopedrini Wednesday, March 26, 2014 5:46:00 PM Categories: Access Google Earth Hunter VBA
The reach area of each cell of the network directly affects the efficiency of the system in terms of Quality, Capacity and Coverage. Therefore it is essential that each one be perfectly adjusted. These adjustments include changes to the configuration parameters (eg, for load balancing), and also adjustment of physical parameters. In the latter case, the adjustment of tilts and azimuths (and sometimes height) of the antennas is a key factor in achieving the best possible results. The... read more
 
Comments 

Hunter GE Propagation Analyzer (Application) 

Posted by leopedrini Wednesday, October 30, 2013 9:03:00 AM Categories: Access Google Earth Hunter Microsoft Excel VBA
We're starting a new sequence of Hunter Tool tutorial. In today's tutorial we will see the module 'Hunter GE Propagation Analyzer', which deals with Performance counters collected data and plots them in Google Earth. That way we can perform different types of analysis, as shown in detail in tutorial Analyzing Coverage with Propagation Delay - PD and Timing Advance - TA (GSM-WCDMA-LTE), whose reading is highly recommended before proceeding. Note: as always the files from this... read more
 
Comments 

Hunter Google Earth Performance KPI Plot (Application) 

Thursday, June 28, 2012 7:49:00 PM Categories: Access Hunter KPI Microsoft Excel Performance VBA
Hello. We will continue the series of Hunter Tool modules, showing today the module responsible for the plot of Network Performance (KPI) in Google Earth. Needless to say: the analysis of Performance indicators (KPI) is an essential task to evaluate any system. And in terms of user experience, i.e. to facilitate the analysis as much as possible, Google Earth is becoming increasingly used in virtually all areas, not just in Telecommunications and IT. // As one ... read more
 
Comments 

Hunter GE Network (Application) UPDATED 

Friday, March 23, 2012 8:28:00 AM Categories: Access Google Earth Hunter Microsoft Excel
Hello friends, today we will talk about a small change in our presentation way, or the methodology of Hunter tutorials, mainly due to user requests. Until today, all tutorials were written so extensively, aiming mainly to allow an easy understanding of everything that was needed so that all users could learn how to use their own tools available, such as Microsoft Access and Google Earth. To do this, in several tutorials, we extensively detailed the use of Access and VBA, demonstrating how ... read more
 
Comments 

Hunter FTP Client (using Access, Excel e VBA) 

Thursday, January 12, 2012 7:25:00 PM Categories: Access FTP Hunter Microsoft Excel VBA
When you need to access a specific FTP server and download or upload one or more files, the best option is to use the standard FTP programs, like the one we recommend: Filezilla. // However, when this task has become repetitive, as when we download daily files from multiple OSS (via FTP), then it's better to automate it - less wasted time, minimize errors, etc.. And a way to automate the execution of FTP is to create a Windows application that performs the work. Let's ... read more
 
Comments 

Hunter Converter - Addresses to KML (Google Earth Coordinates) 

Monday, December 19, 2011 11:21:00 AM Categories: Access Converters Hunter
The conversion of Coordinates to Addresses is an issue that arouses interest from many areas, not just Telecom. // And one reason is that this mapping is increasingly present in our day-to-day, for example when we receive a list of Addresses, and we need to make such a coverage analysis at each point. There are several ways to obtain this conversion from a manual to fully automated type. But when we don't have a standard procedure to obtain these data, we ended up... read more
 
Comments 

Hunter xFilter – Customized Excel Filter based on Cell Typed Value 

Friday, December 09, 2011 12:57:00 PM Categories: Microsoft Excel
Microsoft Office Excel without any doubt is one of the most used program when we need to do Data Presentations such as charts and graphs. When Data are showed in tables, a feature also commonly used are the filters, to limit the records of the table based on certain criteria. The Excel Filter options are already good, but we can always do a little better, especially in the issue of improving the the user experience and interactivity. // For example: we can quickly ... read more
 
Comments 

Hunter Performance - Live Report - KPI Summary (via Email) 

Thursday, October 27, 2011 2:55:00 PM Categories: Access Hunter KPI Performance
There's no doubt the main objective of Telecommunications Engineers is to get the best possible performance of the system, in terms of Call Quality, Dropped and Block Rates, QoS and Data Speed, Availability of the Network or any other indicator. // With the Excellence of Performance, it's easier to increase the customer base and also increase its satisfaction. You can also do a better resources management - OPEX and CAPEX, that can be translated into significant gains also... read more
 
Comments 

Hunter Mapbasic Tool - GSM Frequency Plan and Neighbors Analisys 

Thursday, September 29, 2011 6:59:00 PM Categories: Hunter Mapbasic Mapinfo
Frequency Planning and Neighbor List Verification are two major tasks required to ensure an efficiently Optimized Network. // This analysis can be done in several ways, and one of them is by checking geo-referenced plots, where possible problems of 'Interference' or 'Missing Neighbors' can be easily identified. Google Earth is a good place for this type of inspection, but Mapinfo also has its advantages - especially in terms of interactivity (eg it is easier to create an ... read more
 
Comments 

Hunter Updater - Mapinfo Network Cells (Mapbasic Tool) 

Monday, September 19, 2011 9:17:00 PM Categories: Access Hunter Mapbasic Mapinfo Updater
One advantage of working with an organized and integrated modules - such as the methodology suggested by Hunter - is the gain that this scenario provides. Let's begin to understand how this works with the module 'Hunter Updater'. // Currently we have the main databases with our information (Network, Parameters, and Performance). And we also have a number of other external tools we use in every way, in daily work, and the data update for them is crucial to the outcome of... read more
 
Comments 

Hunter Performance - KPI Base Tables 

Wednesday, September 07, 2011 9:42:00 AM Categories: Access Hunter KPI Performance
Moving forward in the creation of our entire System for our Network Monitoring and Analysis, today we'll see the next step: defining the KPI Base Tables. // These tables are extremely important, as it will be from it we'll create several applications, using algorithms and intelligence. From these tables, we easily create charts and dashboards, reports, and all that is necessary for a quick and efficient analysis, always following our simplified methodology. Note: Again,... read more
 
Comments 

Hunter Performance - KPI Parser and Importer 

Monday, August 29, 2011 3:36:00 PM Categories: Access Hunter KPI Performance
Network Performance Monitoring is certainly one of the most important activity in the daily work for all people involved. So we're beginning today several tutorials related to Performance / KPI, this big challenge, whatever the area of Telecom & IT. // When we improve the Performance, we also improved customer satisfaction - reducing its complaints. In addition, we maximize revenue (fewer drops, fewer blockages, fewer failures: more calls, more quality, more... read more
 
Comments 

Hunter Audit - Check Parameters (Application) 

Sunday, August 07, 2011 9:52:00 PM Categories: Access Audit Hunter Parameters
One of the most important tasks for an efficient control of a cellular network is to ensure that all of its Configuration Parameters (GSM, UMTS, LTE ...) are properly adjusted. // Any one parameter, incorrectly configured can cause real damage to the Performance, and therefore to Customer Satisfaction. And the time it takes to find such a problem is unnecessary - since the problem could be easily and quickly found by an efficient and automatic algorithm. The causes for... read more
 
Comments 

Hunter GE Network (Application) 

Thursday, July 21, 2011 3:14:00 PM Categories: Access Google Earth Hunter
With the plot of the network information (sites and cells) in a geo-referenced way, we can greatly benefit from an easier and more intuitive visualization of it, and it also helps identify problems such as misdirected cells (azimuths). // Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic translator, with only a final and... read more
 
Comments 

Hunter GE Drive Test (Application) 

Thursday, June 16, 2011 6:13:00 PM Categories: Access Drive Test Hunter
After several tutorials to familiarize with the Hunter methodology, let's continue now with more practical applications, ready to use on a daily basis. // Today we see the application responsible for creating KMZ files from text files or Microsoft Excel spreadsheets, exported from any commercial Drive Test Software. Who knows the power of custom tools will be amazed how, with a little creativity, we have simple solutions but they leave nothing to be desired in relation... read more
 
Comments 

Hunter Parameters (Schema) 

Monday, May 16, 2011 8:23:00 PM Categories: Hunter Parameters
One of the keys to the success of all activities of the Network is to collect all information of the configuration parameters (GSM, UMTS, LTE ...) on a single and updated database. // From this base (parameters database) we can accomplish a lot of actions, with benefits of several types: audit parameters, accurate reporting, plotting to Google Earth and Mapinfo, updating other databases and other tools such as drive test etc.. If you're reading this tutorial, you... read more
 
Comments 

Folder Structure for Telecom 

Friday, May 06, 2011 2:23:00 PM Categories: Hunter Process
Let's talk today about organization, especially the documentation of sites in a cellular network. Quite simply, let's see how this information can work to our advantage. // We like and agree with a famous phrase used in IT: "Every non-hierarchical structure tends to become obsolete." But what does this have to do with me? Let's talk a little more about it, and then you decide for yourself whether the suggested practices apply to you, or you can help. So here we... read more
 
Comments 

Engineering Sketch - Croquis 

Monday, April 18, 2011 8:21:00 PM Categories: Hunter
At first glance, this is a subject that seems to be not so important, or at least not have much relationship with Telecom and IT. // But then answer the following question: "If your boss asks you to do a draft, an outline of the installation of a site on the rooftop of a building, how would you get it? What are the minimum information that such a design should contain?" So, even if it seems a simple matter, it's worth talking a little about it. Even if only to remind... read more
 
Comments 

Quick Notes 

Friday, March 11, 2011 11:44:00 AM
Returning to post blog entries in telecomHall Blog for Telecom and IT developers, let's start with small suggestions - procedures - of work that simplify our day to day. // This tutorial is fast and simple, but serves to resume the development in this section. Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic translator, ... read more
 
Comments 

Hunter GE Operators 

Thursday, November 18, 2010 3:37:00 PM Categories: Access Google Earth Hunter
Hello everybody. As we all know, due to the numerous problems encountered in the development methodology telecomHall, I stopped sending macros, code, files, etc.. Of course, I have suspended the accounts of all subscribers until then, they are no longer charged for anything more. // However, many of you asked me to continue, even though he was just teaching some algorithms, standard procedures, etc.. And I've had articles ready for publishing weekly. Anyway, the tool, or... read more
 
Comments 

New Forum 

Tuesday, July 27, 2010 8:00:00 PM Categories: News
Hello The tutorial today is slightly different from those you have been following. It is time we present in our news portal. // So today we'll learn a new feature available on our website: The Forums! Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic translator, with only a final and 'quick' review). We apologize and we... read more
 
Comments 

Mapinfo KPI 

Tuesday, July 20, 2010 8:00:00 PM Categories: KPI Mapinfo
Let's enjoy that we already have some KPI's in our tables, and have a little review on how to use this kidn of data in Mapinfo. // In our today's tutorial, we'll learn how to work with georeferenced data for KPI's, an excellent way to display reports and allowing a quick inspection of the network. Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes ... read more
 
Comments 

Hunter KPI (Base Tables) 

Tuesday, July 13, 2010 8:00:00 PM Categories: Access Hunter KPI
When we talk about or KPI in Performance Analysis, what immediately comes to mind? While the answer to this question is particular to each person, we can think of a general answer in a report: a table, chart, map or even a combination of all. // No matter what the format of this report is, it is correct to state that it serves to tell us a comparison of indicators. This comparison may be on a fixed value, or on a different magnitude, among others. These are the 'algorithms' ... read more
 
Comments 

Hunter GE Drive Test (Best Server) 

Tuesday, July 06, 2010 8:00:00 PM Categories: Access Drive Test Google Earth Hunter
We have already learned how to plot the information of coverage (Signal Level) of any network - GSM, UMTS or any other technology - based on data from a text file on Google Earth. We have also seen how interfaces can be easily created in Access to interact with applications. // Today we go a bit further, and learn how to plot the data for Best Server of any network, and now we start to use user interfaces, always seeking a better user experience - even if those users be... read more
 
Comments 

Hunter Interface 

Tuesday, June 29, 2010 8:00:00 PM Categories: Access Hunter
We've already learned some applications using System Hunter, mainly using VBA and Access and Excel. Except that until now, we need to run any of it - for example Hunter GE Network, which plots the network information sectors in Google Earth - we neede to use methods not so friendly, like running macros directly in the program interface or the VBE environment. // But when we talk about applications, the first thing that comes to mind is an interface, does not it? Okay, the... read more
 
Comments 

Hunter KPI 

Tuesday, June 22, 2010 8:00:00 PM Categories: Access Hunter KPI
The KPI is a major part in any cellular network. And the same skills to analyze, therefore, a major task for us who work in this area. So, let's see a little of both today: more theoretical knowledge that we will use from now on in several modules that work with KPI Hunter, and a little Access database, specifically to learn to work with data in tables and queries. // Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and... read more
 
Comments 

KPI Intro 

Tuesday, June 15, 2010 8:00:00 PM Categories: Access Hunter KPI
Hello! If you are following all the tutorials, you've seen that we can represent our network through geo-referencing tools such as Mapinfo and Google Earth, and also that with this kind of tools we can perform tasks such as analysis of drive tests. But there are other important ways to evaluate a network, one, probably the main one, is through the analysis of statistics, and this is what we'll start seeing today. // Start? Yes, start, because the analysis of statistics is a ... read more
 
Comments 

Hunter GE Drive Test (Signal Level) 

Tuesday, June 08, 2010 8:00:00 PM Categories: Access Drive Test Google Earth Hunter
As we mentioned before, Drive Test is important for a more complete analysis of the network. The various post-processing tools available have a complete set for this analysis, but sometimes our work can be much simplified, and why not, sometimes getting a better result. // This is particularly the case for the custom processing of drive test - we can not even have the power of algorithms and details of some software, but we got results surprisingly simple and efficient.... read more
 
Comments 

Hunter GE Network (Multi-Tech) 

Tuesday, June 01, 2010 8:00:00 PM Categories: Access Google Earth Hunter
We already learned some important concepts for Network plotting data on Google Earth. Today we will improve a little our application (Hunter GE Network) in order to achieve a more professional result and that allows to work with layers of various technologies. // In addition, we will learn what styles are and how they are used in a simple way to achieve amazing results, not only for the purpose that we see today, but also in creating thematic maps on whatever the... read more
 
Comments 

Hunter Mail 

Tuesday, May 25, 2010 8:00:00 PM Categories: Access e-mail Hunter
One of the applications we use a lot from now on in several modules of the Hunter is sending e-mails. Whether to send the result of an analysis, a periodic report, a check of parameters, or any other purpose, sending automated e-mail saves us considerable time in formatting, minimizes errors, among other advantages that we will soon. // So, let's take a break location based on modules, which mainly use Mapinfo and Google Earth, and return to work a little harder with Access ... read more
 
Comments 

Hunter Mapbasic PlotSectors 

Tuesday, May 18, 2010 8:00:00 PM Categories: Hunter Mapbasic Mapinfo
The representation of sectors across our network of lines as we have seen is sufficient for several tests. However, it is sometimes more interesting to work with symbols instead of simple lines, such as the sector represented by a symbol like a rose petal. Today we will create our first program Mapbasic - where we'll see how this is done. // Note: Almost all tutorials have related files, which are sent to Subscribers. If you are a Subscriber, please check the ... read more
 
Comments 

Digital GIS Data 

Tuesday, May 11, 2010 8:00:00 PM Categories: GIS Data Mapinfo
Databases: If you have not used, believe, will use! Are very important as an adjunct to many tasks of analysis and reporting. // For example, in a report with the municipalities more offenders dropped calls can make a table. But we can make a thematic map. Which is better? Note the picture below and draw your own conclusions. Databases are also essential tools for predicting how the Asset3g Aircom or x-Wizard of Optimi. In the prediction tools, the databases are ... read more
 
Comments 

Drive Test - Mapinfo & Google Earth 

Tuesday, May 04, 2010 8:00:00 PM Categories: Drive Test Google Earth Mapbasic Mapinfo
The analysis of drive test are key to any kind of telecom professional, either in the implementation of data collection or just in the analysis. Although through the analysis of KPI's you can identify problems like dropped calls, the drive tests allow a deeper analysis in the field. Identifying areas of each sector of coverage, interference, among others. // Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish.... read more
 
Comments 

Hunter Mapinfo Network VBA Automation 

Tuesday, April 27, 2010 8:00:00 PM Categories: Access Hunter Mapbasic Mapinfo
In the previous tutorial, we had our first contact with Mapinfo and Mapbasic. We had a brief introduction to Mapinfo, and also how to use Mapbasic - your programming language without having Mapbasic installed. Although soon we will see a series of programs Mapbasic, today we will take the opportunity and not let us use the Mapbasic itself, through the interface of your program. Alternatively, we learn a new concept that can be learned and that we also use a lot, not only with the MapInfo:... read more
 
Comments 

Mapinfo Network 

Tuesday, April 20, 2010 8:00:00 PM Categories: Mapbasic Mapinfo
The geo-referenced analysis are widely used in the field of Telecom and IT. Up to now use some programs Access and Google Earth to facilitate the acquisition of geo-referenced data, but there are several other tools as good as these, and also widely used. This is the case for example of MapInfo, which still uses SQL and also has its own language automation - the Mapbasic. Today we will have our first contact with him, and some tips for using the program. Later we will return to using Google... read more
 
Comments 

Hunter GE Network (Legend - Folder - Info) 

Tuesday, April 13, 2010 8:00:00 PM Categories: Access Google Earth Hunter
The data from our network - sites and sectors - are already automatically plotted on Google Earth, so good. But the presentation of data can be much better. We saw how to change the characteristics of sectors and sites manually through the interface of the program. Today we will learn how to make a series of improvements that can be done to make this data much more organized and presentable. // Note: All telecomHall articles are originally written in Portuguese. Following... read more
 
Comments 

Hunter GE Network (Sectors) 

Tuesday, April 06, 2010 8:00:00 PM Categories: Access Google Earth Hunter
Plot the data from our network of sites on Google Earth has been the beginning, and we had our first contact with the way this is done. Equally or more important that information from websites is the information sector, however, is viewing the sectors of our BTS's. // Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic... read more
 
Comments 

Hunter GE Network (Sites) 

Tuesday, March 30, 2010 8:00:00 PM Categories: Access Google Earth Hunter
It's a fact and nobody can deny today's extreme importance of Google and the tools that are part of it. And one of these tools is Google Earth, a really great help to our area of Telecom and IT, although it is used for numerous other applications. But generally people use only a small part of its potential, as individual users. However, knowing a few secrets, you will stand out easily. // Note: All telecomHall articles are originally written in Portuguese. Following we... read more
 
Comments 

Hunter Network 

Tuesday, March 23, 2010 8:00:00 PM Categories: Access Hunter
Ready to start? So here we go. This is the first contact with the practical development. We will start our system from scratch, from the network data to the tools designed to be used in it. Surely it would be a long journey, because there are undoubtedly a lot to explore. But we also believe will be increasingly productive and rewarding for all. So let's not waste time, and start. // Note: All telecomHall articles are originally written in Portuguese. Following we translate ... read more
 
Comments 

Concepts and Definitions 

Tuesday, March 16, 2010 8:00:00 PM Categories: Hunter
Before we begin our project, it is essential to understand some concepts and definitions, which are widely used, and which will serve as the basis for the commencement of work involving telecommunications, IT and Programming. From this point, we apply the methodology of teaching telecomHall, removing any doubts and are preparing to proceed. // Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is... read more
 
Comments 

Live Activity

English Portugues Espanhol