{
  "version": "18.5.10",
  "sheets": [
    {
      "id": "c1dd5136-2d63-4eb2-8a48-42eae5ba2086",
      "name": "Main",
      "colNumber": 10,
      "rowNumber": 139,
      "rows": {
        "11": { "size": 45 },
        "28": { "size": 17 },
        "29": { "size": 46 },
        "48": { "size": 42 },
        "67": { "size": 41 },
        "86": { "size": 39 },
        "104": { "size": 43 },
        "105": { "size": 43 },
        "106": { "size": 27 },
        "107": { "size": 27 },
        "108": { "size": 27 },
        "109": { "size": 27 },
        "110": { "size": 27 },
        "111": { "size": 27 },
        "112": { "size": 27 },
        "113": { "size": 27 },
        "114": { "size": 27 },
        "115": { "size": 27 },
        "117": { "size": 42 },
        "118": { "size": 43 },
        "119": { "size": 27 },
        "120": { "size": 27 },
        "121": { "size": 27 },
        "122": { "size": 27 },
        "123": { "size": 27 },
        "124": { "size": 27 },
        "125": { "size": 27 },
        "126": { "size": 27 },
        "127": { "size": 27 },
        "128": { "size": 27 }
      },
      "cols": {
        "0": { "size": 308 },
        "1": { "size": 48 },
        "2": { "size": 113 },
        "3": { "size": 95 },
        "4": { "size": 98 },
        "5": { "size": 115 },
        "6": { "size": 23 },
        "7": { "size": 235 },
        "8": { "size": 107 },
        "9": { "size": 120 }
      },
      "merges": [
        "B106:C106",
        "B107:C107",
        "B108:C108",
        "B109:C109",
        "B110:C110",
        "B111:C111",
        "B112:C112",
        "B113:C113",
        "B114:C114",
        "B115:C115",
        "B116:C116"
      ],
      "cells": {
        "A12": "=_t(\"Purchase Value by confirmation date\")",
        "A30": "=_t(\"% On time deliveries by vendor\")",
        "A49": "=_t(\"Top vendors by amount\")",
        "A68": "=_t(\"Top vendors by lead time in days\")",
        "A87": "=_t(\"Average product purchased cost by confirmation week\")",
        "A105": "=_t(\"Top purchase orders by value\")",
        "A106": "=ODOO.LIST.HEADER(1,\"name\")",
        "A107": "=ODOO.LIST(1,1,\"name\")",
        "A108": "=ODOO.LIST(1,2,\"name\")",
        "A109": "=ODOO.LIST(1,3,\"name\")",
        "A110": "=ODOO.LIST(1,4,\"name\")",
        "A111": "=ODOO.LIST(1,5,\"name\")",
        "A112": "=ODOO.LIST(1,6,\"name\")",
        "A113": "=ODOO.LIST(1,7,\"name\")",
        "A114": "=ODOO.LIST(1,8,\"name\")",
        "A115": "=ODOO.LIST(1,9,\"name\")",
        "A116": "=ODOO.LIST(1,10,\"name\")",
        "A118": "=_t(\"Top purchased products\")",
        "B106": "=ODOO.LIST.HEADER(1,\"partner_id\")",
        "B107": "=ODOO.LIST(1,1,\"partner_id\")",
        "B108": "=ODOO.LIST(1,2,\"partner_id\")",
        "B109": "=ODOO.LIST(1,3,\"partner_id\")",
        "B110": "=ODOO.LIST(1,4,\"partner_id\")",
        "B111": "=ODOO.LIST(1,5,\"partner_id\")",
        "B112": "=ODOO.LIST(1,6,\"partner_id\")",
        "B113": "=ODOO.LIST(1,7,\"partner_id\")",
        "B114": "=ODOO.LIST(1,8,\"partner_id\")",
        "B115": "=ODOO.LIST(1,9,\"partner_id\")",
        "B116": "=ODOO.LIST(1,10,\"partner_id\")",
        "D106": "=ODOO.LIST.HEADER(1,\"user_id\")",
        "D107": "=ODOO.LIST(1,1,\"user_id\")",
        "D108": "=ODOO.LIST(1,2,\"user_id\")",
        "D109": "=ODOO.LIST(1,3,\"user_id\")",
        "D110": "=ODOO.LIST(1,4,\"user_id\")",
        "D111": "=ODOO.LIST(1,5,\"user_id\")",
        "D112": "=ODOO.LIST(1,6,\"user_id\")",
        "D113": "=ODOO.LIST(1,7,\"user_id\")",
        "D114": "=ODOO.LIST(1,8,\"user_id\")",
        "D115": "=ODOO.LIST(1,9,\"user_id\")",
        "D116": "=ODOO.LIST(1,10,\"user_id\")",
        "E106": "=ODOO.LIST.HEADER(1, \"date_order\", _t(\"Order date\"))",
        "E107": "=if(A107<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E108": "=if(A108<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E109": "=if(A109<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E110": "=if(A110<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E111": "=if(A111<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E112": "=if(A112<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E113": "=if(A113<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E114": "=if(A114<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E115": "=if(A115<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "E116": "=if(A116<>\"\",edate(ODOO.LIST(1,row()-94,\"date_order\"),0),\"\")",
        "F106": "=ODOO.LIST.HEADER(1,\"amount_total\")",
        "F107": "=ODOO.LIST(1,1,\"amount_total\")",
        "F108": "=ODOO.LIST(1,2,\"amount_total\")",
        "F109": "=ODOO.LIST(1,3,\"amount_total\")",
        "F110": "=ODOO.LIST(1,4,\"amount_total\")",
        "F111": "=ODOO.LIST(1,5,\"amount_total\")",
        "F112": "=ODOO.LIST(1,6,\"amount_total\")",
        "F113": "=ODOO.LIST(1,7,\"amount_total\")",
        "F114": "=ODOO.LIST(1,8,\"amount_total\")",
        "F115": "=ODOO.LIST(1,9,\"amount_total\")",
        "F116": "=ODOO.LIST(1,10,\"amount_total\")",
        "H105": "=_t(\"Top 10 late receipts\")",
        "H118": "=_t(\"Supplier Dependency Chart\")",
        "A119": "=PIVOT(12, 10, FALSE, FALSE)",
        "H106": "=PIVOT(13, 10, FALSE, FALSE)"
      },
      "styles": {
        "A12": 1,
        "A30": 1,
        "A49": 1,
        "A68": 1,
        "A87": 1,
        "A105": 1,
        "A118": 1,
        "H105": 1,
        "H118": 1,
        "A119": 2,
        "A106:E106": 2,
        "H106": 2,
        "A107:A116": 3,
        "B107:B115": 4,
        "C107:F116": 4,
        "A120:F129": 4,
        "H107:H116": 4,
        "F106": 5,
        "B119:F119": 5
      },
      "formats": { "H107:H116": 1 },
      "borders": {
        "A105:F105": 1,
        "A118:F118": 1,
        "A12:J12": 1,
        "A30:J30": 1,
        "A49:J49": 1,
        "A68:J68": 1,
        "A87:J87": 1,
        "H105:J105": 1,
        "H118:J118": 1,
        "A106:F106": 2,
        "A13:J13": 2,
        "A31:J31": 2,
        "A50:J50": 2,
        "A69:J69": 2,
        "A88:J88": 2,
        "I106:J106": 2,
        "H119:J119": 2,
        "A107:F107": 3,
        "I107": 3,
        "A108:F116": 4,
        "A121:F129": 4,
        "H108:I116": 4,
        "A117:F117": 5,
        "A130:F130": 5,
        "H117:I117": 5,
        "A119:F119": 6,
        "H106": 6,
        "A120:F120": 7,
        "H107": 7
      },
      "conditionalFormats": [
        {
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "F107:F115" },
          "id": "ebb6c811-91eb-4222-831a-8a315f764cd2",
          "ranges": ["A107:A115"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "C120:C129" },
          "id": "9bdcb3d1-db68-43fb-bfa2-62ffc88803a3",
          "ranges": ["A120:A129"]
        }
      ],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "c79871cd-6483-4d0f-9493-cca9725c3dd7",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": {
              "text": "Purchased value",
              "align": "left",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "KPIs!D3",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "KPIs!D4",
            "humanize": true,
            "chartId": "c79871cd-6483-4d0f-9493-cca9725c3dd7"
          },
          "offset": { "x": 0, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "939104fa-dea7-4c61-9991-0654ab1dbf8d",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": {
              "text": "Number of orders",
              "align": "left",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "KPIs!C3",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "KPIs!C4",
            "humanize": false,
            "chartId": "939104fa-dea7-4c61-9991-0654ab1dbf8d"
          },
          "offset": { "x": 499, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "3607d85d-8efd-4432-b4fd-8157b834e4c4",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": {
              "text": "Average order value",
              "align": "left",
              "color": "#434343",
              "bold": true
            },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "KPIs!I3",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "KPIs!I4",
            "humanize": true,
            "chartId": "3607d85d-8efd-4432-b4fd-8157b834e4c4"
          },
          "offset": { "x": 250, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "45e7f600-9d45-49d4-865a-5f0ad24104f9",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": {
              "text": "Days to Receive",
              "align": "left",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "KPIs!H3",
            "baselineDescr": { "text": "last period" },
            "keyValue": "KPIs!H4",
            "humanize": true,
            "chartId": "45e7f600-9d45-49d4-865a-5f0ad24104f9"
          },
          "offset": { "x": 0, "y": 125 },
          "col": 0,
          "row": 0
        },
        {
          "id": "e0ddc454-8376-4e21-b7fe-262d4a1c057e",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "percentage",
            "title": {
              "text": "Quantity ordered",
              "align": "left",
              "color": "#434343",
              "bold": true
            },
            "type": "scorecard",
            "background": "#EFF6FF",
            "baseline": "KPIs!E3",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "KPIs!E4",
            "humanize": true,
            "chartId": "e0ddc454-8376-4e21-b7fe-262d4a1c057e"
          },
          "offset": { "x": 748, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "de913d05-7245-41a9-9939-0e1808def088",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": {
              "text": "Days to Confirm",
              "align": "left",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "KPIs!G3",
            "baselineDescr": { "text": "last period" },
            "keyValue": "KPIs!G4",
            "humanize": true,
            "chartId": "de913d05-7245-41a9-9939-0e1808def088"
          },
          "offset": { "x": 250, "y": 125 },
          "col": 0,
          "row": 0
        },
        {
          "id": "7d77e1dc-020d-4c44-b379-9a59b7c4d46d",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "difference",
            "title": {
              "text": "Supplier service level",
              "align": "left",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "KPIs!D10",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "KPIs!D11",
            "humanize": false,
            "chartId": "7d77e1dc-020d-4c44-b379-9a59b7c4d46d"
          },
          "offset": { "x": 499, "y": 125 },
          "col": 0,
          "row": 0
        },
        {
          "id": "b90dc169-577a-467b-b8b5-d5ad079efcc5",
          "width": 242,
          "height": 107,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "difference",
            "title": {
              "text": "On time deliveries",
              "align": "left",
              "bold": true,
              "color": "#434343"
            },
            "type": "scorecard",
            "background": "#ECFDF5",
            "baseline": "KPIs!C17",
            "baselineDescr": { "text": "since last period" },
            "keyValue": "KPIs!B17",
            "humanize": false,
            "chartId": "b90dc169-577a-467b-b8b5-d5ad079efcc5"
          },
          "offset": { "x": 748, "y": 125 },
          "col": 0,
          "row": 0
        },
        {
          "id": "72b620ea-22fe-4fe6-aceb-02898ae59a8a",
          "width": 1263,
          "height": 383,
          "tag": "chart",
          "data": {
            "title": { "text": "", "align": "center", "bold": true },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["date_approve:day"],
              "measure": "price_total",
              "order": null,
              "resModel": "purchase.report",
              "mode": "line",
              "cumulated": false,
              "cumulatedStart": false
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [
                "&",
                ["state", "!=", "draft"],
                "&",
                ["state", "!=", "sent"],
                ["state", "!=", "cancel"]
              ],
              "groupBy": ["date_approve:day"],
              "orderBy": []
            },
            "type": "odoo_line",
            "dataSets": [
              {}
            ],
            "verticalAxisPosition": "left",
            "stacked": true,
            "cumulative": false,
            "cumulatedStart": false,
            "axesDesign": {
              "x": {
                "title": { "text": "Confirmation Date" }
              },
              "y": {
                "title": { "text": "Purchase Value" }
              }
            },
            "fillArea": true,
            "chartId": "72b620ea-22fe-4fe6-aceb-02898ae59a8a",
            "fieldMatching": {
              "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime" },
              "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
              "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
              "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
              "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 298 },
          "col": 0,
          "row": 0
        },
        {
          "id": "a876a7f1-80d3-4bce-a533-12ed1fa0def1",
          "width": 1264,
          "height": 413,
          "tag": "chart",
          "data": {
            "title": { "text": "", "align": "center", "bold": true },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["partner_id"],
              "measure": "on_time_rate",
              "order": "DESC",
              "resModel": "vendor.delay.report",
              "mode": "bar"
            },
            "searchParams": {
              "comparison": null,
              "context": {
                "quotation_only": true,
                "active_model": "purchase.order",
                "active_id": 27,
                "active_ids": [27]
              },
              "domain": [
                ["qty_total", ">", 0]
              ],
              "groupBy": ["partner_id"],
              "orderBy": []
            },
            "type": "odoo_bar",
            "dataSets": [
              {}
            ],
            "verticalAxisPosition": "left",
            "stacked": true,
            "axesDesign": {
              "x": {
                "title": { "text": "Vendors" }
              },
              "y": {
                "title": { "text": "% of On Time Deliveries" }
              }
            },
            "chartId": "a876a7f1-80d3-4bce-a533-12ed1fa0def1",
            "fieldMatching": {
              "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date", "type": "datetime", "offset": 0 },
              "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
              "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": {},
              "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
              "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 729 },
          "col": 0,
          "row": 0
        },
        {
          "id": "460a1cef-70a5-4190-b681-6483e826bd09",
          "width": 1263,
          "height": 415,
          "tag": "chart",
          "data": {
            "type": "combo",
            "dataSetsHaveTitle": true,
            "dataSets": [
              { "dataRange": "KPIs!C35:C45", "yAxisId": "y", "type": "bar" },
              { "dataRange": "KPIs!B35:B45", "yAxisId": "y1", "type": "line" }
            ],
            "legendPosition": "top",
            "labelRange": "KPIs!A36:A45",
            "title": { "text": "", "align": "center", "bold": true },
            "aggregated": false,
            "axesDesign": {
              "y": {
                "title": { "text": "Value" }
              },
              "y1": {
                "title": { "text": "Count" }
              },
              "x": {
                "title": { "text": "Vendors" }
              }
            },
            "humanize": true,
            "chartId": "460a1cef-70a5-4190-b681-6483e826bd09"
          },
          "offset": { "x": 0, "y": 1185 },
          "col": 0,
          "row": 0
        },
        {
          "id": "310ab7a9-fcb7-4db3-8369-fcfddec9f178",
          "width": 1264,
          "height": 414,
          "tag": "chart",
          "data": {
            "type": "combo",
            "dataSetsHaveTitle": true,
            "dataSets": [
              { "dataRange": "KPIs!F55:F65", "yAxisId": "y", "type": "bar" },
              { "dataRange": "KPIs!G55:G65", "type": "line" }
            ],
            "legendPosition": "top",
            "labelRange": "KPIs!E55:E65",
            "title": { "text": "", "align": "center", "bold": true },
            "aggregated": false,
            "axesDesign": {
              "x": {
                "title": { "text": "Vendors" }
              },
              "y": {
                "title": { "text": "Lead Time" }
              }
            },
            "showValues": false,
            "humanize": true,
            "chartId": "310ab7a9-fcb7-4db3-8369-fcfddec9f178"
          },
          "offset": { "x": 0, "y": 1640 },
          "col": 0,
          "row": 0
        },
        {
          "id": "4d31c500-1186-498b-b589-d7b4ce1ccc4b",
          "width": 462,
          "height": 311,
          "tag": "chart",
          "data": {
            "title": { "text": "", "align": "center" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["user_id"],
              "measure": "amount_total",
              "order": null,
              "resModel": "purchase.order",
              "mode": "pie"
            },
            "searchParams": {
              "comparison": null,
              "context": { "quotation_only": true },
              "domain": [
                ["state", "=", "purchase"]
              ],
              "groupBy": ["user_id"],
              "orderBy": []
            },
            "type": "odoo_pie",
            "dataSets": [
              {}
            ],
            "chartId": "4d31c500-1186-498b-b589-d7b4ce1ccc4b",
            "fieldMatching": {
              "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "message_partner_ids", "type": "many2many" },
              "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "activity_user_id", "type": "many2one" },
              "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "create_date", "type": "datetime", "offset": 0 },
              "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
              "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "product_id.categ_id", "type": "many2one" }
            }
          },
          "offset": { "x": 800, "y": 2905 },
          "col": 0,
          "row": 0
        },
        {
          "id": "98f4f82c-16ed-4d9f-9bef-6965a0c35513",
          "width": 1262,
          "height": 390,
          "tag": "chart",
          "data": {
            "title": { "text": "", "align": "center", "bold": true },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["date_approve:month", "product_id"],
              "measure": "price_average",
              "order": null,
              "resModel": "purchase.report",
              "mode": "line",
              "cumulated": false,
              "cumulatedStart": false
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [
                "&",
                ["state", "!=", "draft"],
                "&",
                ["state", "!=", "sent"],
                ["state", "!=", "cancel"]
              ],
              "groupBy": ["date_approve:month", "product_id"],
              "orderBy": []
            },
            "type": "odoo_line",
            "dataSets": [
              {},
              {},
              {},
              {},
              {},
              {},
              {},
              {},
              {},
              {},
              {},
              {}
            ],
            "verticalAxisPosition": "left",
            "stacked": false,
            "cumulative": false,
            "cumulatedStart": false,
            "axesDesign": {
              "y": {
                "title": { "text": "Products Purchased cost" }
              }
            },
            "fillArea": false,
            "chartId": "98f4f82c-16ed-4d9f-9bef-6965a0c35513",
            "fieldMatching": {
              "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime" },
              "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
              "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
              "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
              "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 2092 },
          "col": 0,
          "row": 0
        }
      ],
      "tables": [
        {
          "range": "A105:F116",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A118:F129",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    },
    {
      "id": "sheet1",
      "name": "KPIs",
      "colNumber": 26,
      "rowNumber": 184,
      "rows": {},
      "cols": {
        "0": { "size": 153 },
        "1": { "size": 135 },
        "2": { "size": 135 },
        "3": { "size": 85 },
        "4": { "size": 77 },
        "5": { "size": 83 },
        "6": { "size": 100 },
        "7": { "size": 99 },
        "8": { "size": 88 },
        "9": { "size": 50 }
      },
      "merges": ["A34:C34", "A68:C68", "A53:C53", "A54:C54"],
      "cells": {
        "A1": "=_t(\"Order date Filter\")",
        "A3": "=_t(\"Previous period\")",
        "A4": "=_t(\"Selected period\")",
        "A8": "=_t(\"Orders with reception picking\")",
        "A10": "=_t(\"Previous period\")",
        "A11": "=_t(\"Selected period\")",
        "A17": "=PIVOT.HEADER(5)",
        "A18": "=PIVOT.HEADER(5,\"#partner_id\",1)",
        "A19": "=PIVOT.HEADER(5,\"#partner_id\",2)",
        "A20": "=PIVOT.HEADER(5,\"#partner_id\",3)",
        "A21": "=PIVOT.HEADER(5,\"#partner_id\",4)",
        "A22": "=PIVOT.HEADER(5,\"#partner_id\",5)",
        "A23": "=PIVOT.HEADER(5,\"#partner_id\",6)",
        "A24": "=PIVOT.HEADER(5,\"#partner_id\",7)",
        "A25": "=PIVOT.HEADER(5,\"#partner_id\",8)",
        "A26": "=PIVOT.HEADER(5,\"#partner_id\",9)",
        "A27": "=PIVOT.HEADER(5,\"#partner_id\",10)",
        "A34": "=_t(\"Orders value by vendor\")",
        "A36": "=PIVOT.HEADER(9,\"#partner_id\",1)",
        "A37": "=PIVOT.HEADER(9,\"#partner_id\",2)",
        "A38": "=PIVOT.HEADER(9,\"#partner_id\",3)",
        "A39": "=PIVOT.HEADER(9,\"#partner_id\",4)",
        "A40": "=PIVOT.HEADER(9,\"#partner_id\",5)",
        "A41": "=PIVOT.HEADER(9,\"#partner_id\",6)",
        "A42": "=PIVOT.HEADER(9,\"#partner_id\",7)",
        "A43": "=PIVOT.HEADER(9,\"#partner_id\",8)",
        "A44": "=PIVOT.HEADER(9,\"#partner_id\",9)",
        "A45": "=PIVOT.HEADER(9,\"#partner_id\",10)",
        "A54": "=_t(\"Lead time top 10\")",
        "A56": "=PIVOT.HEADER(10,\"#partner_id\",1)",
        "A57": "=PIVOT.HEADER(10,\"#partner_id\",2)",
        "A58": "=PIVOT.HEADER(10,\"#partner_id\",3)",
        "A59": "=PIVOT.HEADER(10,\"#partner_id\",4)",
        "A60": "=PIVOT.HEADER(10,\"#partner_id\",5)",
        "A61": "=PIVOT.HEADER(10,\"#partner_id\",6)",
        "A62": "=PIVOT.HEADER(10,\"#partner_id\",7)",
        "A63": "=PIVOT.HEADER(10,\"#partner_id\",8)",
        "A64": "=PIVOT.HEADER(10,\"#partner_id\",9)",
        "A65": "=PIVOT.HEADER(10,\"#partner_id\",10)",
        "A68": "=_t(\"Late receipts\")",
        "A70": "=PIVOT.HEADER(11,\"#reference\",1)",
        "A71": "=PIVOT.HEADER(11,\"#reference\",2)",
        "A72": "=PIVOT.HEADER(11,\"#reference\",3)",
        "A73": "=PIVOT.HEADER(11,\"#reference\",4)",
        "A74": "=PIVOT.HEADER(11,\"#reference\",5)",
        "A75": "=PIVOT.HEADER(11,\"#reference\",6)",
        "A76": "=PIVOT.HEADER(11,\"#reference\",7)",
        "A77": "=PIVOT.HEADER(11,\"#reference\",8)",
        "A78": "=PIVOT.HEADER(11,\"#reference\",9)",
        "A79": "=PIVOT.HEADER(11,\"#reference\",10)",
        "A85": "=_t(\"Product level overview\")",
        "A86": "=_t(\"Product\")",
        "A87": "=PIVOT.HEADER(12,\"#product_id\",1)",
        "A88": "=PIVOT.HEADER(12,\"#product_id\",2)",
        "A89": "=PIVOT.HEADER(12,\"#product_id\",3)",
        "A90": "=PIVOT.HEADER(12,\"#product_id\",4)",
        "A91": "=PIVOT.HEADER(12,\"#product_id\",5)",
        "A92": "=PIVOT.HEADER(12,\"#product_id\",6)",
        "A93": "=PIVOT.HEADER(12,\"#product_id\",7)",
        "A94": "=PIVOT.HEADER(12,\"#product_id\",8)",
        "A95": "=PIVOT.HEADER(12,\"#product_id\",9)",
        "A96": "=PIVOT.HEADER(12,\"#product_id\",10)",
        "B1": "=ODOO.FILTER.VALUE(\"Order date\")",
        "B2": "=PIVOT.HEADER(1,\"measure\",\"__count\")",
        "B3": "=if(B1<>\"\",PIVOT.VALUE(2,\"__count\"),\"N/A\")",
        "B4": "=PIVOT.VALUE(1,\"__count\")",
        "B9": "=PIVOT.HEADER(6,\"measure\",\"qty_ordered:sum\")",
        "B10": "=PIVOT.VALUE(7,\"qty_ordered:sum\")",
        "B11": "=PIVOT.VALUE(6,\"qty_ordered:sum\")",
        "B14": "=_t(\"On time deliveries\")",
        "B15": "=_t(\"Selected period\")",
        "B16": "=PIVOT.HEADER(5,\"measure\",\"on_time_rate:sum\")",
        "B17": "=PIVOT.VALUE(5,\"on_time_rate:sum\")/100",
        "B18": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",1)",
        "B19": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",2)",
        "B20": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",3)",
        "B21": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",4)",
        "B22": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",5)",
        "B23": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",6)",
        "B24": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",7)",
        "B25": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",8)",
        "B26": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",9)",
        "B27": "=PIVOT.VALUE(5,\"on_time_rate:sum\",\"#partner_id\",10)",
        "B35": "=_t(\"Orders count\")",
        "B36": "=PIVOT.VALUE(9,\"__count\", \"#partner_id\",1)",
        "B37": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",2)",
        "B38": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",3)",
        "B39": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",4)",
        "B40": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",5)",
        "B41": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",6)",
        "B42": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",7)",
        "B43": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",8)",
        "B44": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",9)",
        "B45": "=PIVOT.VALUE(9,\"__count\",\"#partner_id\",10)",
        "B55": "=_t(\"Lead time\")",
        "B56": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",1)",
        "B57": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",2)",
        "B58": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",3)",
        "B59": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",4)",
        "B60": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",5)",
        "B61": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",6)",
        "B62": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",7)",
        "B63": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",8)",
        "B64": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",9)",
        "B65": "=PIVOT.VALUE(10,\"cycle_time:avg\",\"#partner_id\",10)",
        "B69": "=PIVOT.HEADER(11,\"measure\",\"delay:avg\")",
        "B70": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",1)",
        "B71": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",2)",
        "B72": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",3)",
        "B73": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",4)",
        "B74": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",5)",
        "B75": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",6)",
        "B76": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",7)",
        "B77": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",8)",
        "B78": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",9)",
        "B79": "=PIVOT.VALUE(11,\"delay:avg\",\"#reference\",10)",
        "B86": "=PIVOT.HEADER(12,\"measure\",\"__count\")",
        "B87": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",1) ",
        "B88": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",2)",
        "B89": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",3)",
        "B90": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",4)",
        "B91": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",5)",
        "B92": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",6)",
        "B93": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",7)",
        "B94": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",8)",
        "B95": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",9)",
        "B96": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",10)",
        "C2": "=PIVOT.HEADER(1,\"measure\",\"order_id\")",
        "C3": "=if(B1<>\"\",PIVOT.VALUE(2,\"order_id\"),\"N/A\")",
        "C4": "=PIVOT.VALUE(1,\"order_id\")",
        "C9": "=PIVOT.HEADER(6,\"measure\",\"qty_received:sum\")",
        "C10": "=PIVOT.VALUE(7,\"qty_received:sum\")",
        "C11": "=PIVOT.VALUE(6,\"qty_received:sum\")",
        "C15": "=_t(\"Previous period\")",
        "C16": "=PIVOT.HEADER(5,\"measure\",\"on_time_rate:sum\")",
        "C17": "=PIVOT.VALUE(8,\"on_time_rate:sum\")/100",
        "C18": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",1)",
        "C19": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",2)",
        "C20": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",3)",
        "C21": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",4)",
        "C22": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",5)",
        "C23": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",6)",
        "C24": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",7)",
        "C25": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",8)",
        "C26": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",9)",
        "C27": "=PIVOT.VALUE(8,\"on_time_rate:sum\",\"#partner_id\",10)",
        "C35": "=_t(\"Total value\")",
        "C36": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",1)",
        "C37": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",2)",
        "C38": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",3)",
        "C39": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",4)",
        "C40": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",5)",
        "C41": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",6)",
        "C42": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",7)",
        "C43": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",8)",
        "C44": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",9)",
        "C45": "=PIVOT.VALUE(9,\"price_total:sum\",\"#partner_id\",10)",
        "C55": "=_t(\"Global value\")",
        "C56": "=if(B56<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C57": "=if(B57<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C58": "=if(B58<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C59": "=if(B59<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C60": "=if(B60<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C61": "=if(B61<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C62": "=if(B62<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C63": "=if(B63<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C64": "=if(B64<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C65": "=if(B65<>\"\",PIVOT.VALUE(10,\"cycle_time:avg\"),\"\")",
        "C69": "=_t(\"Average global\")",
        "C70": "=if(B70<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C71": "=if(B71<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C72": "=if(B72<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C73": "=if(B73<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C74": "=if(B74<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C75": "=if(B75<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C76": "=if(B76<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C77": "=if(B77<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C78": "=if(B78<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C79": "=if(B79<>\"\",PIVOT.VALUE(11,\"delay:avg\"),\"\")",
        "C86": "=PIVOT.HEADER(12,\"measure\",\"price_total:sum\")",
        "C87": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",1) ",
        "C88": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",2)",
        "C89": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",3)",
        "C90": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",4)",
        "C91": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",5)",
        "C92": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",6)",
        "C93": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",7)",
        "C94": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",8)",
        "C95": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",9)",
        "C96": "=PIVOT.VALUE(12,\"price_total:sum\",\"#product_id\",10)",
        "D2": "=PIVOT.HEADER(1,\"measure\",\"price_total\")",
        "D3": "=  if( PIVOT.VALUE(2,\"price_total\")<>\"\",    PIVOT.VALUE(2,\"price_total\"),\"N/A\")",
        "D4": "=PIVOT.VALUE(1,\"price_total\")",
        "D9": "=_t(\"Fill rate\")",
        "D10": "=iferror(C10/B10,\"N/A\")",
        "D11": "=iferror(C11/B11,\"N/A\")",
        "D86": "=PIVOT.HEADER(12,\"measure\",\"price_average:avg\")",
        "D87": "=PIVOT.VALUE(12,\"qty_ordered:sum\",\"#product_id\",1) ",
        "D88": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",2)",
        "D89": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",3)",
        "D90": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",4)",
        "D91": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",5)",
        "D92": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",6)",
        "D93": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",7)",
        "D94": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",8)",
        "D95": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",9)",
        "D96": "=PIVOT.VALUE(12,\"price_average:avg\",\"#product_id\",10)",
        "E2": "=PIVOT.HEADER(1,\"measure\",\"qty_ordered\")",
        "E3": "= if( PIVOT.VALUE(2,\"qty_ordered\")<>\"\",    PIVOT.VALUE(2,\"qty_ordered\"),\"N/A\")",
        "E4": "=PIVOT.VALUE(1,\"qty_ordered\")",
        "E56": "=SORT(A56:C65,2,false)",
        "E86": "=PIVOT.HEADER(12,\"measure\",\"delay_pass:avg\")",
        "E87": "=PIVOT.VALUE(12,\"__count\",\"#product_id\",1) ",
        "E88": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",2)",
        "E89": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",3)",
        "E90": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",4)",
        "E91": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",5)",
        "E92": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",6)",
        "E93": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",7)",
        "E94": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",8)",
        "E95": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",9)",
        "E96": "=PIVOT.VALUE(12,\"delay_pass:avg\",\"#product_id\",10)",
        "F2": "=PIVOT.HEADER(1,\"measure\",\"qty_received\")",
        "F3": "=if( PIVOT.VALUE(2,\"qty_received\")<>\"\",    PIVOT.VALUE(2,\"qty_received\"),\"N/A\")",
        "F4": "=PIVOT.VALUE(1,\"qty_received\")",
        "F55": "=_t(\"Lead time\")",
        "G2": "=PIVOT.HEADER(1,\"measure\",\"delay\")",
        "G3": "=if(B1<>\"\",round(PIVOT.VALUE(2,\"delay\"),0)& \" day\"& if(round(PIVOT.VALUE(2,\"delay\"),0)>1,\"s\",\"\"),\"N/A\")",
        "G4": "=ROUND(PIVOT.VALUE(1,\"delay\"),0)& \" day\"& if(round(PIVOT.VALUE(1,\"delay\"),0)>1,\"s\",\"\")",
        "G16": "=PIVOT.HEADER(13,\"picking_name\",\"WH/IN/00007\")",
        "G17": "=PIVOT.HEADER(13)",
        "G55": "=_t(\"Global value\")",
        "H2": "=PIVOT.HEADER(1,\"measure\",\"delay_pass\")",
        "H3": "=if(B1<>\"\",round(PIVOT.VALUE(2,\"delay_pass\"),0)& \" days\",\"N/A\")",
        "H4": "=round(PIVOT.VALUE(1,\"delay_pass\"),0)& \" days\"",
        "H14": "=PIVOT.HEADER(13)",
        "H15": "=PIVOT.HEADER(13,\"measure\",\"delay:avg\")",
        "H16": "=PIVOT.VALUE(13,\"delay:avg\",\"picking_name\",\"WH/IN/00007\")",
        "H17": "=PIVOT.VALUE(13,\"delay:avg\")",
        "I2": "=_t(\"Average order\")",
        "I3": "=if(B1<>\"\",iferror(D3/C3,\"N/A\"),\"N/A\")",
        "I4": "=iferror(D4/C4,\"N/A\")",
        "J2": "=_t(\"Fill rate\")",
        "J3": "=if(ODOO.FILTER.VALUE(\"Order date\")<>\"\",iferror(F3/E3,\"N/A\"),\"N/A\")",
        "J4": "=iferror(F4/E4,\"N/A\")"
      },
      "styles": {
        "A9": 6,
        "A14:A15": 6,
        "C14": 6,
        "B8:D8": 6,
        "A2:J2": 6,
        "A4": 7,
        "A11": 7,
        "A8": 8,
        "B14:B15": 8,
        "C15": 8,
        "B9:D9": 8,
        "A34:C34": 9,
        "A54:C54": 9,
        "A68:C68": 9
      },
      "formats": {
        "B36:B45": 2,
        "B87:B96": 2,
        "B4:C4": 2,
        "B10:C11": 3,
        "B18:C27": 3,
        "C36:C45": 3,
        "B56:C65": 3,
        "B70:C79": 3,
        "C87:E96": 3,
        "D3:F4": 3,
        "I4": 3,
        "D10:D11": 4,
        "J4": 4
      },
      "borders": {
        "A9": 8,
        "J15:K15": 8,
        "A10": 9,
        "A11": 10,
        "J16": 10,
        "A12": 11,
        "J17:K17": 11,
        "A16:A26": 12,
        "A37:A44": 12,
        "A56:A64": 12,
        "A71:A78": 12,
        "D16:D27": 12,
        "D36:D45": 12,
        "D70:D79": 12,
        "E56:E64": 12,
        "H55:H65": 12,
        "A27": 13,
        "A45": 13,
        "A65": 13,
        "A79": 13,
        "E65": 13,
        "B36": 14,
        "B70": 14,
        "A28:C28": 14,
        "A46:C46": 14,
        "A66:C66": 14,
        "A80:C80": 14,
        "E66:G66": 14,
        "B27": 15,
        "B45": 15,
        "B65": 15,
        "B79": 15,
        "A35:C35": 15,
        "A54:C54": 15,
        "A69:C69": 15,
        "F65": 15,
        "E54:G54": 15,
        "A36": 16,
        "A55": 16,
        "A70": 16,
        "E55": 16,
        "B55": 17,
        "C36": 17,
        "C70": 17,
        "F55": 17,
        "C16:C26": 18,
        "C37:C44": 18,
        "C56:C64": 18,
        "C71:C78": 18,
        "G56:G64": 18,
        "C27": 19,
        "C45": 19,
        "C65": 19,
        "C79": 19,
        "G65": 19,
        "C55": 20,
        "G55": 20,
        "D55:D65": 21,
        "I16": 22,
        "K16": 23,
        "L16": 24
      },
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [
        {
          "range": "A2:J4",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": false,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "TableStyleLight5"
          }
        },
        {
          "range": "A8:D11",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 2,
            "bandedRows": false,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "TableStyleLight5"
          }
        },
        {
          "range": "A14:C27",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 2,
            "bandedRows": false,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "TableStyleLight5"
          }
        },
        {
          "range": "G14:H17",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": true,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "styleId": "TableStyleMedium5",
            "automaticAutofill": true
          }
        }
      ],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    }
  ],
  "styles": {
    "1": { "fontSize": 16, "bold": true, "textColor": "#01636B" },
    "2": { "textColor": "#434343", "bold": true, "fontSize": 11 },
    "3": { "textColor": "#01636B", "verticalAlign": "middle" },
    "4": { "textColor": "#434343", "verticalAlign": "middle" },
    "5": {
      "textColor": "#434343",
      "bold": true,
      "fontSize": 11,
      "align": "center"
    },
    "6": { "fillColor": "#E4D9E1" },
    "7": { "bold": true },
    "8": { "fillColor": "#E4D9E1", "bold": true },
    "9": { "align": "center", "bold": true }
  },
  "formats": { "1": "@", "2": "0", "3": "#,##0.00", "4": "0.00%" },
  "borders": {
    "1": {
      "bottom": { "style": "thin", "color": "#CCCCCC" }
    },
    "2": {
      "top": { "style": "thin", "color": "#CCCCCC" }
    },
    "3": {
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "4": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "5": {
      "top": { "style": "thick", "color": "#FFFFFF" }
    },
    "6": {
      "top": { "style": "thin", "color": "#CCCCCC" },
      "bottom": { "style": "thin", "color": "#FFFFFF" }
    },
    "7": {
      "top": { "style": "thin", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "8": {
      "bottom": { "color": "#B498AE", "style": "thin" }
    },
    "9": {
      "top": { "color": "#B498AE", "style": "thin" },
      "bottom": { "color": "#B498AE", "style": "thin" }
    },
    "10": {
      "left": { "color": "#B498AE", "style": "thin" },
      "top": { "color": "#B498AE", "style": "thin" },
      "bottom": { "color": "#B498AE", "style": "thin" }
    },
    "11": {
      "top": { "color": "#B498AE", "style": "thin" }
    },
    "12": {
      "left": { "style": "thin", "color": "#000000" }
    },
    "13": {
      "left": { "style": "thin", "color": "#000000" },
      "bottom": { "style": "thin", "color": "#000000" }
    },
    "14": {
      "top": { "style": "thin", "color": "#000000" }
    },
    "15": {
      "bottom": { "style": "thin", "color": "#000000" }
    },
    "16": {
      "left": { "style": "thin", "color": "#000000" },
      "top": { "style": "thin", "color": "#000000" }
    },
    "17": {
      "top": { "style": "thin", "color": "#000000" },
      "right": { "style": "thin", "color": "#000000" }
    },
    "18": {
      "right": { "style": "thin", "color": "#000000" }
    },
    "19": {
      "right": { "style": "thin", "color": "#000000" },
      "bottom": { "style": "thin", "color": "#000000" }
    },
    "20": {
      "left": { "style": "thin", "color": "#000000" },
      "top": { "style": "thin", "color": "#000000" },
      "right": { "style": "thin", "color": "#000000" }
    },
    "21": {
      "left": { "style": "thin", "color": "#000000" },
      "right": { "style": "thin", "color": "#000000" }
    },
    "22": {
      "right": { "color": "#B498AE", "style": "thin" }
    },
    "23": {
      "top": { "color": "#B498AE", "style": "thin" },
      "right": { "color": "#B498AE", "style": "thin" },
      "bottom": { "color": "#B498AE", "style": "thin" }
    },
    "24": {
      "left": { "color": "#B498AE", "style": "thin" }
    }
  },
  "revisionId": "START_REVISION",
  "uniqueFigureIds": true,
  "settings": {
    "locale": {
      "name": "English (US)",
      "code": "en_US",
      "thousandsSeparator": ",",
      "decimalSeparator": ".",
      "dateFormat": "mm/dd/yyyy",
      "timeFormat": "hh:mm:ss",
      "formulaArgSeparator": ",",
      "weekStart": 7
    }
  },
  "pivots": {
    "e201d49b-b62d-4d8d-8fc6-9b24be90e383": {
      "type": "ODOO",
      "domain": [
        "&",
        "&",
        ["state", "!=", "draft"],
        ["state", "!=", "sent"],
        ["state", "!=", "cancel"]
      ],
      "context": {},
      "sortedColumn": null,
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "order_id",
          "fieldName": "order_id",
          "aggregator": "count_distinct"
        },
        { "id": "price_total", "fieldName": "price_total", "aggregator": "sum" },
        { "id": "qty_ordered", "fieldName": "qty_ordered", "aggregator": "sum" },
        { "id": "qty_received", "fieldName": "qty_received", "aggregator": "sum" },
        { "id": "delay", "fieldName": "delay", "aggregator": "avg" },
        { "id": "delay_pass", "fieldName": "delay_pass", "aggregator": "avg" }
      ],
      "model": "purchase.report",
      "columns": [],
      "rows": [],
      "name": "Purchase Analysis",
      "actionXmlId": "purchase.action_purchase_order_report_all",
      "formulaId": "1",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime", "offset": 0 },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "70523a3c-eeae-48d9-9cc9-7189bac49948": {
      "type": "ODOO",
      "domain": [
        "&",
        "&",
        ["state", "!=", "draft"],
        ["state", "!=", "sent"],
        ["state", "!=", "cancel"]
      ],
      "context": {},
      "sortedColumn": null,
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "order_id",
          "fieldName": "order_id",
          "aggregator": "count_distinct"
        },
        { "id": "price_total", "fieldName": "price_total", "aggregator": "sum" },
        { "id": "qty_ordered", "fieldName": "qty_ordered", "aggregator": "sum" },
        { "id": "qty_received", "fieldName": "qty_received", "aggregator": "sum" },
        { "id": "delay", "fieldName": "delay", "aggregator": "avg" },
        { "id": "delay_pass", "fieldName": "delay_pass", "aggregator": "avg" }
      ],
      "model": "purchase.report",
      "columns": [],
      "rows": [],
      "name": "Purchase Analysis (comparison period)",
      "actionXmlId": "purchase.action_purchase_order_report_all",
      "formulaId": "2",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime", "offset": -2 },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "199b2891-1cb1-4819-a671-b7cf81d257ee": {
      "type": "ODOO",
      "domain": [],
      "context": {
        "active_id": 27,
        "active_ids": [27]
      },
      "sortedColumn": {
        "measure": "on_time_rate:sum",
        "order": "desc",
        "domain": []
      },
      "measures": [
        {
          "id": "on_time_rate:sum",
          "fieldName": "on_time_rate",
          "aggregator": "sum",
          "format": "0.00%"
        }
      ],
      "model": "vendor.delay.report",
      "columns": [],
      "rows": [
        { "fieldName": "partner_id" }
      ],
      "name": "Delay Report by Vendor",
      "actionXmlId": "purchase_stock.action_purchase_vendor_delay_report",
      "formulaId": "5",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date", "type": "datetime", "offset": 0 },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": {},
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "0f734312-7aca-4de4-899e-9be29f8db77a": {
      "type": "ODOO",
      "domain": [
        "&",
        ["order_id.picking_ids", "!=", false],
        "&",
        ["state", "!=", "draft"],
        "&",
        ["state", "!=", "sent"],
        ["state", "!=", "cancel"]
      ],
      "context": {},
      "sortedColumn": null,
      "measures": [
        {
          "id": "qty_ordered:sum",
          "fieldName": "qty_ordered",
          "aggregator": "sum"
        },
        {
          "id": "qty_received:sum",
          "fieldName": "qty_received",
          "aggregator": "sum"
        }
      ],
      "model": "purchase.report",
      "columns": [],
      "rows": [
        { "fieldName": "partner_id" }
      ],
      "name": "Purchase Analysis orders with receptions",
      "actionXmlId": "purchase.action_purchase_order_report_all",
      "formulaId": "6",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime" },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "42c079fd-738e-42a2-9e48-d284ac91cec8": {
      "type": "ODOO",
      "domain": [
        "&",
        ["order_id.picking_ids", "!=", false],
        "&",
        ["state", "!=", "draft"],
        "&",
        ["state", "!=", "sent"],
        ["state", "!=", "cancel"]
      ],
      "context": {},
      "sortedColumn": null,
      "measures": [
        {
          "id": "qty_ordered:sum",
          "fieldName": "qty_ordered",
          "aggregator": "sum"
        },
        {
          "id": "qty_received:sum",
          "fieldName": "qty_received",
          "aggregator": "sum"
        }
      ],
      "model": "purchase.report",
      "columns": [],
      "rows": [
        { "fieldName": "partner_id" }
      ],
      "name": "Purchase Analysis orders with receptions (comparison period)",
      "actionXmlId": "purchase.action_purchase_order_report_all",
      "formulaId": "7",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime", "offset": -2 },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "54896f88-c43a-48d5-b4e6-680f8185c4be": {
      "type": "ODOO",
      "domain": [],
      "context": {
        "active_id": 27,
        "active_ids": [27]
      },
      "sortedColumn": {
        "measure": "on_time_rate:sum",
        "order": "desc",
        "domain": []
      },
      "measures": [
        {
          "id": "on_time_rate:sum",
          "fieldName": "on_time_rate",
          "aggregator": "sum",
          "format": "0.00%"
        }
      ],
      "model": "vendor.delay.report",
      "columns": [],
      "rows": [
        { "fieldName": "partner_id" }
      ],
      "name": "Vendor Delay Report by Vendor (comparison period)",
      "actionXmlId": "purchase_stock.action_purchase_vendor_delay_report",
      "formulaId": "8",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date", "type": "datetime", "offset": -2 },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": {},
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "5afaf175-5128-4a21-8ca7-e5a8cbcfb66f": {
      "type": "ODOO",
      "domain": [
        "&",
        ["state", "!=", "draft"],
        "&",
        ["state", "!=", "sent"],
        ["state", "!=", "cancel"]
      ],
      "context": {},
      "sortedColumn": {
        "measure": "price_total:sum",
        "order": "desc",
        "domain": []
      },
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "price_total:sum",
          "fieldName": "price_total",
          "aggregator": "sum"
        }
      ],
      "model": "purchase.report",
      "columns": [],
      "rows": [
        { "fieldName": "partner_id" }
      ],
      "name": "Purchase Analysis by Vendor",
      "actionXmlId": "purchase.action_purchase_order_report_all",
      "formulaId": "9",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime" },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "a8bd5818-7e66-4d55-bf02-e96d4044adbd": {
      "type": "ODOO",
      "domain": [
        "&",
        ["picking_type_code", "=", "incoming"],
        ["state", "=", "done"]
      ],
      "context": {},
      "measures": [
        { "id": "cycle_time:avg", "fieldName": "cycle_time", "aggregator": "avg" }
      ],
      "model": "stock.report",
      "columns": [],
      "rows": [
        { "fieldName": "partner_id" }
      ],
      "name": "Stock Overview  by supplier",
      "actionXmlId": "stock_enterprise.stock_report_action_performance",
      "formulaId": "10",
      "fieldMatching": {
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "picking_id.purchase_id.user_id", "type": "many2one" },
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "creation_date", "type": "datetime", "offset": 0 },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "categ_id", "type": "many2one" }
      }
    },
    "e5c3dcd9-f846-466c-acef-026ff4abc128": {
      "type": "ODOO",
      "domain": [
        "&",
        ["picking_type_code", "!=", false],
        "&",
        ["is_late", "=", true],
        "&",
        ["state", "=", "done"],
        ["picking_type_code", "=", "incoming"]
      ],
      "context": {},
      "sortedColumn": {
        "measure": "delay:avg",
        "order": "desc",
        "domain": []
      },
      "measures": [
        { "id": "delay:avg", "fieldName": "delay", "aggregator": "avg" },
        { "id": "__count", "fieldName": "__count" }
      ],
      "model": "stock.report",
      "columns": [],
      "rows": [
        { "fieldName": "reference" }
      ],
      "name": "Stock Overview by Reference",
      "actionXmlId": "stock_enterprise.stock_report_action_performance",
      "formulaId": "11",
      "fieldMatching": {
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "picking_id.purchase_id.user_id", "type": "many2one" },
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "creation_date", "type": "datetime", "offset": 0 },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "categ_id", "type": "many2one" }
      }
    },
    "62839209-cede-424e-ace3-5f2a11bb24d4": {
      "type": "ODOO",
      "domain": [
        "&",
        "&",
        ["state", "!=", "draft"],
        ["state", "!=", "sent"],
        ["state", "!=", "cancel"]
      ],
      "context": {},
      "sortedColumn": {
        "measure": "price_total:sum",
        "order": "desc",
        "domain": []
      },
      "measures": [
        { "id": "__count", "fieldName": "__count" },
        {
          "id": "price_total:sum",
          "fieldName": "price_total",
          "aggregator": "sum"
        },
        {
          "id": "qty_ordered:sum",
          "fieldName": "qty_ordered",
          "aggregator": "sum"
        },
        {
          "id": "price_average:avg",
          "fieldName": "price_average",
          "aggregator": "avg"
        },
        { "id": "delay_pass:avg", "fieldName": "delay_pass", "aggregator": "avg" }
      ],
      "model": "purchase.report",
      "columns": [],
      "rows": [
        { "fieldName": "product_id" }
      ],
      "name": "Product",
      "actionXmlId": "purchase.action_purchase_order_report_all",
      "formulaId": "12",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "date_order", "type": "datetime" },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "category_id", "type": "many2one" }
      }
    },
    "51f5e50e-a60e-4096-ade2-0d6019fe9fe9": {
      "type": "ODOO",
      "domain": [
        "&",
        ["picking_type_code", "!=", false],
        "&",
        ["is_late", "=", true],
        "&",
        ["state", "=", "done"],
        ["picking_type_code", "=", "incoming"]
      ],
      "context": {},
      "sortedColumn": {
        "measure": "delay:avg",
        "order": "desc",
        "domain": []
      },
      "measures": [
        {
          "id": "delay:avg",
          "fieldName": "delay",
          "aggregator": "avg",
          "isHidden": false
        }
      ],
      "model": "stock.report",
      "columns": [],
      "rows": [
        { "fieldName": "picking_name" }
      ],
      "name": "Picking Name",
      "actionXmlId": "stock_enterprise.stock_report_action_performance",
      "formulaId": "13",
      "fieldMatching": {
        "3e8575de-1649-4bcb-9e8c-367655452c70": { "chain": "creation_date", "type": "datetime" },
        "eaabbadf-abbf-46a1-ab7b-00f0c73e453e": { "chain": "partner_id", "type": "many2one" },
        "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a": { "chain": "picking_id.purchase_id.user_id", "type": "many2one" },
        "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32": { "chain": "product_id", "type": "many2one" },
        "698db1cf-95a4-4fa6-8364-56ff2d5b0adf": { "chain": "categ_id", "type": "many2one" }
      }
    }
  },
  "pivotNextId": 14,
  "customTableStyles": {},
  "globalFilters": [
    {
      "id": "3e8575de-1649-4bcb-9e8c-367655452c70",
      "type": "date",
      "label": "Order date"
    },
    {
      "id": "eaabbadf-abbf-46a1-ab7b-00f0c73e453e",
      "type": "relation",
      "label": "Vendor",
      "defaultValueDisplayNames": [],
      "modelName": "res.partner",
      "includeChildren": false
    },
    {
      "id": "99ff934e-4d52-4353-a1a3-b4c0f4dfe03a",
      "type": "relation",
      "label": "Buyer",
      "defaultValueDisplayNames": [],
      "modelName": "res.users",
      "includeChildren": false
    },
    {
      "id": "41a58f16-d8c0-4ede-a391-ef2fcaaa0e32",
      "type": "relation",
      "label": "Product",
      "defaultValueDisplayNames": [],
      "modelName": "product.product",
      "includeChildren": false
    },
    {
      "id": "698db1cf-95a4-4fa6-8364-56ff2d5b0adf",
      "type": "relation",
      "label": "Product Category",
      "defaultValueDisplayNames": [],
      "modelName": "product.category",
      "includeChildren": true
    }
  ],
  "lists": {
    "1": {
      "columns": [
        "priority",
        "name",
        "partner_id",
        "company_id",
        "user_id",
        "date_order",
        "activity_ids",
        "origin",
        "amount_total",
        "state"
      ],
      "domain": [
        ["state", "=", "purchase"]
      ],
      "model": "purchase.order",
      "context": { "quotation_only": true },
      "orderBy": [
        { "name": "amount_total", "asc": false }
      ],
      "id": "1",
      "name": "Purchase orders by Total",
      "fieldMatching": {}
    },
    "5": {
      "columns": [
        "priority",
        "name",
        "partner_id",
        "scheduled_date",
        "origin",
        "company_id",
        "state",
        "activity_exception_decoration",
        "json_popover"
      ],
      "domain": [
        "&",
        ["has_deadline_issue", "=", true],
        "&",
        ["state", "=", "done"],
        "&",
        ["picking_type_code", "=", "incoming"],
        ["location_id.usage", "=", "supplier"]
      ],
      "model": "stock.picking",
      "context": {
        "contact_display": "partner_address",
        "restricted_picking_type_code": "incoming"
      },
      "orderBy": [],
      "id": "5",
      "name": "Receipts",
      "fieldMatching": {}
    }
  },
  "listNextId": 6,
  "chartOdooMenusReferences": {
    "4d31c500-1186-498b-b589-d7b4ce1ccc4b": "purchase.menu_purchase_root",
    "98f4f82c-16ed-4d9f-9bef-6965a0c35513": "purchase.menu_purchase_form_action",
    "a876a7f1-80d3-4bce-a533-12ed1fa0def1": "purchase.menu_purchase_form_action",
    "72b620ea-22fe-4fe6-aceb-02898ae59a8a": "purchase.purchase_report",
    "460a1cef-70a5-4190-b681-6483e826bd09": "purchase.menu_purchase_form_action",
    "310ab7a9-fcb7-4db3-8369-fcfddec9f178": "purchase.menu_purchase_form_action"
  }
}
