DISCLAIMER: The information on this site is presented on an "as is" basis, and does not claim to present definitive information, make recommendation or to represent such official bodies such as the Standard Celeration Society. Users of this site agree that the owner of the site or authors of pages and articles are indemnified against legal liability
To return to Precision Teaching wiki
Excel Charting Templates
EXCEL CHARTING TEMPLATES--Stuart Harder, Owen White, Scott Born
Updated Stacked Dots Chart-NOW Multiple Frequencies Chart
SCCFB(mf)(dcpm)v6-0a.xls
MORE COMMENTS AND TECHNICAL NOTES ON THIS TEMPLATE
Daily Count per Minute
SCCFB_dcpm_v7_1.xls
COMMENTS AND TECHNICAL NOTES ON THIS TEMPLATE
(like a Dpmin-11DC DAILY per minute chart)
Daily Count per day
SCCFB_dcpd_v7_1.xls
(like a Dpday-2EC DAILY per day).
Monthly Count per Month
SCCFB_mcpm_v7_1.xls
(like a Mpmon-3EC MONTHLY per month)
Weekly Count per Week
SCCFB_wcpw_v7_1.xls
(like a [Wpwk-3EC WEEKLY per week)
Yearly Count per Year. 1-1,000,000
SCCFB_ycpy_1__v7_1.xls
To display yearly counts where zero counts are not anticipated. This template is scaled from 1 to 1,000,000.
(like a YC-1EN YEARLY per year)
Yearly Count per Year. 0.1-100,000
SCCFB_ycpy_v7_1.xls
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)
Yearly per year 0.1-100,000 v.7-0
Excel--PLEASE RIGHT-CLICK & SAVE. THANKS!
SCCFB_ycpy_v7_0
Yearly per year 1-1,000,000 v. 1.7.0
Excel--PLEASE RIGHT-CLICK & SAVE. THANKS!
SCCFB_ycpy_1_v7_0
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"
Stacked dots EXCEL template v.6-0b (SCCFB(mdf(dcpm)v.6-0b)
Excel--PLEASE RIGHT-CLICK & SAVE. THANKS!
SCCFB(mdf(dcpm)v.6-0b
About the template
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
Top
SCCFB (daily count per minute) Charting Template v7-1_w
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.
Top
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
Comments (0)
You don't have permission to comment on this page.