mrtomeq

services:
  kensobi:
    image: kensobi/kensobi
    ports:
      - "3000:3000"
    volumes:
      - kensobi_storage:/var/lib/grafana
  postgres:
    image: kensobi/postgres
    environment:

mrtomeq

[
    {
        "id": "9d048712.32d248",
        "type": "tab",
        "label": "Polyworks CSV to DB",
        "disabled": false,
        "info": ""
    },
    {
        "id": "de960753.d25e38",

mrtomeq

[
    {
        "id": "f7dd5695.c01598",
        "type": "tab",
        "label": "CSV to GOM XML",
        "disabled": false,
        "info": ""
    },
    {
        "id": "1b562d91.3c71f2",

mrtomeq

INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (2,0.7979,1.128,0.853,1.88,2.659,0,3.267,0,3.267);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (3,0.8862,1.693,0.888,1.023,1.954,0,2.568,0,2.574);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (4,0.9213,2.059,0.88,0.729,1.628,0,2.266,0,2.282);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_range_limit, a2_xbar_limit_range, a3_xbar_limit_sigma, b3_sigma_lcl, b4_sigma_ucl, d3_range_lcl, d4_range_ucl) VALUES (5,0.94,2.326,0.864,0.577,1.427,0,2.089,0,2.114);
INSERT INTO spc_constants(subgroup, c4_xbar_sigma, d2_xbar_range, d3_ran

mrtomeq

INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.9187413,'2020-09-09T09:51:25-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.3271292,'2020-09-09T11:30:00-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.532118,'2020-09-09T13:08:34-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.2763528,'2020-09-09T14:47:08-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,231.7268046,'2020-09-09T16:25:42-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.2779324,'2020-09-09T18:04:17-04:00');
INSERT INTO measurements (partId, characteristicId, measurementValue, measurementDate) VALUES (1,1,233.1495872,'2020-09-09T19:42:51-04:00');
INSERT INTO measurements (partId, char