{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["予測入力","売上予測","一覧"],"not_rendered":{"charts":1,"images":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"予測入力","index":0,"n_rows":29,"n_cols":11,"rows_kept":29}
[{"$nulls":10}," "]
[null,"社外秘"]
[null,"会社名"]
[null,"売上予測"]
[]
[null,"取引先名","営業担当者","販売地域","販売カテゴリ","予測金額","営業段階","販売の確率","案件成立見込み","加重予測"]
[null,"アダタムコーポレーション"," 営業担当者 1","米国-北東部","コンサルティング",{"v":150000,"d":"¥150,000.00"},"正式承認",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},{"v":135000,"d":"¥135,000.00"}]
[null,"アドベンチャー ワークス"," 営業担当者 2","米国-南東部","製品",{"v":145200,"d":"¥145,200.00"},"営業案件",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":14520,"d":"¥14,520.00"}]
[null,"アルペン スキー ハウス"," 営業担当者 3","米国-北中部","トレーニング",{"v":162500,"d":"¥162,500.00"},"要特定",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":32500,"d":"¥32,500.00"}]
[null,"ボールドウィン科学博物館"," 営業担当者 4","米国-中南部","ミックス",{"v":147500,"d":"¥147,500.00"},"スポンサー",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":44250,"d":"¥44,250.00"}]
[null,"ジャパン航空"," 営業担当者 5","米国-北西部","専門サービス",{"v":148000,"d":"¥148,000.00"},"予算検証済み",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},{"v":59200,"d":"¥59,200.00"}]
[null,"City Power & Light"," 営業担当者 1","南西-南西部","サポート",{"v":175000,"d":"¥175,000.00"},"要分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},{"v":87500,"d":"¥87,500.00"}]
[null,"伊予商店株式会社"," 営業担当者 3","カナダ-東部","ミックス",{"v":149000,"d":"¥149,000.00"},"ソリューション提案済み",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,7,1)","v":"2020-07-01"},{"v":89400,"d":"¥89,400.00"}]
[null,"コーホーワイナリー"," 営業担当者 5","カナダ-西部","トレーニング",{"v":142000,"d":"¥142,000.00"},"書面による提案済み",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},{"v":99400,"d":"¥99,400.00"}]
[null,"Contoso 株式会社"," 営業担当者 3","EMEA-フランス","ミックス",{"v":172500,"d":"¥172,500.00"},"口頭での承認",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},{"v":155250,"d":"¥155,250.00"}]
[null,"コントソ製薬"," 営業担当者 4","EMEA-ドイツ","製品",{"v":163500,"d":"¥163,500.00"},"スポンサー",{"v":0.2,"d":"20%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":32700,"d":"¥32,700.00"}]
[null,"Consolidated Messenger"," 営業担当者 5","EMEA-イタリア","製品",{"v":155500,"d":"¥155,500.00"},"正式承認",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":155500,"d":"¥155,500.00"}]
[null,"Fabrikam, Inc."," 営業担当者 4","EMEA-その他","コンサルティング",{"v":166000,"d":"¥166,000.00"},"営業案件",{"v":0.1,"d":"10%"},{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},{"v":16600,"d":"¥16,600.00"}]
[null,"Fourth Coffee"," 営業担当者 3","APSA-アジア","トレーニング",{"v":180000,"d":"¥180,000.00"},"予算検証済み",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":54000,"d":"¥54,000.00"}]
[null,"Graphic Design Institute"," 営業担当者 2","APSA-太平洋","サービス",{"v":140000,"d":"¥140,000.00"},"ソリューション提案済み",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,5,1)","v":"2020-05-01"},{"v":84000,"d":"¥84,000.00"}]
[null,"Humongous Insurance"," 営業担当者 1","APSA-メキシコ","サポート",{"v":155000,"d":"¥155,000.00"},"スポンサー",{"v":0.3,"d":"30%"},{"$f":"DATE(YEAR(TODAY())+1,6,1)","v":"2020-06-01"},{"v":46500,"d":"¥46,500.00"}]
[null,"Litware, Inc."," 営業担当者 2","APSA-オーストラリア","専門サービス",{"v":173200,"d":"¥173,200.00"},"要分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,10,1)","v":"2020-10-01"},{"v":86600,"d":"¥86,600.00"}]
[null,"Lucerne Publishing"," 営業担当者 5","APSA-その他","サービス",{"v":146500,"d":"¥146,500.00"},"ソリューション提案済み",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,12,1)","v":"2020-12-01"},{"v":87900,"d":"¥87,900.00"}]
[null,"Margie's Travel"," 営業担当者 4","米国-北東部","サポート",{"v":156750,"d":"¥156,750.00"},"書面による提案済み",{"v":0.7,"d":"70%"},{"$f":"DATE(YEAR(TODAY())+1,11,1)","v":"2020-11-01"},{"v":109725,"d":"¥109,725.00"}]
[null,"Northwind Traders"," 営業担当者 3","米国-中南部","専門サービス",{"v":162000,"d":"¥162,000.00"},"口頭での承認",{"v":0.9,"d":"90%"},{"$f":"DATE(YEAR(TODAY())+1,2,1)","v":"2020-02-01"},{"v":145800,"d":"¥145,800.00"}]
[null,"ソフト商事株式会社"," 営業担当者 4","カナダ-東部","ミックス",{"v":157000,"d":"¥157,000.00"},"正式承認",{"v":1,"d":"100%"},{"$f":"DATE(YEAR(TODAY())+1,3,1)","v":"2020-03-01"},{"v":157000,"d":"¥157,000.00"}]
[null,"ファイン美術学校"," 営業担当者 3","EMEA-フランス","サービス",{"v":173000,"d":"¥173,000.00"},"予算検証済み",{"v":0.4,"d":"40%"},{"$f":"DATE(YEAR(TODAY())+1,4,1)","v":"2020-04-01"},{"v":69200,"d":"¥69,200.00"}]
[null,"明治商店株式会社"," 営業担当者 5","EMEA-UK","ミックス",{"v":171000,"d":"¥171,000.00"},"要分析",{"v":0.5,"d":"50%"},{"$f":"DATE(YEAR(TODAY())+1,8,1)","v":"2020-08-01"},{"v":85500,"d":"¥85,500.00"}]
[null,"中央日本株式会社"," 営業担当者 1","APSA-オーストラリア","製品",{"v":168000,"d":"¥168,000.00"},"ソリューション提案済み",{"v":0.6,"d":"60%"},{"$f":"DATE(YEAR(TODAY())+1,9,1)","v":"2020-09-01"},{"v":100800,"d":"¥100,800.00"}]

{"sheet":"売上予測","index":1,"n_rows":20,"n_cols":18,"rows_kept":20}
[{"$nulls":10}," "]
[null,"社外秘"]
[]
[null,"売上予測グラフ"]
[]
[null,"開始月",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"}]
[]
[null,"月","月間予測","累計",{"$nulls":11},{"$f":"B8","v":"月"},"月間予測","累計"]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+0,1)","v":"2020-01-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B9,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B9),MONTH(売上予測!B9)+1,0))","v":{"v":151600,"d":"¥151,600"}},{"$f":"IF(ISNUMBER(D8),D8+C9,C9)","v":{"v":151600,"d":"¥151,600"}},{"$nulls":11},{"$f":"B9","v":"2020-01-01"},{"$f":"C9","v":{"v":151600,"d":"¥151,600"}},{"$f":"D9-C9","v":0}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+1,1)","v":"2020-02-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B10,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B10),MONTH(売上予測!B10)+1,0))","v":{"v":160320,"d":"¥160,320"}},{"v":311920,"d":"¥311,920"},{"$nulls":11},"2020-02-01",{"$f":"C10","v":{"v":160320,"d":"¥160,320"}},{"$f":"D10-C10","v":{"v":151600,"d":"¥151,600"}}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+2,1)","v":"2020-03-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B11,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B11),MONTH(売上予測!B11)+1,0))","v":{"v":243500,"d":"¥243,500"}},{"v":555420,"d":"¥555,420"},{"$nulls":11},"2020-03-01",{"v":243500,"d":"¥243,500"},{"v":311920,"d":"¥311,920"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+3,1)","v":"2020-04-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B12,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B12),MONTH(売上予測!B12)+1,0))","v":{"v":113450,"d":"¥113,450"}},{"v":668870,"d":"¥668,870"},{"$nulls":11},"2020-04-01",{"v":113450,"d":"¥113,450"},{"v":555420,"d":"¥555,420"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+4,1)","v":"2020-05-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B13,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B13),MONTH(売上予測!B13)+1,0))","v":{"v":143200,"d":"¥143,200"}},{"v":812070,"d":"¥812,070"},{"$nulls":11},"2020-05-01",{"v":143200,"d":"¥143,200"},{"v":668870,"d":"¥668,870"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+5,1)","v":"2020-06-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B14,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B14),MONTH(売上予測!B14)+1,0))","v":{"v":134000,"d":"¥134,000"}},{"v":946070,"d":"¥946,070"},{"$nulls":11},"2020-06-01",{"v":134000,"d":"¥134,000"},{"v":812070,"d":"¥812,070"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+6,1)","v":"2020-07-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B15,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B15),MONTH(売上予測!B15)+1,0))","v":{"v":89400,"d":"¥89,400"}},{"v":1035470,"d":"¥1,035,470"},{"$nulls":11},"2020-07-01",{"v":89400,"d":"¥89,400"},{"v":946070,"d":"¥946,070"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+7,1)","v":"2020-08-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B16,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B16),MONTH(売上予測!B16)+1,0))","v":{"v":184900,"d":"¥184,900"}},{"v":1220370,"d":"¥1,220,370"},{"$nulls":11},"2020-08-01",{"v":184900,"d":"¥184,900"},{"v":1035470,"d":"¥1,035,470"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+8,1)","v":"2020-09-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B17,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B17),MONTH(売上予測!B17)+1,0))","v":{"v":100800,"d":"¥100,800"}},{"v":1321170,"d":"¥1,321,170"},{"$nulls":11},"2020-09-01",{"v":100800,"d":"¥100,800"},{"v":1220370,"d":"¥1,220,370"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+9,1)","v":"2020-10-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B18,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B18),MONTH(売上予測!B18)+1,0))","v":{"v":241850,"d":"¥241,850"}},{"v":1563020,"d":"¥1,563,020"},{"$nulls":11},"2020-10-01",{"v":241850,"d":"¥241,850"},{"v":1321170,"d":"¥1,321,170"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+10,1)","v":"2020-11-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B19,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B19),MONTH(売上予測!B19)+1,0))","v":{"v":142425,"d":"¥142,425"}},{"v":1705445,"d":"¥1,705,445"},{"$nulls":11},"2020-11-01",{"v":142425,"d":"¥142,425"},{"v":1563020,"d":"¥1,563,020"}]
[null,{"$f":"DATE(YEAR(開始_月),MONTH(開始_月)+11,1)","v":"2020-12-01"},{"$f":"SUMIFS(表_予測入力[加重予測],表_予測入力[案件成立見込み],\">=\"&売上予測!B20,表_予測入力[案件成立見込み],\"<=\"&DATE(YEAR(売上予測!B20),MONTH(売上予測!B20)+1,0))","v":{"v":243400,"d":"¥243,400"}},{"v":1948845,"d":"¥1,948,845"},{"$nulls":11},"2020-12-01",{"v":243400,"d":"¥243,400"},{"v":1705445,"d":"¥1,705,445"}]

{"sheet":"一覧","index":2,"n_rows":21,"n_cols":8,"rows_kept":21}
[null,"リスト"]
[]
[null,"営業担当者",null,"営業地域",null,"営業項目",null,"営業段階"]
[null," 営業担当者 1",null,"米国-北東部",null,"コンサルティング",null,"要特定"]
[null," 営業担当者 2",null,"米国-南東部",null,"ミックス",null,"営業案件"]
[null," 営業担当者 3",null,"米国-北中部",null,"製品",null,"要分析"]
[null," 営業担当者 4",null,"米国-中南部",null,"専門サービス",null,"ソリューション提案済み"]
[null," 営業担当者 5",null,"米国-北西部",null,"サービス",null,"書面による提案済み"]
[{"$nulls":3},"南西-南西部",null,"サポート",null,"口頭での承認"]
[{"$nulls":3},"カナダ-東部",null,"トレーニング",null,"正式承認"]
[{"$nulls":3},"カナダ-西部",{"$nulls":3},"予算検証済み"]
[{"$nulls":3},"EMEA-フランス",{"$nulls":3},"スポンサー"]
[{"$nulls":3},"EMEA-ドイツ"]
[{"$nulls":3},"EMEA-イタリア"]
[{"$nulls":3},"EMEA-その他"]
[{"$nulls":3},"APSA-アジア"]
[{"$nulls":3},"APSA-太平洋"]
[{"$nulls":3},"APSA-メキシコ"]
[{"$nulls":3},"APSA-オーストラリア"]
[{"$nulls":3},"APSA-その他"]
[{"$nulls":3},"EMEA-UK"]