PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

Waterfall Chart
Box and Whiskers


 

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Archive for September, 2008

Animated Dashboards?

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

The Dashboard Spy wrote about Animating Dashboard Charts with Flash on the Dashboards by Example blog. The examples in the Spy’s post were taken from our friends at Fusion Charts:

financial flash dashboard demo
sales flash dashboard demo
sales management dashboard
airline dashboard demo

As I discussed in my comment to the Spy’s post is that a little animation goes [...]

Waterfall Utility - Last Time I’ll Bug You

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Nearly a month ago I announced my first commercial utility, the PTS Waterfall Chart Utility. Last week I announced a Waterfall Utility Update with a couple fixes and enhancements.
If you want to download a trial version, or purchase the professional version, go to PTS Waterfall Chart Utility. To review the documentation, go to PTS Waterfall [...]

Excel User Conference Recap

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

 
The 2008 East Coast Excel User Conference was held last Wednesday through Friday. We met at the Trump Taj Mahal casino and hotel, I mean, resort (which doesn’t mean sort again).
The conference was organized by Damon Longworth, and the presenters included Damon as well as Bob Umlas, Bernard Liengme, and myself.
The rigorous three-day schedule [...]

Macs vs. PCs

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Chandoo has posted the new Microsoft Ads in Microsoft says ‘I am PC’ and it is brilliant. Contrary to my expectations, especially after the abortive Bill and Jerry spots, I enjoyed these ads. Microsoft finally has countered those insipid Mac vs. PC ads (see review in Slate), in a tasteful and clever way. Hey, I [...]

Waterfall Utility Update

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

 
Three weeks ago I announced my first commercial utility, the PTS Waterfall Chart Utility (blog entry). If you want to download a trial version, or purchase the professional version, go to PTS Waterfall Chart Utility. To review the documentation, go to PTS Waterfall Chart Utility Documentation.
Today I’ve released an updated version. This version includes the [...]

2008 Excel User Conference - Next Week

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

The Microsoft Excel User Conference will be held on September 24-26, 2008, at the Trump Taj Mahal, Atlantic City, New Jersey. That’s only a few days from now.
The conference will feature working sessions and classes designed to expand a user’s working knowledge of the dominant spreadsheet software. These sessions will be led by respected [...]

Interesting Stuff (19 Sept 2008)

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Fewer links today, in fact, fewer posts all week. It’s been rather busy. . . .

Microsoft wants you to Give Us Feedback for Microsoft Office 2007. No, really. (Thanks for the link, Echo.)

 

Sept. 12, 1958: Kilby Chips In, Integrates Circuit (Wired Magazine). I didn’t see this link in time to include it with my last [...]

The Purpose of Charting

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Raymond Chen posted recently that The purpose of charts is normally to make information easier, not harder, to understand.
Not always. More often the purpose of a chart seems to be to:

Make the presenter look smart, or at least cool.
Make the presenter’s product look better than the competition, despite the facts.
Accentuate (fabricate) the positive and obfuscate [...]

Logarithmic Axis Scales

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Dr. Nicolas Bissantz wrote in Do time series charts really compare time series? about time series being difficult to compare. The chart he discussed showed the cost of energy for three different heating methods. Says Nicolas, “The lines suggest that the price for heating oil has exploded, while electricity and natural gas have increased moderately.”
[...]

SOLVER - Optimization Approach to a Simple Physics Problem

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

In Graphical Approach to a Simple Physics Problem and Regression Approach to a Simple Physics Problem I have discussed approaches to solving my daughter’s physics homework. Basically, the problem started with this data, showing the time to drain water through a hole in a bucket, based on the diameter of the hole and the initial [...]

Create Excel dashboards quickly with Plug-N-Play reports.