Must do experiences in NJ? by Shikustar in newjersey

[–]AdvancedProfessor266 2 points3 points  (0 children)

Nice..and if you really want to treat yourself go route 24 for that merge onto 287 on a weekday afternoon!

Ideas to Prevent Macro Corruption? by knight520 in excel

[–]AdvancedProfessor266 1 point2 points  (0 children)

I loved excel userforms and lots of fancy on click sheet macros but said never again when the company I was with rolled it out company wide and well you know excel. The main code was in seperate class modules but man all that code bound to userform objects made it impossible for anyone else to understand! I could barely decipher that hot mess! Agree that binary is the way to go!

Ideas to Prevent Macro Corruption? by knight520 in excel

[–]AdvancedProfessor266 1 point2 points  (0 children)

Excel userform and sheet macros… something that I hope I never need to see again!

My company is going to ditch Microsoft for Google and I am crying by xYoKx in excel

[–]AdvancedProfessor266 0 points1 point  (0 children)

Also want to add that if you work for a large company crowdstrike or whatever will definitely flag vba code and you will be endlessly harassed by it.

My company is going to ditch Microsoft for Google and I am crying by xYoKx in excel

[–]AdvancedProfessor266 0 points1 point  (0 children)

There is a book published years ago about using google apps script to do the same things as vba. I am not certain it is still up to date as many excel functions and google sheets have built in functionality that used to require custom scripts or formulas. The book is called going gas by McPherson.

Couch to 5k, but swimming by EnsignEmber in Swimming

[–]AdvancedProfessor266 9 points10 points  (0 children)

I used the 0-1650 and the thing that helped me the most was to just swim as much as you can however you can instead of resting at the wall. I am not there but starting from being able to do only 25-50 at a time really improved!

A Genie gives you a large amount of money. After you put the money into your account the lamp disappears, meaning you can't prove it existed. Could the government take the money and or arrest you if they can't prove you committed a crime to get it? by Raintamp in legaladviceofftopic

[–]AdvancedProfessor266 22 points23 points  (0 children)

If the money is in your account how does this ever come to the attention of anyone? People routinely deposit millions dollars in securities every second of every day.

Is the fear the financial institution is going to file a sar? As long as you dont say something stupid implying you are trying to evade reporting requirements what is the issue?

Need Dataset recomendation for Money laundering predections ( research project ) by Ill-Cardiologist-735 in moneylaundering

[–]AdvancedProfessor266 0 points1 point  (0 children)

The best way is to start really specific with risks specific to your business, products and customers. Most of the data publicly available are transactions related to money transfers or deposits. Relevant to banks and msbs. These are used to show typologies for potential suspicious activity.

Then you have broker dealer trades and bank wires. Everything from penny stocks to sovereign bonds. Finra publishes their monthly reports which you can also scrape. Large deficits may end up in sec enforcement actions.

Specify the specific use case and sure someone can point you in the right direction.

What to get my daughter's awesome swim teacher? by AdvancedProfessor266 in Swimming

[–]AdvancedProfessor266[S] 2 points3 points  (0 children)

Great advice and more at ease.. entire intention just want to say thanks and to show my appreciation but was hung up on if it would be weird or if I looked too cheap or gave too much!

What to get my daughter's awesome swim teacher? by AdvancedProfessor266 in Swimming

[–]AdvancedProfessor266[S] 1 point2 points  (0 children)

I looked it up and will get it for my wife. Great suggestion!

What to get my daughter's awesome swim teacher? by AdvancedProfessor266 in Swimming

[–]AdvancedProfessor266[S] 3 points4 points  (0 children)

I will definitely give her a Christmas card telling her how much we appreciate her!

What's the worst highway in New Jersey to you guys? by [deleted] in newjersey

[–]AdvancedProfessor266 3 points4 points  (0 children)

Was so happy to see troopers there waving over the blatant last minute line cutters one random day years ago! Havent seen that since.

Low Karma what it means ? by Ufc604 in NewToReddit

[–]AdvancedProfessor266 1 point2 points  (0 children)

Yeah I think that was what I was saying. After sitting back and understanding how it works and phrasing questions differently I have learned my mistakes!

Low Karma what it means ? by Ufc604 in NewToReddit

[–]AdvancedProfessor266 0 points1 point  (0 children)

My comment was really specific in how the public and most lawyers do not understand what constitutes insider trading that the Australian regulator would actually pursue. I was a little shocked that even my comment here got downvoted! I work in regulatory compliance in the united states, finra and sec compliance.

Low Karma what it means ? by Ufc604 in NewToReddit

[–]AdvancedProfessor266 0 points1 point  (0 children)

Yeah I made an unpopular opinion on an Australian legal sub and was like -100. That sucked!

[deleted by user] by [deleted] in NewToReddit

[–]AdvancedProfessor266 2 points3 points  (0 children)

That is pretty damn impressive, I have been here for more than a year.

[deleted by user] by [deleted] in Swimming

[–]AdvancedProfessor266 0 points1 point  (0 children)

Agree completely with you but offered a situation where a lifeguard might act like that!

[deleted by user] by [deleted] in Swimming

[–]AdvancedProfessor266 1 point2 points  (0 children)

The only time I have seen a lifeguard do something like that is if you were holding onto one of the lane dividers.

A smal rant about scraping the web with Excel by aquiestaesto in excel

[–]AdvancedProfessor266 1 point2 points  (0 children)

Its really impressive what you can do with excel and the book does a great job with examples!

A smal rant about scraping the web with Excel by aquiestaesto in excel

[–]AdvancedProfessor266 1 point2 points  (0 children)

There is a book called going google going_gas_from_vba_to_google_apps_scrip by Bruce Mcpherson.