I was auditing a spreadsheet the other day and I noticed that when I used the formula auditing tools to trace dependents, a pattern came up that looked like a dog. I know…too much silly juice for me.
So anyway, I thought it would be cool to purposely write formulas so when you applied formula auditing, it made a picture.
Like this:
This is an easy one. First write these formulas.
Then place your cursor in cell H10 and select Trace Precedents under the Formulas tab. This will cause Excel to draw arrows from all the cells that feed the formula in cell H10.
Like so:
Do the same for the rest of the formulas. And you have your picture.
Here, I’ve copied and pasted a few times, took away the gridlines, and made the values white.
Here’s an April fool’s challenge.
Take your best shot at creating your own formula auditing art. Share your entry via a link in the comments field.
The coolest entry will win this book:
Here’s a tip: Draw out a frame of your picture first using lines and arrows. Then use your frame to build out your formulas. Once your formulas are built, delete your frame and apply the formula auditing.
I gotta try this, but I don’t want that book. If I win, you can donate it to an orphanage.
Ok, just had to try this, too. Here is my submission:
http://img682.yfrog.com/i/dpig.png/
Per John’s entry, I routinely take candy from children, so I have no compunction about winning the book in lieu of the orphans. I might even consider taking the book and reading it, while eating a large bowl of taffy on the front steps of the orphanage. Just a thought.
It occurred to me you may want my proof.. see the formulae here:
http://yfrog.com/1rdpigproofp
I also added a colored image with my proof (not in Excel–I draw the line at actual hard work).
I had to cheat on the snout – just entered zeroes:
http://img181.yfrog.com/i/pign.jpg/
This is a fomula auditing art formula.
https://docs.google.com/leaf?id=0B_BGP56EAtuiMTU1ZGMyZWYtYTgwYy00NGZiLWJmMGYtMjhkY2RmYTlkMGIy&hl=en