{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["潛在客戶資料","銷售預測 ","每月加權預測"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"潛在客戶資料","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"merged":[[3,1,3,8]]}
[null,"公司名稱"]
[null,"詳細的潛在客戶追蹤工具"]
[null,{"$f":"TODAY()","v":"2018-05-21"}]
[null,{"$f":"公司_名稱","v":"公司名稱"},{"$nulls":7},"機密"]
[null,"潛在客戶名稱","潛在客戶連絡人","潛在客戶來源","潛在客戶地區","潛在客戶類型","潛在商機","銷售機率","預測結案時間","加權預測"]
[null,"A.Datum Corporation",{"$nulls":3},"策略性",{"v":300000,"d":"NT$300,000.00"},{"v":0.9,"d":"90%"},"一月",{"$f":"IFERROR(IF(潛在客戶資料[銷售機率]<>\"\",潛在客戶資料[銷售機率]*潛在客戶資料[潛在商機],\"\"),\"\")","v":{"v":270000,"d":"NT$270,000.00"}}]
[null,"Adventure Works",{"$nulls":3},"策略性",{"v":200000,"d":"NT$200,000.00"},{"v":0.1,"d":"10%"},"二月",{"$f":"IFERROR(IF(潛在客戶資料[銷售機率]<>\"\",潛在客戶資料[銷售機率]*潛在客戶資料[潛在商機],\"\"),\"\")","v":{"v":20000,"d":"NT$20,000.00"}}]
[null,"Alpine Ski House",{"$nulls":3},"戰術性",{"v":100000,"d":"NT$100,000.00"},{"v":0.2,"d":"20%"},"三月",{"$f":"IFERROR(IF(潛在客戶資料[銷售機率]<>\"\",潛在客戶資料[銷售機率]*潛在客戶資料[潛在商機],\"\"),\"\")","v":{"v":20000,"d":"NT$20,000.00"}}]
[null,"合計",{"$nulls":4},{"$f":"SUBTOTAL(109,潛在客戶資料[潛在商機])","v":{"v":600000,"d":"NT$600,000.00"}},null,null,{"$f":"SUBTOTAL(109,潛在客戶資料[加權預測])","v":{"v":310000,"d":"NT$310,000.00"}}]

{"sheet":"銷售預測 ","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"merged":[[3,1,3,11],[3,12,3,13]]}
[null,{"$f":"公司_名稱","v":"公司名稱"}]
[null,"銷售預測"]
[null,{"$f":"追蹤工具日期","v":"2018-05-21"}]
[null,{"$f":"公司_名稱","v":"公司名稱"},{"$nulls":10},"機密"]
[null,"潛在客戶名稱","一月預測","二月預測","三月預測","四月預測","五月預測","六月預測","七月預測","八月預測","九月預測","十月預測","十一月預測","十二月預測"]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":"A.Datum Corporation"},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":270000,"d":"NT$270,000"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":20000,"d":"NT$20,000"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":"Alpine Ski House"},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":20000,"d":"NT$20,000"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":{"v":0,"d":"NT$0"}}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潛在客戶資料[潛在客戶名稱] <> \"\", ROW(銷售預測[潛在客戶名稱])<>最後項目),潛在客戶資料[潛在客戶名稱], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"三月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"四月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"五月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"六月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"七月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"八月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"九月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十一月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潛在客戶資料[預測結案時間] <>\"\",IF(潛在客戶資料[預測結案時間]= \"十二月\",潛在客戶資料[加權預測],0),\"\"),\"\")","v":""}]
[null,"合計",{"$f":"SUBTOTAL(109,銷售預測[一月預測])","v":{"v":270000,"d":"NT$270,000"}},{"$f":"SUBTOTAL(109,銷售預測[二月預測])","v":{"v":20000,"d":"NT$20,000"}},{"$f":"SUBTOTAL(109,銷售預測[三月預測])","v":{"v":20000,"d":"NT$20,000"}},{"$f":"SUBTOTAL(109,銷售預測[四月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[五月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[六月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[七月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[八月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[九月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[十月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[十一月預測])","v":{"v":0,"d":"NT$0"}},{"$f":"SUBTOTAL(109,銷售預測[十二月預測])","v":{"v":0,"d":"NT$0"}}]
[null,"累計總和",{"$f":"C20","v":{"v":270000,"d":"NT$270,000"}},{"$f":"C21+D20","v":{"v":290000,"d":"NT$290,000"}},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"},{"v":310000,"d":"NT$310,000"}]

{"sheet":"每月加權預測","index":2,"n_rows":3,"n_cols":2,"rows_kept":3}
[null,{"$f":"公司_名稱","v":"公司名稱"}]
[null,"每月加權預測"]
[null," "]