Zovo Spreadsheet Compare

Compare two spreadsheets

使うべきか

品質と安全性

A
説明の品質
100%
スキーマの完全性
90%
命名の品質
90%
ポイズニングのリスク
100%
権限の一致
100%
プロトコルへの準拠
100%

ツール定義とプロトコルへの準拠に関する自動分析に基づいています。

コンテキストコスト

~4,899トークン数(ツール定義)
~27.3 KB一般的なレスポンスサイズ
注意への影響は大きい(128k コンテキストの 3.83%)

これは、サーバーのツールがモデルのコンテキストに読み込まれるたびに消費されるおおよそのトークン数です。数が多いほど、ほかのタスクに使える注意が減ります。

インストール

ワンクリックインストール

これを `claude_desktop_config.json` ファイルに追加してください:

{
  "mcpServers": {
    "sheet-compare": {
      "url": "https://sheet-compare.zovo.one/mcp"
    }
  }
}

リモートエンドポイント

https://sheet-compare.zovo.one/mcpstreamable-http

できること

ツール一覧

ツール(2)

🟢 読み取り専用🟡 書き込み🔴 削除⚪ 不明
🟢compare_spreadsheets(old_file, new_file, old_table, new_table, old_sheet, ...)

Use this when the user has two versions of the same spreadsheet (CSV or Excel: price list, inventory, roster, budget, product catalog, CRM export) and wants to "compare two excel files", "compare two spreadsheets", "find the differences between two csv files", "what changed between these files" or "list what changed". Matches rows by a key column it detects (or key_columns), lists all added, removed and changed rows with each changed cell old -> new, numeric change and percent, plus renamed/moved columns and key changes, and returns an Excel workbook (Summary, Changed, Cell changes, Added, Removed, annotated new version) and a changes CSV. Does not merge or join two different tables (e.g. customers + orders), does not compare Word or PDF documents, and does not edit either file.

入力スキーマ

{
  "type": "object",
  "properties": {
    "old_file": {
      "type": "object",
      "properties": {
        "download_url": {
          "type": "string",
          "description": "Temporary download link for the file, supplied by ChatGPT."
        },
        "file_id": {
          "type": "string",
          "description": "ChatGPT file id, e.g. file_abc123."
        },
        "mime_type": {
          "description": "Media type if known, e.g. application/pdf.",
          "type": "string"
        },
        "file_name": {
          "description": "Original file name if known, e.g. statement.pdf.",
          "type": "string"
        }
      },
      "required": [
        "download_url",
        "file_id"
      ],
      "description": "The OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv."
    },
    "new_file": {
      "type": "object",
      "properties": {
        "download_url": {
          "type": "string",
          "description": "Temporary download link for the file, supplied by ChatGPT."
        },
        "file_id": {
          "type": "string",
          "description": "ChatGPT file id, e.g. file_abc123."
        },
        "mime_type": {
          "description": "Media type if known, e.g. application/pdf.",
          "type": "string"
        },
        "file_name": {
          "description": "Original file name if known, e.g. statement.pdf.",
          "type": "string"
        }
      },
      "required": [
        "download_url",
        "file_id"
      ],
      "description": "The NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv."
    },
    "old_table": {
      "description": "Instead of old_file: the older version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.00\\nB2,5.00\".",
      "type": "string",
      "maxLength": 200000
    },
    "new_table": {
      "description": "Instead of new_file: the newer version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.50\\nC3,7.00\".",
      "type": "string",
      "maxLength": 200000
    },
    "old_sheet": {
      "description": "Sheet (tab) to read from the old workbook, e.g. Prices Q3. Default: the sheet with the same name as in the new workbook, else the first sheet with data.",
      "type": "string",
      "maxLength": 100
    },
    "new_sheet": {
      "description": "Sheet (tab) to read from the new workbook, e.g. Prices Q4.",
      "type": "string",
      "maxLength": 100
    },
    "key_columns": {
      "description": "Column(s) that identify a row, to override the automatic key, e.g. [\"SKU\"] or [\"Store\", \"Product code\"].",
      "maxItems": 5,
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 100
      }
    },
    "ignore_columns": {
      "description": "Columns to leave out of the comparison, e.g. [\"Last updated\", \"Notes\"].",
      "maxItems": 50,
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 100
      }
    },
    "column_map": {
      "description": "Old column name -> new column name for renamed columns, e.g. {\"Unit Price\": \"Price (USD)\"}. Turns off automatic rename detection.",
      "type": "object",
      "propertyNames": {
        "type": "string",
        "maxLength": 100
      },
      "additionalProperties": {
        "type": "string",
        "maxLength": 100
      }
    },
    "ignore_case": {
      "description": "Treat ABC and abc as equal, e.g. true. Default false.",
      "type": "boolean"
    },
    "trim_whitespace": {
      "description": "Ignore leading/trailing and repeated spaces, e.g. true (default).",
      "type": "boolean"
    },
    "compare_numbers_as_values": {
      "description": "Compare numbers by value so \"1,200.00\" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text.",
      "type": "boolean"
    },
    "normalize_dates": {
      "description": "Compare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default).",
      "type": "boolean"
    },
    "numeric_tolerance": {
      "description": "Numbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0.",
      "type": "number",
      "minimum": 0,
      "maximum": 1000000000
    },
    "header_row_old": {
      "description": "Row number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first.",
      "type": "integer",
      "minimum": 1,
      "maximum": 1000
    },
    "header_row_new": {
      "description": "Row number of the column headings in the new file, e.g. 3.",
      "type": "integer",
      "minimum": 1,
      "maximum": 1000
    },
    "compare_row_numbers": {
      "description": "Compare a running row-number column (#, Row, No.: 1, 2, 3...) like any other column, e.g. true. Default false: it shifts whenever a row is inserted, so it is skipped with a note.",
      "type": "boolean"
    },
    "detect_key_changes": {
      "description": "Report a removed row and an added row whose other values are identical as one key change (e.g. a SKU renumbered), e.g. true (default).",
      "type": "boolean"
    }
  },
  "$schema": "http://json-schema.org/draft-07/schema#"
}

出力スキーマ

{
  "type": "object",
  "properties": {
    "files": {
      "type": "object",
      "properties": {
        "old": {
          "type": "object",
          "properties": {
            "name": {
              "type": "string"
            },
            "sheet": {
              "type": [
                "string",
                "null"
              ]
            },
            "rows": {
              "type": "number"
            },
            "header_row": {
              "type": "number"
            }
          },
          "required": [
            "name",
            "sheet",
            "rows",
            "header_row"
          ],
          "additionalProperties": false
        },
        "new": {
          "type": "object",
          "properties": {
            "name": {
              "type": "string"
            },
            "sheet": {
              "type": [
                "string",
                "null"
              ]
            },
            "rows": {
              "type": "number"
            },
            "header_row": {
              "type": "number"
            }
          },
          "required": [
            "name",
            "sheet",
            "rows",
            "header_row"
          ],
          "additionalProperties": false
        }
      },
      "required": [
        "old",
        "new"
      ],
      "additionalProperties": false
    },
    "key": {
      "type": "object",
      "properties": {
        "mode": {
          "type": "string",
          "enum": [
            "key",
            "content"
          ]
        },
        "columns": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "explanation": {
          "type": "string"
        },
        "repeated_keys": {
          "type": "array",
          "items": {
            "type": "string"
          }
        }
      },
      "required": [
        "mode",
        "columns",
        "explanation"
      ],
      "additionalProperties": false
    },
    "counts": {
      "type": "object",
      "properties": {
        "changed_rows": {
          "type": "number"
        },
        "changed_cells": {
          "type": "number"
        },
        "added_rows": {
          "type": "number"
        },
        "removed_rows": {
          "type": "number"
        },
        "key_changes": {
          "type": "number"
        },
        "unchanged_rows": {
          "type": "number"
        },
        "old_rows": {
          "type": "number"
        },
        "new_rows": {
          "type": "number"
        }
      },
      "required": [
        "changed_rows",
        "changed_cells",
        "added_rows",
        "removed_rows",
        "key_changes",
        "unchanged_rows",
        "old_rows",
        "new_rows"
      ],
      "additionalProperties": false
    },
    "columns": {
      "type": "object",
      "properties": {
        "compared": {
          "type": "number"
        },
        "added": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "removed": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "renamed": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "from": {
                "type": "string"
              },
              "to": {
                "type": "string"
              },
              "agreement_pct": {
                "type": [
                  "number",
                  "null"
                ]
              }
            },
            "required": [
              "from",
              "to",
              "agreement_pct"
            ],
            "additionalProperties": false
          }
        },
        "moved": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "name": {
                "type": "string"
              },
              "from": {
                "type": "string"
              },
              "to": {
                "type": "string"
              }
            },
            "required": [
              "name",
              "from",
              "to"
            ],
            "additionalProperties": false
          }
        },
        "ignored": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "more": {
          "type": "object",
          "propertyNames": {
            "type": "string"
          },
          "additionalProperties": {
            "type": "number"
          }
        }
      },
      "required": [
        "compared",
        "added",
        "removed",
        "renamed",
        "moved",
        "ignored"
      ],
      "additionalProperties": false
    },
    "by_column": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "column": {
            "type": "string"
          },
          "changed": {
            "type": "number"
          },
          "increases": {
            "type": "number"
          },
          "decreases": {
            "type": "number"
          },
          "total_delta": {
            "type": [
              "number",
              "null"
            ]
          },
          "avg_pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "max_increase": {
            "anyOf": [
              {
                "type": "object",
                "properties": {
                  "key": {
                    "type": "string"
                  },
                  "old": {
                    "type": "string"
                  },
                  "new": {
                    "type": "string"
                  },
                  "delta": {
                    "type": "number"
                  },
                  "pct": {
                    "type": [
                      "number",
                      "null"
                    ]
                  }
                },
                "required": [
                  "key",
                  "old",
                  "new",
                  "delta",
                  "pct"
                ],
                "additionalProperties": false
              },
              {
                "type": "null"
              }
            ]
          },
          "max_decrease": {
            "anyOf": [
              {
                "type": "object",
                "properties": {
                  "key": {
                    "type": "string"
                  },
                  "old": {
                    "type": "string"
                  },
                  "new": {
                    "type": "string"
                  },
                  "delta": {
                    "type": "number"
                  },
                  "pct": {
                    "type": [
                      "number",
                      "null"
                    ]
                  }
                },
                "required": [
                  "key",
                  "old",
                  "new",
                  "delta",
                  "pct"
                ],
                "additionalProperties": false
              },
              {
                "type": "null"
              }
            ]
          }
        },
        "required": [
          "column",
          "changed",
          "increases",
          "decreases",
          "total_delta",
          "avg_pct",
          "max_increase",
          "max_decrease"
        ],
        "additionalProperties": false
      }
    },
    "biggest_changes": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "key": {
            "type": "string"
          },
          "old": {
            "type": "string"
          },
          "new": {
            "type": "string"
          },
          "delta": {
            "type": "number"
          },
          "pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "column": {
            "type": "string"
          }
        },
        "required": [
          "key",
          "old",
          "new",
          "delta",
          "pct",
          "column"
        ],
        "additionalProperties": false
      }
    },
    "changes_preview": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "key": {
            "type": "string"
          },
          "old_row": {
            "type": "number"
          },
          "new_row": {
            "type": "number"
          },
          "cells": {
            "type": "array",
            "items": {
              "type": "object",
              "properties": {
                "column": {
                  "type": "string"
                },
                "old": {
                  "type": "string"
                },
                "new": {
                  "type": "string"
                },
                "delta": {
                  "type": [
                    "number",
                    "null"
                  ]
                },
                "pct": {
                  "type": [
                    "number",
                    "null"
                  ]
                },
                "unit": {
                  "description": "pp: delta is in percentage points (percent columns)",
                  "type": "string",
                  "const": "pp"
                }
              },
              "required": [
                "column",
                "old",
                "new",
                "delta",
                "pct"
              ],
              "additionalProperties": false
            }
          }
        },
        "required": [
          "key",
          "old_row",
          "new_row",
          "cells"
        ],
        "additionalProperties": false
      }
    },
    "added_preview": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "removed_preview": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "key_changes_preview": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "from": {
            "type": "string"
          },
          "to": {
            "type": "string"
          }
        },
        "required": [
          "from",
          "to"
        ],
        "additionalProperties": false
      }
    },
    "excluded_rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "file": {
            "type": "string"
          },
          "row": {
            "type": "number"
          },
          "reason": {
            "type": "string"
          },
          "label": {
            "type": "string"
          }
        },
        "required": [
          "file",
          "row",
          "reason",
          "label"
        ],
        "additionalProperties": false
      }
    },
    "notes": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "downloads": {
      "type": "object",
      "properties": {
        "xlsx": {
          "type": "string"
        },
        "csv": {
          "type": "string"
        }
      },
      "required": [
        "xlsx",
        "csv"
      ],
      "additionalProperties": false
    },
    "complete_list": {
      "type": "string"
    }
  },
  "required": [
    "files",
    "key",
    "counts",
    "columns",
    "by_column",
    "biggest_changes",
    "changes_preview",
    "added_preview",
    "removed_preview",
    "key_changes_preview",
    "excluded_rows",
    "notes",
    "downloads",
    "complete_list"
  ],
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false
}
🟢summarize_changes(old_file, new_file, old_table, new_table, old_sheet, ...)

Use this when the user has two versions of a spreadsheet and wants a summary rather than a full list: "how many prices went up", "which columns changed the most", "biggest changes between these two files", "average price increase". Returns counts (changed, added, removed rows), per-column statistics (cells changed, increases, decreases, total and average percent change, largest increase and decrease) and the biggest single changes, with the same Excel and CSV downloads. Use compare_spreadsheets for the row-by-row list. Does not forecast or explain why values changed.

入力スキーマ

{
  "type": "object",
  "properties": {
    "old_file": {
      "type": "object",
      "properties": {
        "download_url": {
          "type": "string",
          "description": "Temporary download link for the file, supplied by ChatGPT."
        },
        "file_id": {
          "type": "string",
          "description": "ChatGPT file id, e.g. file_abc123."
        },
        "mime_type": {
          "description": "Media type if known, e.g. application/pdf.",
          "type": "string"
        },
        "file_name": {
          "description": "Original file name if known, e.g. statement.pdf.",
          "type": "string"
        }
      },
      "required": [
        "download_url",
        "file_id"
      ],
      "description": "The OLDER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q3.xlsx or roster-september.csv."
    },
    "new_file": {
      "type": "object",
      "properties": {
        "download_url": {
          "type": "string",
          "description": "Temporary download link for the file, supplied by ChatGPT."
        },
        "file_id": {
          "type": "string",
          "description": "ChatGPT file id, e.g. file_abc123."
        },
        "mime_type": {
          "description": "Media type if known, e.g. application/pdf.",
          "type": "string"
        },
        "file_name": {
          "description": "Original file name if known, e.g. statement.pdf.",
          "type": "string"
        }
      },
      "required": [
        "download_url",
        "file_id"
      ],
      "description": "The NEWER version (CSV, TSV or Excel .xlsx), e.g. pricelist_2026Q4.xlsx or roster-october.csv."
    },
    "old_table": {
      "description": "Instead of old_file: the older version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.00\\nB2,5.00\".",
      "type": "string",
      "maxLength": 200000
    },
    "new_table": {
      "description": "Instead of new_file: the newer version pasted as CSV/TSV text with a header row, e.g. \"SKU,Price\\nA1,10.50\\nC3,7.00\".",
      "type": "string",
      "maxLength": 200000
    },
    "old_sheet": {
      "description": "Sheet (tab) to read from the old workbook, e.g. Prices Q3. Default: the sheet with the same name as in the new workbook, else the first sheet with data.",
      "type": "string",
      "maxLength": 100
    },
    "new_sheet": {
      "description": "Sheet (tab) to read from the new workbook, e.g. Prices Q4.",
      "type": "string",
      "maxLength": 100
    },
    "key_columns": {
      "description": "Column(s) that identify a row, to override the automatic key, e.g. [\"SKU\"] or [\"Store\", \"Product code\"].",
      "maxItems": 5,
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 100
      }
    },
    "ignore_columns": {
      "description": "Columns to leave out of the comparison, e.g. [\"Last updated\", \"Notes\"].",
      "maxItems": 50,
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 100
      }
    },
    "column_map": {
      "description": "Old column name -> new column name for renamed columns, e.g. {\"Unit Price\": \"Price (USD)\"}. Turns off automatic rename detection.",
      "type": "object",
      "propertyNames": {
        "type": "string",
        "maxLength": 100
      },
      "additionalProperties": {
        "type": "string",
        "maxLength": 100
      }
    },
    "ignore_case": {
      "description": "Treat ABC and abc as equal, e.g. true. Default false.",
      "type": "boolean"
    },
    "trim_whitespace": {
      "description": "Ignore leading/trailing and repeated spaces, e.g. true (default).",
      "type": "boolean"
    },
    "compare_numbers_as_values": {
      "description": "Compare numbers by value so \"1,200.00\" equals 1200, e.g. true (default). Codes with leading zeros (00123) stay text.",
      "type": "boolean"
    },
    "normalize_dates": {
      "description": "Compare dates by calendar day, so 2026-03-05, 3/5/2026 and an Excel date serial are equal, e.g. true (default).",
      "type": "boolean"
    },
    "numeric_tolerance": {
      "description": "Numbers that differ by this much or less count as equal, e.g. 0.01 to ignore rounding by a cent. Default 0.",
      "type": "number",
      "minimum": 0,
      "maximum": 1000000000
    },
    "header_row_old": {
      "description": "Row number of the column headings in the old file when it is not detected, e.g. 3 when two title rows come first.",
      "type": "integer",
      "minimum": 1,
      "maximum": 1000
    },
    "header_row_new": {
      "description": "Row number of the column headings in the new file, e.g. 3.",
      "type": "integer",
      "minimum": 1,
      "maximum": 1000
    },
    "compare_row_numbers": {
      "description": "Compare a running row-number column (#, Row, No.: 1, 2, 3...) like any other column, e.g. true. Default false: it shifts whenever a row is inserted, so it is skipped with a note.",
      "type": "boolean"
    },
    "detect_key_changes": {
      "description": "Report a removed row and an added row whose other values are identical as one key change (e.g. a SKU renumbered), e.g. true (default).",
      "type": "boolean"
    }
  },
  "$schema": "http://json-schema.org/draft-07/schema#"
}

出力スキーマ

{
  "type": "object",
  "properties": {
    "files": {
      "type": "object",
      "properties": {
        "old": {
          "type": "object",
          "properties": {
            "name": {
              "type": "string"
            },
            "sheet": {
              "type": [
                "string",
                "null"
              ]
            },
            "rows": {
              "type": "number"
            },
            "header_row": {
              "type": "number"
            }
          },
          "required": [
            "name",
            "sheet",
            "rows",
            "header_row"
          ],
          "additionalProperties": false
        },
        "new": {
          "type": "object",
          "properties": {
            "name": {
              "type": "string"
            },
            "sheet": {
              "type": [
                "string",
                "null"
              ]
            },
            "rows": {
              "type": "number"
            },
            "header_row": {
              "type": "number"
            }
          },
          "required": [
            "name",
            "sheet",
            "rows",
            "header_row"
          ],
          "additionalProperties": false
        }
      },
      "required": [
        "old",
        "new"
      ],
      "additionalProperties": false
    },
    "key": {
      "type": "object",
      "properties": {
        "mode": {
          "type": "string",
          "enum": [
            "key",
            "content"
          ]
        },
        "columns": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "explanation": {
          "type": "string"
        },
        "repeated_keys": {
          "type": "array",
          "items": {
            "type": "string"
          }
        }
      },
      "required": [
        "mode",
        "columns",
        "explanation"
      ],
      "additionalProperties": false
    },
    "counts": {
      "type": "object",
      "properties": {
        "changed_rows": {
          "type": "number"
        },
        "changed_cells": {
          "type": "number"
        },
        "added_rows": {
          "type": "number"
        },
        "removed_rows": {
          "type": "number"
        },
        "key_changes": {
          "type": "number"
        },
        "unchanged_rows": {
          "type": "number"
        },
        "old_rows": {
          "type": "number"
        },
        "new_rows": {
          "type": "number"
        }
      },
      "required": [
        "changed_rows",
        "changed_cells",
        "added_rows",
        "removed_rows",
        "key_changes",
        "unchanged_rows",
        "old_rows",
        "new_rows"
      ],
      "additionalProperties": false
    },
    "columns": {
      "type": "object",
      "properties": {
        "compared": {
          "type": "number"
        },
        "added": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "removed": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "renamed": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "from": {
                "type": "string"
              },
              "to": {
                "type": "string"
              },
              "agreement_pct": {
                "type": [
                  "number",
                  "null"
                ]
              }
            },
            "required": [
              "from",
              "to",
              "agreement_pct"
            ],
            "additionalProperties": false
          }
        },
        "moved": {
          "type": "array",
          "items": {
            "type": "object",
            "properties": {
              "name": {
                "type": "string"
              },
              "from": {
                "type": "string"
              },
              "to": {
                "type": "string"
              }
            },
            "required": [
              "name",
              "from",
              "to"
            ],
            "additionalProperties": false
          }
        },
        "ignored": {
          "type": "array",
          "items": {
            "type": "string"
          }
        },
        "more": {
          "type": "object",
          "propertyNames": {
            "type": "string"
          },
          "additionalProperties": {
            "type": "number"
          }
        }
      },
      "required": [
        "compared",
        "added",
        "removed",
        "renamed",
        "moved",
        "ignored"
      ],
      "additionalProperties": false
    },
    "by_column": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "column": {
            "type": "string"
          },
          "changed": {
            "type": "number"
          },
          "increases": {
            "type": "number"
          },
          "decreases": {
            "type": "number"
          },
          "total_delta": {
            "type": [
              "number",
              "null"
            ]
          },
          "avg_pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "max_increase": {
            "anyOf": [
              {
                "type": "object",
                "properties": {
                  "key": {
                    "type": "string"
                  },
                  "old": {
                    "type": "string"
                  },
                  "new": {
                    "type": "string"
                  },
                  "delta": {
                    "type": "number"
                  },
                  "pct": {
                    "type": [
                      "number",
                      "null"
                    ]
                  }
                },
                "required": [
                  "key",
                  "old",
                  "new",
                  "delta",
                  "pct"
                ],
                "additionalProperties": false
              },
              {
                "type": "null"
              }
            ]
          },
          "max_decrease": {
            "anyOf": [
              {
                "type": "object",
                "properties": {
                  "key": {
                    "type": "string"
                  },
                  "old": {
                    "type": "string"
                  },
                  "new": {
                    "type": "string"
                  },
                  "delta": {
                    "type": "number"
                  },
                  "pct": {
                    "type": [
                      "number",
                      "null"
                    ]
                  }
                },
                "required": [
                  "key",
                  "old",
                  "new",
                  "delta",
                  "pct"
                ],
                "additionalProperties": false
              },
              {
                "type": "null"
              }
            ]
          }
        },
        "required": [
          "column",
          "changed",
          "increases",
          "decreases",
          "total_delta",
          "avg_pct",
          "max_increase",
          "max_decrease"
        ],
        "additionalProperties": false
      }
    },
    "biggest_changes": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "key": {
            "type": "string"
          },
          "old": {
            "type": "string"
          },
          "new": {
            "type": "string"
          },
          "delta": {
            "type": "number"
          },
          "pct": {
            "type": [
              "number",
              "null"
            ]
          },
          "column": {
            "type": "string"
          }
        },
        "required": [
          "key",
          "old",
          "new",
          "delta",
          "pct",
          "column"
        ],
        "additionalProperties": false
      }
    },
    "changes_preview": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "key": {
            "type": "string"
          },
          "old_row": {
            "type": "number"
          },
          "new_row": {
            "type": "number"
          },
          "cells": {
            "type": "array",
            "items": {
              "type": "object",
              "properties": {
                "column": {
                  "type": "string"
                },
                "old": {
                  "type": "string"
                },
                "new": {
                  "type": "string"
                },
                "delta": {
                  "type": [
                    "number",
                    "null"
                  ]
                },
                "pct": {
                  "type": [
                    "number",
                    "null"
                  ]
                },
                "unit": {
                  "description": "pp: delta is in percentage points (percent columns)",
                  "type": "string",
                  "const": "pp"
                }
              },
              "required": [
                "column",
                "old",
                "new",
                "delta",
                "pct"
              ],
              "additionalProperties": false
            }
          }
        },
        "required": [
          "key",
          "old_row",
          "new_row",
          "cells"
        ],
        "additionalProperties": false
      }
    },
    "added_preview": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "removed_preview": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "key_changes_preview": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "from": {
            "type": "string"
          },
          "to": {
            "type": "string"
          }
        },
        "required": [
          "from",
          "to"
        ],
        "additionalProperties": false
      }
    },
    "excluded_rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "file": {
            "type": "string"
          },
          "row": {
            "type": "number"
          },
          "reason": {
            "type": "string"
          },
          "label": {
            "type": "string"
          }
        },
        "required": [
          "file",
          "row",
          "reason",
          "label"
        ],
        "additionalProperties": false
      }
    },
    "notes": {
      "type": "array",
      "items": {
        "type": "string"
      }
    },
    "downloads": {
      "type": "object",
      "properties": {
        "xlsx": {
          "type": "string"
        },
        "csv": {
          "type": "string"
        }
      },
      "required": [
        "xlsx",
        "csv"
      ],
      "additionalProperties": false
    },
    "complete_list": {
      "type": "string"
    }
  },
  "required": [
    "files",
    "key",
    "counts",
    "columns",
    "by_column",
    "biggest_changes",
    "changes_preview",
    "added_preview",
    "removed_preview",
    "key_changes_preview",
    "excluded_rows",
    "notes",
    "downloads",
    "complete_list"
  ],
  "$schema": "http://json-schema.org/draft-07/schema#",
  "additionalProperties": false
}

コミュニティ

このサーバーを評価する

エビデンス

最近の観測

検証済みバージョンは記録されていませんツール 2 件