This site under reconstruction.
This post will be a short one since I’m working on a project for a friend. The random function in Excel is kind of a neat function. There are two: 1) rand() and randbetween(a,b). Some uses for it are: 1) Randomize your numbers in Monte Carlo simulation; 2) Randomly organize your numbers if you want to…
The last post was a little puzzle on determining tax rates if the computer is not cooperating. This is an old puzzle from back in the early 90’s, so we shouldn’t face this kind of issue today. At least, I hope things have improved. Please see prior post for the description of the puzzle since I will jump…
Suppose you were handed an assignment one day, one which your boss and co-workers could not figure out. They needed to figure out which tax amounts were related to which expenses. For some reason, the computer system dished out a list of numbers with no rhyme or reason or description. The only clue you had…
“Financial services firms such as Lehman Brothers, Bear Stearns, Morgan Stanley, and JPMorgan Chase have contracted out number crunching and financial analysis to Indian MBAs…And throughout India, you’ll find chartered accountants who prepare American tax returns….” p38, A Whole New Mind, hardcover, Daniel Pink. “In 2003, some 25,000 U.S. tax returns were done in…
I’m still working on converting numbers from PDF files so I haven’t had a chance to write here or come up with decent accompanying pictures. I couldn’t convert from PDF straight to Excel; I had to do a roundabout method via converting first to Word and then copying and pasting from Word to Excel. This method…
Ever run across a situation where you download data and they don’t line up properly? Or your data is downloaded as a report with lots of empty white spaces to make your report look nice but is not convenient for data analysis? Or you have a PDF instead of nice data? Right now I’m helping…
You must be logged in to post a comment.