Blog

Hunter GE Network (Application) UPDATED

Fri, 23 Mar 2012 12:28:00 GMT

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 we... read more

Hunter FTP Client (using Access, Excel e VBA)

Fri, 13 Jan 2012 00:25:00 GMT

Today we saw how you can build a 'FTP Client' application using Excel, Access and VBA.

As advantages of a custom application like this, we highlight the possibility of automation of repetitive tasks - and therefore unnecessary, or at least capable of being improved.

Hunter Converter - Addresses to KML (Google Earth Coordinates)

Mon, 19 Dec 2011 16:21:00 GMT

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 wasting a... read more

Hunter xFilter – Customized Excel Filter based on Cell Typed Value

Fri, 09 Dec 2011 17:57:00 GMT

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 filter... read more

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

Thu, 27 Oct 2011 18:55:00 GMT

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 in ... read more

Hunter Mapbasic Tool - GSM Frequency Plan and Neighbors Analisys

Thu, 29 Sep 2011 22:59:00 GMT

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

Hunter Updater - Mapinfo Network Cells (Mapbasic Tool)

Tue, 20 Sep 2011 01:17:00 GMT

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 the... read more

Hunter Performance - KPI Base Tables

Wed, 07 Sep 2011 13:42:00 GMT

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

Hunter Performance - KPI Parser and Importer

Mon, 29 Aug 2011 19:36:00 GMT

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

Hunter Audit - Check Parameters (Application)

Mon, 08 Aug 2011 01:52:00 GMT

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

Hunter GE Network (Application)

Thu, 21 Jul 2011 19:14:00 GMT

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

Hunter GE Drive Test (Application)

Thu, 16 Jun 2011 22:13:00 GMT

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 to... read more

Hunter Parameters (Schema)

Tue, 17 May 2011 00:23:00 GMT

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 probably... read more

Folder Structure for Telecom

Fri, 06 May 2011 18:23:00 GMT

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 go. ... read more

Engineering Sketch - Croquis

Tue, 19 Apr 2011 00:21:00 GMT

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

Quick Notes

Fri, 11 Mar 2011 16:44:00 GMT

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

Hunter GE Operators

Thu, 18 Nov 2010 20:37:00 GMT

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

New Forum

Wed, 28 Jul 2010 00:00:00 GMT

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

Mapinfo KPI

Wed, 21 Jul 2010 00:00:00 GMT

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 we ... read more

Hunter KPI (Base Tables)

Wed, 14 Jul 2010 00:00:00 GMT

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

Hunter GE Drive Test (Best Server)

Wed, 07 Jul 2010 00:00:00 GMT

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

Hunter Interface

Wed, 30 Jun 2010 00:00:00 GMT

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 way ... read more

Hunter KPI

Wed, 23 Jun 2010 00:00:00 GMT

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

KPI Intro

Wed, 16 Jun 2010 00:00:00 GMT

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

Hunter GE Drive Test (Signal Level)

Wed, 09 Jun 2010 00:00:00 GMT

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. Today ... read more

Hunter GE Network (Multi-Tech)

Wed, 02 Jun 2010 00:00:00 GMT

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 application... read more

Hunter Mail

Wed, 26 May 2010 00:00:00 GMT

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

Hunter Mapbasic PlotSectors

Wed, 19 May 2010 00:00:00 GMT

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 received ... read more

Digital GIS Data

Wed, 12 May 2010 00:00:00 GMT

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 the way ... read more

Drive Test - Mapinfo & Google Earth

Wed, 05 May 2010 00:00:00 GMT

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

Hunter Mapinfo Network VBA Automation

Wed, 28 Apr 2010 00:00:00 GMT

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

Mapinfo Network

Wed, 21 Apr 2010 00:00:00 GMT

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

Hunter GE Network (Legend - Folder - Info)

Wed, 14 Apr 2010 00:00:00 GMT

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

Hunter GE Network (Sectors)

Wed, 07 Apr 2010 00:00:00 GMT

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

Hunter GE Network (Sites)

Wed, 31 Mar 2010 00:00:00 GMT

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

Hunter Network

Wed, 24 Mar 2010 00:00:00 GMT

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

Concepts and Definitions

Wed, 17 Mar 2010 00:00:00 GMT

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