{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["直通车","钻展","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"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":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,3,5,15]]}
[]
[]
[]
[]
[]
[null,null,null,"直通车费用计算表"]
[]
[null,null,null,"日销售目标"]
[{"$nulls":4},"日订单数",30]
[{"$nulls":4},"目标UV",300]
[{"$nulls":4},"直通车UV",{"$f":"F10-150","v":150}]
[{"$nulls":4},"直通车目标销售额",{"$f":"L19*H19","v":2600}]
[{"$nulls":4},"点击数",{"$f":"F19","v":400}]
[{"$nulls":4},"点击率",{"$f":"N19","v":0.4}]
[{"$nulls":4},"展现数",{"$f":"O19","v":1000}]
[{"$nulls":4},"最高点击单价",{"$f":"G19","v":1.95}]
[]
[{"$nulls":4},"点击转化率","点击数","最高点击单价","客单价","目标销售额","毛利率","利润","订单数","UV成本","点击率","展现数"]
[{"$nulls":4},0.05,{"$f":"L19/E19","v":400},{"$f":"K19/F19","v":1.95},130,{"$f":"L19*H19","v":2600},0.3,{"$f":"I19*J19","v":780},{"$f":"F9-10","v":20},{"$f":"G19*F19/F11","v":5.2},0.4,{"$f":"F19/N19","v":1000}]
[]
[null,null,null,"备注：上表中，日订单数、点击转化率、客单价、毛利率、目标uv、现有日单数、现有UV、点击率需手动填写。"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},"直通车费用（以1元点击单价计）",null,{"$f":"1*F19","v":400}]
[{"$nulls":4},"销售利润",null,{"$f":"K19","v":780}]
[{"$nulls":4},"减去直通车费用之后的利润",null,{"$f":"G29-G28","v":380}]
[{"$nulls":4},"销售额/直通车费用",null,{"$f":"I19/G28","v":6.5}]
[{"$nulls":4},"销售利润/直通车费用",null,{"$f":"G29/G28","v":1.95}]
[{"$nulls":4},"减去直通车费用之后的利润/直通车费用",null,{"$f":"G30/G28","v":0.95}]

{"sheet":"钻展","index":1,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,3,5,17]]}
[]
[]
[]
[]
[]
[null,null,null,"钻展费用计算表"]
[]
[null,null,null,"日销售目标"]
[{"$nulls":4},"日订单数",{"$nulls":4},{"$f":"L20+10","v":240.76923076923077}]
[{"$nulls":4},"CPM目标销售额",{"$nulls":4},30000]
[{"$nulls":4},"引入UV"]
[{"$nulls":4},"单位UV费用"]
[{"$nulls":4},"点击数",{"$nulls":4},{"$f":"J20","v":11538.461538461539}]
[{"$nulls":4},"点击率",{"$nulls":4},{"$f":"I20","v":0.03}]
[{"$nulls":4},"展现数",{"$nulls":4},{"$f":"E20","v":384615.38461538462}]
[{"$nulls":4},"CPM数",{"$nulls":4},{"$f":"E20/1000","v":384.61538461538464}]
[{"$nulls":4},"最高每CPM出价",{"$nulls":4},{"$f":"H20","v":23.4}]
[]
[{"$nulls":4},"展现数","CPM数","位置","每CPM最高费用","点击率","点击数","转化率","钻展订单数","客单价","销售额","平均毛利率","利润"]
[{"$nulls":4},{"$f":"J20/I20","v":384615.38461538462},{"$f":"E20/1000","v":384.61538461538464},null,{"$f":"P20/F20","v":23.4},0.03,{"$f":"L20/K20","v":11538.461538461539},0.02,{"$f":"N20/M20","v":230.76923076923077},130,{"$f":"J10","v":30000},0.3,{"$f":"N20*O20","v":9000}]
[]
[null,null,null,"备注：上表中，CPM目标销售额、转化率、客单价、平均毛利率、现有日单数、引入UV、点击率需手动填写。"]
[]
[]
[]
[{"$nulls":4},"CPM费用（以1元CPM出价计）",null,null,{"$f":"1*F20","v":384.61538461538464}]
[{"$nulls":4},"销售利润",null,null,{"$f":"P20","v":9000}]
[{"$nulls":4},"减去CPM费用之后的利润",null,null,{"$f":"H27-H26","v":8615.3846153846152}]
[{"$nulls":4},"销售额/CPM费用",null,null,{"$f":"N20/H26","v":78}]
[{"$nulls":4},"销售利润/CPM费用",null,null,{"$f":"H27/H26","v":23.4}]
[{"$nulls":4},"减去CPM费用之后的利润/CPM费用",null,null,{"$f":"H28/H26","v":22.4}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}