{
    "version": 21,
    "sheets": [
        {
            "id": "sheet1",
            "name": "Dashboard",
            "colNumber": 11,
            "rowNumber": 85,
            "rows": {
                "6": { "size": 37 },
                "21": { "size": 44 },
                "22": { "size": 33 },
                "23": { "size": 30 },
                "24": { "size": 30 },
                "25": { "size": 30 },
                "26": { "size": 30 },
                "27": { "size": 30 },
                "28": { "size": 30 },
                "29": { "size": 30 },
                "30": { "size": 30 },
                "31": { "size": 30 },
                "32": { "size": 30 },
                "33": { "size": 41 },
                "34": { "size": 33 },
                "35": { "size": 30 },
                "36": { "size": 30 },
                "37": { "size": 30 },
                "38": { "size": 30 },
                "39": { "size": 30 },
                "40": { "size": 30 },
                "41": { "size": 30 },
                "42": { "size": 30 },
                "43": { "size": 30 },
                "44": { "size": 30 },
                "45": { "size": 42 },
                "46": { "size": 33 },
                "47": { "size": 30 },
                "48": { "size": 30 },
                "49": { "size": 30 },
                "50": { "size": 30 },
                "51": { "size": 30 },
                "52": { "size": 30 },
                "53": { "size": 30 },
                "54": { "size": 30 },
                "55": { "size": 30 },
                "56": { "size": 30 },
                "58": { "size": 35 }
            },
            "cols": {
                "2": { "size": 127 },
                "4": { "size": 128 },
                "5": { "size": 34 },
                "7": { "size": 132 },
                "8": { "size": 127 }
            },
            "merges": ["A58:E58", "G58:K58"],
            "cells": {
                "A7": { "content": "=_t(\"Transfer to be assigned\")" },
                "A22": { "content": "=_t(\"Open receptions to date\")" },
                "A34": {
                    "content": "=_t(\"Open internal transfers to date\")"
                },
                "A46": { "content": "=_t(\"Open deliveries to date\")" },
                "A59": { "content": "=_t(\"Receptions next 7 days\")" },
                "G7": { "content": "=_t(\"Open transfers to date\")" },
                "G22": { "content": "=_t(\"Open late receipts\")" },
                "G23": { "content": "=_t(\"Transfer\")" },
                "G24": { "content": "=ODOO.LIST(6,1,\"name\")" },
                "G25": { "content": "=ODOO.LIST(6,2,\"name\")" },
                "G26": { "content": "=ODOO.LIST(6,3,\"name\")" },
                "G27": { "content": "=ODOO.LIST(6,4,\"name\")" },
                "G28": { "content": "=ODOO.LIST(6,5,\"name\")" },
                "G29": { "content": "=ODOO.LIST(6,6,\"name\")" },
                "G30": { "content": "=ODOO.LIST(6,7,\"name\")" },
                "G31": { "content": "=ODOO.LIST(6,8,\"name\")" },
                "G32": { "content": "=ODOO.LIST(6,9,\"name\")" },
                "G33": { "content": "=ODOO.LIST(6,10,\"name\")" },
                "G34": { "content": "=_t(\"Open late internal transfers\")" },
                "G35": { "content": "=_t(\"Transfer\")" },
                "G36": { "content": "=ODOO.LIST(3,1,\"name\")" },
                "G37": { "content": "=ODOO.LIST(3,2,\"name\")" },
                "G38": { "content": "=ODOO.LIST(3,3,\"name\")" },
                "G39": { "content": "=ODOO.LIST(3,4,\"name\")" },
                "G40": { "content": "=ODOO.LIST(3,5,\"name\")" },
                "G41": { "content": "=ODOO.LIST(3,6,\"name\")" },
                "G42": { "content": "=ODOO.LIST(3,7,\"name\")" },
                "G43": { "content": "=ODOO.LIST(3,8,\"name\")" },
                "G44": { "content": "=ODOO.LIST(3,9,\"name\")" },
                "G45": { "content": "=ODOO.LIST(3,10,\"name\")" },
                "G46": { "content": "=_t(\"Open late deliveries\")" },
                "G47": { "content": "=_t(\"Transfer\")" },
                "G48": { "content": "=ODOO.LIST(2,1,\"name\")" },
                "G49": { "content": "=ODOO.LIST(2,2,\"name\")" },
                "G50": { "content": "=ODOO.LIST(2,3,\"name\")" },
                "G51": { "content": "=ODOO.LIST(2,4,\"name\")" },
                "G52": { "content": "=ODOO.LIST(2,5,\"name\")" },
                "G53": { "content": "=ODOO.LIST(2,6,\"name\")" },
                "G54": { "content": "=ODOO.LIST(2,7,\"name\")" },
                "G55": { "content": "=ODOO.LIST(2,8,\"name\")" },
                "G56": { "content": "=ODOO.LIST(2,9,\"name\")" },
                "G57": { "content": "=ODOO.LIST(2,10,\"name\")" },
                "G59": { "content": "=_t(\"Deliveries next 7 days\")" },
                "H23": { "content": "=_t(\"Scheduled on\")" },
                "H24": { "content": "=ODOO.LIST(6,1,\"scheduled_date\")" },
                "H25": { "content": "=ODOO.LIST(6,2,\"scheduled_date\")" },
                "H26": { "content": "=ODOO.LIST(6,3,\"scheduled_date\")" },
                "H27": { "content": "=ODOO.LIST(6,4,\"scheduled_date\")" },
                "H28": { "content": "=ODOO.LIST(6,5,\"scheduled_date\")" },
                "H29": { "content": "=ODOO.LIST(6,6,\"scheduled_date\")" },
                "H30": { "content": "=ODOO.LIST(6,7,\"scheduled_date\")" },
                "H31": { "content": "=ODOO.LIST(6,8,\"scheduled_date\")" },
                "H32": { "content": "=ODOO.LIST(6,9,\"scheduled_date\")" },
                "H33": { "content": "=ODOO.LIST(6,10,\"scheduled_date\")" },
                "H35": { "content": "=_t(\"Scheduled on\")" },
                "H36": { "content": "=ODOO.LIST(3,1,\"scheduled_date\")" },
                "H37": { "content": "=ODOO.LIST(3,2,\"scheduled_date\")" },
                "H38": { "content": "=ODOO.LIST(3,3,\"scheduled_date\")" },
                "H39": { "content": "=ODOO.LIST(3,4,\"scheduled_date\")" },
                "H40": { "content": "=ODOO.LIST(3,5,\"scheduled_date\")" },
                "H41": { "content": "=ODOO.LIST(3,6,\"scheduled_date\")" },
                "H42": { "content": "=ODOO.LIST(3,7,\"scheduled_date\")" },
                "H43": { "content": "=ODOO.LIST(3,8,\"scheduled_date\")" },
                "H44": { "content": "=ODOO.LIST(3,9,\"scheduled_date\")" },
                "H45": { "content": "=ODOO.LIST(3,10,\"scheduled_date\")" },
                "H47": { "content": "=_t(\"Scheduled on\")" },
                "H48": { "content": "=ODOO.LIST(2,1,\"scheduled_date\")" },
                "H49": { "content": "=ODOO.LIST(2,2,\"scheduled_date\")" },
                "H50": { "content": "=ODOO.LIST(2,3,\"scheduled_date\")" },
                "H51": { "content": "=ODOO.LIST(2,4,\"scheduled_date\")" },
                "H52": { "content": "=ODOO.LIST(2,5,\"scheduled_date\")" },
                "H53": { "content": "=ODOO.LIST(2,6,\"scheduled_date\")" },
                "H54": { "content": "=ODOO.LIST(2,7,\"scheduled_date\")" },
                "H55": { "content": "=ODOO.LIST(2,8,\"scheduled_date\")" },
                "H56": { "content": "=ODOO.LIST(2,9,\"scheduled_date\")" },
                "H57": { "content": "=ODOO.LIST(2,10,\"scheduled_date\")" },
                "I23": { "content": "=_t(\"Responsible\")" },
                "I24": { "content": "=ODOO.LIST(6,1,\"user_id\")" },
                "I25": { "content": "=ODOO.LIST(6,2,\"user_id\")" },
                "I26": { "content": "=ODOO.LIST(6,3,\"user_id\")" },
                "I27": { "content": "=ODOO.LIST(6,4,\"user_id\")" },
                "I28": { "content": "=ODOO.LIST(6,5,\"user_id\")" },
                "I29": { "content": "=ODOO.LIST(6,6,\"user_id\")" },
                "I30": { "content": "=ODOO.LIST(6,7,\"user_id\")" },
                "I31": { "content": "=ODOO.LIST(6,8,\"user_id\")" },
                "I32": { "content": "=ODOO.LIST(6,9,\"user_id\")" },
                "I33": { "content": "=ODOO.LIST(6,10,\"user_id\")" },
                "I35": { "content": "=_t(\"Responsible\")" },
                "I36": { "content": "=ODOO.LIST(3,1,\"user_id\")" },
                "I37": { "content": "=ODOO.LIST(3,2,\"user_id\")" },
                "I38": { "content": "=ODOO.LIST(3,3,\"user_id\")" },
                "I39": { "content": "=ODOO.LIST(3,4,\"user_id\")" },
                "I40": { "content": "=ODOO.LIST(3,5,\"user_id\")" },
                "I41": { "content": "=ODOO.LIST(3,6,\"user_id\")" },
                "I42": { "content": "=ODOO.LIST(3,7,\"user_id\")" },
                "I43": { "content": "=ODOO.LIST(3,8,\"user_id\")" },
                "I44": { "content": "=ODOO.LIST(3,9,\"user_id\")" },
                "I45": { "content": "=ODOO.LIST(3,10,\"user_id\")" },
                "I47": { "content": "=_t(\"Responsible\")" },
                "I48": { "content": "=ODOO.LIST(2,1,\"user_id\")" },
                "I49": { "content": "=ODOO.LIST(2,2,\"user_id\")" },
                "I50": { "content": "=ODOO.LIST(2,3,\"user_id\")" },
                "I51": { "content": "=ODOO.LIST(2,4,\"user_id\")" },
                "I52": { "content": "=ODOO.LIST(2,5,\"user_id\")" },
                "I53": { "content": "=ODOO.LIST(2,6,\"user_id\")" },
                "I54": { "content": "=ODOO.LIST(2,7,\"user_id\")" },
                "I55": { "content": "=ODOO.LIST(2,8,\"user_id\")" },
                "I56": { "content": "=ODOO.LIST(2,9,\"user_id\")" },
                "I57": { "content": "=ODOO.LIST(2,10,\"user_id\")" },
                "J23": { "content": "=_t(\"Vendor\")" },
                "J24": { "content": "=ODOO.LIST(6,1,\"partner_id\")" },
                "J25": { "content": "=ODOO.LIST(6,2,\"partner_id\")" },
                "J26": { "content": "=ODOO.LIST(6,3,\"partner_id\")" },
                "J27": { "content": "=ODOO.LIST(6,4,\"partner_id\")" },
                "J28": { "content": "=ODOO.LIST(6,5,\"partner_id\")" },
                "J29": { "content": "=ODOO.LIST(6,6,\"partner_id\")" },
                "J30": { "content": "=ODOO.LIST(6,7,\"partner_id\")" },
                "J31": { "content": "=ODOO.LIST(6,8,\"partner_id\")" },
                "J32": { "content": "=ODOO.LIST(6,9,\"partner_id\")" },
                "J33": { "content": "=ODOO.LIST(6,10,\"partner_id\")" },
                "J47": { "content": "=_t(\"Customer\")" },
                "J48": { "content": "=ODOO.LIST(2,1,\"partner_id\")" },
                "J49": { "content": "=ODOO.LIST(2,2,\"partner_id\")" },
                "J50": { "content": "=ODOO.LIST(2,3,\"partner_id\")" },
                "J51": { "content": "=ODOO.LIST(2,4,\"partner_id\")" },
                "J52": { "content": "=ODOO.LIST(2,5,\"partner_id\")" },
                "J53": { "content": "=ODOO.LIST(2,6,\"partner_id\")" },
                "J54": { "content": "=ODOO.LIST(2,7,\"partner_id\")" },
                "J55": { "content": "=ODOO.LIST(2,8,\"partner_id\")" },
                "J56": { "content": "=ODOO.LIST(2,9,\"partner_id\")" },
                "J57": { "content": "=ODOO.LIST(2,10,\"partner_id\")" }
            },
            "styles": {
                "A7": 1,
                "A22": 1,
                "A34": 1,
                "A46": 1,
                "A59": 1,
                "G7": 1,
                "G22": 1,
                "G34": 1,
                "G46": 1,
                "G59": 1,
                "K46": 1,
                "A24:F33": 2,
                "A36:F45": 2,
                "A48:F57": 2,
                "B7:F7": 3,
                "B22:F22": 3,
                "B34:F34": 3,
                "B46:F46": 3,
                "B59:F59": 3,
                "H46:J46": 3,
                "H22:K22": 3,
                "H34:K34": 3,
                "H59:K59": 3,
                "G35:I35": 4,
                "G23:J23": 4,
                "K35": 4,
                "G47:K47": 4,
                "G24:G33": 5,
                "G36:G45": 5,
                "G48:G57": 5,
                "H7:K7": 6,
                "H24:J33": 7,
                "K30:K33": 7,
                "H36:K45": 7,
                "H48:K57": 7
            },
            "formats": { "B48:C57": 1 },
            "borders": {
                "A7:E7": 1,
                "A22:E22": 1,
                "A34:E34": 1,
                "A46:E46": 1,
                "A59:E59": 1,
                "G7:K7": 1,
                "G22:K22": 1,
                "G34:K34": 1,
                "G46:K46": 1,
                "G59:K59": 1,
                "A8:E8": 2,
                "A23:E23": 2,
                "A35:E35": 2,
                "A47:E47": 2,
                "A60:E60": 2,
                "G8:K8": 2,
                "G23:K23": 2,
                "G35:K35": 2,
                "G47:K47": 2,
                "G60:K60": 2
            },
            "conditionalFormats": [],
            "figures": [
                {
                    "id": "829a167d-18e9-4898-a974-080119c3218c",
                    "x": 0,
                    "y": 9,
                    "width": 219,
                    "height": 107,
                    "tag": "chart",
                    "data": {
                        "baselineColorDown": "#DC6965",
                        "baselineColorUp": "#00A04A",
                        "baselineMode": "difference",
                        "title": {
                            "0": "L",
                            "1": "a",
                            "2": "t",
                            "3": "e",
                            "4": " ",
                            "5": "d",
                            "6": "e",
                            "7": "l",
                            "8": "i",
                            "9": "v",
                            "10": "e",
                            "11": "r",
                            "12": "i",
                            "13": "e",
                            "14": "s",
                            "text": "Late deliveries",
                            "align": "left",
                            "bold": true,
                            "color": "#434343"
                        },
                        "type": "scorecard",
                        "background": "#EFF6FF",
                        "keyValue": "Data!B2",
                        "humanize": false
                    }
                },
                {
                    "id": "bcc37636-96f7-4911-a330-86b4195c4a95",
                    "x": 228,
                    "y": 9,
                    "width": 219,
                    "height": 107,
                    "tag": "chart",
                    "data": {
                        "baselineColorDown": "#DC6965",
                        "baselineColorUp": "#00A04A",
                        "baselineMode": "difference",
                        "title": {
                            "0": "L",
                            "1": "a",
                            "2": "t",
                            "3": "e",
                            "4": " ",
                            "5": "r",
                            "6": "e",
                            "7": "c",
                            "8": "e",
                            "9": "p",
                            "10": "t",
                            "11": "i",
                            "12": "o",
                            "13": "n",
                            "14": "s",
                            "text": "Late receptions",
                            "align": "left",
                            "color": "#434343",
                            "bold": true
                        },
                        "type": "scorecard",
                        "background": "#EFF6FF",
                        "keyValue": "Data!B3",
                        "humanize": false
                    }
                },
                {
                    "id": "c90eee49-4216-443b-807b-18929ea44af7",
                    "x": 457,
                    "y": 9,
                    "width": 219,
                    "height": 107,
                    "tag": "chart",
                    "data": {
                        "baselineColorDown": "#DC6965",
                        "baselineColorUp": "#00A04A",
                        "baselineMode": "difference",
                        "title": {
                            "0": "L",
                            "1": "a",
                            "2": "t",
                            "3": "e",
                            "4": " ",
                            "5": "i",
                            "6": "n",
                            "7": "t",
                            "8": "e",
                            "9": "r",
                            "10": "n",
                            "11": "a",
                            "12": "l",
                            "13": " ",
                            "14": "t",
                            "15": "r",
                            "16": "a",
                            "17": "n",
                            "18": "s",
                            "19": "f",
                            "20": "e",
                            "21": "r",
                            "22": "s",
                            "text": "Late internal transfer",
                            "align": "left",
                            "bold": true,
                            "color": "#434343"
                        },
                        "type": "scorecard",
                        "background": "#EFF6FF",
                        "keyValue": "Data!B4",
                        "humanize": false
                    }
                },
                {
                    "id": "d38e4873-0fc1-4733-bf96-700877a9a756",
                    "x": 0,
                    "y": 1681,
                    "width": 542,
                    "height": 343,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "none",
                        "metaData": {
                            "groupBy": ["scheduled_date:day"],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "line",
                            "cumulated": false,
                            "cumulatedStart": false
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 1,
                                "active_ids": [1],
                                "params": {
                                    "action": 901,
                                    "active_id": 1,
                                    "model": "stock.picking",
                                    "view_type": "graph",
                                    "menu_id": 637,
                                    "debug": 1,
                                    "cids": 1
                                },
                                "contact_display": "partner_address"
                            },
                            "domain": "[\"&\", \"&\", \"&\", (\"picking_type_code\", \"=\", \"incoming\"), (\"scheduled_date\", \">=\", context_today()), (\"scheduled_date\", \"<=\", context_today() + datetime.timedelta(days = 7)), (\"state\", \"in\", [\"waiting\", \"confirmed\", \"assigned\"])]",
                            "groupBy": ["scheduled_date:day"],
                            "orderBy": []
                        },
                        "type": "odoo_line",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "cumulative": false,
                        "fillArea": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                },
                {
                    "id": "82d8a8ed-d30e-4a64-8dde-af18e4e7ff8f",
                    "x": 579,
                    "y": 1681,
                    "width": 548,
                    "height": 346,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "none",
                        "metaData": {
                            "groupBy": ["scheduled_date:day"],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "line",
                            "cumulated": false,
                            "cumulatedStart": false
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 1,
                                "active_ids": [1],
                                "params": {
                                    "action": 901,
                                    "active_id": 1,
                                    "model": "stock.picking",
                                    "view_type": "graph",
                                    "menu_id": 637,
                                    "debug": 1,
                                    "cids": 1
                                },
                                "contact_display": "partner_address"
                            },
                            "domain": "[\"&\", \"&\", \"&\", (\"scheduled_date\", \">=\", context_today()), (\"scheduled_date\", \"<=\", context_today() + datetime.timedelta(days = 7)), (\"picking_type_code\", \"=\", \"outgoing\"), (\"state\", \"in\", [\"waiting\", \"confirmed\", \"assigned\"])]",
                            "groupBy": ["scheduled_date:day"],
                            "orderBy": []
                        },
                        "type": "odoo_line",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "cumulative": false,
                        "fillArea": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                },
                {
                    "id": "73fc118c-802b-4332-90a0-076112accdcc",
                    "x": 577,
                    "y": 175,
                    "width": 547,
                    "height": 322,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "none",
                        "metaData": {
                            "groupBy": [
                                "scheduled_date:day",
                                "picking_type_id"
                            ],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "bar"
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 5,
                                "active_ids": [5],
                                "contact_display": "partner_address"
                            },
                            "domain": "[\"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"scheduled_date\", \"<=\", context_today())]",
                            "groupBy": [
                                "scheduled_date:day",
                                "picking_type_id"
                            ],
                            "orderBy": []
                        },
                        "type": "odoo_bar",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                },
                {
                    "id": "75a32b49-2814-499d-b9ce-c5b0c3813bdc",
                    "x": 0,
                    "y": 175,
                    "width": 546,
                    "height": 322,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "top",
                        "metaData": {
                            "groupBy": [
                                "scheduled_date:day",
                                "picking_type_id"
                            ],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "bar"
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 5,
                                "active_ids": [5],
                                "contact_display": "partner_address"
                            },
                            "domain": [
                                "&",
                                [
                                    "state",
                                    "in",
                                    ["confirmed", "waiting", "assigned"]
                                ],
                                ["user_id", "=", false]
                            ],
                            "groupBy": [
                                "scheduled_date:day",
                                "picking_type_id"
                            ],
                            "orderBy": []
                        },
                        "type": "odoo_bar",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                },
                {
                    "id": "9e0b69fd-33ad-4e27-bada-e64f5a3189d3",
                    "x": 0,
                    "y": 541,
                    "width": 547,
                    "height": 321,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "none",
                        "metaData": {
                            "groupBy": ["user_id"],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "bar"
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 5,
                                "active_ids": [5],
                                "params": {
                                    "action": 901,
                                    "active_id": 5,
                                    "model": "stock.picking",
                                    "view_type": "graph",
                                    "menu_id": 637,
                                    "debug": 1,
                                    "cids": 1
                                },
                                "contact_display": "partner_address"
                            },
                            "domain": "[\"&\", \"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"picking_type_code\", \"=\", \"incoming\"), (\"scheduled_date\", \"<=\", context_today())]",
                            "groupBy": ["user_id"],
                            "orderBy": []
                        },
                        "type": "odoo_bar",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                },
                {
                    "id": "3270f063-a3ec-4756-bf7b-e78fc61bb78e",
                    "x": 0,
                    "y": 1290,
                    "width": 543,
                    "height": 344,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "none",
                        "metaData": {
                            "groupBy": ["user_id"],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "bar"
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 5,
                                "active_ids": [5],
                                "params": {
                                    "action": 901,
                                    "active_id": 5,
                                    "model": "stock.picking",
                                    "view_type": "graph",
                                    "menu_id": 637,
                                    "debug": 1,
                                    "cids": 1
                                },
                                "contact_display": "partner_address"
                            },
                            "domain": "[\"&\", \"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"scheduled_date\", \"<=\", context_today()), (\"picking_type_code\", \"=\", \"outgoing\")]",
                            "groupBy": ["user_id"],
                            "orderBy": []
                        },
                        "type": "odoo_bar",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                },
                {
                    "id": "1acf6787-306a-44ef-8edf-6ee731fab35d",
                    "x": 0,
                    "y": 915,
                    "width": 545,
                    "height": 333,
                    "tag": "chart",
                    "data": {
                        "title": { "text": "" },
                        "background": "#FFFFFF",
                        "legendPosition": "none",
                        "metaData": {
                            "groupBy": ["user_id"],
                            "measure": "__count",
                            "order": null,
                            "resModel": "stock.picking",
                            "mode": "bar"
                        },
                        "searchParams": {
                            "comparison": null,
                            "context": {
                                "active_id": 5,
                                "active_ids": [5],
                                "params": {
                                    "action": 901,
                                    "active_id": 5,
                                    "model": "stock.picking",
                                    "view_type": "graph",
                                    "menu_id": 637,
                                    "debug": 1,
                                    "cids": 1
                                },
                                "contact_display": "partner_address"
                            },
                            "domain": "[\"&\", \"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"scheduled_date\", \"<=\", context_today()), (\"picking_type_code\", \"=\", \"internal\")]",
                            "groupBy": ["user_id"],
                            "orderBy": []
                        },
                        "type": "odoo_bar",
                        "verticalAxisPosition": "left",
                        "stacked": true,
                        "fieldMatching": {
                            "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                                "chain": "location_id",
                                "type": "many2one"
                            },
                            "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                                "chain": "location_dest_id",
                                "type": "many2one"
                            },
                            "a311c75a-9843-4666-a845-2a646f4785f8": {
                                "chain": "product_id",
                                "type": "many2one"
                            },
                            "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                                "chain": "message_partner_ids",
                                "type": "many2many"
                            },
                            "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                                "chain": "user_id",
                                "type": "many2one"
                            },
                            "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                                "chain": "picking_type_id",
                                "type": "many2one"
                            }
                        }
                    }
                }
            ],
            "tables": [],
            "areGridLinesVisible": true,
            "isVisible": true,
            "headerGroups": { "ROW": [], "COL": [] },
            "dataValidationRules": [],
            "comments": {}
        },
        {
            "id": "7ae69dd3-4d94-444e-9a5d-601e0446f793",
            "name": "Data",
            "colNumber": 26,
            "rowNumber": 100,
            "rows": {},
            "cols": { "0": { "size": 145 } },
            "merges": [],
            "cells": {
                "A2": { "content": "Late deliveries" },
                "A3": { "content": "Late receptions" },
                "A4": { "content": "Late internal transfers" },
                "B1": { "content": "KPI" },
                "B2": {
                    "content": "=IF(ISBLANK(B2),0,PIVOT.VALUE(6,\"__count\"))"
                },
                "B3": {
                    "content": "=IF(ISBLANK(B3),0,PIVOT.VALUE(5,\"__count\"))"
                },
                "B4": {
                    "content": "=IF(ISBLANK(B4),0,PIVOT.VALUE(7,\"__count\"))"
                }
            },
            "styles": { "A1:A4": 8, "B1": 8 },
            "formats": { "B4": 2 },
            "borders": {},
            "conditionalFormats": [],
            "figures": [],
            "tables": [],
            "areGridLinesVisible": true,
            "isVisible": true,
            "headerGroups": { "ROW": [], "COL": [] },
            "dataValidationRules": [],
            "comments": {}
        }
    ],
    "styles": {
        "1": { "bold": true, "fontSize": 16, "textColor": "#01666B" },
        "2": { "verticalAlign": "middle" },
        "3": { "fontSize": 16 },
        "4": { "textColor": "#434343", "bold": true, "fontSize": 11 },
        "5": { "textColor": "#01666B", "verticalAlign": "middle" },
        "6": { "bold": true, "fontSize": 16 },
        "7": { "textColor": "#434343", "verticalAlign": "middle" },
        "8": { "bold": true, "fillColor": "#E6F2F3" }
    },
    "formats": { "1": "mm/dd/yyyy", "2": "0" },
    "borders": {
        "1": { "bottom": { "style": "thin", "color": "#CCCCCC" } },
        "2": { "top": { "style": "thin", "color": "#CCCCCC" } }
    },
    "revisionId": "69bc418f-4f32-43be-8bc9-f59ba4b7f567",
    "uniqueFigureIds": true,
    "settings": {
        "locale": {
            "name": "English (US)",
            "code": "en_US",
            "thousandsSeparator": ",",
            "decimalSeparator": ".",
            "dateFormat": "mm/dd/yyyy",
            "timeFormat": "hh:mm:ss",
            "formulaArgSeparator": ",",
            "weekStart": 7
        }
    },
    "pivots": {
        "5": {
            "type": "ODOO",
            "domain": "[\"&\", \"&\", (\"picking_type_id.code\", \"=\", \"incoming\"), (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), \"|\", (\"date_deadline\", \"<\", current_date), (\"scheduled_date\", \"<\", current_date)]",
            "context": {
                "active_model": "stock.picking.type",
                "active_id": 1,
                "active_ids": [1],
                "contact_display": "partner_address",
                "search_default_picking_type_id": [1],
                "default_picking_type_id": 1,
                "default_company_id": 1
            },
            "sortedColumn": null,
            "measures": [{ "id": "__count", "fieldName": "__count" }],
            "model": "stock.picking",
            "name": "Transfer - Late receptions",
            "fieldMatching": {
                "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                    "chain": "location_id",
                    "type": "many2one"
                },
                "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                    "chain": "location_dest_id",
                    "type": "many2one"
                },
                "a311c75a-9843-4666-a845-2a646f4785f8": {
                    "chain": "product_id",
                    "type": "many2one"
                },
                "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                    "chain": "message_partner_ids",
                    "type": "many2many"
                },
                "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                    "chain": "user_id",
                    "type": "many2one"
                },
                "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                    "chain": "picking_type_id",
                    "type": "many2one"
                }
            },
            "formulaId": "5",
            "columns": [],
            "rows": []
        },
        "6": {
            "type": "ODOO",
            "domain": "[\"&\", \"&\", (\"picking_type_id.code\", \"=\", \"outgoing\"), (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), \"|\", (\"date_deadline\", \"<\", current_date), (\"scheduled_date\", \"<\", current_date)]",
            "context": {
                "active_model": "stock.picking.type",
                "active_id": 2,
                "active_ids": [2],
                "contact_display": "partner_address",
                "search_default_picking_type_id": [2],
                "default_picking_type_id": 2,
                "default_company_id": 1
            },
            "sortedColumn": null,
            "measures": [{ "id": "__count", "fieldName": "__count" }],
            "model": "stock.picking",
            "name": "Transfer - Late deliveries",
            "fieldMatching": {
                "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                    "chain": "location_id",
                    "type": "many2one"
                },
                "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                    "chain": "location_dest_id",
                    "type": "many2one"
                },
                "a311c75a-9843-4666-a845-2a646f4785f8": {
                    "chain": "product_id",
                    "type": "many2one"
                },
                "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                    "chain": "message_partner_ids",
                    "type": "many2many"
                },
                "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                    "chain": "user_id",
                    "type": "many2one"
                },
                "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                    "chain": "picking_type_id",
                    "type": "many2one"
                }
            },
            "formulaId": "6",
            "columns": [],
            "rows": []
        },
        "7": {
            "type": "ODOO",
            "domain": "[\"&\", \"&\", \"|\", (\"date_deadline\", \"<\", current_date), (\"scheduled_date\", \"<\", current_date), (\"picking_type_code\", \"=\", \"internal\"), (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"])]",
            "context": {
                "active_id": 5,
                "active_ids": [5],
                "contact_display": "partner_address"
            },
            "sortedColumn": null,
            "measures": [{ "id": "__count", "fieldName": "__count" }],
            "model": "stock.picking",
            "name": "Transfer - Late internal transfers",
            "fieldMatching": {
                "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                    "chain": "location_id",
                    "type": "many2one"
                },
                "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                    "chain": "location_dest_id",
                    "type": "many2one"
                },
                "a311c75a-9843-4666-a845-2a646f4785f8": {
                    "chain": "product_id",
                    "type": "many2one"
                },
                "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                    "chain": "message_partner_ids",
                    "type": "many2many"
                },
                "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                    "chain": "user_id",
                    "type": "many2one"
                },
                "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                    "chain": "picking_type_id",
                    "type": "many2one"
                }
            },
            "formulaId": "7",
            "columns": [],
            "rows": []
        }
    },
    "pivotNextId": 8,
    "customTableStyles": {},
    "odooVersion": 12,
    "globalFilters": [
        {
            "id": "6a738f48-e4d7-4b69-9f69-889b703ccff7",
            "type": "relation",
            "label": "Source location",
            "defaultValue": [],
            "defaultValueDisplayNames": [],
            "modelName": "stock.location"
        },
        {
            "id": "4f4dae92-1bd5-466d-a7ca-dace8a4838dd",
            "type": "relation",
            "label": "Destination locations",
            "defaultValue": [],
            "defaultValueDisplayNames": [],
            "modelName": "stock.location"
        },
        {
            "id": "a77447da-4a1c-4bc2-b38f-0f0678f1933b",
            "type": "relation",
            "label": "Operation Type",
            "defaultValue": [],
            "defaultValueDisplayNames": [],
            "modelName": "stock.picking.type",
            "includeChildren": false
        },
        {
            "id": "a311c75a-9843-4666-a845-2a646f4785f8",
            "type": "relation",
            "label": "Product",
            "defaultValue": [],
            "defaultValueDisplayNames": [],
            "modelName": "product.product",
            "includeChildren": false
        },
        {
            "id": "0c53514d-da7c-4e17-89c4-8c4e4ed42224",
            "type": "relation",
            "label": "Contact",
            "defaultValue": [],
            "defaultValueDisplayNames": [],
            "modelName": "res.partner"
        },
        {
            "id": "152684de-d10f-48a8-95f8-50b2b2e778bb",
            "type": "relation",
            "label": "Responsible",
            "defaultValueDisplayNames": [],
            "modelName": "res.users",
            "includeChildren": false
        }
    ],
    "lists": {
        "2": {
            "columns": ["name", "partner_id", "user_id", "scheduled_date"],
            "domain": "[\"&\", \"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"scheduled_date\", \"<=\", context_today()), (\"picking_type_code\", \"=\", \"outgoing\")]",
            "model": "stock.picking",
            "context": {
                "active_model": "stock.picking.type",
                "active_id": 1,
                "active_ids": [1],
                "contact_display": "partner_address",
                "search_default_picking_type_id": [1],
                "default_picking_type_id": 1,
                "default_company_id": 1
            },
            "orderBy": [{ "name": "scheduled_date", "asc": true }],
            "id": "2",
            "name": "Late Deliveries",
            "fieldMatching": {
                "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                    "chain": "location_id",
                    "type": "many2one"
                },
                "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                    "chain": "location_dest_id",
                    "type": "many2one"
                },
                "a311c75a-9843-4666-a845-2a646f4785f8": {
                    "chain": "product_id",
                    "type": "many2one"
                },
                "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                    "chain": "message_partner_ids",
                    "type": "many2many"
                },
                "97e2923e-f5ca-4989-b4dd-9a677e3bc824": {
                    "chain": "activity_user_id",
                    "type": "many2one"
                },
                "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                    "chain": "user_id",
                    "type": "many2one"
                },
                "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                    "chain": "picking_type_id",
                    "type": "many2one"
                }
            }
        },
        "3": {
            "columns": ["name", "user_id", "scheduled_date"],
            "domain": "[\"&\", \"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"scheduled_date\", \"<=\", context_today()), (\"picking_type_code\", \"=\", \"internal\")]",
            "model": "stock.picking",
            "context": {
                "active_model": "stock.picking.type",
                "active_id": 1,
                "active_ids": [1],
                "contact_display": "partner_address",
                "search_default_picking_type_id": [1],
                "default_picking_type_id": 1,
                "default_company_id": 1
            },
            "orderBy": [{ "name": "scheduled_date", "asc": true }],
            "id": "3",
            "name": "Late internal transfers",
            "fieldMatching": {
                "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                    "chain": "location_id",
                    "type": "many2one"
                },
                "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                    "chain": "location_dest_id",
                    "type": "many2one"
                },
                "a311c75a-9843-4666-a845-2a646f4785f8": {
                    "chain": "product_id",
                    "type": "many2one"
                },
                "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                    "chain": "message_partner_ids",
                    "type": "many2many"
                },
                "97e2923e-f5ca-4989-b4dd-9a677e3bc824": {
                    "chain": "activity_user_id",
                    "type": "many2one"
                },
                "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                    "chain": "user_id",
                    "type": "many2one"
                },
                "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                    "chain": "picking_type_id",
                    "type": "many2one"
                }
            }
        },
        "6": {
            "columns": ["name", "partner_id", "user_id", "scheduled_date"],
            "domain": "[\"&\", \"&\", (\"state\", \"in\", [\"confirmed\", \"waiting\", \"assigned\"]), (\"picking_type_code\", \"=\", \"incoming\"), (\"scheduled_date\", \"<=\", context_today())]",
            "model": "stock.picking",
            "context": {
                "active_model": "stock.picking.type",
                "active_id": 1,
                "active_ids": [1],
                "contact_display": "partner_address",
                "search_default_picking_type_id": [1],
                "default_picking_type_id": 1,
                "default_company_id": 1
            },
            "orderBy": [{ "name": "scheduled_date", "asc": true }],
            "id": "6",
            "name": "Late receipts",
            "fieldMatching": {
                "6a738f48-e4d7-4b69-9f69-889b703ccff7": {
                    "chain": "location_id",
                    "type": "many2one"
                },
                "4f4dae92-1bd5-466d-a7ca-dace8a4838dd": {
                    "chain": "location_dest_id",
                    "type": "many2one"
                },
                "a311c75a-9843-4666-a845-2a646f4785f8": {
                    "chain": "product_id",
                    "type": "many2one"
                },
                "0c53514d-da7c-4e17-89c4-8c4e4ed42224": {
                    "chain": "message_partner_ids",
                    "type": "many2many"
                },
                "97e2923e-f5ca-4989-b4dd-9a677e3bc824": {
                    "chain": "activity_user_id",
                    "type": "many2one"
                },
                "152684de-d10f-48a8-95f8-50b2b2e778bb": {
                    "chain": "user_id",
                    "type": "many2one"
                },
                "a77447da-4a1c-4bc2-b38f-0f0678f1933b": {
                    "chain": "picking_type_id",
                    "type": "many2one"
                }
            }
        }
    },
    "listNextId": 7,
    "chartOdooMenusReferences": {
        "829a167d-18e9-4898-a974-080119c3218c": "stock.out_picking",
        "bcc37636-96f7-4911-a330-86b4195c4a95": "stock.in_picking",
        "c90eee49-4216-443b-807b-18929ea44af7": "stock.int_picking",
        "82d8a8ed-d30e-4a64-8dde-af18e4e7ff8f": "stock.out_picking",
        "9e0b69fd-33ad-4e27-bada-e64f5a3189d3": "stock.in_picking",
        "3270f063-a3ec-4756-bf7b-e78fc61bb78e": "stock.out_picking",
        "1acf6787-306a-44ef-8edf-6ee731fab35d": "stock.int_picking",
        "d38e4873-0fc1-4733-bf96-700877a9a756": "stock.in_picking"
    }
}
