## Over the Past Year, the Price of an IP Address Has More Than Doubled

According to information published IPv4 Global, a IP address auction service, the price of IP addresses between August 2020 and August 2021 has more than doubled.

Their data shows that at the end of August 29, 2020 the price per IP was \$23.24. As of August 29, 2021, the price was \$47.50.

IPv4 Global handles auctions, escrow, and related transactional services for IP block auctions. For example, you can buy a /22 in ARIN, a /23 in RIPE, etc. The fact that they handle so many IP address transactions gives them an excellent base of data upon which to draw trends.

### raindog308

I’m Andrew, techno polymath and long-time LowEndTalk community Moderator. My technical interests include all things Unix, perl, python, shell scripting, and relational database systems. I enjoy writing technical articles here on LowEndBox to help people get more out of their VPSes.

## Google Sheets – assign a year and date rank in ARRAYFORMULA

I want to number production runs in my system based on a continual count for that year, which is then preceeded by the year (with duplicates sharing the same number). For example, if the data set was

``````1 Nov 20
1 Nov 20
1 Dec 20
1 Jan 21
1 Feb 21
1 Nov 20
``````

Then the production run number would be as follows:

``````1 Nov 20    20.01
1 Nov 20    20.01
1 Dec 20    20.02
1 Jan 21    21.01
1 Feb 21    21.02
1 Nov 20    20.01
``````

And I can’t for the life of me work out how to do that as an ARRAYFORMULA. Obviously ranking is pretty simple:

``````=ARRAYFORMULA(IF(A1:A<>"", RANK(A1:A, UNIQUE(A:A), 1), ""))
``````

But that will give me a continual ranking (without re-starting every year); is there any way to do what I want in an arrayformula?

## usa – How can one find out how many days per year a city x experiences a temperature of less than y degrees at time z of the day?

WeatherSpark solves your problem (“do I need a warm jacket?”) perfectly. Go to their page for Seattle, then click on September and you get this wonderful chart:

As you can see, if you travel to Seattle on Sep 1st, night time temperatures get down to 14 degrees. If you want to dive deeper and ask about 8pm specifically, the next chart can do that as well:

This tells you that temps stay above 18 degrees until roughly September 22nd and you should expect cooler weather after that. Not “exact temperatures” but this is as good as it gets, short of downloading public weather datasets.

If you do wish to download and parse data on your own, you can use the Mesowest service for US measurements. After making a free account, you will be able to download data for 1 year/month at a time. In 2020, the lowest temperature at 8PM in September was 56F/13C according to that dataset. If you want to get data for more years, you’ll have to write a small script to download/parse multiple CSVs or make use of their public API.

## macbook pro – Apple have just bricked my 2016 year Mac via remote update. What are my options?

Yesterday morning I have turned on my 2016 year MacBook Pro with touchbar, just to discover that it now shows the message that “A critical update must be installed to your Mac, yet the update cannot be installed, yet the Mac cannot be used till it will be installed”, so what’s now?

• I have retried multiple times as the dialog suggests.
• I booted into minimal mode by holding the left shift. It boots in this mode. In the App store I have, indeed, found a big update pending that “requires restart”. I have updated all other apps but this was not helpful.
• I tried to reset the operating system by booting with CMD+R, this way of booting worked but no attempts to reset were successful.
• The Mac was running High Sierra. I have updated it to Big Sur from minimal mode, and even looks like I have succeeded. The error message now shows up in the differently looking dialog but it is still the same.

The Mac was bought in a normal store and worked flawlessly up to now. I have never opened it, never tried any major intrusions like disk partitioning and during the recent months in general was not doing anything serious with it. Apart from trashing the laptop, what are my other options now? Is the complete factory reset possible? Or would it run Linux maybe?

Apart from the advice how to fix the laptop, it would be very interesting to know what is the update here so critical that the computer cannot be used at all if it cannot be installed.

## customs and immigration – How can a UK 10 year visa ban affect a US visa application?

Yes, it can affect your chances of obtaining a US visa.

This 2015 question is similar, and has a relevant answer that addresses your question. Since the answer was posted the law has not changed in favor of applicants.

In the answer posted October 2, 2015, a well-respected member of this community wrote:

Yes, they share information. The controlling reference for this is a
treaty between the US and UK which was drafted in 2013 and entered
into force last year (2014) which says in part…

• CONSIDERING that the effective administration and enforcement of the
immigration and nationality laws of the United States of America and
the United Kingdom are important to protect the health and safety of
their populations, to maintain the security of their societies, and
their territories to persons who are criminals or security risks;

• ACKNOWLEDGING that identification of individuals who are inadmissible
under their respective immigration laws enhances their ability to
facilitate the travel of bona fide visitors;

So the answer is yes, the two governments share information, not only
by this treaty (and similar ones), but also by terms implicit in the
“Special Relationship”.

Based upon all of this, it is natural to conclude that a pejorative history in one of the signatories will affect visa decisions in the other signatory. This does not mean visa applications will be automatically refused, the decision-maker in each country will decide based upon all available information and sometimes this can be favourable to the applicant; but most of the time it would not be favourable to the applicant.

Thus, your UK ban clearly carries a negative effect. Based on that negative effect, the US may deny your application. If your US application is otherwise exemplary, the US may grant you a visa. Whether your US visa application will be granted or denied, however, cannot be known in advance: the only way to know for sure is to apply for a US visa.

## customs and immigration – UK 10 year visa ban

Yes, it can affect your chances of obtaining a US visa.

This 2015 question is similar, and has a relevant answer that addresses your question. Since the answer was posted the law has not changed in favor of applicants.

In the answer posted October 2, 2015, a well-respected member of this community wrote:

Yes, they share information. The controlling reference for this is a
treaty between the US and UK which was drafted in 2013 and entered
into force last year (2014) which says in part…

• CONSIDERING that the effective administration and enforcement of the
immigration and nationality laws of the United States of America and
the United Kingdom are important to protect the health and safety of
their populations, to maintain the security of their societies, and
their territories to persons who are criminals or security risks;

• ACKNOWLEDGING that identification of individuals who are inadmissible
under their respective immigration laws enhances their ability to
facilitate the travel of bona fide visitors;

So the answer is yes, the two governments share information, not only
by this treaty (and similar ones), but also by terms implicit in the
“Special Relationship”.

Based upon all of this, it is natural to conclude that a pejorative history in one of the signatories will affect visa decisions in the other signatory. This does not mean visa applications will be automatically refused, the decision-maker in each country will decide based upon all available information and sometimes this can be favourable to the applicant; but most of the time it would not be favourable to the applicant.

Thus, your UK ban clearly carries a negative effect. Based on that negative effect, the US may deny your application. If your US application is otherwise exemplary, the US may grant you a visa. Whether your US visa application will be granted or denied, however, cannot be known in advance: the only way to know for sure is to apply for a US visa.

## ≋≋≋ [HostDive] Awesome Web Hosting! Starting \$3.9 /Year! NA/EU! SSD Storage! FREE SSL! ≋≋≋

Welcome to HostDive.com ≋≋≋ !

Yearly Web Hosting Promo Offer:

If you buy any of our Packages Annually: 60-70% Discounts Across the Board!

 // Diver Package // 1 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Surfer Package // 3 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Sailor Package // 10 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt)Unlimited Addon DomainsUnlimited SubdomainsUnlimited Database(s)Unlimited Email AccountsDirectAdmin Control Panel 0 Addon Domains 5 Addon Domains Softaculous Script Installer 0 Subdomains 5 Subdomains And much more… Pricing: 1 Database(s) 5 Database(s) \$2.99 / Month 2 Email AccountsDirectAdmin Control Panel 5 Email AccountsDirectAdmin Control Panel OR–> \$14.99 / Year <– — US Server: —Order Now Softaculous Script Installer Softaculous Script Installer ———— — EU Server: —Order Now And much more… Pricing: And much more… Pricing: ———— \$0.99 / Month \$1.99 / Month OR–> \$3.99 / Year <–(Massive Yearly Promo) — US Server: —Order Now OR–> \$8.99 / Year <– — US Server: —Order Now ———— — EU Server: —Order Now ———— — EU Server: —Order Now ———— ————

Additional Features: LiteSpeed, Backups, PHP, PERL, Python, MySQL, RoundCube, Crons, ionCube, SpamAssassin, And more…

 // Diver Package // 4 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Surfer Package // 15 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Sailor Package // 25 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt)Unlimited Addon DomainsUnlimited SubdomainsUnlimited Database(s)Unlimited Email AccountsDirectAdmin Control Panel 0 Addon Domains 5 Addon Domains Softaculous Script Installer 0 Subdomains 5 Subdomains And much more… Pricing: 1 Database(s) 5 Database(s) \$3.99 / Month 2 Email AccountsDirectAdmin Control Panel 5 Email AccountsDirectAdmin Control Panel OR–> \$24.99 / Year <– — US Server: —Order Now Softaculous Script Installer Softaculous Script Installer ———— — EU Server: —Order Now And much more… Pricing: And much more… Pricing: ———— \$1.99 / Month \$2.99 / Month OR–> \$8.99 / Year <– — US Server: —Order Now OR–> \$14.99 / Year <– — US Server: —Order Now ———— — EU Server: —Order Now ———— — EU Server: —Order Now ———— ————

Additional Features: LiteSpeed, Backups, PHP, PERL, Python, MySQL, RoundCube, Crons, ionCube, SpamAssassin, And more…

 // Diver Package // 1 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Surfer Package // 3 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Sailor Package // 10 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt)Unlimited Addon DomainsUnlimited SubdomainsUnlimited Database(s)Unlimited Email AccountscPanel Control Panel 0 Addon Domains 5 Addon Domains Softaculous Script Installer 0 Subdomains 5 Subdomains And much more… Pricing: 1 Database(s) 5 Database(s) \$3.99 / Month 2 Email AccountscPanel Control Panel 5 Email AccountscPanel Control Panel OR–> \$24.99 / Year <– — NA Server: —Order Now Softaculous Script Installer Softaculous Script Installer ———— And much more… Pricing: And much more… Pricing: \$1.99 / Month \$2.99 / Month OR–> \$8.99 / Year <– — NA Server: —Order Now OR–> \$14.99 / Year <– — NA Server: —Order Now ———— ————

Additional Features: LiteSpeed, Backups, PHP, PERL, Python, MySQL, RoundCube, Crons, ionCube, SpamAssassin, Git, Node, And more…

FAQ:

When will my service be provisioned?

Do you offer refunds?

You don’t have to buy a domain name from us if you already own one elsewhere. Just select the correct option during checkout!

You can automatically upgrade/downgrade within the same server. If you would like to migrate across servers please open a ticket!

What is the difference between Shared hosting and CMS hosting?

CMS hosting allows more storage space as CMS solutions such as WordPress or Prestashop requires as much as 10 times more storage than their HTML counterparts.

What is the difference between DirectAdmin and cPanel?

Both control panels offer the same features and capabilities. However, we are able to provide DirectAdmin accounts for a far lower price due to the higher licensing costs associated with cPanel.

What version of PHP are you running?

We have: PHP 4.4, 5.1, 5.2, 5.3, 5.4, 5.5, 5.6, 7.0, 7.1, 7.2, 7.3, 7.4

## ⚡ US/UK ⚡ 40% OFF SSD cPanel Hosting ⚡ FREE SSL / UNLIMITED BANDWIDTH ⚡ from £9 A YEAR!

FREE LET’s ENCRYPT SSL CERTIFICATES / ULTRA FAST CLOUDLINUX cPanel UK & US SERVERS

PLEASE FEEL FREE TO CONTACT ON LIVE CHAT ON OUR WEBSITE FOR ANY QUESTIONS

Cheap Web Hosting offer some of the most reliable hosting in the UK and US. Our servers are located in the UK and US and we have a variety of plans available at discounted prices

We currently have 1 x UK Server and 1 x US server to choose from – 1 x London / 1 x New York

*Our Main Packages*

*Mini Plan*

SSD Disk Space – 1GB

Bandwidth – Unlimited

Hosted Websites – 2

Subdomains – 5

E-mail Accounts – 100

Control Panel – Cpanel
Regular Yearly Price – £15 – 40% off with coupon TOPDEAL = £9.00

*Basic Plan*

SSD Disk Space – 2GB

Bandwidth – Unlimited

Hosted Websites – 3

Subdomains – 5

E-mail Accounts – 100

Control Panel – Cpanel
Regular Yearly Price – £22 – 40% off with coupon TOPDEAL = £13.20

*Standard Plan*

SSD Disk Space – 5GB

Bandwidth – Unlimited

Hosted Websites – 5

Subdomains – 30

E-mail Accounts – Unlimited

Control Panel – Cpanel
Regular Yearly Price – £30 – 40% off with coupon TOPDEAL = £18

SSD Disk Space – 10GB

Bandwidth – Unlimited

Hosted Websites – Unlimited

Subdomains – Unlimited

E-mail accounts – Unlimited

Control Panel – Cpanel
Regular Yearly Price – £66- 40% off with coupon TOPDEAL = £39.6

Whats in the package?

– 99.99% or higher uptime of your website

– No hidden fees during checkout process

– 5 minutes setup after the payment is made

– 30 Day Moneyback, no questions asked

– Professional support

– 24/7 Network and service monitoring

– Fast, reliable and up-to-date servers

USE COUPON CODE TOPDEAL TO GET ONE TIME 40% OFF DISCOUNT

## linveo.com| 1st Year Free OR 75% off on select Annual Plans | SSD | Free SSL | MariaDB

For a limited time only, linveo.com is offering a FREE YEAR on our Starter Shared Hosting package. If you need more resources, pick up one of our other Shared Hosting packages with 75% off on annual billing.

Use discount code 1YEARFREE or 75OFF2021

Starter

512 MB SSD Storage Space

5 GB Monthly Bandwidth

5 Databases

1 Domain

No E-mail

Price: 1st year free with discount code 1YEARFREE
[Order Now]

Hobby

1 GB SSD Storage Space

25 GB Monthly Bandwidth

Unlimited Databases

Unlimited Domains

Unlimited E-mails

Price: \$2.00/month or 75% off Annual Plans with discount code 75OFF2021
[Order Now]

Professional

5 GB SSD Storage Space

50 GB Monthly Bandwidth

Unlimited Databases

Unlimited Domains

Unlimited E-mails

Price: \$4.00/month or 75% off Annual Plans with discount code 75OFF2021
[Order Now]

25 GB SSD Storage Space

250 GB Monthly Bandwidth

Unlimited Databases

Unlimited Domains

Unlimited E-mails

Price: \$6.00/month or 75% off Annual Plans with discount code 75OFF2021
[Order Now]

All plans come with

• Free Let’s Encrypt SSL Certificates
• Nightly Backups
• CloudLinux OS
• Softaculous Auto Installer

## ≋≋≋ [HostDive] Awesome Web Hosting! Starting \$3.9 /Year! NA/EU! SSD Storage! FREE SSL! ≋≋≋

Welcome to HostDive.com ≋≋≋ !

Yearly Web Hosting Promo Offer:

If you buy any of our Packages Annually: 60-70% Discounts Across the Board!

 // Diver Package // 1 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Surfer Package // 3 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Sailor Package // 10 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt)Unlimited Addon DomainsUnlimited SubdomainsUnlimited Database(s)Unlimited Email AccountsDirectAdmin Control Panel 0 Addon Domains 5 Addon Domains Softaculous Script Installer 0 Subdomains 5 Subdomains And much more… Pricing: 1 Database(s) 5 Database(s) \$2.99 / Month 2 Email AccountsDirectAdmin Control Panel 5 Email AccountsDirectAdmin Control Panel OR–> \$14.99 / Year <– — US Server: —Order Now Softaculous Script Installer Softaculous Script Installer ———— — EU Server: —Order Now And much more… Pricing: And much more… Pricing: ———— \$0.99 / Month \$1.99 / Month OR–> \$3.99 / Year <–(Massive Yearly Promo) — US Server: —Order Now OR–> \$8.99 / Year <– — US Server: —Order Now ———— — EU Server: —Order Now ———— — EU Server: —Order Now ———— ————

Additional Features: LiteSpeed, Backups, PHP, PERL, Python, MySQL, RoundCube, Crons, ionCube, SpamAssassin, And more…

 // Diver Package // 4 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Surfer Package // 15 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Sailor Package // 25 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt)Unlimited Addon DomainsUnlimited SubdomainsUnlimited Database(s)Unlimited Email AccountsDirectAdmin Control Panel 0 Addon Domains 5 Addon Domains Softaculous Script Installer 0 Subdomains 5 Subdomains And much more… Pricing: 1 Database(s) 5 Database(s) \$3.99 / Month 2 Email AccountsDirectAdmin Control Panel 5 Email AccountsDirectAdmin Control Panel OR–> \$24.99 / Year <– — US Server: —Order Now Softaculous Script Installer Softaculous Script Installer ———— — EU Server: —Order Now And much more… Pricing: And much more… Pricing: ———— \$1.99 / Month \$2.99 / Month OR–> \$8.99 / Year <– — US Server: —Order Now OR–> \$14.99 / Year <– — US Server: —Order Now ———— — EU Server: —Order Now ———— — EU Server: —Order Now ———— ————

Additional Features: LiteSpeed, Backups, PHP, PERL, Python, MySQL, RoundCube, Crons, ionCube, SpamAssassin, And more…

 // Diver Package // 1 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Surfer Package // 3 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt) // Sailor Package // 10 GB SSD StorageUnlimited BandwidthFREE SSL (Lets Encrypt)Unlimited Addon DomainsUnlimited SubdomainsUnlimited Database(s)Unlimited Email AccountscPanel Control Panel 0 Addon Domains 5 Addon Domains Softaculous Script Installer 0 Subdomains 5 Subdomains And much more… Pricing: 1 Database(s) 5 Database(s) \$3.99 / Month 2 Email AccountscPanel Control Panel 5 Email AccountscPanel Control Panel OR–> \$24.99 / Year <– — NA Server: —Order Now Softaculous Script Installer Softaculous Script Installer ———— And much more… Pricing: And much more… Pricing: \$1.99 / Month \$2.99 / Month OR–> \$8.99 / Year <– — NA Server: —Order Now OR–> \$14.99 / Year <– — NA Server: —Order Now ———— ————

Additional Features: LiteSpeed, Backups, PHP, PERL, Python, MySQL, RoundCube, Crons, ionCube, SpamAssassin, Git, Node, And more…

FAQ:

When will my service be provisioned?

Do you offer refunds?

You don’t have to buy a domain name from us if you already own one elsewhere. Just select the correct option during checkout!

You can automatically upgrade/downgrade within the same server. If you would like to migrate across servers please open a ticket!

What is the difference between Shared hosting and CMS hosting?

CMS hosting allows more storage space as CMS solutions such as WordPress or Prestashop requires as much as 10 times more storage than their HTML counterparts.

What is the difference between DirectAdmin and cPanel?

Both control panels offer the same features and capabilities. However, we are able to provide DirectAdmin accounts for a far lower price due to the higher licensing costs associated with cPanel.

What version of PHP are you running?

We have: PHP 4.4, 5.1, 5.2, 5.3, 5.4, 5.5, 5.6, 7.0, 7.1, 7.2, 7.3, 7.4