Excel will tell you the truth about love

posted Jun 7, 2012, 7:12 AM by Krisztina Szabó   [ updated Feb 11, 2014, 6:11 AM ]
"He loves me - he loves me not" Do you remember this game?

http://heathengrrl.blogspot.hu/2006/10/loves-me-he-loves-me-not-daisy-story.html

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!

With love,
Kris
and The FrankensTeam

Č
Ĉ
roberto mensa,
Jun 7, 2012, 7:12 AM
Ĉ
roberto mensa,
Jun 7, 2012, 7:12 AM
Comments

Basic bibliography by r

Basic bibliography by Kris

A-Z