{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Лист1","1","2","3","4","5","6","7","8","9","10"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[" ",null,null,null,"F4",null,null,null,1]
["N","F1","F2","F3","Приход","Расход",null,null,2,{"$f":"\"SELECT\n    \"&I2&\" AS N,\n\"&\"    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n\"&\"    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n\"&\"    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n\"&\"    IIF(\n\"&\"        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n\"&\"        'Приход',\n\"&\"        IIF(\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n\"&\"            'Расход',\n\"&\"            NULL\n\"&\"        )\n\"&\"    ) AS F4,\n\"&\"    IIF(\n\"&\"        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n\"&\"        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n\"&\"        IIF(\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n\"&\"            NULL\n\"&\"        )\n\"&\"    ) AS F6\n\"&\"FROM\n\"&\"    (\n\"&\"        SELECT\n\"&\"            *\n\"&\"        FROM\n\"&\"            (\n\"&\"                SELECT\n\"&\"                    MAX(F1) AS a,\n\"&\"                    MAX(F2) AS b,\n\"&\"                    MAX(F3) AS c,\n\"&\"                    SUM(F5) AS d\n\"&\"                FROM\n\"&\"                    `\"&I1&\"$`\n\"&\"                GROUP BY\n\"&\"                    F1,\n\"&\"                    F2,\n\"&\"                    F3\n\"&\"            ) t1\n\"&\"            LEFT JOIN (\n\"&\"                 SELECT\n\"&\"                     MAX(F1) AS a,\n\"&\"                     MAX(F2) AS b,\n\"&\"                     MAX(F3) AS c,\n\"&\"                     SUM(F5) AS d\n\"&\"                 FROM\n\"&\"                     `\"&I2&\"$`\n\"&\"                 GROUP BY\n\"&\"                     F1,\n\"&\"                     F2,\n\"&\"                     F3\n\"&\"             ) t2\n\"&\"                ON t1.a = t2.a\n\"&\"                AND t1.b = t2.b\n\"&\"                AND t1.c = t2.c\n\"&\"        UNION ALL\n\"&\"        SELECT\n\"&\"            *\n\"&\"        FROM\n\"&\"            (\n\"&\"                SELECT\n\"&\"                    MAX(F1) AS a,\n\"&\"                    MAX(F2) AS b,\n\"&\"                    MAX(F3) AS c,\n\"&\"                    SUM(F5) AS d\n\"&\"                FROM\n\"&\"                    `\"&I1&\"$`\n\"&\"                GROUP BY\n\"&\"                    F1,\n\"&\"                    F2,\n\"&\"                    F3\n\"&\"            ) t1\n\"&\"            RIGHT JOIN (\n\"&\"                 SELECT\n\"&\"                     MAX(F1) AS a,\n\"&\"                     MAX(F2) AS b,\n\"&\"                     MAX(F3) AS c,\n\"&\"                     SUM(F5) AS d\n\"&\"                 FROM\n\"&\"                     `\"&I2&\"$`\n\"&\"                 GROUP BY\n\"&\"                     F1,\n\"&\"                     F2,\n\"&\"                     F3\n\"&\"             ) t2\n\"&\"                ON t1.a = t2.a\n\"&\"                AND t1.b = t2.b\n\"&\"                AND t1.c = t2.c\n\"&\"        WHERE\n\"&\"            t1.d IS NULL\n\"&\"    )\"","v":"SELECT\n    2 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `1$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `2$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `1$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `2$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"}]
[2,"BMW",34356778037,"Датчик износа т/колодок Е65,66",null,3,null,null,3,{"$f":"\"UNION ALL\n\"&\"SELECT\n    \"&I3&\" AS N,\n\"&\"    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n\"&\"    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n\"&\"    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n\"&\"    IIF(\n\"&\"        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n\"&\"        'Приход',\n\"&\"        IIF(\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n\"&\"            'Расход',\n\"&\"            NULL\n\"&\"        )\n\"&\"    ) AS F4,\n\"&\"    IIF(\n\"&\"        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n\"&\"        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n\"&\"        IIF(\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n\"&\"            NULL\n\"&\"        )\n\"&\"    ) AS F6\n\"&\"FROM\n\"&\"    (\n\"&\"        SELECT\n\"&\"            *\n\"&\"        FROM\n\"&\"            (\n\"&\"                SELECT\n\"&\"                    MAX(F1) AS a,\n\"&\"                    MAX(F2) AS b,\n\"&\"                    MAX(F3) AS c,\n\"&\"                    SUM(F5) AS d\n\"&\"                FROM\n\"&\"                    `\"&I2&\"$`\n\"&\"                GROUP BY\n\"&\"                    F1,\n\"&\"                    F2,\n\"&\"                    F3\n\"&\"            ) t1\n\"&\"            LEFT JOIN (\n\"&\"                 SELECT\n\"&\"                     MAX(F1) AS a,\n\"&\"                     MAX(F2) AS b,\n\"&\"                     MAX(F3) AS c,\n\"&\"                     SUM(F5) AS d\n\"&\"                 FROM\n\"&\"                     `\"&I3&\"$`\n\"&\"                 GROUP BY\n\"&\"                     F1,\n\"&\"                     F2,\n\"&\"                     F3\n\"&\"             ) t2\n\"&\"                ON t1.a = t2.a\n\"&\"                AND t1.b = t2.b\n\"&\"                AND t1.c = t2.c\n\"&\"        UNION ALL\n\"&\"        SELECT\n\"&\"            *\n\"&\"        FROM\n\"&\"            (\n\"&\"                SELECT\n\"&\"                    MAX(F1) AS a,\n\"&\"                    MAX(F2) AS b,\n\"&\"                    MAX(F3) AS c,\n\"&\"                    SUM(F5) AS d\n\"&\"                FROM\n\"&\"                    `\"&I2&\"$`\n\"&\"                GROUP BY\n\"&\"                    F1,\n\"&\"                    F2,\n\"&\"                    F3\n\"&\"            ) t1\n\"&\"            RIGHT JOIN (\n\"&\"                 SELECT\n\"&\"                     MAX(F1) AS a,\n\"&\"                     MAX(F2) AS b,\n\"&\"                     MAX(F3) AS c,\n\"&\"                     SUM(F5) AS d\n\"&\"                 FROM\n\"&\"                     `\"&I3&\"$`\n\"&\"                 GROUP BY\n\"&\"                     F1,\n\"&\"                     F2,\n\"&\"                     F3\n\"&\"             ) t2\n\"&\"                ON t1.a = t2.a\n\"&\"                AND t1.b = t2.b\n\"&\"                AND t1.c = t2.c\n\"&\"        WHERE\n\"&\"            t1.d IS NULL\n\"&\"    )\"","v":"UNION ALL\nSELECT\n    3 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `2$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `3$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `2$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `3$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"}]
[null,null,34356789502,"Датчик тормозной Л Пд    Х5 Х6",null,2,null,null,4,{"$f":"\"UNION ALL\n\"&\"SELECT\n    \"&I4&\" AS N,\n\"&\"    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n\"&\"    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n\"&\"    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n\"&\"    IIF(\n\"&\"        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n\"&\"        'Приход',\n\"&\"        IIF(\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n\"&\"            'Расход',\n\"&\"            NULL\n\"&\"        )\n\"&\"    ) AS F4,\n\"&\"    IIF(\n\"&\"        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n\"&\"        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n\"&\"        IIF(\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n\"&\"            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n\"&\"            NULL\n\"&\"        )\n\"&\"    ) AS F6\n\"&\"FROM\n\"&\"    (\n\"&\"        SELECT\n\"&\"            *\n\"&\"        FROM\n\"&\"            (\n\"&\"                SELECT\n\"&\"                    MAX(F1) AS a,\n\"&\"                    MAX(F2) AS b,\n\"&\"                    MAX(F3) AS c,\n\"&\"                    SUM(F5) AS d\n\"&\"                FROM\n\"&\"                    `\"&I3&\"$`\n\"&\"                GROUP BY\n\"&\"                    F1,\n\"&\"                    F2,\n\"&\"                    F3\n\"&\"            ) t1\n\"&\"            LEFT JOIN (\n\"&\"                 SELECT\n\"&\"                     MAX(F1) AS a,\n\"&\"                     MAX(F2) AS b,\n\"&\"                     MAX(F3) AS c,\n\"&\"                     SUM(F5) AS d\n\"&\"                 FROM\n\"&\"                     `\"&I4&\"$`\n\"&\"                 GROUP BY\n\"&\"                     F1,\n\"&\"                     F2,\n\"&\"                     F3\n\"&\"             ) t2\n\"&\"                ON t1.a = t2.a\n\"&\"                AND t1.b = t2.b\n\"&\"                AND t1.c = t2.c\n\"&\"        UNION ALL\n\"&\"        SELECT\n\"&\"            *\n\"&\"        FROM\n\"&\"            (\n\"&\"                SELECT\n\"&\"                    MAX(F1) AS a,\n\"&\"                    MAX(F2) AS b,\n\"&\"                    MAX(F3) AS c,\n\"&\"                    SUM(F5) AS d\n\"&\"                FROM\n\"&\"                    `\"&I3&\"$`\n\"&\"                GROUP BY\n\"&\"                    F1,\n\"&\"                    F2,\n\"&\"                    F3\n\"&\"            ) t1\n\"&\"            RIGHT JOIN (\n\"&\"                 SELECT\n\"&\"                     MAX(F1) AS a,\n\"&\"                     MAX(F2) AS b,\n\"&\"                     MAX(F3) AS c,\n\"&\"                     SUM(F5) AS d\n\"&\"                 FROM\n\"&\"                     `\"&I4&\"$`\n\"&\"                 GROUP BY\n\"&\"                     F1,\n\"&\"                     F2,\n\"&\"                     F3\n\"&\"             ) t2\n\"&\"                ON t1.a = t2.a\n\"&\"                AND t1.b = t2.b\n\"&\"                AND t1.c = t2.c\n\"&\"        WHERE\n\"&\"            t1.d IS NULL\n\"&\"    )\"","v":"UNION ALL\nSELECT\n    4 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `3$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `4$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `3$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `4$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"}]
[null,null,34356791958,"Датчик износа торм накладок",null,1,null,null,5,"UNION ALL\nSELECT\n    5 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `4$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `5$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `4$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `5$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"]
[null,null,61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",null,3,null,null,6,"UNION ALL\nSELECT\n    6 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `5$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `6$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `5$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `6$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"]
[null,null,34353411756,"Датчик износа т/колодок     Х3",null,1,null,null,7,"UNION ALL\nSELECT\n    7 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `6$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `7$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `6$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `7$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"]
[null,null,34356792559,"Датчик тормозн.Л Пд  Е81,82,90",null,1,null,null,8,"UNION ALL\nSELECT\n    8 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `7$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `8$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `7$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `8$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"]
[null,"111",222,"3333",100,null,null,null,9,"UNION ALL\nSELECT\n    9 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `8$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `9$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `8$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `9$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"]
[3,"BMW",34356789445,"Датчик износа т/колодок Е81-93",null,1,null,null,10,"UNION ALL\nSELECT\n    10 AS N,\n    IIF(t1.a IS NULL, t2.a, t1.a) AS F1,\n    IIF(t1.b IS NULL, t2.b, t1.b) AS F2,\n    IIF(t1.c IS NULL, t2.c, t1.c) AS F3,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) > 0,\n        'Приход',\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n            'Расход',\n            NULL\n        )\n    ) AS F4,\n    IIF(\n        IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) < 0,\n        IIF(t1.d IS NULL, 0, t1.d) -IIF(t2.d IS NULL, 0, t2.d),\n        IIF(\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d) <> 0,\n            IIF(t2.d IS NULL, 0, t2.d) -IIF(t1.d IS NULL, 0, t1.d),\n            NULL\n        )\n    ) AS F6\nFROM\n    (\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `9$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            LEFT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `10$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        UNION ALL\n        SELECT\n            *\n        FROM\n            (\n                SELECT\n                    MAX(F1) AS a,\n                    MAX(F2) AS b,\n                    MAX(F3) AS c,\n                    SUM(F5) AS d\n                FROM\n                    `9$`\n                GROUP BY\n                    F1,\n                    F2,\n                    F3\n            ) t1\n            RIGHT JOIN (\n                 SELECT\n                     MAX(F1) AS a,\n                     MAX(F2) AS b,\n                     MAX(F3) AS c,\n                     SUM(F5) AS d\n                 FROM\n                     `10$`\n                 GROUP BY\n                     F1,\n                     F2,\n                     F3\n             ) t2\n                ON t1.a = t2.a\n                AND t1.b = t2.b\n                AND t1.c = t2.c\n        WHERE\n            t1.d IS NULL\n    )"]
[null,null,34356789505,"Датчик тормозной Зд      Х5 Х6",null,1]
[null,null,34356791958,"Датчик износа торм накладок",null,1]
[null,null,34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",null,1]
[null,null,34351182533,"Датчик износа т/колодок    Е36",null,1]
[null,null,34352229018,"Датчик износа т/колодок    Е39",null,1]
[null,"111",222,"3333",null,100]
[4,"BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",4]
[null,null,34352284343,"Датчик износа тормозных накладок Зд [34352284343]",2]
[null,null,34356790340,"датчик кол.",1]
[null,null,34356791962,"Датчик тормозной Зд     F10,18",4]
[null,null,11377548387,"Двигатель привода регулировки",1]
[null,null,12617501786,"Датчик уровня масла",1]
[null,null,12617607909,"Датчик уровня масла",1]
[null,null,41517191011,"Дверь Л Пд",1]
[5,"BMW",34351165579,"Датчик износа т/колодок     Х5",null,2]
[null,null,34351165580,"Датчик износа т/колодок     Х5",null,1]
[null,null,61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",null,1]
[null,null,61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",null,1]
[null,null,34356792292,"Датчик торм.Зд F20,22,30,35,32",null,1]
[null,null,12617607909,"Датчик уровня масла",null,1]
[null,null,41517191011,"Дверь Л Пд",null,1]
[6,"BMW",34351165579,"Датчик износа т/колодок     Х5",null,1]
[null,null,61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",null,5]
[null,null,61359224853,"Датчик интенсивности дождя",null,1]
[null,null,11377548387,"Двигатель привода регулировки",null,1]
[null,null,12617501786,"Датчик уровня масла",null,1]
[7,"BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",2]
[null,null,34356791958,"Датчик износа торм накладок",null,1]
[null,null,34356791963,"Датчик износа тормозных накладок Зд [34356791963]",2]
[null,null,61610032743,"Дворники к-т            Х5 Е53",3]
[null,null,61610427668,"Дворники к-т            Е90,91",11]
[null,null,61610420549,"Дворники к-т      Е81,82,87,88",1]
[8,"BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",null,1]
[null,null,34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",null,1]
[null,null,34356791963,"Датчик износа тормозных накладок Зд [34356791963]",null,1]
[null,null,34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",2]
[null,null,61610032743,"Дворники к-т            Х5 Е53",null,1]
[null,null,61610427668,"Дворники к-т            Е90,91",null,2]
[null,null,34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",null,1]
[9,"BMW",34351165579,"Датчик износа т/колодок     Х5",null,1]
[null,null,34351165580,"Датчик износа т/колодок     Х5",null,1]
[null,null,34356778037,"Датчик износа т/колодок Е65,66",null,2]
[null,null,61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",null,1]
[null,null,61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",null,1]
[null,null,61359293282,"Датчик интенсивности дождя",null,1]
[null,null,61610032743,"Дворники к-т            Х5 Е53",null,1]
[null,null,61610420549,"Дворники к-т      Е81,82,87,88",null,1]
[10,"BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",null,1]
[null,null,34356789505,"Датчик тормозной Зд      Х5 Х6",null,1]
[null,null,61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",null,1]
[null,null,61359293282,"Датчик интенсивности дождя",null,1]
[null,null,61610032743,"Дворники к-т            Х5 Е53",null,1]
[null,null,34356791961,"Датчик тормозной Зд     F07 GT",null,1]
[null,null,61359214978,"Датчик интенс.дождя/наружного освещения",null,1]
[null,null,17118620732,"Держатель",1]
[null,null,41107204080,"Держатель тормозного шланга П",1]
[null,null,51139810465,"Декоративная планка крыла Л Пд",1]
[null,null,51218243615,"Держатель наружн.ручки Л Пд Х5",5]
[null,null,51218243616,"Держатель наруж.ручки Пр Пд Х5",4]
[null,null,51410429856,"Декоративная планка двери л",1]
[null,null,63217174408,"Держ. лампы в блоке зад. фон. в крыле п",1]
["Общий итог",null,null,null,150,158]

{"sheet":"1","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["BMW",34353411756,"Датчик износа т/колодок     Х3",879.23,1]
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,14]
["BMW",34351182533,"Датчик износа т/колодок    Е36",598,1]
["BMW",34352229018,"Датчик износа т/колодок    Е39",773.39,1]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",591.15,1]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,7]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,2]
["BMW",34356791958,"Датчик износа торм накладок",1123.5,3]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,1]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,1]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,1]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,1]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,10]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,33]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",61359224853,"Датчик интенсивности дождя",6993,1]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,1]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792292,"Датчик торм.Зд F20,22,30,35,32",1265.54,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,2]
["BMW",34356792559,"Датчик тормозн.Л Пд  Е81,82,90",879.23,1]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,2]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,1]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",743.4,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]

{"sheet":"2","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,14]
["BMW",34351182533,"Датчик износа т/колодок    Е36",598,1]
["BMW",34352229018,"Датчик износа т/колодок    Е39",773.39,1]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,2]
["BMW",34356791958,"Датчик износа торм накладок",1123.5,2]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,1]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,1]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,1]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,1]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,10]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,30]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",61359224853,"Датчик интенсивности дождя",6993,1]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,1]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792292,"Датчик торм.Зд F20,22,30,35,32",1265.54,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,2]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,2]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,1]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["111",222,"3333",4444,100]

{"sheet":"3","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,14]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34356791958,"Датчик износа торм накладок",1123.5,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,1]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,1]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,1]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,1]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,10]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,30]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",61359224853,"Датчик интенсивности дождя",6993,1]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,1]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792292,"Датчик торм.Зд F20,22,30,35,32",1265.54,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,1]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,1]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]

{"sheet":"4","index":4,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,14]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34356791958,"Датчик износа торм накладок",1123.5,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,3]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,1]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,1]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,5]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,10]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,30]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",61359224853,"Датчик интенсивности дождя",6993,1]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792292,"Датчик торм.Зд F20,22,30,35,32",1265.54,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,1]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["BMW",12617501786,"Датчик уровня масла",7733.88,1]
["BMW",12617607909,"Датчик уровня масла",7733.88,1]
["BMW",41517191011,"Дверь Л Пд",22859.55,1]
["BMW",11377548387,"Двигатель привода регулировки",14764.68,1]

{"sheet":"5","index":5,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,10]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,12]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34356791958,"Датчик износа торм накладок",1123.5,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,3]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,1]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,1]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,5]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,9]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,29]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",61359224853,"Датчик интенсивности дождя",6993,1]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,1]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["BMW",12617501786,"Датчик уровня масла",7733.88,1]
["BMW",11377548387,"Двигатель привода регулировки",14764.68,1]

{"sheet":"6","index":6,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,10]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34356791958,"Датчик износа торм накладок",1123.5,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,3]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,1]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,1]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,5]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,9]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,24]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,1]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]

{"sheet":"7","index":7,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,10]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,3]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,3]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,3]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,5]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,9]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,24]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792568,"Датчик торм. Л Пд    Х5,F15,Х6",1054.6199999999999,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,1]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["BMW",61610427668,"Дворники к-т            Е90,91",1438.5,10]
["BMW",61610427668,"Дворники к-т            Е90,91",1828.01,1]
["BMW",61610032743,"Дворники к-т            Х5 Е53",2038.93,3]
["BMW",61610420549,"Дворники к-т      Е81,82,87,88",1828.01,1]

{"sheet":"8","index":8,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,10]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,11]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,5]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,2]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,2]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,2]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,5]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,9]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,24]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,7]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,3]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["BMW",61610427668,"Дворники к-т            Е90,91",1438.5,8]
["BMW",61610427668,"Дворники к-т            Е90,91",1828.01,1]
["BMW",61610032743,"Дворники к-т            Х5 Е53",2038.93,2]
["BMW",61610420549,"Дворники к-т      Е81,82,87,88",1828.01,1]

{"sheet":"9","index":9,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,9]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,10]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,3]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,2]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,2]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,2]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,5]
["BMW",61359214978,"Датчик интенс.дождя/наружного освещения",7738.92,1]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,8]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,23]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,6]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,3]
["BMW",34356789505,"Датчик тормозной Зд      Х5 Х6",1090.1500000000001,1]
["BMW",34356791961,"Датчик тормозной Зд     F07 GT",1265.54,1]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["BMW",61610427668,"Дворники к-т            Е90,91",1438.5,8]
["BMW",61610427668,"Дворники к-т            Е90,91",1828.01,1]
["BMW",61610032743,"Дворники к-т            Х5 Е53",2038.93,1]

{"sheet":"10","index":10,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["BMW",34351165580,"Датчик износа т/колодок     Х5",668.3,9]
["BMW",34351165579,"Датчик износа т/колодок     Х5",668.3,10]
["BMW",34356778037,"Датчик износа т/колодок Е65,66",773.39,3]
["BMW",34356789445,"Датчик износа т/колодок Е81-93",1160.46,1]
["BMW",34352284343,"Датчик износа тормозных накладок Зд [34352284343]",848.4,2]
["BMW",34356791963,"Датчик износа тормозных накладок Зд [34356791963]",798,2]
["BMW",34356789080,"Датчик износа тормозных накладок Л Пд [34356789080]",707.7,2]
["BMW",34352282935,"Датчик износа тормозных накладок П Пд [34352282935]",616.35,4]
["BMW",61359293279,"Датчик интенс.дождя/осв./содн.св./запот F20,30",4662,8]
["BMW",61359293281,"Датчик интенс.дождя/осв./содн.св./запот.",3935.93,22]
["BMW",61359293282,"ДАТЧИК ИНТЕНСИВНОСТИ ДОЖДЯ",4611.6000000000004,5]
["BMW",12141703277,"Датчик к/вала имп.   Е36,38,39",4218.4799999999996,2]
["BMW",34356790340,"датчик кол.",742.88,2]
["BMW",61359270588,"Датчик регенерации",3453.45,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",1090.1500000000001,1]
["BMW",34356792571,"Датчик тормозн.Зд  Х5М Х6М F15",976.5,3]
["BMW",34356791962,"Датчик тормозной Зд     F10,18",1195.24,5]
["BMW",34356792564,"Датчик тормозной Зд  Е81,82,90",1090.1500000000001,1]
["BMW",34356789502,"Датчик тормозной Л Пд    Х5 Х6",984.31,2]
["BMW",34356789501,"Датчик тормозной Л Пд    Х5 Х6",1090.1500000000001,4]
["BMW",61610427668,"Дворники к-т            Е90,91",1438.5,8]
["BMW",61610427668,"Дворники к-т            Е90,91",1828.01,1]
["BMW",51410429856,"Декоративная планка двери л",5630.1,1]
["BMW",51139810465,"Декоративная планка крыла Л Пд",1399.13,1]
["BMW",63217174408,"Держ. лампы в блоке зад. фон. в крыле п",722.4,1]
["BMW",17118620732,"Держатель",685.13,1]
["BMW",51218243616,"Держатель наруж.ручки Пр Пд Х5",4218.4799999999996,4]
["BMW",51218243615,"Держатель наружн.ручки Л Пд Х5",4218.4799999999996,5]
["BMW",41107204080,"Держатель тормозного шланга П",160.13,1]