Forum

Automatic IP Checking Spreadsheet
 

Hey guys,

I have not started on my stealth journey as of yet, but I made a spreadsheet that might be helpful for most on here. It automatically does the IP checking process for all your accounts.

It's way more efficient than the way some of you might be going about this (ex. pad & pen :faint:, notepad, word or excell visual or manual ctrl-f search)

Here are the steps...

1. Fill in the account column headers with your own info
2. Switch IP
3. Enter current IP in sheet under column for eb/pp account you want to use
4a. if there's a duplicate IP alert, go back to 2
4b. if no duplicate IP alert, scroll to end of eb/pp account column IP list & add current IP to list.

Done!!! The process takes less than 10 seconds... :clap:

The ip list doesn't have to be in any order/sorted. The sheet can instantly auto check up to 100,000 IPs (10,000 each) :eek:

I only did 10 account columns. 10 seemed to be the standard max amount of accounts people are juggling at any given time. However, if you need more than 10 & are familiar with excel, you should be able to figure out what is going on in the alert reference cells to add more account columns for your purposes.

Enjoy :thumb:

will this show duplicates from different user.

does it only show duplicates in that user

It checks the IPs of the other 9 users/accounts for duplicates at the same time.

In the example in the sheet. If you enter 100.000.12.002 as the current IP for any other account other than account 4. You will get a duplicate warning, so the current IP would only be safe to use with account 4.

What is it you want to do specifically?

Edit: Found an error in the sheet...... it was giving an alert in accounts 2-9 if there was a duplicate in the same account.

Fixed the error

Now in the sheet's example...

100.000.12.002 entered as the current IP for account 2 gets a duplicate alert because it was used by account 4 before. However, 100.000.12.002 entered as current IP for account 4 gets no alert because it's in that account's previously used IP list.