Tracking Multiple Accounts with Excel - How do you do it?

[Junkymail]

When I first joined this site I couldn't wrap my head around how on earth I would keep all the accounts organized. Pre-suspension it was so easy because all of the info I used was true! But having multiple secret identities... jeebus! I searched the forums for some example spreadsheets others have used, but didn't really find anything I liked. So I made up my own and would like to share! And since I'm new at having multiple fake identities, please give me your input if you think there's more things I need to be keeping track of!! Every little bit of input helps

ebayhateluv and greenbean - how do you guys do it with sticky notes and index cards? You must be very organized! I'm terrible with paper


This is how I keep track of my accounts for now. The data in this spreadsheet is fake, for demo purposes. I made it so the accounts automatically change color if they are "Suspended" or cooling down, so I don't accidentally use "infected" information from them or something. I also keep track of the account "age" in days.
I also made sure the fields are in order so when I want to register an account, I can figure out all the fake info in the spreadsheet and then it only takes a minute to copy and paste the stuff during registration.


My IP tracker is basic. The IP colors change if the IP address has become "infected" by a suspended account. And I keep track of the MAC addresses for my router so I can keep re-using the same IP's for each account. For example, jane857 will always have the IP address 55.444.222.33. I prefer keeping the IP's consistent per account, rather than getting a brand new random IP each time. I think it makes it look more believable that the account keeps logging in from the same location.

I also made these on access and linked the IP's to the Account names, but went back to using excel because it uses less system resources on the PC.

So this is what's been working for me so far. All of my new accounts are still active so it seems to be doing its job.

So what do your spreadsheets look like? Lets help each other be more efficient!

[MasterChief]

Wow!
Good Stuff!

I dont think tracking the MAC address is necessary though. (+if it was, im screwed )

[Junkymail]

Oh I don't track the MAC address for ebay. I need each MAC address in order to receive the exact same IP address per account. Each account I have has a specific IP address associated with it, but in order to retrieve the same IP each time, I need to know the MAC addy. I think this is a good tip for those of you who have dynamic IP's!

So sneakily enough, I think it makes it looks like each account keeps logging in from the same PC

[GreenBean]

Double WOW. I like color co-ordination!

[MasterChief]

Indulge this techie noob.

How do you get the same IP from a MAC address..and how do you get the same MAC address.

[jscan]

wow thats is great, mine is just a basic excel document, yours is pro great job

[Junkymail]

Originally Posted by MasterChief

Indulge this techie noob.

How do you get the same IP from a MAC address..and how do you get the same MAC address.

I have a router connected to my modem. When I edit the MAC address of the router, the ISP then assigns an IP address to associate with that MAC address until it expires.

For instance, I'll make a new account called Account2. Before I register anything I make an IP that will associate with it. So I go to my IP spreadsheet, copy one of the old MAC addresses and change a couple letters and numbers so its new and unique. When I restart the modem, a new IP is assigned! So now I use this IP for doing anything online associated with Account2.

Now when I need to go back and edit my old Account1, I change the MAC address back, restart the modem, and my old IP comes back! Keep in mind that Dynamic IP's expire anyway, so eventually a new IP might replace the old one. But whatever it changes to, it will keep using that until that one expires too! And so on.

I like being able choose specifically which IP the modem will be retrieving for me Less IP's to keep track of!

I'm not too good at explaining things, but I hope that makes sense!

[MasterChief]

Makes perfect sense, but as I said, Im Noob..

How do you choose the MAC address of the router? Something inbuilt I gotta figure out or a program from the net? I ask cause I got a router at home myself. Never knew I could use it to get a static IP.

[aspkin]

Very nice Junkymail, great information!

[Junkymail]

MasterChief - is your name based on the game Halo? If so, I loved that game lol

Originally Posted by MasterChief

Makes perfect sense, but as I said, Im Noob..

How do you choose the MAC address of the router? Something inbuilt I gotta figure out or a program from the net? I ask cause I got a router at home myself. Never knew I could use it to get a static IP.

The program to change the settings is built into your router To access it, you just use your web browser. You can check your manual how to access your routers settings. But for most routers I've owned, the address has been 192.168.0.1 - Just type that where you would normally type the web address. You need to know the username and password as well if you never logged in before. check your manual for those.

So this is what my screen looks like to change the MAC address:


And with that MAC address I always get this IP

[Junkymail]

And thank you everyone for the compliments! I guess the stuff I learned in school came to use, huh?

[2eXclusiive]

im impressed, good job
ima copy you now =D
thank youuuu

[guitarca18]

Does anyone know if this router mac hack works for comcast??? You may have just solved the "can't change my ip issue" with comcast...Man. I can't wait to go home and try this!

[philly387]

Originally Posted by guitarca18

Does anyone know if this router mac hack works for comcast??? You may have just solved the "can't change my ip issue" with comcast...Man. I can't wait to go home and try this!

I wouldn't really say it is a "hack". It is just an easy way to change from one IP to another. And yes it will work for Comcast

[octagon69]

But I could swear that Comcast doesn't work using Dynamic IPs. To receive a new IP, you normally have to get someone on their end to assign a new Ip to you.

[Scorcher]

Changing the mac address works great with comcast. Thank a bunch junkymail for the excel template.

[Exeneva]

Junkeymail, would you mind sending me one?

[aking]

How do people keep listings and sales organized with mulitple accounts? I have about 10 accounts aging and ready to sell but I am only listing on 2 at the moment. I want to list on 4 accounts with about 10 listings each, but I am afraid this will just get too confusing and time consuming. Maybe I will try to things up in excel. Just gradually start adding accounts until I get used to it.

I really feel like I need another router so I can access 2 different ip address's simultaneously.

Does anyone here currently sell on more than 4 accounts? If you could help that would be awesome. Thanks.