"He loves me - he loves me not" Do you remember this game?
Inspired by the charts we created in Excel - check out our daisy-flower!
We created a random number version and mynumber version. With this latest you can write your own number. And you can send it to him... or her :-)
Tell you are in love - with Excel!!!
You (or to whom you send it) only need to push F9 until all the petals disappear - and you can read the answer!
e no I do not like 30 petals! redo everything ...
37 is better :-)
You can download the file from the bottom of this article by clicking on the arrow at the right-hand side (to remove the password, use "love!").
It is a simple file without VBA. The only trick we use is the iterative calculation together With a circular reference (so, remember to open it in a new Excel window). This way we can increment the value of a cell each time the user re-calculates the sheet by pushing F9. This makes the daisy flower lose its petals one by one answering your question: does he love me.
You can replace the given 5 answers with your own, local language versicle.
Seems it is just a nice gadget, but we hope you will find the technique interesting. We use a pattern for the petals and some not-really complicated formulas to make them disappear and the labels appear.
Enjoy and share!
and The FrankensTeam