| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Work with all your cloud files (Drive, Dropbox, and Slack and Gmail attachments) and documents (Google Docs, Sheets, and Notion) in one place. Try Dokkio (from the makers of PBworks) for free. Now available on the web, Mac, Windows, and as a Chrome extension!

View
 

FrontPage

This version was saved 11 years, 9 months ago View current version     Page history
Saved by Regina Claypool-Frey
on February 23, 2010 at 2:01:04 am
 

  views

STUART HARDER CHARTING TEMPLATES (Excel-based Standard Celeration Charts)


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 go to the  Precision Teaching Hub and Wiki


 

EXCEL CHARTING TEMPLATES--Stuart Harder, Owen White, Scott Born

 


IMPORTANT NOTES about the templates--Please READ BEFORE downloading.

Problems or Questions

 

Stu Harder has given permission for users to email him questions about the templates. If you don't have questions, a note of thanks would be appreciated :-). THANK YOU STU!

If you have problems opening or other with the templates, 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, ex: SCCFB_dcpm_v7_3,
  • the version of Excel that you are using, ex: Excel 2003,
  • the operating system of your computer, ex: Windows XP, ex: 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

 

  1. There is a possible incompatibility with Excel 2007 due to non support of the macro programming language.
    1. The templates so far work well with Excel 2003.
  2. Incompatibility with Open Access Spreadsheets
    1. The Excel Charting templates are NOT compatible with OpenOffice Calc, and will not perform or chart correctly if used with that application.
      1. This is due to incompatibilities in visual basic language used in the macro programming of OpenOffice vs. Microsoft applications.

 

TOP


12/15/08 Latest versions of the templates

 

Note from Stu Harder,

 

"...Version 7-3 of the daily per minute, daily per day, weekly per week, monthly per month, yearly per year, and stacked dots daily per minute 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


3/11/09 The Standard Celeration Chart: Instruction Manual for the Excel Template

 

LARGE FILE (8 Mb): Please right-click and SAVE file.

USER MANUAL, SCCFB.pdf

 

 

TOP


12/15/08 Daily Count per Minute SCCFB dcpm v7-3.xls

(like a Dpmin-11DC DAILY per minute chart)

 

LARGE FILE (2.2Mb): Please right-click and SAVE file

Daily Count per Minute

 

 

TOP


12/15/08 Updated Stacked Dots, NOW Multiple Frequencies SCCFB(mf)(dcpm)v7-3.xls

 

LARGE FILE (4.3 Mb): Please right-click and SAVE file

 Updated Stacked Dots Chart,NOW Multiple Frequencies daily counts per minute

 

 

TOP


12/15/08 Daily Count per Day SCCFB dcpd v7-3a.xls

(like a Dpday-2EC DAILY per day)

LARGE FILE (2.0 Mb): Please right-click and SAVE file

Daily Count per day

 

 

TOP


12/15/08 Weekly Count per Week SCCFB wcpw v7-3.xls

(like a [Wpwk-3EC WEEKLY per week)

LARGE FILE (2.2 Mb): Please right-click and SAVE file

Weekly Count per Week

 

 

TOP


12/15/08 Monthly Count per Month SCCFB mcpm v7-3.xls

(like a Mpmon-3EC MONTHLY per month)

LARGE FILE (2.1 Mb): Please right-click and SAVE file

Monthly Count per Month

 

 

TOP


 

3/11/09 The Standard Celeration Chart: Instruction Manual for the Excel Template

 

LARGE FILE (8 Mb): Please right-click and SAVE file

USER MANUAL, SCCFB.pdf

 

 

TOP


12/15/08 Yearly Count per Year 1-1,000,000 SCCFB ycpy v7-3.xls

(like a YC-1EN YEARLY per year)

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


6/14/07 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)

 

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

counter

 

 

 

 

Comments (0)

You don't have permission to comment on this page.