| buppy |
|
From what I have come across, Excel spreadsheets are often used to produce nice looking tables and the functions used are seldom beyond the arithmetic ones (because your boss doesn't ask for anything more). Here are some Microsoft Excel applications which I hope can give you an idea on how the seldom tapped power of Excel can produce pretty solutions to simple problems. They were originally developed for all kinds of reasons - from plain experimenting, to wanting to solve a simple problem, for fun and as teaching tools (for kids). I call these buppy solutions because using Excel sure beats using a pen and paper, yah? If you are unsure how to download the spreadsheets, read the instructions below. If there's a solution you would like to see let me know and I'll see what I can do. Or if you have an Excel (or Lotus 1-2-3) solution you want to share, write me and I will post it here. |
|
Numbered Days Who doesn't know their own age? But how many days old are you? If you are not yet 26 you haven't lived 10,000 days. numdays.exe (88KB) - preview, download, Same Calendar Do you know that a leap-year calendar is repeated only once every 28 years? If you still have your historic 2000 calendar you can re-use it in 2028. samecal.exe (76KB) - preview, download Chinese Zodiac Sir Isaac Newton was born on Christmas Day of 1642. So which Chinese zodiac sign do you think he was born under? chinzod.exe (72KB) - preview, download
|
Excel versions you'd still remember Excel 95 (ver 7) Excel 97 (ver 8) Excel 2000 (ver 9) Excel 2002 (ver 10) Excel 2003 (ver 11)
|
|
His Excel-lencies |
Multiplication Table Created by Jim Hubbard. Suitable to test one's multiplication skill using randomly generated tables. multitab.exe (120KB) - preview, download Addition Table Jim Hubbard's creation modified by yours truly to become an addition table! Suitable for kids who are not into multiplication yet. addtable.exe (120KB) - preview, download Fraction Teacher Spare yourself the drawing and re-drawing a pie to get the idea of fraction across to a kid. fraction.exe (72KB) - preview, download Number reader Chip Pearson's logic is behind this touched-up solution. Great that your toddler can add 2 numbers together. Now let's hear her read 987,654,321 as a value and not a countdown. readnum.exe (516KB) - preview, download
|
||
|
Prime Numbers So, is 1,001,123 a prime number? Your calculator can't tell you, can it? Here's something that can. primenum.exe (76KB) - preview, download Bank Interest As uninterested as you may be, you'd still want to make the most out of your hard-earned cash when choosing a fixed deposit plan, don't you? bankint.exe (80KB) - preview, download Move Tiles Created by John Walkenbach. One of many traditional games that now can be played on the computer. |
Did you know? You can't name a sheet History. You can use =char(128) to get the Euro (€) symbol. What about ™, © and ® ? |
|
Each of the solutions is zipped and made into an executable. To download, click on the link, save it to a folder of your choice and when that's done double-click it to unzip it. When you open the spreadsheet and are prompted with a warning about macros select the yes or enable macro button or you won't get to enjoy all the features of a solution. They come with little or no instructions on how to use them as I think they are pretty simple and self-explanatory. However if you are still unsure just let me know. Have fun! |