Posts in Category: Access

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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