|
|
|
|
|
 | Solve your Sudoku with Excel/VBA |
| Mark generator for the overworked teaching academic |
| Simple Slot machine programmed with Java Script |
Back
to Main Modeling Topic List
|
Solve your Kakuro: Beta version under Kakuro(v300507)(P).xls (VBA Code is protected) |
|
Solve your Sudoku with Excel/VBA »download (version 13 June 2008)This is a VBA enhanced Excel spreadsheet which solves your Sudoku. Keen to hear whether you find any bugs. I am sure there are much more sophisticated solutions somewhere on the web but it was fun programming this. |
|
Mark generator for the overworked teaching academic »download |
Saves time allocating marks to your class after a test. This mark generator allows you to generate them on a random basis with given mean and standard deviation. Press button until you are happy with the grade distribution of your class. The screenshot below is from the model for a class with 53 students. I believe this distribution would keep everybody happy.
Grade Distribution
| Simple Slot machine programmed with Java Script »Slot Machine |
Java Script is not usually a language used by the financial modeler. It is too slow and the syntax is rather cumbersome (a common feature of lower level programming languages). On the other hand, however, it requires no special software tools as programs are simple text files interpreted by any web browser. The financial modeling courses at Waikato Management School include an assignment that requires students to program a web based Black&Scholes option calculator using either Java or VB Script. This simple JS slot machine serves as an example and starting point. There is also a VBS version for this machine: VBS Simple Slot Machine.
|
