Posts in Category: Microsoft Excel

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 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
 

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 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