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

Subscribe

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Buy me a coffee

If this topic or the blog itself has been helpful, why not support further development by treating me to coffee?


Privacy Policy

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

Archive for September, 2008

Links for September 12, 2008

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


A promise kept
Utah children live their father’s dream of seeing Red Sox play at Fenway
Just when you think the world is full of cynicism and evil politicians, you come across a story like this. Sometimes people can rise to the occasion.

 
Robert Kosara of EagerEyes looks at variations of Square Pie Charts in Engaging Readers [...]

Goal Seek - Optimization Approach to a Simple Physics Problem

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
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 the following data, showing the time to drain water through a hole in a bucket, based on the diameter of the hole and the [...]

Regression Approach to a Simple Physics Problem

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


In Graphical Approach to a Simple Physics Problem I discussed my daughter’s physics homework. The problem was to determine the relationships between how long it takes water to drain from a hole in the bottom of a bucket, the diameter of this hole, and the initial height of water in the bucket. Given this relationship, [...]

Sample Parallel Coordinate Chart

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


In the Microsoft Charting newsgroup, a reader wanted to show separate lines on a line chart to compare the severity of the medical conditions of different patients after one to five visits. The question was whether it would be possible to resolve the individual patients.
A parallel coordinates chart can show an individual’s condition in front [...]

Choosing a Trendline Type

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


In Graphical Approach to a Simple Physics Problem I discussed my daughter’s physics homework. The problem was to determine the relationships between how long it takes water to drain from a hole in the bottom of a bucket, the diameter of this hole, and the initial height of water in the bucket. The data is [...]

Dial Gauge

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


I know I’ve railed against dial gauges in the past, and I’ve removed instructions for creating a speedometer type chart from my site. But this particular implementation is completely appropriate.

From The New Yorker Magazine.

Graphical Approach to a Simple Physics Problem

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


My daughter asked me about her physics homework the other night. The problem was to determine the relationships describing how long it takes water to drain from a hole in the bottom of a bucket given various hole diameters and initial water heights. Given the derived relationships, the student was to determine the time to [...]

Places to Go, Things to See (2008-Sept-05)

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


Francisco of XL Cubed announces the development of an Excel Chart Tamer utility. This utility will be an alternative charting interface, which will offer chart types and formats designed for easy creation of effective charts. A public beta is expected in October. I’m looking forward to it.

John of cellmatrix.net explains Two-Way Variance Analysis in Post [...]

Trendline Fitting Errors

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


Several years ago I helped someone who was having trouble with a fitted trendline in an Excel chart. I saved the example, because I knew I’d have a blog someday, and I’d need a topic. I will use this example to describe a number of errors people encounter when fitting data. The errors are listed [...]

Upcoming Appearances

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


2008 East Coast Excel User Conference

Wednesday - Friday, September 24-26, 2008, Atlantic City, New Jersey
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 leaders in the Microsoft Excel community: Bernard Liengme, Damon Longworth, Bob Umlas, and Jon [...]

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