A-GPS connecting to satellites in miliseconds

a-gps glonass

A-GPS or Assisted GPS is a system that relies on mobile data transmission (mobile internet) to help your mobile phone start GPS applications in record time. Without this system, finding available satellites could take up to 12 minutes. Basically, the phone connects to a server that transmits the positions of the satellites at that time […]

Glonass GPS and Galileo

glonass galileo gps

The GLONASS positioning system (GLObal’naia NAvigatienaia Sputnikovaia Sistema) refers to one of the 3 global positioning satellite networks available today for accurately locating the world map. This network was developed by the Soviet Union in 1976 and is currently maintained by Russia and newer by India. The network is based on 24 satellites arranged in […]

Compare phone – smart mobile tool

Every time I want to buy a new mobile phone I have a big enigma about which model is best suited to my needs for the less money possible. I tried to compare phones (mobile smartphone) over many online store pages, but this kind of comparison is very superficial and only displays information and doesn’t […]

Full Mobile Phone Technical Specifications

Very useful information to analyze and compare before choosing a smartphone. Technical specifications tell us if the model we look at is suited for our needs. Comparing these specifications could bring us the best mobile phone for the less money possible. If you need a comparing tool for mobile phones take a look at this […]

Useful Excel keyboard shortcuts tutorial

Excel Shortcuts

Work with excel as efficient as you can using keyboard shortcuts instead of clicking the mouse. If you take one hand from the keyboard to click the mouse you loose precious time and energy. All you need to know is key shortcuts that do certain action you used to do with the mouse. Excel useful […]

Sumifs and wildcard condition on column contents

how to use sumifs and wildcard

The most used formula in excel is SUMIFS, which, in my opinion, together with a wildcard condition, is the element which supports and ensures the existence and usage of excel application. Let’s imagine we have a spreadsheet which contains 2 columns: first one shows the sales revenues for a certain period and the second shows […]

Variable sheet in excel formulas, calling dynamic sheet name

Dinamic variable sheet name in formulas

Sometimes we need to use in our excel formulas a certain sheet depending on different conditions. Calling variable sheet name in excel formulas For example, if we want to create an easy to use report which needs to apply consolidating formulas on data available on a certain sheet, depending on the user choice. Let’s say […]

SUMIFS across multiple sheets

Sumifs across multiple sheets

First you have to define a SheetList range name (the range of sheet names being the sources of SUMIFS). You can input the name of the sheets in a separate sheet of your excel file. Select all the cells containing this sheet names, then go to the name box field (the upper left field where […]