{
  "version": "18.5.10",
  "sheets": [
    {
      "id": "sheet1",
      "name": "Dashboard",
      "colNumber": 7,
      "rowNumber": 104,
      "rows": {
        "5": { "size": 22 },
        "6": { "size": 38 },
        "16": { "size": 27 },
        "17": { "size": 27 },
        "18": { "size": 27 },
        "19": { "size": 27 },
        "20": { "size": 27 },
        "21": { "size": 27 },
        "22": { "size": 38 },
        "33": { "size": 21 },
        "34": { "size": 21 },
        "35": { "size": 21 },
        "36": { "size": 21 },
        "37": { "size": 21 },
        "38": { "size": 21 },
        "39": { "size": 21 },
        "40": { "size": 45 },
        "41": { "size": 38 },
        "42": { "size": 27 },
        "43": { "size": 27 },
        "44": { "size": 27 },
        "45": { "size": 27 },
        "46": { "size": 27 },
        "47": { "size": 27 },
        "48": { "size": 27 },
        "49": { "size": 27 },
        "50": { "size": 27 },
        "51": { "size": 27 },
        "52": { "size": 24 },
        "53": { "size": 48 },
        "54": { "size": 39 },
        "55": { "size": 27 },
        "56": { "size": 27 },
        "57": { "size": 27 },
        "58": { "size": 27 },
        "59": { "size": 27 },
        "60": { "size": 27 },
        "61": { "size": 27 },
        "62": { "size": 27 },
        "63": { "size": 27 },
        "64": { "size": 27 },
        "66": { "size": 46 },
        "67": { "size": 40 },
        "68": { "size": 27 },
        "69": { "size": 27 },
        "70": { "size": 27 },
        "71": { "size": 27 },
        "72": { "size": 27 },
        "73": { "size": 27 },
        "74": { "size": 27 },
        "75": { "size": 27 },
        "76": { "size": 27 },
        "77": { "size": 27 }
      },
      "cols": {
        "0": { "size": 291 },
        "3": { "size": 42 },
        "4": { "size": 293 }
      },
      "merges": [],
      "cells": {
        "A7": "[MRR over time](odoo://view/{\"viewType\":\"graph\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"event_date:month\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"line\",\"graph_groupbys\":[\"event_date:month\"],\"graph_order\":null,\"graph_stacked\":true,\"graph_cumulated\":true},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A23": "[MRR Breakdown](odoo://view/{\"viewType\":\"graph\",\"action\":{\"xmlId\":\"sale_subscription.sale_order_log_growth_action\",\"domain\":[],\"context\":{\"group_by\":[\"event_date:month\",\"event_type\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"bar\",\"graph_groupbys\":[\"event_date:month\",\"event_type\"],\"graph_order\":null,\"graph_stacked\":true},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Breakdown\"})",
        "A41": "[Top upgrades](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[[\"event_type\",\"=\",\"1_expansion\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A42": "=ODOO.LIST.HEADER(1, \"partner_id\")",
        "A43": "=ODOO.LIST(1,1,\"partner_id\")",
        "A44": "=ODOO.LIST(1,2,\"partner_id\")",
        "A45": "=ODOO.LIST(1,3,\"partner_id\")",
        "A46": "=ODOO.LIST(1,4,\"partner_id\")",
        "A47": "=ODOO.LIST(1,5,\"partner_id\")",
        "A48": "=ODOO.LIST(1,6,\"partner_id\")",
        "A49": "=ODOO.LIST(1,7,\"partner_id\")",
        "A50": "=ODOO.LIST(1,8,\"partner_id\")",
        "A51": "=ODOO.LIST(1,9,\"partner_id\")",
        "A52": "=ODOO.LIST(1,10,\"partner_id\")",
        "A54": "[MRR by Recurrence](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[],\"pivot_measures\":[\"mrr_change_normalized\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"plan_id\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A55": "=CHOOSECOLS(PIVOT(2, 10, FALSE, FALSE), 1)",
        "A67": "[Top Salesperson](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"event_date:month\"],\"pivot_measures\":[\"mrr_change_normalized\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"user_id\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "A68": "=CHOOSECOLS(PIVOT(4, 10, FALSE, FALSE), 1)",
        "B42": "=ODOO.LIST.HEADER(1, \"plan_id\", _t(\"Recurrence\"))",
        "B43": "=ODOO.LIST(1,1,\"plan_id\")",
        "B44": "=ODOO.LIST(1,2,\"plan_id\")",
        "B45": "=ODOO.LIST(1,3,\"plan_id\")",
        "B46": "=ODOO.LIST(1,4,\"plan_id\")",
        "B47": "=ODOO.LIST(1,5,\"plan_id\")",
        "B48": "=ODOO.LIST(1,6,\"plan_id\")",
        "B49": "=ODOO.LIST(1,7,\"plan_id\")",
        "B50": "=ODOO.LIST(1,8,\"plan_id\")",
        "B51": "=ODOO.LIST(1,9,\"plan_id\")",
        "B52": "=ODOO.LIST(1,10,\"plan_id\")",
        "C42": "=ODOO.LIST.HEADER(1, \"recurring_monthly\", _t(\"MRR\"))",
        "C43": "=ODOO.LIST(1,1,\"recurring_monthly\")",
        "C44": "=ODOO.LIST(1,2,\"recurring_monthly\")",
        "C45": "=ODOO.LIST(1,3,\"recurring_monthly\")",
        "C46": "=ODOO.LIST(1,4,\"recurring_monthly\")",
        "C47": "=ODOO.LIST(1,5,\"recurring_monthly\")",
        "C48": "=ODOO.LIST(1,6,\"recurring_monthly\")",
        "C49": "=ODOO.LIST(1,7,\"recurring_monthly\")",
        "C50": "=ODOO.LIST(1,8,\"recurring_monthly\")",
        "C51": "=ODOO.LIST(1,9,\"recurring_monthly\")",
        "C52": "=ODOO.LIST(1,10,\"recurring_monthly\")",
        "C55": "=CHOOSECOLS(PIVOT(2, 10, FALSE, FALSE), 2)",
        "C68": "=CHOOSECOLS(PIVOT(4, 10, FALSE, FALSE), 2)",
        "E41": "[Worst Downgrades](odoo://view/{\"viewType\":\"list\",\"action\":{\"domain\":[[\"event_type\",\"=\",\"15_contraction\"]],\"context\":{\"group_by\":[]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "E42": "=ODOO.LIST.HEADER(2, \"partner_id\")",
        "E43": "=ODOO.LIST(2,1,\"partner_id\")",
        "E44": "=ODOO.LIST(2,2,\"partner_id\")",
        "E45": "=ODOO.LIST(2,3,\"partner_id\")",
        "E46": "=ODOO.LIST(2,4,\"partner_id\")",
        "E47": "=ODOO.LIST(2,5,\"partner_id\")",
        "E48": "=ODOO.LIST(2,6,\"partner_id\")",
        "E49": "=ODOO.LIST(2,7,\"partner_id\")",
        "E50": "=ODOO.LIST(2,8,\"partner_id\")",
        "E51": "=ODOO.LIST(2,9,\"partner_id\")",
        "E52": "=ODOO.LIST(2,10,\"partner_id\")",
        "E54": "[MRR by Team](odoo://view/{\"viewType\":\"pivot\",\"action\":{\"domain\":[],\"context\":{\"group_by\":[\"event_date:month\"],\"pivot_measures\":[\"mrr_change_normalized\"],\"pivot_column_groupby\":[],\"pivot_row_groupby\":[\"team_id\"]},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Analysis\"})",
        "E55": "=CHOOSECOLS(PIVOT(3, 10, FALSE, FALSE), 1)",
        "E68": "=CHOOSECOLS(PIVOT(8, 10, FALSE, FALSE), 1)",
        "F42": "=ODOO.LIST.HEADER(2, \"plan_id\", _t(\"Recurrence\"))",
        "F43": "=ODOO.LIST(2,1,\"plan_id\")",
        "F44": "=ODOO.LIST(2,2,\"plan_id\")",
        "F45": "=ODOO.LIST(2,3,\"plan_id\")",
        "F46": "=ODOO.LIST(2,4,\"plan_id\")",
        "F47": "=ODOO.LIST(2,5,\"plan_id\")",
        "F48": "=ODOO.LIST(2,6,\"plan_id\")",
        "F49": "=ODOO.LIST(2,7,\"plan_id\")",
        "F50": "=ODOO.LIST(2,8,\"plan_id\")",
        "F51": "=ODOO.LIST(2,9,\"plan_id\")",
        "F52": "=ODOO.LIST(2,10,\"plan_id\")",
        "G42": "=ODOO.LIST.HEADER(2, \"recurring_monthly\", _t(\"MRR\"))",
        "G43": "=ODOO.LIST(2,1,\"recurring_monthly\")",
        "G44": "=ODOO.LIST(2,2,\"recurring_monthly\")",
        "G45": "=ODOO.LIST(2,3,\"recurring_monthly\")",
        "G46": "=ODOO.LIST(2,4,\"recurring_monthly\")",
        "G47": "=ODOO.LIST(2,5,\"recurring_monthly\")",
        "G48": "=ODOO.LIST(2,6,\"recurring_monthly\")",
        "G49": "=ODOO.LIST(2,7,\"recurring_monthly\")",
        "G50": "=ODOO.LIST(2,8,\"recurring_monthly\")",
        "G51": "=ODOO.LIST(2,9,\"recurring_monthly\")",
        "G52": "=ODOO.LIST(2,10,\"recurring_monthly\")",
        "G55": "=CHOOSECOLS(PIVOT(3, 10, FALSE, FALSE), 2)",
        "G68": "=CHOOSECOLS(PIVOT(8, 10, FALSE, FALSE), 2)"
      },
      "styles": {
        "A7": 1,
        "A23": 1,
        "A41": 1,
        "A54": 1,
        "A67": 1,
        "E41": 1,
        "E54": 1,
        "E67": 1,
        "A42": 2,
        "A68": 2,
        "A55:C55": 2,
        "C68": 2,
        "E42": 2,
        "E55:G55": 2,
        "E68:G68": 2,
        "A43:A52": 3,
        "E43:E52": 3,
        "B43:C52": 4,
        "A56:C65": 4,
        "A69:C78": 4,
        "F43:G52": 4,
        "E56:G65": 4,
        "E69:G78": 4,
        "B42:C42": 5,
        "F42:G42": 5
      },
      "formats": {},
      "borders": {
        "A41:C41": 1,
        "A54:C54": 1,
        "A67:C67": 1,
        "A7:G7": 1,
        "A23:G23": 1,
        "E41:G41": 1,
        "E54:G54": 1,
        "E67:G67": 1,
        "A55:C55": 2,
        "A68:C68": 2,
        "A8:G8": 2,
        "A24:G24": 2,
        "E55:G55": 2,
        "E68:G68": 2,
        "A42:C42": 3,
        "E42:G42": 3,
        "A43:C51": 4,
        "A57:C64": 4,
        "A70:C77": 4,
        "E43:G51": 4,
        "E57:G64": 4,
        "E70:G77": 4,
        "A52:C52": 5,
        "A65:C65": 5,
        "A78:C78": 5,
        "E52:G52": 5,
        "E65:G65": 5,
        "E78:G78": 5,
        "A56:C56": 6,
        "A69:C69": 6,
        "E56:G56": 6,
        "E69:G69": 6
      },
      "conditionalFormats": [
        {
          "rule": { "type": "DataBarRule", "color": 15726335, "rangeValues": "C43:C52" },
          "id": "5acb23ef-592e-4fde-a59c-35c27be83edf",
          "ranges": ["A43:A52"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "G43:G52" },
          "id": "c2ba42dc-2bfb-4470-9584-5838bc0ab612",
          "ranges": ["E43:E52"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16708338, "rangeValues": "C56:C65" },
          "id": "1ba79425-d7fa-4838-9ef1-11ef0b533704",
          "ranges": ["A56:A65"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 16775149, "rangeValues": "G56:G65" },
          "id": "77f933cc-624f-4ac0-b5a8-7b78533a3b0b",
          "ranges": ["E56:E65"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15135475, "rangeValues": "C69:C78" },
          "id": "d4cd0918-e386-44fc-b537-4d4ba9c9bd30",
          "ranges": ["A69:A78"]
        },
        {
          "rule": { "type": "DataBarRule", "color": 15531509, "rangeValues": "G69:G78" },
          "id": "8a67f1aa-4826-4e58-9ce9-bd186f94e44a",
          "ranges": ["E69:E78"]
        }
      ],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "fd511e83-ffe4-4c18-bd7f-eaf895b7b2ea",
          "width": 196,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Net New", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!C11",
            "baselineDescr": { "text": "ARR" },
            "keyValue": "Data!C10",
            "humanize": false,
            "chartId": "fd511e83-ffe4-4c18-bd7f-eaf895b7b2ea"
          },
          "offset": { "x": 814, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "0be7a14a-ae5b-4aa5-8603-f225fd3a8ab1",
          "width": 196,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "New MRR", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!C3",
            "baselineDescr": { "text": "ARR" },
            "keyValue": "Data!C2",
            "humanize": false,
            "chartId": "0be7a14a-ae5b-4aa5-8603-f225fd3a8ab1"
          },
          "offset": { "x": 0, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "b64cc563-a655-48a8-ab6e-192040fcdbef",
          "width": 196,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Up/Downgrade", "bold": true, "color": "#434343" },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!C7",
            "baselineDescr": { "text": "ARR" },
            "keyValue": "Data!C6",
            "humanize": false,
            "chartId": "b64cc563-a655-48a8-ab6e-192040fcdbef"
          },
          "offset": { "x": 203, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "e16dfa8a-35ab-4a26-8fd1-dde560ee90b1",
          "width": 196,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Churn", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#FEF2F2",
            "baseline": "Data!C9",
            "baselineDescr": { "text": "ARR" },
            "keyValue": "Data!C8",
            "humanize": false,
            "chartId": "e16dfa8a-35ab-4a26-8fd1-dde560ee90b1"
          },
          "offset": { "x": 406, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "257ebd49-e289-48fb-a9cd-3720a9bdd2fb",
          "width": 196,
          "height": 104,
          "tag": "chart",
          "data": {
            "baselineColorDown": "#DC6965",
            "baselineColorUp": "#00A04A",
            "baselineMode": "text",
            "title": { "text": "Non Rec. Invoiced ", "color": "#434343", "bold": true },
            "type": "scorecard",
            "background": "#FFF7ED",
            "baseline": "Data!C15",
            "baselineDescr": { "text": "of total invoiced" },
            "keyValue": "Data!C13",
            "humanize": false,
            "chartId": "257ebd49-e289-48fb-a9cd-3720a9bdd2fb"
          },
          "offset": { "x": 611, "y": 11 },
          "col": 0,
          "row": 0
        },
        {
          "id": "eed907ce-ec89-4d39-a1ea-85b96845ecaa",
          "width": 1010,
          "height": 368,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "none",
            "metaData": {
              "groupBy": ["event_date:month"],
              "measure": "mrr_change_normalized",
              "order": null,
              "resModel": "sale.order.log.report",
              "mode": "line",
              "cumulated": true,
              "cumulatedStart": true
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [],
              "groupBy": ["event_date:month"],
              "orderBy": []
            },
            "type": "odoo_line",
            "dataSets": [
              {}
            ],
            "verticalAxisPosition": "left",
            "stacked": false,
            "cumulative": true,
            "cumulatedStart": true,
            "fillArea": true,
            "chartId": "eed907ce-ec89-4d39-a1ea-85b96845ecaa",
            "fieldMatching": {
              "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
              "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
              "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
              "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
              "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
              "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 175 },
          "col": 0,
          "row": 0
        },
        {
          "id": "76549119-0bbd-45b1-b0cb-b4a5a599a59d",
          "width": 1010,
          "height": 377,
          "tag": "chart",
          "data": {
            "title": { "text": "" },
            "background": "#FFFFFF",
            "legendPosition": "top",
            "metaData": {
              "groupBy": ["event_date:month", "event_type"],
              "measure": "mrr_change_normalized",
              "order": null,
              "resModel": "sale.order.log.report",
              "mode": "bar"
            },
            "searchParams": {
              "comparison": null,
              "context": {},
              "domain": [],
              "groupBy": ["event_date:month", "event_type"],
              "orderBy": []
            },
            "type": "odoo_bar",
            "dataSets": [
              {},
              {},
              {}
            ],
            "verticalAxisPosition": "left",
            "stacked": true,
            "chartId": "76549119-0bbd-45b1-b0cb-b4a5a599a59d",
            "fieldMatching": {
              "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
              "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
              "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
              "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
              "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
              "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
            }
          },
          "offset": { "x": 0, "y": 582 },
          "col": 0,
          "row": 0
        },
        {
          "id": "92dd504d-44d5",
          "col": 3,
          "row": 66,
          "offset": { "x": 41, "y": 13 },
          "width": 486,
          "height": 367,
          "tag": "carousel",
          "data": {
            "chartDefinitions": {
              "ada2dcf5-a811": {
                "title": {},
                "background": "#FFFFFF",
                "legendPosition": "left",
                "metaData": {
                  "groupBy": ["country_id"],
                  "measure": "mrr_change_normalized",
                  "order": null,
                  "resModel": "sale.order.log.report",
                  "mode": "bar"
                },
                "searchParams": {
                  "context": {},
                  "domain": [],
                  "groupBy": ["country_id"],
                  "orderBy": []
                },
                "type": "odoo_geo",
                "actionXmlId": "sale_subscription.sale_order_log_growth_action",
                "dataSets": [
                  {}
                ],
                "colorScale": "blues"
              }
            },
            "items": [
              { "type": "chart", "chartId": "ada2dcf5-a811", "title": "Map" },
              { "type": "carouselDataView", "title": "Top 10" }
            ],
            "fieldMatching": {
              "ada2dcf5-a811": {
                "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date" },
                "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
                "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
                "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
                "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
                "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
              }
            },
            "title": {
              "text": "MRR by Country",
              "fontSize": 21,
              "color": "#01666B",
              "bold": true
            }
          }
        }
      ],
      "tables": [
        {
          "range": "A42:C52",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A55:C65",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "A68:C78",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E42:G52",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E55:G65",
          "type": "static",
          "config": {
            "hasFilters": false,
            "totalRow": false,
            "firstColumn": false,
            "lastColumn": false,
            "numberOfHeaders": 1,
            "bandedRows": true,
            "bandedColumns": false,
            "automaticAutofill": true,
            "styleId": "None"
          }
        },
        {
          "range": "E68:G78",
          "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": "3c31419a-d2cc-40b4-86ea-ab7cd02ef7d9",
      "name": "Data",
      "colNumber": 24,
      "rowNumber": 105,
      "rows": {},
      "cols": {
        "0": { "size": 143 }
      },
      "merges": [],
      "cells": {
        "A1": "=_t(\"KPI\")",
        "A2": "=_t(\"New MRR\")",
        "A3": "=_t(\"New ARR\")",
        "A4": "=_t(\"Contraction\")",
        "A5": "=_t(\"Expansion\")",
        "A6": "=_t(\"Up/Downgrade\")",
        "A7": "=_t(\"Up/Down ARR\")",
        "A8": "=_t(\"Churn\")",
        "A9": "=_t(\"Churn ARR\")",
        "A10": "=_t(\"Net New\")",
        "A11": "=_t(\"Net New ARR\")",
        "A12": "=_t(\"Recurring Invoiced\")",
        "A13": "=_t(\"Non Recurring Invoiced\")",
        "A14": "=_t(\"Recurring Invoiced (%)\")",
        "A15": "=_t(\"Non Recurring Invoiced (%)\")",
        "B1": "=_t(\"Current\")",
        "B2": "=PIVOT.VALUE(1,\"mrr_change_normalized\",\"event_type\",\"0_creation\")",
        "B3": "=B2*12",
        "B4": "=PIVOT.VALUE(1,\"mrr_change_normalized\",\"event_type\",\"15_contraction\")",
        "B5": "=PIVOT.VALUE(1,\"mrr_change_normalized\",\"event_type\",\"1_expansion\")",
        "B6": "=B4+B5",
        "B7": "=B6*12",
        "B8": "=PIVOT.VALUE(1,\"mrr_change_normalized\",\"event_type\",\"2_churn\")",
        "B9": "=B8*12",
        "B10": "=B2+B6+B8",
        "B11": "=B10*12",
        "B12": "=PIVOT.VALUE(7,\"price_total\")",
        "B13": "=PIVOT.VALUE(6,\"price_total\")",
        "B14": "=B12/(B12+B13)",
        "B15": "=B13/(B12+B13)",
        "C1": "=_t(\"Current\")",
        "C2": "=FORMAT.LARGE.NUMBER(B2)",
        "C3": "=FORMAT.LARGE.NUMBER(B3)",
        "C4": "=FORMAT.LARGE.NUMBER(B4)",
        "C5": "=FORMAT.LARGE.NUMBER(B5)",
        "C6": "=FORMAT.LARGE.NUMBER(B6)",
        "C7": "=FORMAT.LARGE.NUMBER(B7)",
        "C8": "=FORMAT.LARGE.NUMBER(B8)",
        "C9": "=FORMAT.LARGE.NUMBER(B9)",
        "C10": "=FORMAT.LARGE.NUMBER(B10)",
        "C11": "=FORMAT.LARGE.NUMBER(B11)",
        "C12": "=FORMAT.LARGE.NUMBER(B12)",
        "C13": "=FORMAT.LARGE.NUMBER(B13)",
        "C14": "=FORMAT.LARGE.NUMBER(B14)",
        "C15": "=FORMAT.LARGE.NUMBER(B15)"
      },
      "styles": { "A1:C1": 6, "A2:A15": 7 },
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    },
    {
      "id": "9f3fe95c-7290-43c3-a39f-2615b364f550",
      "name": "Sheet1",
      "colNumber": 26,
      "rowNumber": 100,
      "rows": {},
      "cols": {},
      "merges": [],
      "cells": {
        "A1": "[MRR Breakdown](odoo://view/{\"viewType\":\"graph\",\"action\":{\"xmlId\":\"sale_subscription.sale_order_log_growth_action\",\"domain\":[],\"context\":{\"group_by\":[\"event_date:month\",\"event_type\"],\"graph_measure\":\"mrr_change_normalized\",\"graph_mode\":\"bar\",\"graph_groupbys\":[\"event_date:month\",\"event_type\"],\"graph_order\":null,\"graph_stacked\":true},\"modelName\":\"sale.order.log.report\",\"views\":[[false,\"graph\"],[false,\"list\"],[false,\"pivot\"],[false,\"search\"]]},\"threshold\":0,\"name\":\"MRR Breakdown\"})"
      },
      "styles": {},
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    }
  ],
  "styles": {
    "1": { "bold": true, "fontSize": 16 },
    "2": { "textColor": "#434343", "bold": true, "fontSize": 11 },
    "3": { "textColor": "#01666B", "verticalAlign": "middle" },
    "4": { "textColor": "#434343", "verticalAlign": "middle" },
    "5": {
      "textColor": "#434343",
      "bold": true,
      "fontSize": 11,
      "align": "center"
    },
    "6": { "bold": true },
    "7": { "fillColor": "#E6F2F3" }
  },
  "formats": {},
  "borders": {
    "1": {
      "bottom": { "style": "thin", "color": "#CCCCCC" }
    },
    "2": {
      "top": { "style": "thin", "color": "#CCCCCC" }
    },
    "3": {
      "top": { "style": "thin", "color": "#CCCCCC" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "4": {
      "top": { "style": "thick", "color": "#FFFFFF" },
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    },
    "5": {
      "top": { "style": "thick", "color": "#FFFFFF" }
    },
    "6": {
      "bottom": { "style": "thick", "color": "#FFFFFF" }
    }
  },
  "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": {
    "1": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      },
      "context": { "search_default_group_by_event_date": 1 },
      "domain": [],
      "id": "1",
      "measures": [
        { "id": "mrr_change_normalized", "fieldName": "mrr_change_normalized" },
        { "id": "arr_change_normalized", "fieldName": "arr_change_normalized" },
        { "id": "__count", "fieldName": "__count" }
      ],
      "model": "sale.order.log.report",
      "name": "Sale Order Log Analysis by Type of event",
      "sortedColumn": null,
      "formulaId": "1",
      "columns": [],
      "rows": [
        { "fieldName": "event_type" }
      ]
    },
    "2": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      },
      "context": {
        "params": { "model": "sale.order.log.report", "view_type": "pivot" }
      },
      "domain": [],
      "id": "2",
      "measures": [
        {
          "id": "mrr_change_normalized",
          "fieldName": "mrr_change_normalized",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.order.log.report",
      "name": "Recurrence",
      "sortedColumn": {
        "measure": "mrr_change_normalized",
        "order": "desc",
        "domain": []
      },
      "formulaId": "2",
      "columns": [],
      "rows": [
        { "fieldName": "plan_id" }
      ]
    },
    "3": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      },
      "context": {
        "params": { "model": "sale.order.log.report", "view_type": "pivot" },
        "search_default_group_by_event_date": 1
      },
      "domain": [],
      "id": "3",
      "measures": [
        {
          "id": "mrr_change_normalized",
          "fieldName": "mrr_change_normalized",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.order.log.report",
      "name": "Recurrence",
      "sortedColumn": {
        "measure": "mrr_change_normalized",
        "order": "desc",
        "domain": []
      },
      "formulaId": "3",
      "columns": [],
      "rows": [
        { "fieldName": "team_id" }
      ]
    },
    "4": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      },
      "context": { "search_default_group_by_event_date": 1 },
      "domain": [],
      "id": "4",
      "measures": [
        {
          "id": "mrr_change_normalized",
          "fieldName": "mrr_change_normalized",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.order.log.report",
      "name": "Salesperson",
      "sortedColumn": {
        "measure": "mrr_change_normalized",
        "order": "desc",
        "domain": []
      },
      "formulaId": "4",
      "columns": [],
      "rows": [
        { "fieldName": "user_id" }
      ]
    },
    "6": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": {},
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": {},
        "866b40f9-0436-4e8b-8ec1-69c18381c876": {},
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": {}
      },
      "context": {
        "params": {
          "action": 574,
          "model": "account.move.line",
          "view_type": "pivot",
          "cids": 1,
          "menu_id": 650
        },
        "journal_type": "general",
        "search_default_posted": 1
      },
      "domain": [
        "&",
        "&",
        [
          "display_type",
          "not in",
          ["line_section", "line_note"]
        ],
        ["parent_state", "!=", "cancel"],
        ["subscription_id", "=", false]
      ],
      "id": "6",
      "measures": [
        { "id": "price_total", "fieldName": "price_total" },
        { "id": "__count", "fieldName": "__count" }
      ],
      "model": "account.move.line",
      "name": "Journal Items",
      "sortedColumn": null,
      "formulaId": "6",
      "columns": [],
      "rows": []
    },
    "7": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": {},
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": {},
        "866b40f9-0436-4e8b-8ec1-69c18381c876": {},
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": {}
      },
      "context": {
        "params": {
          "action": 574,
          "model": "account.move.line",
          "view_type": "pivot",
          "cids": 1,
          "menu_id": 650
        },
        "journal_type": "general",
        "search_default_posted": 1
      },
      "domain": [
        "&",
        "&",
        [
          "display_type",
          "not in",
          ["line_section", "line_note"]
        ],
        ["parent_state", "!=", "cancel"],
        ["subscription_id", "!=", false]
      ],
      "id": "7",
      "measures": [
        { "id": "price_total", "fieldName": "price_total" },
        { "id": "__count", "fieldName": "__count" }
      ],
      "model": "account.move.line",
      "name": "Journal Items",
      "sortedColumn": null,
      "formulaId": "7",
      "columns": [],
      "rows": []
    },
    "8": {
      "type": "ODOO",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date" },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "efcb1557-c59e-45c7-b970-1d3df23908db": { "chain": "partner_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      },
      "context": {
        "params": {
          "action": 1667,
          "model": "sale.order.log.report",
          "view_type": "pivot",
          "cids": 1,
          "menu_id": 1119
        }
      },
      "domain": [],
      "id": "8",
      "measures": [
        {
          "id": "mrr_change_normalized",
          "fieldName": "mrr_change_normalized",
          "userDefinedName": "MRR"
        }
      ],
      "model": "sale.order.log.report",
      "name": "Country",
      "sortedColumn": {
        "measure": "mrr_change_normalized",
        "order": "desc",
        "domain": []
      },
      "formulaId": "8",
      "columns": [],
      "rows": [
        { "fieldName": "country_id" }
      ]
    }
  },
  "pivotNextId": 9,
  "customTableStyles": {},
  "globalFilters": [
    {
      "id": "954bb57d-1c53-4918-a516-c179fc19579b",
      "type": "date",
      "label": "Date",
      "defaultValue": "last_12_months"
    },
    {
      "id": "a20dbbaa-c062-4527-bd96-641257f29345",
      "type": "relation",
      "label": "Country",
      "defaultValueDisplayNames": [],
      "modelName": "res.country"
    },
    {
      "id": "efcb1557-c59e-45c7-b970-1d3df23908db",
      "type": "relation",
      "label": "Customer",
      "defaultValueDisplayNames": [],
      "modelName": "res.partner"
    },
    {
      "id": "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4",
      "type": "relation",
      "label": "Sales Team",
      "defaultValueDisplayNames": [],
      "modelName": "crm.team"
    },
    {
      "id": "866b40f9-0436-4e8b-8ec1-69c18381c876",
      "type": "relation",
      "label": "Salesperon",
      "defaultValueDisplayNames": [],
      "modelName": "res.users"
    },
    {
      "id": "bb803250-fe24-48ab-ab18-54ec5ab5806f",
      "type": "relation",
      "label": "Recurrence",
      "defaultValueDisplayNames": [],
      "modelName": "sale.subscription.plan"
    }
  ],
  "lists": {
    "1": {
      "columns": [
        "order_id",
        "event_date",
        "user_id",
        "event_type",
        "partner_id",
        "team_id",
        "company_id",
        "plan_id",
        "amount_signed",
        "recurring_monthly",
        "log_currency_id"
      ],
      "domain": [
        ["event_type", "=", "1_expansion"]
      ],
      "model": "sale.order.log.report",
      "context": { "search_default_group_by_event_date": 1 },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false },
        { "name": "order_id", "asc": true },
        { "name": "event_date", "asc": false },
        { "name": "id", "asc": false }
      ],
      "id": "1",
      "name": "MRR Analysis by Monthly Recurring Revenue",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      }
    },
    "2": {
      "columns": [
        "order_id",
        "event_date",
        "user_id",
        "event_type",
        "partner_id",
        "team_id",
        "company_id",
        "plan_id",
        "amount_signed",
        "recurring_monthly",
        "log_currency_id"
      ],
      "domain": [
        ["event_type", "=", "15_contraction"]
      ],
      "model": "sale.order.log.report",
      "context": { "search_default_group_by_event_date": 1 },
      "orderBy": [
        { "name": "recurring_monthly", "asc": false },
        { "name": "order_id", "asc": true },
        { "name": "event_date", "asc": false },
        { "name": "id", "asc": false }
      ],
      "id": "2",
      "name": "MRR Analysis by Monthly Recurring Revenue",
      "fieldMatching": {
        "954bb57d-1c53-4918-a516-c179fc19579b": { "chain": "event_date", "type": "date", "offset": 0 },
        "a20dbbaa-c062-4527-bd96-641257f29345": { "chain": "country_id", "type": "many2one" },
        "ab1df29c-770b-4ec5-bf93-cd3f57bcdab4": { "chain": "team_id", "type": "many2one" },
        "866b40f9-0436-4e8b-8ec1-69c18381c876": { "chain": "user_id", "type": "many2one" },
        "bb803250-fe24-48ab-ab18-54ec5ab5806f": { "chain": "plan_id", "type": "many2one" }
      }
    }
  },
  "listNextId": 4,
  "chartOdooMenusReferences": {
    "0be7a14a-ae5b-4aa5-8603-f225fd3a8ab1": "sale_subscription.menu_sale_order_log_analysis_report",
    "b64cc563-a655-48a8-ab6e-192040fcdbef": "sale_subscription.menu_sale_order_log_analysis_report",
    "e16dfa8a-35ab-4a26-8fd1-dde560ee90b1": "sale_subscription.menu_sale_order_log_analysis_report",
    "fd511e83-ffe4-4c18-bd7f-eaf895b7b2ea": "sale_subscription.menu_sale_order_log_analysis_report",
    "eed907ce-ec89-4d39-a1ea-85b96845ecaa": "sale_subscription.menu_sale_subscription_root",
    "76549119-0bbd-45b1-b0cb-b4a5a599a59d": "sale_subscription.menu_sale_subscription_root",
    "257ebd49-e289-48fb-a9cd-3720a9bdd2fb": "account.menu_action_move_out_invoice_type"
  }
}
