contador Saltar al contenido

iPhone with 3, calculate how much it costs you with Excel

A few days ago we promptly announced the new H3G (3 Italy) rates here. So you probably already know that the offer consists of three subscription plans and as many rechargeable. But just how easy to choose the best one?

Macity has decided to help you in this choice with a tool that considers the overall cost of the plan during the entire duration of its constraint and that above all adjusts to your phone usage profile with an Excel document compatible with the 2004 and 2008 versions of Excel for Mac and that does not contain macros.

The purchase cost of the iPhone (Upfront) is taken into consideration, which varies according to the model (3) and the plan (6) and the monthly cost for the entire period covered. In addition, for subscriptions there is also the Government Concession Tax (TCG) and the related promo in the case of Number Portability. Instead for the rechargeable plans we have considered the flat rate for Internet Traffic which, although optional, no iPhone user will want to avoid subscribing, given also its unquestionable convenience (plus in free promo until the end of the year).

The use of this document could not be simpler: 1. You choose the iPhone model with a click2. You set the starting date of the plan (subscription or top-up) – it is used to calculate the promo3. You set your consumption profile (hypothesis voice minutes, SMS, MMS). Once this is done you will have the "total cost of the period" (the entire duration of the bond) for each of the plans.

For rechargeable plans, the "total cost of the period net of the residual charge at the end of the period" was also indicated.

Let's clarify the meaning of this data.

In the case of a subscription, for example, we will have a number of voice minutes included per week which, if not fully used, are lost at the beginning of the following week.

In the case of rechargeable plans, however, we will have a monthly reload constraint that we will necessarily have to do, but we will not be "obliged" to consume it all in the month and will still be available in the following month. So if our average consumption profile is lower than the monthly top-up, we will end up with a "residual charge" that we can use even after the bond expires.

This is a "small" advantage of the rechargeable plans on which no seller will ever draw your attention.

To download the Excel document click here

Our readers can discuss the topic on this forum page

(By Walter Mandorino)