Category Archives : spreadsheets

Home  >>  spreadsheets

Lecturing OR

I have to admit I never though I would be lecturing an operations research related subject. However, it is with great pleasure that last term I was able to lecture Econometrics with computer assistance (we used Gretl, which is open source) to undergraduate level. This term I have started to…

Netflix Prize for Dummies [III]

On July 30, 2007, Posted by , In databases,Netflix,spreadsheets, With 1 Comment

Now we’ve got the data into a MySQL database, so next step is accessing it from our prefered application (sometimes, that means MS Excel, i.e.). So, let’s go: 1) Make sure you system is up to date (specially the Jet Engine). 2) Download and install the last MySQL ODBC Connector….

Return On Investment

On July 4, 2007, Posted by , In business,spreadsheets, With No Comments

When analysing investment projects someone has to deal with the golden question “is it going to be profitable?”, followed by, “when?”. There are so many ways of answering these questions, but at the moment I’m going to focus on 3, very briefly: 1) Net Present Value (NPV).- Get all the…