Quinn-Curtis Forums
Quinn-Curtis Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Tools for Java
 QCSPCChart SPC for Java
 Lower Alarm Limit
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wryates

USA
11 Posts

Posted - 24 Jul 2014 :  16:05:15  Show Profile  Reply with Quote
I have a MEAN_RANGE_CHART that i built in the winforms version and one in the javascript version.

In the javascript version the UCL is not highlighting and the symbols changing color like it does with the .net version.

Here is the JSON:

{
    "StaticProperties": {
        "Canvas": {
            "Width": 1900,
            "Height": 900
        },
        "SPCChartStrings": {
            "TitleHeader": "",
            "ChartNumberHeader": "",
            "DateHeader": "",
            "GaugeHeader": ""
        },
        "DefaultFontName": "Arial, sans-serif",
        "DefaultTableFont": {
            "Name": "'Comic Sans MS', cursive, sans-serif",
            "Size": 15,
            "Style": "Bold"
        }
    },
    "SPCChart": {
        "InitChartProperties": {
            "SPCChartType": "MEAN_RANGE_CHART",
            "ChartMode": "Batch",
            "NumSamplesPerSubgroup": 2,
            "NumDatapointsInView": 15
        },
        "Scrollbar": {
            "EnableScrollBar": true,
            "ScrollbarPosition": "SCROLLBAR_POSITION_MIN"
        },
        "TableSetup": {
            "HeaderStringsLevel": "HEADER_STRINGS_LEVEL1",
            "EnableInputStringsDisplay": true,
            "EnableCategoryValues": false,
            "EnableCalculatedValues": true,
            "EnableProcessCapabilityValues": true,
            "EnableTotalSamplesValues": true,
            "EnableNotes": false,
            "EnableTimeValues": true,
            "EnableDataToolTip": true,
            "EnableNotesToolTip": false,
            "EnableAlarmStatusValues": true,
            "TableBackgroundMode": "TABLE_STRIPED_COLOR_BACKGROUND",
            "TableAlarmEmphasisMode": "ALARM_HIGHLIGHT_BAR",
            "ChartAlarmEmphasisMode": "ALARM_HIGHLIGHT_SYMBOL",
            "BackgroundColor1": "WHITE",
            "BackgroundColor2": "BISQUE",
            "ChartData": {
                "Title": "HH Observations",
                "PartNumber": "",
                "ChartNumber": "Humane Handling",
                "PartName": "",
                "Operation": "",
                "SpecificationLimits": "",
                "Operator": "",
                "Machine": "",
                "Gauge": "",
                "UnitOfMeasure": "",
                "ZeroEquals": "",
                "DateString": "Falling",
                "NotesMessage": "",
                "TimeFormat": "TIMEDATEFORMAT_24HM",
                "TitleHeader": "PROCESS: ",
                "PartNumberHeader": "",
                "ChartNumberHeader": "GROUP: ",
                "PartNameHeader": "",
                "OperationHeader": "",
                "SpecificationLimitsHeader": "",
                "OperatorHeader": "",
                "MachineHeader": "",
                "GaugeHeader": "",
                "UnitOfMeasureHeader": "",
                "ZeroEqualsHeader": "",
                "DateHeader": "MEASURE: ",
                "NotesHeader": ""
            }
        },
        "PrimaryChartSetup": {
            "XAxisLabels": {
                "TextColor": "ALICEBLUE",
                "Format": "TIMEDATEFORMAT_24HM",
                "OverlapLabelMode": "OVERLAP_LABEL_DRAW",
                "AxisLabelMode": "AXIS_LABEL_MODE_STRING"
            },
            "FrequencyHistogram": {
                "EnableDisplayFrequencyHistogram": true,
                "PlotBackgroundColor": "WHITE",
                "BarColor": "LIGHTBLUE"
            },
            "ControlLimits": {
                "Decimal": 1,
                "Target": {
                    "LineColor": "GREEN",
                    "TextColor": "ALICEBLUE"
                },
                "LCL3": {
                    "LineColor": "DEEPSKYBLUE",
                    "TextColor": "ALICEBLUE"
                },
                "UCL3": {
                    "LineColor": "SALMON",
                    "TextColor": "ALICEBLUE"
                }
            }
        },
        "SecondaryChartSetup": {
            "XAxisLabels": {
                "TextColor": "ALICEBLUE",
                "Format": "TIMEDATEFORMAT_24HM",
                "OverlapLabelMode": "OVERLAP_LABEL_DRAW",
                "AxisLabelMode": "AXIS_LABEL_MODE_STRING"
            },
            "FrequencyHistogram": {
                "EnableDisplayFrequencyHistogram": true,
                "PlotBackgroundColor": "WHITE",
                "BarColor": "LIGHTBLUE"
            },
            "ControlLimits": {
                "Decimal": 1,
                "Target": {
                    "LineColor": "GREEN",
                    "TextColor": "ALICEBLUE"
                },
                "LCL3": {
                    "LineColor": "DEEPSKYBLUE",
                    "TextColor": "ALICEBLUE"
                },
                "UCL3": {
                    "LineColor": "SALMON",
                    "TextColor": "ALICEBLUE"
                }
            }
        },
        "SampleData": {
            "SampleIntervalRecords": [
                {
                    "TimeStamp": 1297053780000,
                    "BatchCount": 1,
                    "Note": "Sunday, February 6, 2011",
                    "BatchIDString": "22:43\r\n02/06/11",
                    "SampleValues": [
                        0,
                        1
                    ]
                },
                {
                    "TimeStamp": 1297056240000,
                    "BatchCount": 2,
                    "Note": "Sunday, February 6, 2011",
                    "BatchIDString": "23:24",
                    "SampleValues": [
                        2,
                        0
                    ]
                },
                {
                    "TimeStamp": 1299192480000,
                    "BatchCount": 3,
                    "Note": "Thursday, March 3, 2011",
                    "BatchIDString": "16:48\r\n03/03/11",
                    "SampleValues": [
                        1,
                        1
                    ]
                },
                {
                    "TimeStamp": 1300230120000,
                    "BatchCount": 4,
                    "Note": "Tuesday, March 15, 2011",
                    "BatchIDString": "18:02\r\n03/15/11",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300230180000,
                    "BatchCount": 5,
                    "Note": "Tuesday, March 15, 2011",
                    "BatchIDString": "18:03",
                    "SampleValues": [
                        1,
                        44
                    ]
                },
                {
                    "TimeStamp": 1300231020000,
                    "BatchCount": 6,
                    "Note": "Tuesday, March 15, 2011",
                    "BatchIDString": "18:17",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300395240000,
                    "BatchCount": 7,
                    "Note": "Thursday, March 17, 2011",
                    "BatchIDString": "15:54\r\n03/17/11",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300396740000,
                    "BatchCount": 8,
                    "Note": "Thursday, March 17, 2011",
                    "BatchIDString": "16:19",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300397280000,
                    "BatchCount": 9,
                    "Note": "Thursday, March 17, 2011",
                    "BatchIDString": "16:28",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300400820000,
                    "BatchCount": 10,
                    "Note": "Thursday, March 17, 2011",
                    "BatchIDString": "17:27",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300472580000,
                    "BatchCount": 11,
                    "Note": "Friday, March 18, 2011",
                    "BatchIDString": "13:23\r\n03/18/11",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300480020000,
                    "BatchCount": 12,
                    "Note": "Friday, March 18, 2011",
                    "BatchIDString": "15:27",
                    "SampleValues": [
                        1,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300485840000,
                    "BatchCount": 13,
                    "Note": "Friday, March 18, 2011",
                    "BatchIDString": "17:04",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300486020000,
                    "BatchCount": 14,
                    "Note": "Friday, March 18, 2011",
                    "BatchIDString": "17:07",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300486080000,
                    "BatchCount": 15,
                    "Note": "Friday, March 18, 2011",
                    "BatchIDString": "17:08",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1300735800000,
                    "BatchCount": 16,
                    "Note": "Monday, March 21, 2011",
                    "BatchIDString": "14:30\r\n03/21/11",
                    "SampleValues": [
                        0,
                        2
                    ]
                },
                {
                    "TimeStamp": 1303413540000,
                    "BatchCount": 17,
                    "Note": "Thursday, April 21, 2011",
                    "BatchIDString": "14:19\r\n04/21/11",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1303419180000,
                    "BatchCount": 18,
                    "Note": "Thursday, April 21, 2011",
                    "BatchIDString": "15:53",
                    "SampleValues": [
                        0,
                        3
                    ]
                },
                {
                    "TimeStamp": 1308673200000,
                    "BatchCount": 19,
                    "Note": "Tuesday, June 21, 2011",
                    "BatchIDString": "11:20\r\n06/21/11",
                    "SampleValues": [
                        2,
                        1
                    ]
                },
                {
                    "TimeStamp": 1313786400000,
                    "BatchCount": 20,
                    "Note": "Friday, August 19, 2011",
                    "BatchIDString": "15:40\r\n08/19/11",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315334520000,
                    "BatchCount": 21,
                    "Note": "Tuesday, September 6, 2011",
                    "BatchIDString": "13:42\r\n09/06/11",
                    "SampleValues": [
                        1,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315335180000,
                    "BatchCount": 22,
                    "Note": "Tuesday, September 6, 2011",
                    "BatchIDString": "13:53",
                    "SampleValues": [
                        31,
                        3
                    ]
                },
                {
                    "TimeStamp": 1315342920000,
                    "BatchCount": 23,
                    "Note": "Tuesday, September 6, 2011",
                    "BatchIDString": "16:02",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315343220000,
                    "BatchCount": 24,
                    "Note": "Tuesday, September 6, 2011",
                    "BatchIDString": "16:07",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315343400000,
                    "BatchCount": 25,
                    "Note": "Tuesday, September 6, 2011",
                    "BatchIDString": "16:10",
                    "SampleValues": [
                        0,
                        1
                    ]
                },
                {
                    "TimeStamp": 1315406520000,
                    "BatchCount": 26,
                    "Note": "Wednesday, September 7, 2011",
                    "BatchIDString": "09:42\r\n09/07/11",
                    "SampleValues": [
                        0,
                        14
                    ]
                },
                {
                    "TimeStamp": 1315407120000,
                    "BatchCount": 27,
                    "Note": "Wednesday, September 7, 2011",
                    "BatchIDString": "09:52",
                    "SampleValues": [
                        179,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315427400000,
                    "BatchCount": 28,
                    "Note": "Wednesday, September 7, 2011",
                    "BatchIDString": "15:30",
                    "SampleValues": [
                        1,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315577940000,
                    "BatchCount": 29,
                    "Note": "Friday, September 9, 2011",
                    "BatchIDString": "09:19\r\n09/09/11",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1315579260000,
                    "BatchCount": 30,
                    "Note": "Friday, September 9, 2011",
                    "BatchIDString": "09:41",
                    "SampleValues": [
                        154,
                        122
                    ]
                },
                {
                    "TimeStamp": 1318987440000,
                    "BatchCount": 31,
                    "Note": "Tuesday, October 18, 2011",
                    "BatchIDString": "20:24\r\n10/18/11",
                    "SampleValues": [
                        12,
                        31
                    ]
                },
                {
                    "TimeStamp": 1329157140000,
                    "BatchCount": 32,
                    "Note": "Monday, February 13, 2012",
                    "BatchIDString": "12:19\r\n02/13/12",
                    "SampleValues": [
                        3,
                        0
                    ]
                },
                {
                    "TimeStamp": 1329236460000,
                    "BatchCount": 33,
                    "Note": "Tuesday, February 14, 2012",
                    "BatchIDString": "10:21\r\n02/14/12",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1329238920000,
                    "BatchCount": 34,
                    "Note": "Tuesday, February 14, 2012",
                    "BatchIDString": "11:02",
                    "SampleValues": [
                        2,
                        2
                    ]
                },
                {
                    "TimeStamp": 1329259140000,
                    "BatchCount": 35,
                    "Note": "Tuesday, February 14, 2012",
                    "BatchIDString": "16:39",
                    "SampleValues": [
                        9,
                        0
                    ]
                },
                {
                    "TimeStamp": 1403794440000,
                    "BatchCount": 36,
                    "Note": "Thursday, June 26, 2014",
                    "BatchIDString": "09:54\r\n06/26/14",
                    "SampleValues": [
                        0,
                        0
                    ]
                },
                {
                    "TimeStamp": 1403794920000,
                    "BatchCount": 37,
                    "Note": "Thursday, June 26, 2014",
                    "BatchIDString": "10:02",
                    "SampleValues": [
                        0,
                        0
                    ]
                }
            ]
        },
        "Methods": {
            "AutoCalculateControlLimits": [
                true,
                true
            ],
            "AutoScaleYAxes": [
                true,
                true
            ],
            "RebuildUsingCurrentData": true
        }
    }
}


As you can see, the UCL highlights work, but the LCL should highlight when the range is zero like the LCL.

Thanks

quinncurtis

1586 Posts

Posted - 25 Jul 2014 :  11:57:24  Show Profile  Reply with Quote
First, there is a basic error in your program which causes the table to be shifted compared to the chart data points. In the SampleData portion of the JSON you start the BatchCount at 1. This should always start at 0. So either insert a record for BatchCount 0, or re-number the BatchCount values to start at 0.

In the software, we explicitly setup the low limit test for the secondary chart to be a less than test (<), not less than or equal to (<=), specifically to prevent a range of 0 from triggering alarms. A large number of our users found a <= test unacceptable for their data. This is true for ALL current versions of the software. The other versions of our software are much more flexible when it comes to changing internal parameters which control this type of test; not so with the JSON version. If you find this unacceptable for your application, should you purchase the software, we can change that for you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Quinn-Curtis Forums © 2000-2018 Quinn-Curtis, Inc. Go To Top Of Page
Powered By: Snitz Forums 2000 Version 3.4.07