{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["このファイルの使い方","リード分析","マスタ"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"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":"このファイルの使い方","index":0,"n_rows":169,"n_cols":2,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"①PORTERSのレポートの設定"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"レポートの設定は以上です。そのまま実行を押していただいて問題ございません・"]
[]
[]
[null,"②データ本Excelシートに張り付ける"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"③リード分析のマクロ設定"]
[null,"Excelの開発のタブをクリックし、マクロをクリック"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"リード分析更新が選択された状態で「編集」をクリック"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"お客様の環境にあったフェーズ名に変更するため、マクロを書き換えます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"同様に黄色背景の部分を自社のフェーズに書き換えます。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"最後に画面上部の保存をクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[null,"マクロの設定は以上です。"]
[]
[null,"④実際に実行する"]
[null,"リード分析のボタンをクリックお願いします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"こちらでデータが出力されます。"]

{"sheet":"リード分析","index":1,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["決定者名","決定者ID","決定プロセスID","面談日時","書類推薦日","面接実施日","内定承諾日","入社決定日","リードタイム（面談→入社）","担当CA"]
["田中太郎",11360,11055,"2025-04-20","2025-04-30","2025-05-08","2025-06-04","2025-06-20","61日","春原優作"]
["鈴木次郎",11361,11052,"2025-04-20","2025-04-30","2025-05-09","2025-06-12","2025-06-20","61日","春原優作"]
["佐藤一郎",11362,11047,"2025-04-20","2025-04-25","2025-05-01","2025-05-12","2025-05-26","36日","春原優作"]

{"sheet":"マスタ","index":2,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[" 候補者ID","個人氏名","エントリーサイト","フェーズ","面談日","選考プロセス ID","選考プロセス","選考プロセス日付","担当CA"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11053,"求人打診","2025-04-23T13:23:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11054,"求人打診","2025-04-23T13:23:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"求人打診","2025-04-23T13:23:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"書類推薦","2025-04-30T13:29:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"一次面接","2025-05-08T13:29:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"二次面接","2025-05-16T13:29:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"最終面接","2025-05-22T13:29:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"企業内定","2025-05-30T13:29:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"内定承諾","2025-06-04T13:29:00","春原優作"]
[11360,"田中太郎","Indeed","面談設定済","2025-04-20T10:00:00",11055,"入社日決定","2025-06-20T13:36:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11050,"求人打診","2025-04-23T13:23:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11051,"求人打診","2025-04-23T13:23:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"求人打診","2025-04-23T13:23:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"書類推薦","2025-04-30T13:30:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"一次面接","2025-05-09T13:30:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"二次面接","2025-05-21T13:30:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"最終面接","2025-05-30T13:30:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"企業内定","2025-06-05T13:30:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"内定承諾","2025-06-12T13:30:00","春原優作"]
[11361,"鈴木次郎","自社サイト","面談設定済","2025-04-20T10:00:00",11052,"入社日決定","2025-06-20T13:30:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"求人打診","2025-04-23T13:22:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"書類推薦","2025-04-25T13:26:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"一次面接","2025-05-01T13:27:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"二次面接","2025-05-03T13:27:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"最終面接","2025-05-05T13:28:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"企業内定","2025-05-09T13:28:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"内定承諾","2025-05-12T13:28:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11047,"入社日決定","2025-05-26T13:28:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11048,"求人打診","2025-04-23T13:22:00","春原優作"]
[11362,"佐藤一郎","RAN","面談設定済","2025-04-20T10:00:00",11049,"求人打診","2025-04-23T13:22:00","春原優作"]