{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["潜在顾客数据","预测销售额 ","每月加权预测"],"not_rendered":{"charts":1,"images":2,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"潜在顾客数据","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[2,1,2,2],[3,4,3,8]]}
[]
[]
[null,"详细的潜在顾客跟踪表"]
[null,{"$f":"TODAY()","v":"2022-06-23"}]
[null,"公司名称\t\t\t\t\t\t\t\t\t\t",{"$nulls":7},"机密"]
[null,"潜在顾客名称","潜在顾客联系信息","潜在顾客\n来源","潜在顾客\n地区","潜在顾客\n类型","潜在商机","销售机会","预测结算","加权预测"]
[null,"Adatum Corporation",null,"网站","北部","战略性",{"v":300000,"d":"¥300,000.00"},{"v":0.9,"d":"¥1"},"1 月",{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[销售机会]]<>\"\",潜在顾客数据[[#This Row],[销售机会]]*潜在顾客数据[[#This Row],[潜在商机]],\"\"),\"\")","v":{"v":270000,"d":"¥270,000.00"}}]
[null,"Adventure Works",null,"社交活动","南部","战略性",{"v":200000,"d":"¥200,000.00"},{"v":0.1,"d":"¥0"},"2 月",{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[销售机会]]<>\"\",潜在顾客数据[[#This Row],[销售机会]]*潜在顾客数据[[#This Row],[潜在商机]],\"\"),\"\")","v":{"v":20000,"d":"¥20,000.00"}}]
[null,"Alpine Ski House",null,"社交活动","北部","战术性",{"v":100000,"d":"¥100,000.00"},{"v":0.2,"d":"¥0"},"3 月",{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[销售机会]]<>\"\",潜在顾客数据[[#This Row],[销售机会]]*潜在顾客数据[[#This Row],[潜在商机]],\"\"),\"\")","v":{"v":20000,"d":"¥20,000.00"}}]
[null,"汇总",{"$nulls":4},{"$f":"SUBTOTAL(109,潜在顾客数据[潜在商机])","v":{"v":600000,"d":"¥600,000.00"}},null,null,{"$f":"SUBTOTAL(109,潜在顾客数据[加权预测])","v":{"v":310000,"d":"¥310,000.00"}}]

{"sheet":"预测销售额 ","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,5,0,9],[2,1,2,2],[4,12,4,13]]}
[]
[]
[null,"预测销售额"]
[null,{"$f":"TrackerDate","v":"2022-06-23"}]
[null,{"$f":"潜在顾客数据!B5:I5","v":"公司名称\t\t\t\t\t\t\t\t\t\t"},{"$nulls":10},"机密"]
[null,"潜在顾客名称","1 月\n预测","2 月\n预测","3 月\n预测","4 月\n预测","5 月\n预测","6 月\n预测","7 月\n预测","8 月\n预测","9 月\n预测","10 月\n预测","11 月\n预测","12 月\n预测"]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":"Adatum Corporation"},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":270000,"d":"¥270,000"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}}]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":"Adventure Works"},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":20000,"d":"¥20,000"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}}]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":"Alpine Ski House"},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":20000,"d":"¥20,000"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":{"v":0,"d":"¥0"}}]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(AND(潜在顾客数据[[#This Row],[潜在顾客名称]] <> \"\", ROW(预测销售额[潜在顾客名称])<>LastEntry),潜在顾客数据[潜在顾客名称], \"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"1 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"2 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"3 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"4 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"5 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"6 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"7 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"8 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"9 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"10 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"11 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(潜在顾客数据[[#This Row],[预测结算]] <>\"\",IF(潜在顾客数据[[#This Row],[预测结算]]= \"12 月\",潜在顾客数据[加权预测],0),\"\"),\"\")","v":""}]
[null,"汇总",{"$f":"SUBTOTAL(109,预测销售额[1 月\n预测])","v":{"v":270000,"d":"¥270,000"}},{"$f":"SUBTOTAL(109,预测销售额[2 月\n预测])","v":{"v":20000,"d":"¥20,000"}},{"$f":"SUBTOTAL(109,预测销售额[3 月\n预测])","v":{"v":20000,"d":"¥20,000"}},{"$f":"SUBTOTAL(109,预测销售额[4 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[5 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[6 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[7 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[8 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[9 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[10 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[11 月\n预测])","v":{"v":0,"d":"¥0"}},{"$f":"SUBTOTAL(109,预测销售额[12 月\n预测])","v":{"v":0,"d":"¥0"}}]
[null,"累积总收入",{"$f":"C14","v":{"v":270000,"d":"¥270,000"}},{"$f":"C15+D14","v":{"v":290000,"d":"¥290,000"}},{"$f":"D15+E14","v":{"v":310000,"d":"¥310,000"}},{"$f":"E15+F14","v":{"v":310000,"d":"¥310,000"}},{"$f":"F15+G14","v":{"v":310000,"d":"¥310,000"}},{"$f":"G15+H14","v":{"v":310000,"d":"¥310,000"}},{"$f":"H15+I14","v":{"v":310000,"d":"¥310,000"}},{"$f":"I15+J14","v":{"v":310000,"d":"¥310,000"}},{"$f":"J15+K14","v":{"v":310000,"d":"¥310,000"}},{"$f":"K15+L14","v":{"v":310000,"d":"¥310,000"}},{"$f":"L15+M14","v":{"v":310000,"d":"¥310,000"}},{"$f":"M15+N14","v":{"v":310000,"d":"¥310,000"}}]

{"sheet":"每月加权预测","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"merged":[[0,5,0,9]]}
[]
[]
[null,"每月加权预测"]