views
STUART HARDER CHARTING TEMPLATES (Excel-based Standard Celeration Charts)
Stuart Harder, Owen White, Scott Born
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
TOP
IMPORTANT NOTES about the templates--Please READ BEFORE downloading.
Problems or Questions
Stuart Harder has given permission for users to email him questions about the templates.
(If you don't have questions but find the templates useful, a note of thanks would be appreciated.)
If you have problems with the templates (can't open, crashes, incorrect operation)
please contact Stu Harder, and me so we are aware of issues, and can post a note on this site notifying others.
Please note
- the file name of the template,
-
the version of Excel that you are using
-
the operating system of your computer
-
ex: Windows XP, or
-
MacOS 8, and
-
SPECIFIC problems with the template,
-
ex: "Excel shuts down", or
-
"can't open file with "corrupted file" message", etc.
This helps Stu to figure out what might be the problem, and helps me in noting the specific problem. Thanks!
TOP
Issues and Incompatibilities
- There is a possible incompatibility with Excel 2007 due to non support of the macro programming language.
- The templates so far work well with Excel 2003.
- Incompatibility with Open Access Spreadsheets
- The Excel Charting templates are NOT compatible with OpenOffice Calc, and will not perform or chart correctly if used with that application.
- This is due to incompatibilities in visual basic language used in the macro programming of OpenOffice vs. Microsoft applications.
TOP
The Standard Celeration Chart: Instruction Manual for the Excel Template (3/11/09)
LARGE FILE (8 Mb): Please right-click and SAVE file.
USER MANUAL, SCCFB.pdf
TOP
Latest versions of the templates (12/15/08; 6/14/07 for 0.1-100,000 SCCFB_ycpy_v7_1.xls )
Note from Stuart Harder,
"...Version 7-3 of the
- daily per minute,
- stacked dots daily per minute
- daily per day,
- weekly per week,
- monthly per month,
- yearly per year
are all upgraded with the fix.
I also updated a routine users may not have known about. This routine removes the connecting lines between data points that border phase change lines.
- To remove connecting lines, invoke Control+Shift+K (Windows) or Command+Option+Shift+K (Mac).
- To reverse the process, invoke Control+Shift+J (Windows) and Command+Option+Shift+J (Mac).
Be sure to do this before removing phase lines as the the program needs to know where to look for the disconnected data points.
There may be test data in the template. Clear before using"
TOP
12/15/08
LARGE FILE (2.2Mb): Please right-click and SAVE file
Daily Count per Minute
TOP
Updated Stacked Dots, NOW Multiple Frequencies SCCFB(mf)(dcpm)v7-3.xls
12/15/08
LARGE FILE (4.3 Mb): Please right-click and SAVE file
Updated Stacked Dots Chart,NOW Multiple Frequencies daily counts per minute
TOP
Daily Count per Day SCCFB dcpd v7-3a.xls (like Dpday-2EC DAILY per day)
12/15/08
LARGE FILE (2.0 Mb): Please right-click and SAVE file
Daily Count per day
TOP
Weekly Count per Week SCCFB wcpw v7-3.xls (like Wpwk-3EC WEEKLY per week)
12/15/08
LARGE FILE (2.2 Mb): Please right-click and SAVE file
Weekly Count per Week
TOP
12/15/08
LARGE FILE (2.1 Mb): Please right-click and SAVE file
Monthly Count per Month
TOP
Yearly Count per Year 1-1,000,000 SCCFB ycpy v7-3.xls (like YC-1EN YEARLY per year)
12/15/08
To display yearly counts where zero counts are not anticipated. This template is scaled from 1 to 1,000,000.
LARGE FILE (2.1 mb): Please right-click and SAVE file
Yearly Count per Year. 1-1,000,000
TOP
Yearly Count per Year 0.1-100,000 SCCFB_ycpy_v7_1.xls
6/14/07
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)
LARGE FILE (2.0 Mb): Please right-click and SAVE file
Yearly Count per Year. 0.1-100,000**
TOP
views
Recent visitors
Younow
Someone else2 hrs ago
Someone else2 hrs ago
Someone else5 hrs ago
Someone else19 hrs ago
Someone else21 hrs ago
Someone else1 day ago
Someone else1 day ago
Someone else1 day ago
Someone else1 day ago
2/8/08 6/1/2018
Comments (3)
Regina Claypool-Frey said
at 8:27 am on Mar 11, 2009
3/11/09: Manual added by Stu Harder
Nice Stu--perfect.
3/11/09 Header for Manual changed from "Normal" to "Header3" to show up in Table of Contents, and font color to RED to accentuate from the rest of the text by RGCF
Regina Claypool-Frey said
at 12:27 pm on Feb 23, 2010
2/23/10 - Reformatted the page for appearance, and corrected dead links to Behavior Research Company.
Regina Claypool-Frey said
at 12:28 am on May 11, 2010
Possible FAQ, IF there is a need to unlock a page, per a 5/10/10 question and reply by Stu Harder.
1. Start fresh. On the Progress Record page, click the green button and clear the entire workbook of its data. The start over.
2. An alternative. On the Progress Record page, click the button to clear the raw data.
3. A final alternative. Unlock the Progress Record page with Cntl+Option+U (Command+Option+Shift+U on a Mac).
Please be certain you a attempting to enter data in the correct cells of the Progress Record page. You should be entering data in columns E, F, and G only.
You don't have permission to comment on this page.