Math Programs with MS-Excel

BELOW ARE A FEW PROGRAMS I WROTE TO DEMONSTRATE WHAT CAN BE DONE WITH EXCEL. PLEASE NOTE:
Excel 2000 or higher versions have security levels set that may not allow You to execute my macros. The possible levels are:

High - macros are automatically disabled
Medium - User is prompted to enable or disable macros
Low - User receives no prompts, macros are automatically enabled

If You still trust my macros but are not able to execute them You must lower Your security level within Your Excel application. In order to do that You have to go thru: Tools menu -> Macros submenu -> Security Level tab. There You have to set the security level to (at least) medium or low.


© Gerald Schmidt
A program that generates barcode. Click the START-button, Excel will be loaded. Press CTRL+E and follow the instructions that will help You to enter a barcode number. The program will send the barcode to Your printer, so Your printer must be on. You can test the barcode with a scanner at Your grocery store, it will easily identify the corresponding article by the number You entered.
EXPLANATION IN GERMAN
A program that tests Your calculation skills. Click the START-button. Excel will be loaded. Press button: "Neue Rechnungen" and follow the instructions: Choose a maximum value for the MULTIPLICANT and then a maximum value for the MULTIPLIER. Excel will generate random values between "1" and Your chosen maximum value. Then choose the number of calculations You want to do. If Your entries in the blue cells are correct, the word "BRAVO" (wonderful), otherwise the word "FALSCH" (wrong) will appear.
EXPLANATION IN GERMAN
A program that plots the distribution of the Gaussian primes in the complex plain. Click the START-button: This will load the Macro "Gaussvba.xls". Then You simply press CTRL+G. A beautiful pattern will be created within a radius that You will be allowed to define. So You can either accept the default value "32" (by pressing ENTER) or overwrite it with another value (and then press ENTER). Have fun with the patterns that the program will create! You can save these patterns on your hard drive!
The only exception: This is a HTML/Javascript. The script is building up a table dynamically. For each of the 200 cells a random background-color is generated. The hexcode of that color is explicitly written into the cell for the sake of easy identification. The user can click on any cell to convert the background-color to the color of the chosen cell. Scroll down one page to have that color fill the whole screen. A neat little script to discover and try ot new color tones.