Open side-bar Menu
 The AEC Lens

Archive for March 30th, 2016

Applying the High-tech Wizardry of Sparklines to Economic Data

Wednesday, March 30th, 2016

Article source: CMDGroup

Yes, I’m an economist first, but in my secondary role as ‘tech whiz’ – my wife and kids would guffaw at that assertion – I’ve come across an exciting feature of standard Excel spreadsheets that I feel must be shared with you.

Of course, there’s always the danger that I’ve finally clued in to something everybody else has known about for years. However, I’ve asked around and it seems most people aren’t yet aware of a tool called ‘Sparklines’ that is highly worthwhile.

And neat and cool and easy to use.

Let’s suppose you have a ‘wall’ of data, such as appears in Table 1 that accompanies this Economy at a Glance. I’ve included the row numbers and column letters for ease of explanation.

The statistics in cells ‘C2’ diagonally to ‘O22’ are percent changes of U.S. put-in-place construction investment, latest 12-month averages versus previous 12-month averages.
(more…)




© 2024 Internet Business Systems, Inc.
670 Aberdeen Way, Milpitas, CA 95035
+1 (408) 882-6554 — Contact Us, or visit our other sites:
TechJobsCafe - Technical Jobs and Resumes EDACafe - Electronic Design Automation GISCafe - Geographical Information Services  MCADCafe - Mechanical Design and Engineering ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy PolicyAdvertise