Personal tools
Help » Global Spectrum Database » Using the MHz per pop sheets

Using the MHz per pop sheets

Nov 10, 2015 by admin

Gives a more detailed explanation of the data used to make the MHz/pop calculations and how it can be used

The MHz per pop data is contained in this sheet:
  • MHz PER POP 

Historic exchange rates or current exchange rates?

The MHz per pop sheets show both  a historic figure (col AF) using the dollar exchange rates at the time and a current figure, using  this year's exchange rates (col AE). 

GSD MHz per pop circled

Depending on the project you may prefer to use the historic or the current exchange rates: 

  • The historic exchange rate represents the value placed on the licence at the time using the most common currency benchmark: USD
  • Current exchange rates would make allowances for what would seem to be an artificially depressed price if the country involved had low exchange rates due to wider economic circumstances.

You may prefer to cross reference by comparing both sets of figures.

Revealing all the data

Some of the columns in both MHz/pop sheets are hidden to show the data in the simplest possible form. You can unhide these to reveal the figures on which the MHz/pop calculations are made.

Much of the information contained in the LICENCES sheet (details about the frequencies sold and technologies used) is duplicated for your convenience in the MHz/pop sheets and can be revealed by unhiding all columns A-V. 

Columns Y-AF show the following data not found elsewhere in the spreadsheet and used to make the MHz/pop calculations:

  • MHz/pop in original currency
  • Auction price at current USD exchange
  • Auction price at historic USD exchange
  • Price/MHz/pop at current USD rates
  • Price/MHz/pop at historic USD rates
  • Actual pop covered by licence
  • Price/MHz/ adjusted pop at current USD rates
  • Price/MHz/ adjusted pop at historic USD rates

Exchange rate data

The historic and current exchange rate data on which the MHz/pop calculations are made is available in a separate sheet called EXCHANGE RATES. 

Please note that some licence prices were quoted in Euros before the official introduction of the currency in 1999. In these circumstances we use the ECU exchange rate for the relevant year.

 
Document Actions