An easy way to track IP address when when using multiple stealth's.

[ash213]

as stupid as it sounds i usually just write the ip down in a note book and if i cant see the same ip for the last 50 odd log ins i dont worry.

i should track them constantly i suppose.

considering using this type of spreadsheet but where would you locate the file?

for example on my mac i have 10+ log in accounts that im in and out of all the time.

where would i save the excel file to bring it open every time?

cheers

[JamesNorth101]

USB stick, or a master account that you can access from all the other user accounts, cloud storage, ect ect

Need to make sure that IP has never been used before, be it 50 or 500 previous IP's.

[Geegee83]

Just created it and it works

Can't thank you enough JN101!

[Dazzler87]

for people like myself who don't have a clue about excel and spreadsheets would it be easier to just buy the upgreded version of ip burger? does this work as good? thanks

[JamesNorth101]

Not used it myself, but it was created by Aspkin, so I have no doubt that it will work an absolute treat.

[Dazzler87]

thanks for the fast reply mate think i will give it a go

[corleone]

Originally Posted by JamesNorth101

This is a very easy way to make sure that you never use the same IP address twice.

At the top of excel select the column A.


Select the conditional formatting button at the top of the page under the home tab

Select highlight cell rules, then duplicate values.

Make sure the left drop down cell says duplicate, and then select what ever works best for you on the right, I choose light filled red with dark red text personally. Then click ok.

After that is done, click column A again, conditional formatting, select highlight cell rules, then duplicate values again. This time change the left hand drop down value to unique, then the right hand drop down menu to again what ever suits you. I choose green filled with dark green text.

If the cell lights up red, you need to get a new IP, if it lights up green your good to go

Hope this helps

Thanks! Good stuff.

[90210]

Is there any way I can *pay* to get the IPTracker from IP Burger vs. having to do a trial that I cannot cancel? I don't have a new version of Excel (I have Excel 2003) and therefore cannot follow JamesNorth's instructions. Thanks.

[GreenBean]

@90210
Just added this to your thread.

Can you not use a free download of a newer version of excel? I did that without problems.

[JamesNorth101]

Have a look at LibreOffice Calc

[GreenBean]

Originally Posted by JamesNorth101

Have a look at LibreOffice Calc

Yeah, it is good to use with LINUX


Here's the URL

Calc Features » LibreOffice

[UndergroundMafia]

Originally Posted by MM78

Also, if you want to check your IP quickly here is a good way:

1. Enter your IP address associated with your Account

2. Click on "Find & Select" at the top right hand corner of Excel

3. Either Copy/Paste, or enter manually your IP in the search field

4. Click on "Find All"

This will find all the cells with the same IP, here's a little example.

Shortcut to find & select press ctrl+F

[mctrader07]

Originally Posted by JamesNorth101

This is a very easy way to make sure that you never use the same IP address twice.

At the top of excel select the column A.


Select the conditional formatting button at the top of the page under the home tab

Select highlight cell rules, then duplicate values.

Make sure the left drop down cell says duplicate, and then select what ever works best for you on the right, I choose light filled red with dark red text personally. Then click ok.

After that is done, click column A again, conditional formatting, select highlight cell rules, then duplicate values again. This time change the left hand drop down value to unique, then the right hand drop down menu to again what ever suits you. I choose green filled with dark green text.

If the cell lights up red, you need to get a new IP, if it lights up green your good to go

Hope this helps

that is helpful tips thanks

[qiangzi1999]

is it possible to upload a sample for us?

appreciated!!

Originally Posted by JamesNorth101

This is a very easy way to make sure that you never use the same IP address twice.

At the top of excel select the column A.


Select the conditional formatting button at the top of the page under the home tab

Select highlight cell rules, then duplicate values.

Make sure the left drop down cell says duplicate, and then select what ever works best for you on the right, I choose light filled red with dark red text personally. Then click ok.

After that is done, click column A again, conditional formatting, select highlight cell rules, then duplicate values again. This time change the left hand drop down value to unique, then the right hand drop down menu to again what ever suits you. I choose green filled with dark green text.

If the cell lights up red, you need to get a new IP, if it lights up green your good to go

Hope this helps

[JamesNorth101]

Uploaded as a zip file.

[Sandy D]

Originally Posted by JamesNorth101

Uploaded as a zip file.

Awesome James!

How did the antiques you found do?

[JamesNorth101]

Originally Posted by Sandy D

Awesome James!

How did the antiques you found do?

In a museum storage at the moment waiting to be inspected by one of their far eastern experts. Looking forward to seeing what they have to say when they get around to hopefully in the next month or so

[GoteBay]

My spreadsheet for IP tracking looks like this! Conditional formatting used, when IP is entered, you can tell by color code.

[JamesNorth101]

Really does make stealth a lot easier.

[Landizzle]

Woow! Great info here guys thanks alot! - i just sit back and wait for my new internet provider! :P

[JamesNorth101]

Use the time to read as much of the forum as you can

Whole forum is a massive wealth of information

[Landizzle]

Haha yeah its impressive how much Info There is! I already Think i know how to setup my stealths, actually og this gonna Work as i know its gonna do, Then om glad thay i Got suspended! Thanks eBay!