Tracking Multiple Accounts with Excel - How do you do it?
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 ⊗⊗⊗⊗ 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 ⊗⊗⊗⊗, 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 ⊗⊗⊗⊗ 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!
|