Message from Stuart Harder, 6/11/07

"Here are two versions of the yearly count per year template.

The first is based on a six-cycle scale of .1 to 100,000. Use this template to display data with zero-count years as the template will place zero counts just below the record floor. (The record floor is usually set at 1.0 unless partial data years are present).

The second template may be used to display yearly counts where zero counts are not anticipated. This template is scaled from 1 to 1,000,000.

I've been working with Dennis Edinger to test these templates on Excel 2007 but I have not had a chance to verify that these two are error-free. I've made the same corrections to these two templates as I've done to others that now work, but it is still no guarantee that all will be well until the test is done.

Should anyone using the templates encounter difficulties, please let me know. Thanks.

Stu"

Sat, 22 Jul 2006 13:10:13 -0500

Reply-To: Precision Teaching/Standard Celeration Charting

From: Stuart Harder

Subject: Updated Stacked Dots Chart- Now called the Multiple Frequencies

Chart

I want to take this opportunity to post a new and improved version of

the stacked dots template to the list. Here is a list of improvements:

A. In addition to the stacked dots charts (line free and blue line

versions), there are a number of charts that represent different ways to

move from multiple daily frequencies to a reduced data set. These

charts are:

1. First Frequency of the Day (FFOD)

2. Total Frequency of the Day (TFOD) - acceleration and deceleration

series are based on total daily frequencies taken across all

timings divided by total performance time (the sum of the record

floors)

3. Median Frequency of the Day (MFOD)

4. Highest Frequency of the Day (HFOD) - this chart links the

deceleration frequency to the highest acceleration frequency

obtained for a particular day. We had referred to this chart as

the Best Timing of the Day and my first run at this chart plotted

best acceleration and best deceleration timings for the day. The

present method seems, because of the time-lock between

acceleration and deceleration series, to be more reasonable.

5. Min/Max - plots the highest and lowest acceleration frequency on a

day line and plots the highest and lowest deceleration frequency

for that same day line. This is a very good chart because it

preserves total bounce while allowing the eye to follow the jumps

and turns.

6. Best-Worst Accuracy Index - plots the best and worst case accuracy

ratios for each day. Dashed horizontal lines break out % Correct

on the right hand ordinate.

Each chart is designed to give you a different view of your data and

allows one to see the consequences of choosing one data reduction method

over another.

B. Trend Line Methods. This template supports only two methods for

finding the celeration line:

1. Median Slope (Owen White). This is a new and improved routine

based on Owen's work. The reader should review the paper Owen

wrote on this method and I can make it available to the list with

Owen's permission. After fairly extensive testing with large data

sets I discovered that the normally proficient 'double back'

criterion for finding the celeration line gets bogged down as it

cycles through potentially thousands of iterations to find a

solution. While the routine might ultimately return the best

line, the time-cost was prohibitive. I, therefore, made a command

decision to force the routine into a linear regression solution

after 10 iterations. This seemed a reasonable criterion as most

times the median slope method will result in a solution within 3-5

iterations. I followed this same solution when the double back

criterion overtly fails. Owen proposed other solutions to this

special case but they pose other programming difficulties I did

not wish to tackle. If anyone is interested in how I approached

the solution to Owen's method, please write me and I'll work up a

summary.

2. Linear Regression . This is the same routine as before but the

manner in which the data are handled has been made very efficient

resulting in tremendous speed gains.

C. Celeration Lines by Specific Chart . In my initial set up with the

stacked dots chart, I did not pay attention placing celeration lines on

the data reduction charts. In this version, no matter which chart you

select (except min/max and the best-worst accuracy index charts which do

not support celeration lines), the celeration finder moves the data for

the specified dates and the specific data reduction method into the

computational routine. This results in a unique set of celeration lines

for each chart.

D. Bounce Calculations . This version of the template takes advantage of

Excel's built in functions to vastly improve the speed for finding up,

down, and total bounce.

E. Aimstars . This version of the template uses blue up and down

pointing triangles for Aimstars. If you do not see these triangles when

you enter the date and frequencies, you will see an "s" or "t" on the

chart instead. Click ONE TIME on the letter "s" or "t". Change the

font to "Monotype Sorts." This will change the letter to the

appropriate symbol. The template attached to this post should present

Aimstars correctly on Windows machines, but perhaps not for Macs.

Well, that's it. Please give this template a try. Oh, there are data

on this template so you can see what things look like. I have buttons

on the Progress Record page to clear all of the raw data and all

celeration lines. Go to the Notes and Phase Change page and click the

button there to erase phase change lines, and go to the Aimstar page to

find the button to erase aimstars. Also, go to the Setup page, select

everything from the name to just above the Synch Date and then select

Edit->Clear->Contents. Once you've cleared everything out, save the

clean copy.

Feel free to contact me on or off list with questions, comments, or

suggestions.

Best Regards,

Stuart R. Harder

5/1/07 NEW 2.1Mb Excel file; please RIGHT-CLICK and SAVE

SCCFB (daily count per minute) Charting Template v7-1_w

Note from Stu on the template:

"...I've spent quite a bit of time on the daily count per minute template

(now version 7-1(w)). Actually, I don't think the specification for

Windows with the (w) matters any more, but just in case I am going to

keep the designation.

All fonts have been set to Microsoft's arial, arial bold, and

wingding3. These three fonts are part of Windows basic font package so

there should be no forced substitutes.

The user can now add celeration lines to the Accuracy Ratio chart.

There is a new chart added to the template called the Correlation

Chart. It follows Eric Haughton's suggestion to correlate Incorrects

with Corrects. I am not satisfied with the final form of this chart,

but it is a good start. Ultimately, I'd like to set this up to plot

data points in different colors for each phase or condition on the

Standard Chart. This will permit easy examination of phase differences.

The Summary Table contains the addition of columns that calculate the

relative change in the Absolute Mean Ratio from one phase to the next.

This was suggested by Johnson and Pennypacker. The Absolute Mean Ratio

(AMR) is a superb measure of variability that compares the ratio of

every data point in pairwise fashion to every other point.

4/25/07 NEW 1.88Mb Excel file; please RIGHT-CLICK and SAVE

SCCFB (daily count per minute) Charting Template v7-0_w

Updated further debugged version of the template.

I have deactivated the link for the previous version of the template below, but left the information up for reference.

4/13/07 1.88Mb Excel file

SCCFB (daily count per minute) Charting Template v7-0

Owen White, Stuart Harder and Scott Born

1.88Mb, Excel file

Note: this is powerful, but may be technical for newbies

Accompanying instructional video is being completed by Stu Harder and is planned

for release and posting here at the end of the month.

In the meantime, if you get stuck or have questions, Stu Harder has given

permission for users to send him questions at contact