{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["使い方","顧客管理表","担当者・月別商談額レポート","商談総額ランキング","リスト"],"not_rendered":{"charts":1,"images":40,"macros":0,"external_links":0,"defined_names":12,"comments":1,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":718,"n_cols":19,"rows_kept":718,"cut":false,"hidden":false,"merged":[]}
["テンプレートの使い方",{"$nulls":15},"※最終更新日：2020/12/25"]
[]
[null,"当テンプレートは、社内で蓄積された顧客情報を管理する為のツールとなります。"]
[]
[null,"「顧客情報」として、【リード（見込み客）情報】、【実際に商談化（取引先）した情報】の管理が行えます。"]
[]
[]
[null,"＜入力シート＞"]
[]
[null,null,"顧客情報は、シート「顧客管理表」に対して入力してください。"]
{"$rows_empty":31}
[null,"＜基本的な使い方＞"]
[]
[null,null,null,"１．「取引先セクション」「連絡先セクション」「商談セクション」の入力について"]
[]
[{"$nulls":4},"当テンプレートは１行につき＜３セクション＞で構成されています。"]
[]
[{"$nulls":4},"【会社情報のみ管理したい場合】"]
[]
[{"$nulls":5},"→「取引先セクション」のみ入力してください"]
[]
[{"$nulls":4},"【会社情報＋担当者情報を管理したい場合】"]
[]
[{"$nulls":5},"→「取引先セクション」と「連絡先セクション」を入力してください。"]
[{"$nulls":5},"１企業で複数担当者を管理したい場合は下記のように入力してください"]
[]
[{"$nulls":5},"取引先セクション",{"$nulls":6},"連絡先セクション",{"$nulls":5},"商談セクション"]
[{"$nulls":5},"取引先名",{"$nulls":4},"～",null,"姓",null,null,null,"～",null,"～"]
[{"$nulls":5},"株式会社サンプル１",{"$nulls":4},"～",null,"木村",null,null,null,"～",null,"－"]
[{"$nulls":5},"株式会社サンプル１",{"$nulls":4},"～",null,"鈴木",null,null,null,"～",null,"－"]
[{"$nulls":5},"株式会社サンプル２",{"$nulls":4},"～",null,"小林",null,null,null,"～",null,"－"]
[]
[{"$nulls":5},"※上記明細２行目の「鈴木」に対しても「取引先セクション」の情報を入力してください。"]
[{"$nulls":5},"入力されない場合、入力後にフィルター（データの絞り込み）をすることが出来なくなります。"]
[]
[{"$nulls":4},"【会社情報＋担当者情報＋商談情報の全てを管理したい場合】"]
[]
[{"$nulls":5},"→全てのセクションに対して入力してください。"]
[{"$nulls":5},"１企業で複数担当者、複数商談等を管理したい場合は下記のように入力してください"]
[]
[{"$nulls":5},"取引先セクション",{"$nulls":6},"連絡先セクション",{"$nulls":5},"商談セクション"]
[{"$nulls":5},"取引先名",{"$nulls":4},"～",null,"姓",null,null,null,"～",null,"商談名"]
[{"$nulls":5},"株式会社サンプル１",{"$nulls":4},"～",null,"木村",null,null,null,"～",null,"－"]
[{"$nulls":5},"株式会社サンプル１",{"$nulls":4},"～",null,"鈴木",null,null,null,"～",null,"商談０１"]
[{"$nulls":5},"株式会社サンプル１",{"$nulls":4},"～",null,"鈴木",null,null,null,"～",null,"商談０２"]
[{"$nulls":5},"株式会社サンプル２",{"$nulls":4},"～",null,"小林",null,null,null,"～",null,"－"]
[]
[{"$nulls":5},"※上記明細２～３行目の「鈴木」に対しての商談に対しては、「取引先セクション」及び「連絡先セクション」の情報を入力してください。"]
[{"$nulls":5},"入力されない場合、入力後にフィルター（データの絞り込み）をすることが出来なくなります。"]
[]
[]
[{"$nulls":4},"※当テンプレートは＜３セクション＞構成である為、「横長」となっていますが、シート「顧客管理票」の上部の「＋」「－」となっている部分（下記赤枠）を押下しますと一時的に項目を非表示となり、入力・確認がしやすくなります。"]
{"$rows_empty":40}
[null,null,null,"２．リード情報を入力する"]
[]
[{"$nulls":4},"リード（見込み客）情報として管理する場合は、「見込み客」を「〇」としてください。"]
[{"$nulls":4},"フィルターで「〇」のみを選択することで、「リード情報のみ表示する」とすることが出来ます。"]
{"$rows_empty":20}
[null,null,null,"３．取引前（リード）の段階で失注となった場合、行をグレー表示"]
[]
[{"$nulls":4},"「見込み客ステータス」を『失注』とすることで、その行はグレーで表示されます。"]
{"$rows_empty":24}
[null,null,null,"４．「姓」に対して入力漏れを防止させる （入力必須チェックではありません）"]
[]
[{"$nulls":4},"当テンプレートでは、お客様の「姓」を必ず入力してもらいたい為、未入力である場合は、セルの背景色を「青色」で表示します。"]
{"$rows_empty":24}
[null,null,null,"５．各項目で検索"]
[]
[{"$nulls":4},"フィルター機能を使うことで、データの絞り込みが出来ます。"]
{"$rows_empty":21}
[null,null,null,"６．表の色を変更する"]
[]
[{"$nulls":4},"①…表（B6セル以降の表）内のどの項目でも構いませんのでクリックしてください"]
{"$rows_empty":22}
[{"$nulls":4},"②…「ホーム」　⇒　「テーブルとして書式設定」　⇒　お好きな色をクリックすると、表の色が変更されます"]
{"$rows_empty":30}
[null,null,null,"７．選択（リスト）項目の内容を変更"]
[]
[{"$nulls":4},"①…「シート名（どのシートでも構いません）」で右クリック　⇒　再表示"]
{"$rows_empty":13}
[{"$nulls":4},"②…「リスト」が選択されている状態で、OKボタンをクリック"]
{"$rows_empty":12}
[{"$nulls":4},"③…A～B列がリストを設定している場所となります。"]
[]
[{"$nulls":5},"例えば「担当者」を追加したい場合、10行目までが担当者の設定箇所となりますが、11行目に行挿入するのはNGです。"]
[]
[{"$nulls":5},"▼追加前"]
{"$rows_empty":12}
[{"$nulls":5},"▼その項目（今回例の場合「担当者」）の一番最終行の下に行挿入。これはNGです。"]
{"$rows_empty":13}
[{"$nulls":5},"▼追加する場合は、必ずその項目（今回例の場合「担当者」）の一番最終行の「上」に行挿入してください。"]
{"$rows_empty":24}
[{"$nulls":4},"④…追加が完了しましたら、再度シート「リスト」を非表示にしましょう（勝手に書き換えられない為に）"]
[]
[{"$nulls":5},"▼シート「リスト」で右クリック"]
[]
[]
[]
[]
[{"$nulls":5},"▼「非表示」"]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"▼シート「リスト」が非表示となります"]
[]
[]
[]
[]
[]
[null,null,null,"８．管理者以外は「列の挿入／削除」や「行削除」は不可としています"]
[]
[{"$nulls":4},"「ホーム」　⇒　「シートの保護」で設定しています。"]
{"$rows_empty":8}
[{"$nulls":4},"▼列の挿入、列の削除、行の削除は許可しない設定にしています"]
{"$rows_empty":22}
[{"$nulls":4},"▼列の挿入、列の削除、行の削除は出来ません"]
{"$rows_empty":26}
[{"$nulls":4},"▼保護を解除したい場合"]
[]
[{"$nulls":4},"「ホーム」　⇒　「シート保護の解除」をクリック"]
{"$rows_empty":7}
[{"$nulls":4},"初期状態のパスワードは「1234」となっておりますので、適時変更してください。"]
{"$rows_empty":20}
[null,null,null,"９．レポート"]
[]
[{"$nulls":4},"当テンプレートでは、「商談レポート」として２種類用意しています。"]
[]
[{"$nulls":4},"①…「担当者・月別商談額レポート」"]
[]
[{"$nulls":5},"→担当者がどの年月でどれだけの商談（金額）を成約させたかを管理するレポート"]
[]
[{"$nulls":4},"②…「商談総額ランキング」"]
[]
[{"$nulls":5},"→担当者毎の商談金額が多い順にグラフ表示します"]
[]
[]
[{"$nulls":4},"▼レポートの元となる情報は、シート「顧客管理表」の【商談セクション】に入力されたデータとなります"]
{"$rows_empty":21}
[{"$nulls":4},"▼担当者・月別商談額レポートは、シート「担当者・月別商談額レポート」をクリック"]
{"$rows_empty":21}
[{"$nulls":4},"▼シート「顧客管理表」のデータを修正した場合、レポートは自動反映しません。表内のセル（どこでも構いません）で右クリック　⇒　「更新」をクリックすることで最新の状態となります"]
{"$rows_empty":13}
[{"$nulls":4},"▼レポートはシート「レポート」をクリック"]
[]
[]
[]
[]
[]
[{"$nulls":4},"▼商談総額ランキングは、シート「商談総額ランキング」をクリック"]
{"$rows_empty":23}
[{"$nulls":4},"▼シート「顧客管理表」のデータを修正した場合、レポートは自動反映しません。表内のセル（どこでも構いません）で右クリック　⇒　「更新」をクリックすることで最新の状態となります"]
{"$rows_empty":15}
[{"$nulls":4},"※「担当者・月別商談額レポート」、「商談総額ランキング」共に、『商談が\"受注\"になったデータのみ』等の絞り込みが可能です。"]
[{"$nulls":4},"「ステージ」の右の「▼」をクリックし、絞り込みしたいステージのみ選択してください。"]
{"$rows_empty":24}
[null,"＜おまけ＞"]
[]
[null,null,null,"郵便番号から住所へ変換する方法"]
[]
[{"$nulls":4},"１．全角で郵便番号を入力"]
{"$rows_empty":13}
[{"$nulls":4},"２．スペースキーを２回押す"]
{"$rows_empty":7}
[{"$nulls":4},"３．変換されました"]
{"$rows_empty":12}
[{"$nulls":4},"※上記の変換をする為にはIME辞書（郵便番号辞書）の設定が必要です"]
[]
[{"$nulls":5},"▼タスクバーのMicrosoft IMEのアイコンを右クリック"]
[]
[]
[]
[{"$nulls":5},"▼「追加辞書サービス」→「辞書の設定」"]
{"$rows_empty":15}
[{"$nulls":5},"▼「システム辞書」の「郵便番号辞書」がチェックされていること"]
{"$rows_empty":23}
["免責事項"]
[]
[]
[null,"当ツールについては、当社は細心の注意を払って作成しておりますが、"]
[null,"ツール上で生じたデータ破損などの問題については、当社は一切の責任を負いかねます。予めご了承ください。"]
[null,"使い方などご不明な点がございましたら弊社までお気軽にお問合せください。"]
[]
[null,"市場開発課 Zoho営業担当 "]
[null,"TEL : 03-5350-9171"]
[null,"Mail: zoho-sales@data-service.jp"]
[]
[null,"データサービス×Zoho CRM"]
[null,"https://www.ds-cloud.jp/"]

{"sheet":"顧客管理表","index":1,"n_rows":104,"n_cols":48,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
[]
[null,"  顧客管理表"]
[]
[null,"【取引先セクション】",{"$nulls":15},"【連絡先セクション】",{"$nulls":15},"【商談セクション】"]
[null,"取引先名","見込み客","見込み客ステータス","見込み客のデータ元","ランク","取引先の種類","企業形態","業界","親取引先","電話番号","Fax","Webサイト","従業員数","郵便番号","住所（取引先）","詳細情報（取引先）","姓","名","メール","職位","部署","電話番号（連絡先）","電話番号（自宅）","電話番号（その他）","Fax（連絡先）","携帯電話","誕生日","郵便番号（連絡先）","住所（連絡先）","詳細情報（連絡先）","見込み客のデータ元2","メール送付不可","商談名","ステージ","完了予定日","総額","確度","次のステップ","詳細情報（商談）","売上の期待値","商談の期間","担当者","作成日","作成者","更新日","更新者","完了年月"]
[null,"山川商事株式会社","〇","連絡済（到達）","広告","A","顧客","非上場","中小企業","","000-000-0001","","",10,"386-0404","長野県上田市上丸子4-5-1","","山本","裕太","yuta.michi@abcmail.aaa","マネージャー","営業部","000-000-0001","","","","000-0000-0001","","386-0404","長野県上田市上丸子4-5-1","","","不可",{"$nulls":8},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[null,"新八重洲重工株式会社",null,"連絡済み（不在）","社員からの紹介","B","顧客","非上場","中小企業","","000-000-0002","","",20,"108-0073","東京都港区三田3-20-13","","中島","富男","tomi.nakajima@defmail.bbb","正社員","経営企画部","000-000-0002","","","","000-0000-0002","","108-0073","東京都港区三田3-20-13","","",null,"新八重洲重工株式会社-商談01","ニーズの分析","2020-09-13",7000000,20,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":1400000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":53},"堀川 鉄洋","2020-11-02","堀川 鉄洋",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/09"}]
[null,"株式会社FLT",null,"対応不要","外部からの紹介","C","顧客","非上場","中小企業","","000-000-0003","","",30,"192-0917","東京都八王子市西片倉4-2-13","","北並","剛志","tsuyoshi.kitanami@ghimail.ccc","社長","代表取締役","000-000-0003","","","","000-0000-0003","","192-0917","東京都八王子市西片倉4-2-13","","",null,"株式会社FLT-商談01","提案","2020-05-12",6250000,40,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":2500000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":52},"畑 薫","2020-11-03","畑 薫",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/05"}]
[null,"ハービック株式会社",null,"連絡済（到達）","パートナー","D","競合","非上場","中小企業","","000-000-0004","","",40,"869-2601","熊本県阿蘇市一の宮町手野4-5-13","","杉浦","優香","yuka.sugiura@jklmail.ddd","部長","システム管理者","000-000-0004","","","","000-0000-0004","","869-2601","熊本県阿蘇市一の宮町手野4-5-13","","",null,"ハービック株式会社-商談01","意思決定","2020-09-15",5000000,60,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":3000000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":51},"岸 夏希","2020-11-04","岸 夏希",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/09"}]
[null,"株式会社ストアユナイテッド",null,"失注","外部からの紹介","E","顧客","非上場","独立系ソフトウェアベンダー","","000-000-0005","","",50,"133-0053","東京都江戸川区北篠崎3-14-14","","千葉","雅夫","masao.chiba@mnomail.eee","マネージャー","開発部","000-000-0005","","","","000-0000-0005","","133-0053","東京都江戸川区北篠崎3-14-14","","",null,"株式会社ストアユナイテッド-商談01","見積もりの提示","2020-11-17",4000000,75,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":3000000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":234},"栗田 美佐子","2020-05-05","栗田 美佐子",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/11"}]
[null,"株式会社東西新聞社",null,"見込みあり","展示会","A","顧客","非上場","中小企業","","000-000-0006","","",60,"723-0011","広島県三原市東町4-4-12","","平田","健","ken.hirata@pqrmail.fff","室長","システム室","000-000-0006","","","","000-0000-0006","","723-0011","広島県三原市東町4-4-12","","",null,"株式会社東西新聞社-商談01","交渉","2020-10-12",3000000,90,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":2700000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":85},"福田 遥","2020-10-01","福田 遥",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/10"}]
[null,"株式会社アーガス",null,"連絡済（到達）","Webからのダウンロード","B","顧客","非上場","中小企業","","000-000-0007","","",70,"992-0263","山形県東置賜郡高畠町下和田1-8-6","","清水","真奈美","manami.shimizu@stumail.ggg","担当","総務部","000-000-0007","","","","000-0000-0007","","992-0263","山形県東置賜郡高畠町下和田1-8-6","","",null,"株式会社アーガス-商談01","受注","2020-06-14",2000000,100,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":2000000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":48},"浅沼 大樹","2020-11-07","浅沼 大樹",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/06"}]
[null,"ザスカー株式会社",null,"今後連絡","広告","C","顧客","非上場","中小企業","","000-000-0008","","",80,"783-0049","高知県南国市岡豊町中島3-8-9","","岸田","雅俊","masatoshi.kishida@vwxmail.hhh","リーダー","経理チーム","000-000-0008","","","","000-0000-0008","","783-0049","高知県南国市岡豊町中島3-8-9","","",null,"ザスカー株式会社-商談01","失注","2020-08-13",5000000,0,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":0},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":78},"中園 圭","2020-10-08","中園 圭",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/08"}]
[null,"レクト・プロバイダー株式会社",null,"失注","展示会","E","顧客","非上場","中小企業","株式会社アーガス","000-000-0009","","",90,"866-0823","熊本県八代市十条町4-6-14","","亀山","ミキ","miki.kameyama@yzamail.hhh","部長","営業部","000-000-0009","","","","000-0000-0009","","866-0823","熊本県八代市十条町4-6-14","","",null,"レクト・プロバイダー株式会社-商談01","競合選択による失注","2020-10-12",3000000,0,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":0},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":49},"長谷川 啓介","2020-11-06","長谷川 啓介",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/10"}]
[null,"鉄日建設株式会社",null,"連絡済（到達）","営業メール","D","顧客","上場","大規模企業","","000-000-0010","","",1000,"384-0001","長野県小諸市小原1-10-12","","岩田","哲弘","tetsuhiro.iwada@bcdmail.iii","担当","品質管理室","000-000-0010","","","","000-0000-0010","","384-0001","長野県小諸市小原1-10-12","","",null,"鉄日建設株式会社-商談01","条件確認","2020-12-14",10000000,10,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":1000000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":48},"畑 薫","2020-11-07","畑 薫",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/12"}]
[null,"鉄日建設株式会社",null,"連絡済（到達）","外部からの紹介","D","顧客","上場","大規模企業","","000-000-0010","","",1000,"384-0001","長野県小諸市小原1-10-12","","鈴木","一郎","test@bcdmail.iii",null,"営業部","000-000-0011","","","","000-0000-0011","","384-0001","長野県小諸市小原1-10-12","","",null,"鉄日建設株式会社-商談02","受注","2020-11-11",1860000,80,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":1488000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":46},"岸 夏希","2020-11-09","岸 夏希",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/11"}]
[null,"鉄日建設株式会社",null,"連絡済（到達）","外部からの紹介","D","顧客","上場","大規模企業","","000-000-0010","","",1000,"384-0001","長野県小諸市小原1-10-12","","鈴木","一郎","test@bcdmail.iii",null,"営業部","000-000-0011","","","","000-0000-0011","","384-0001","長野県小諸市小原1-10-12","","",null,"鉄日建設株式会社-商談03","受注","2020-07-30",4800000,70,"","",{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":3360000},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":109},"栗田 美佐子","2020-09-07","栗田 美佐子",null,null,{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":"2020/07"}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":15},{"$f":"_xlfn.CONCAT(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]
[{"$nulls":40},{"$f":"IF(テーブル24[[#This Row],[確度]]<>\"\",テーブル24[[#This Row],[総額]]*(テーブル24[[#This Row],[確度]]/100),\"\")","v":""},{"$f":"IF(テーブル24[[#This Row],[作成日]]<>\"\",DATEDIF(テーブル24[[#This Row],[作成日]],TODAY(),\"D\"),\"\")","v":""},{"$nulls":5},{"$f":"IF(テーブル24[[#This Row],[完了予定日]]<>\"\",YEAR(テーブル24[[#This Row],[完了予定日]]) & \"/\" & RIGHT(\"00\"&MONTH(テーブル24[[#This Row],[完了予定日]]),2),\"\")","v":""}]

{"sheet":"担当者・月別商談額レポート","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["担当者・月別商談額レポート"]
[]
[null,"ステージ","(すべて)"]
[]
[null,"担当者・月別商談額","完了年月"]
[null,"担当者",null,"2020/05","2020/06","2020/07","2020/08","2020/09","2020/10","2020/11","2020/12","(空白)","総計"]
[null,"岸 夏希",0,0,0,0,0,5000000,0,1860000,0,0,6860000]
[null,"栗田 美佐子",0,0,0,4800000,0,0,0,4000000,0,0,8800000]
[null,"浅沼 大樹",0,0,2000000,0,0,0,0,0,0,0,2000000]
[null,"畑 薫",0,6250000,0,0,0,0,0,0,10000000,0,16250000]
[null,"福田 遥",0,0,0,0,0,0,3000000,0,0,0,3000000]
[null,"(空白)",0,0,0,0,0,0,0,0,0,0,0]
[null,"堀川 鉄洋",0,0,0,0,0,7000000,0,0,0,0,7000000]
[null,"中園 圭",0,0,0,0,5000000,0,0,0,0,0,5000000]
[null,"長谷川 啓介",0,0,0,0,0,0,3000000,0,0,0,3000000]
[null,"総計",0,6250000,2000000,4800000,5000000,12000000,6000000,5860000,10000000,0,51910000]

{"sheet":"商談総額ランキング","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["商談総額ランキング"]
[]
[null,"ステージ","(すべて)"]
[]
[null,"担当者","合計 / 総額"]
[null,"畑 薫",16250000]
[null,"栗田 美佐子",8800000]
[null,"堀川 鉄洋",7000000]
[null,"岸 夏希",6860000]
[null,"中園 圭",5000000]
[null,"長谷川 啓介",3000000]
[null,"福田 遥",3000000]
[null,"浅沼 大樹",2000000]
[null,"(空白)"]

{"sheet":"リスト","index":4,"n_rows":144,"n_cols":2,"rows_kept":144,"cut":false,"hidden":true,"merged":[]}
["担当者","宮地 亮介"]
[null,"堀川 鉄洋"]
[null,"浅沼 大樹"]
[null,"畑 薫"]
[null,"岸 夏希"]
[null,"栗田 美佐子"]
[null,"長谷川 啓介"]
[null,"福田 遥"]
[null,"山上 奈々"]
[null,"中園 圭"]
["見込み客ステータス","-None-"]
[null,"連絡済み（不在）"]
[null,"今後対応"]
[null,"連絡済（到達）"]
[null,"対応不要"]
[null,"失注"]
[null,"未連絡"]
[null,"見込みあり"]
[null,"見込みなし"]
[null,"今後連絡"]
[null,"連絡済（不在）"]
["見込み客のデータ元","-None-"]
[null,"広告"]
[null,"電話営業（コールドコール）"]
[null,"社員からの紹介"]
[null,"外部からの紹介"]
[null,"オンラインショップ"]
[null,"パートナー"]
[null,"広報活動"]
[null,"営業メール"]
[null,"パートナーセミナー"]
[null,"社内セミナー"]
[null,"展示会"]
[null,"Webからのダウンロード"]
[null,"Web検索"]
[null,"チャット"]
["業界","-None-"]
[null,"アプリケーションサービスプロバイダー"]
[null,"データ/通信OEM"]
[null,"ERP関連企業"]
[null,"政府/地方公共団体"]
[null,"大規模企業"]
[null,"独立系ソフトウェアベンダー"]
[null,"MSP（マネージメントサービスプロバイダー）"]
[null,"ネットワーク関連企業"]
[null,"独立系ソフトウェア会社"]
[null,"光通信"]
[null,"サービスプロバイダー"]
[null,"中小企業"]
[null,"倉庫業"]
[null,"ストレージサービスプロバイダー"]
[null,"システムインテグレーター"]
[null,"無線通信業"]
[null,"独立系ソフト開発会社"]
["接触ステータス","-None-"]
[null,"連絡先入手済み"]
[null,"有効"]
[null,"連絡不可"]
[null,"キャンセル"]
[null,"連絡拒否"]
["都道府県","北海道"]
[null,"青森県"]
[null,"岩手県"]
[null,"宮城県"]
[null,"秋田県"]
[null,"山形県"]
[null,"福島県"]
[null,"茨城県"]
[null,"栃木県"]
[null,"群馬県"]
[null,"埼玉県"]
[null,"千葉県"]
[null,"東京都"]
[null,"神奈川県"]
[null,"新潟県"]
[null,"富山県"]
[null,"石川県"]
[null,"福井県"]
[null,"山梨県"]
[null,"長野県"]
[null,"岐阜県"]
[null,"静岡県"]
[null,"愛知県"]
[null,"三重県"]
[null,"滋賀県"]
[null,"京都府"]
[null,"大阪府"]
[null,"兵庫県"]
[null,"奈良県"]
[null,"和歌山県"]
[null,"鳥取県"]
[null,"島根県"]
[null,"岡山県"]
[null,"広島県"]
[null,"山口県"]
[null,"徳島県"]
[null,"香川県"]
[null,"愛媛県"]
[null,"高知県"]
[null,"福岡県"]
[null,"佐賀県"]
[null,"長崎県"]
[null,"熊本県"]
[null,"大分県"]
[null,"宮崎県"]
[null,"鹿児島"]
[null,"沖縄県"]
["取引先の種類","-None-"]
[null,"アナリスト"]
[null,"競合"]
[null,"顧客"]
[null,"代理店"]
[null,"システムインテグレーター"]
[null,"投資家"]
[null,"その他"]
[null,"パートナー"]
[null,"プレス"]
[null,"見込み客"]
[null,"リセラー"]
[null,"仕入先"]
["企業形態","-None-"]
[null,"その他"]
[null,"非公開"]
[null,"公開"]
[null,"子会社"]
[null,"上場"]
[null,"非上場"]
["ステージ","条件確認"]
[null,"ニーズの分析"]
[null,"提案"]
[null,"意思決定"]
[null,"見積もりの提示"]
[null,"交渉"]
[null,"受注"]
[null,"失注"]
[null,"競合選択による失注"]
["メール送付不可"]
[null,"不可"]
["ランク"]
[null,"A"]
[null,"B"]
[null,"C"]
[null,"D"]
[null,"E"]