PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart

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

Site search


Recent Posts

Recently Commented

October 2008
S M T W T F S
« Sep    
 1234
567891011
12131415161718
19202122232425
262728293031  

Archive


 

Categories


 

Archive for 'Educational'

Graphical Approach to a Simple Physics Problem

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

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 [...]

Upcoming Appearances

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

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 [...]

Rolling Wheel Animation

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A college science professor named Roger Blickensderfer wrote to me about an animation he was working on. He wanted to trace the path followed by a point on the rim of a rolling wheel. Roger had cobbled something together, and I fiddled with it, and it kind of worked. But I decided I wanted it [...]

Physics Lesson

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A high school physics teacher was asking questions in the Excel programming newsgroup about his VBA procedure that accepted input values (time, position, velocity, and acceleration) from the workbook, calculated values of position and velocity vs. elapsed time, and charted the results. I answered a couple of his VBA questions, but I suggested that he [...]

PTS Charting Classes

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

On infrequent occasions I take my show on the road and offer classes on advanced charting techniques. If I am taking part in an Excel User Conference, for example, I will usually offer a couple classes. There are two classes in particular that I like to present, and that participants rate highly:

Advanced Charting Techniques
Excel Charting [...]

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