Worlds Colliding: Convert a Digital Photo into an Excel Spreadsheet
- Visit http://think-maths.co.uk/spreadsheet  and choose a photo of your choice, as shown in Figure 1.
- Click the Download Excel button to download your resulting Excel file.
Figure 1: Any digital photo can be converted into an Excel spreadsheet.
- If you use a mouse with a scroll wheel, hold down the Ctrl key while you spin the scroll wheel.
- Choose Zoom on the View tab and then specify 10 in the custom field.
- Use the Zoom Slider in the lower right-hand corner of your screen, as shown in Figure 4. You can toggle the Zoom Slider on or off by first right-clicking on Excel's Status bar at the bottom of the screen.
Figure 2: You'll only see a tiny portion of your photo until you zoom out.
- Click on any cell within your photo.
- Choose Conditional Formatting from the Home tab and then choose Manage Rules.
As shown in Figure 5, you'll see the technique relies on the Graded Color Scale, where numbers between 0 and 255 correspond to specific shades of color. Thus, by writing the numerical data from a digital photograph, Parker is able to reconstruct any digital photo within an Excel spreadsheet.
David H. Ringstrom, CPA heads up Accounting Advisors, Inc., an Atlanta-based software and database consulting firm providing training and consulting services nationwide. Contact David at email@example.com  or follow him on Twitter . David speaks at conferences about Microsoft Excel, and presents webcasts for several CPE providers, including AccountingWEB partner CPE Link .