Good evening everyone, Today I started a little project (I will disclose what it is at another time but you can surmise it is referencing the NSFL Bank) which turned into a bigger project and lead to some audits on the bank. The first set of audits I did was on usernames. The ones below are 1 - 5 of the list that I have compiled of 40. They are substantial and up to this point unknown errors with the bank. All of which are human error and no one on the banking team is at fault (Arguably). So no playing the blame game, it's just not a nice thing to do. If you want to blame someone blame yourself for A.) Not watching your bank transactions if you’re on this list and/or B.) You didn’t come up with a better system to check for errors because you are clearly better than everyone else. Sooooo back to the first set of audits. The easiest thing to spot in an audit is usernames that are commonly misspelled or entered incorrectly into the spreadsheet causing inaccurate counts of people's money. Some of these users haven’t even been on the forums in months or years. But the tables should still be corrected just in case. A lot of these errors come from common spelling mistakes or one mistake which in turn goes into a lot of mistakes from using autofill (something I use every time I put something in the bank). Who wants to type out @`StevenO'Sullivan` by hand every transaction? Not me. So let’s get to the ones I found (and because I am human still, I probably missed some.)
Legend
#1-40 username +/- adjustment incoming
A - This is on the archive table of the bank. So A1 would be the archive table, row 1. This is currently not editable and can only be edited by the bank creator which is @timeconsumer if I am not mistaken. Hopefully we don’t have to track down Trey Willie to get this mess cleaned up.
P - This is on the primary log table of the bank. So P1 would be primary log table, row 1. Anything on this table can be adjusted and repaired immediately by any banker.
#1 @AceBoogiieJr +$4,000,000
Transaction | incorrect entry | correct entry
A16035 aceboogiie -> aceboogiiejr
P14 aceboogiie -> DELETE(SHOULDNT EXIST)
So for the first user (I am going alphabetically) there is aceboogiiejr. As you can plainly see the username had the “jr” dropped from the name. There is also Transaction P14. The first few transactions of the primary log are all transactions from the archive log summed up. So if all your transactions equaled $5,000,000, the table would be your username + $5,000,000. That way you have a running total of all your money just in the primary log. Well obviously this user doesnt exist and shouldnt have anything in that set of transactions. That transaction from the archive table should be adding to aceboogiiejr’s account. So the transaction should be deleted and the money should be tacked onto the correct account.
#2 @ADwyer87 +$2,000,000
Transaction | incorrect entry | correct entry
P1489 adwyer81 -> adwyer87
This is a common mistake. Someone accidentally wrote a 7 instead of a one. This can be easily adjusted by correcting the name. No other action needed.
#3 @AngelTwelve +$2,000,000
Transaction | incorrect entry | correct entry
P3288 angel_twelve -> angeltwelve
Again, there is an erroneous character placed in the username causing an incorrect total.
#4 @Anti-Hype +$500,000
Transaction | incorrect entry | correct entry
A14686 anti hype -> anti-hype
P31 anti hype -> DELETE(SHOULDNT EXIST)
This time there was a character left off instead of added. Because it was in the archive table it will follow a similar fix procedure as #1. Fix the username, delete the transaction for the incorrect user and add or subtract the appropriate monies from the correct user.
#5 @Beaver +$4,000,000, dawegg +$4,000,000
Transaction | incorrect entry | correct entry
A15610 beaver'dawegg -> beaver
Ok so this one is a little different than the rest. This time beaver and dawegg had their transaction concatenated into a single transaction. This transaction needs to have dawegg removed and create another transaction as he was never paid the $4,000,000 that he was supposed to.
So the transactions that I posted here are all positive amounts. That’s the luck of the draw. There are some people that will actually be losing money on this deal (Sorry, not sorry). Also the bank managers have been informed so please don’t bug them, they are fixing these inconsistencies. This is just the first 5, crazy. Not only is it just the first 5 but it’s also the first and easiest thing I started looking for. There could be a something in the amount you were supposed to receive (1.000 instead of 1000) that made it error out but without someone looking for the mistake it wouldn’t be found. There could be a formula that is missing that makes it appear that you were given money or had money taken out but since the formula is missing its just… there. So over the course of the next few weeks I will be going through the bank sheets and fixing them and writing about them here so we are transparent and we can fix these errors from ever happening again.
Just as I finished writing most of this I realized I haven’t even started looking at the Media Payouts which is just as much if not more of a mess. So we can expect another set of articles coming from that. Last but not least, while we are fixing things. The bankers (myself included) need to come to a consensus about what date format to use. Taking all these transactions and putting them in a database gets very tiresome after fixing a couple thousand or so dates because they are “backwards” or in a format (dd/mm/yyyy OR yyyy/dd/mm) that no one else on the banking sheets has ever used.
Legend
#1-40 username +/- adjustment incoming
A - This is on the archive table of the bank. So A1 would be the archive table, row 1. This is currently not editable and can only be edited by the bank creator which is @timeconsumer if I am not mistaken. Hopefully we don’t have to track down Trey Willie to get this mess cleaned up.
P - This is on the primary log table of the bank. So P1 would be primary log table, row 1. Anything on this table can be adjusted and repaired immediately by any banker.
#1 @AceBoogiieJr +$4,000,000
Transaction | incorrect entry | correct entry
A16035 aceboogiie -> aceboogiiejr
P14 aceboogiie -> DELETE(SHOULDNT EXIST)
So for the first user (I am going alphabetically) there is aceboogiiejr. As you can plainly see the username had the “jr” dropped from the name. There is also Transaction P14. The first few transactions of the primary log are all transactions from the archive log summed up. So if all your transactions equaled $5,000,000, the table would be your username + $5,000,000. That way you have a running total of all your money just in the primary log. Well obviously this user doesnt exist and shouldnt have anything in that set of transactions. That transaction from the archive table should be adding to aceboogiiejr’s account. So the transaction should be deleted and the money should be tacked onto the correct account.
#2 @ADwyer87 +$2,000,000
Transaction | incorrect entry | correct entry
P1489 adwyer81 -> adwyer87
This is a common mistake. Someone accidentally wrote a 7 instead of a one. This can be easily adjusted by correcting the name. No other action needed.
#3 @AngelTwelve +$2,000,000
Transaction | incorrect entry | correct entry
P3288 angel_twelve -> angeltwelve
Again, there is an erroneous character placed in the username causing an incorrect total.
#4 @Anti-Hype +$500,000
Transaction | incorrect entry | correct entry
A14686 anti hype -> anti-hype
P31 anti hype -> DELETE(SHOULDNT EXIST)
This time there was a character left off instead of added. Because it was in the archive table it will follow a similar fix procedure as #1. Fix the username, delete the transaction for the incorrect user and add or subtract the appropriate monies from the correct user.
#5 @Beaver +$4,000,000, dawegg +$4,000,000
Transaction | incorrect entry | correct entry
A15610 beaver'dawegg -> beaver
Ok so this one is a little different than the rest. This time beaver and dawegg had their transaction concatenated into a single transaction. This transaction needs to have dawegg removed and create another transaction as he was never paid the $4,000,000 that he was supposed to.
So the transactions that I posted here are all positive amounts. That’s the luck of the draw. There are some people that will actually be losing money on this deal (Sorry, not sorry). Also the bank managers have been informed so please don’t bug them, they are fixing these inconsistencies. This is just the first 5, crazy. Not only is it just the first 5 but it’s also the first and easiest thing I started looking for. There could be a something in the amount you were supposed to receive (1.000 instead of 1000) that made it error out but without someone looking for the mistake it wouldn’t be found. There could be a formula that is missing that makes it appear that you were given money or had money taken out but since the formula is missing its just… there. So over the course of the next few weeks I will be going through the bank sheets and fixing them and writing about them here so we are transparent and we can fix these errors from ever happening again.
Just as I finished writing most of this I realized I haven’t even started looking at the Media Payouts which is just as much if not more of a mess. So we can expect another set of articles coming from that. Last but not least, while we are fixing things. The bankers (myself included) need to come to a consensus about what date format to use. Taking all these transactions and putting them in a database gets very tiresome after fixing a couple thousand or so dates because they are “backwards” or in a format (dd/mm/yyyy OR yyyy/dd/mm) that no one else on the banking sheets has ever used.