公司运营情况可视化看板-表格模板,,,,,,求和项:销售单价求和项:进货成本,879.037.581471.996966.2117,256.09.467934.398631.8266,273.011.344442.136938.8583,258.010.326639.235136.134,187.7675173.0306,线上420.3364,线下441.2963,195.0,128.0,146.0,142.0,152.0,140.0,142.0,122.0,123.0,129.0,115.0,132.0,64.5978,57.6808,69.7315,101.4567,60.6335,80.0854,72.6331,86.5152,70.6109,72.2711,59.7688,65.6479,7.6462,5.1599,6.7077,6.0195,7.0414,5.6288,5.5266,4.8789,5.1214,5.0998,4.5606,5.3295,求和项:进货成本,66.2117459.447337.5814,31.8266125.27479.4679,38.8583143.044611.3444,36.134133.866110.3266,173.0306,WPS Ace237.7892,WPS Deno4 Pro34.191,WPS Dind X2 Pro92.9845,稻果Phone 1163.3696,稻果Phone 11 Pro Max89.99,稻果Phone SE 268.1156,稻果Phone XS Max89.9232,稻米10 Pro48.9168,稻米10青春版38.4468,稻米9 SE(全网通)26.0628,稻米CC9 Pro80.3892,稻为D40 Pro55.9736,稻为Date30 Pro50.1486,稻为dova 7 Pro64.2744,稻为畅享Z21.0574,WPS14.6734,稻果23.314,稻米14.9911,稻为15.7418,列标签,线上211.08463.561677.526668.1642420.3364,线下248.363361.713165.51865.7019441.2963,459.4473125.2747143.0446133.8661,879.0,256.0,273.0,258.0,,姓名(全部)求和项:累计销售量汇总求和项:累计销售额汇总求和项:累计利润汇总,求和项:累计销售量求和项:累计销售额求和项:累计利润,计数项:性别,男,女5.05.0,求和项:年龄,37.037.0,341.0341.0,求和项:工作年限,1.01.0,10.010.0,7.07.0,4.04.0,60.060.0, 年销量目标504.0504.0, 累计销售量,分店(全部),求和项:销量求和项:销售额求和项:利润, 柴进45.021.91481.6028, 戴宗29.016.37621.321, 公孙胜29.016.07991.1176, 关胜15.3971.2012 年销售额目标261.0261.0, 呼延灼13.65991.0788 已实现销售额, 花荣41.015.1531.3665, 解宝15.6221.1502, 李逵52.024.60691.7369, 李应13.39931.0756, 刘唐41.018.46541.4716, 卢俊义15.63081.2724, 鲁智深50.025.96132.0202, 秦明19.99941.6822, 石秀24.014.02511.0272 年利润目标22.422.4, 已实现利润, 索超15.98621.2728, 吴用22.09.64930.858, 武松38.019.78671.5618, 徐宁53.030.16472.3674, 杨雄15.14391.2842, 杨志13.31230.72, 张横15.25071.218, 张清14.04081.147, 张顺44.022.55981.5855,1666.0861.632768.7203,,成交日期5月,值,求和项:进货成本,求和项:利润,求和项:进货成本,0.54210.5421,1.49571.4957,0.62760.6276,0.530.53,分店,线上线下,0.45770.4696,1.657512.1304,求和项:利润,WPS Dind X2 Pro0.11560.1156,稻果Phone 110.160.16,稻果Phone 11 Pro Max0.4240.424,稻米10青春版0.030.03,稻米9 SE(全网通)0.06980.0698,稻为dova 7 Pro0.11640.1164,求和项:销量,照相销量,照相销售额137879.0,照相利润9158.0,,分店,销售人员,多维度报表查询(产品报表),产品类别  销量  销售额  利润  销售成本,WPS357.0166.799914.673432.5427,WPS Ace2108.037.78923.11048.6697,WPS Deno4 Pro90.034.1912.4848.8075,WPS Dind X2 Pro155.092.98458.95914.6367,稻为D40 Pro4.01.83520.120.4288,稻果408.0311.398423.31463.5203,稻果Phone 1192.063.36963.6814.9224,稻果Phone 11 Pro Max100.089.995.319.4787,稻果Phone SE 2102.068.11567.03813.1736,稻果Phone XS Max114.089.92327.29615.9456,稻米467.0193.815614.991136.9861,稻米10 Pro86.048.91682.23613.0272,稻米10青春版84.038.44682.529.4094,稻米9 SE(全网通)111.026.06283.87394.9975,稻米CC9 Pro186.080.38926.36129.552,稻为434.0189.618815.741839.9815,稻为D40 Pro118.054.13843.5412.864,稻为Date30 Pro114.050.14864.569.9975,稻为dova 7 Pro113.064.27444.384412.72,稻为畅享Z89.021.05743.25744.4,分店类别,多维度报表查询(人员报表),门店选项求和项:销量求和项:销售额求和项:进货成本求和项:利润, 柴进45.021.91486.18911.6028, 戴宗29.016.37625.66181.321, 公孙胜29.016.07995.46811.1176, 关胜15.3974.23621.2012, 呼延灼13.65994.46961.0788, 花荣41.015.1533.24851.3665, 解宝15.6225.46811.1502, 解珍46.020.19224.49181.7591, 雷横208.0114.024512.2219.1515, 李俊98.048.35175.6313.8484, 李逵52.024.60695.051.7369, 李应33.013.39934.09541.0756, 林冲25.014.40454.18621.252, 刘唐41.018.46543.74481.4716, 卢俊义15.63084.57191.2724, 鲁智深50.025.96134.69842.0202, 秦明35.019.99945.77511.6822, 阮小二42.017.74293.41991.4276, 阮小七14.06.96911.76970.5714, 阮小五21.09.00273.21480.7608, 石秀24.014.02514.74091.0272, 史进32.016.43144.31711.1393, 索超15.98624.40621.2728, 吴用22.09.64933.31710.858, 武松38.019.78674.99441.5618, 徐宁53.030.16475.66182.3674, 燕青35.016.88825.271.2748, 杨雄25.015.14394.4371.2842, 杨志23.013.31232.79640.72, 张横32.015.25074.36731.218, 张清14.04084.99961.147, 张顺44.022.55984.42121.5855, 朱仝36.020.68855.83181.7416,耗崽322.0174.751615.858414.6549,类别,销售人员,多维度报表查询(门店报表),门店选项门店销量门店销售额门店成本门店利润,门店二879.0459.447366.211737.5814,门店三256.0125.274731.82669.4679,门店四273.0143.044638.858311.3444,门店一258.0133.866136.13410.3266,,稻壳儿手机店销售日志,序号销售人员分店类别商品名称销量销售渠道销售单价销售额进货成本利润成交日期,43832.0,6.25680.426843832.0,43833.0,43834.0,11.02080.6443835.0,43836.0,43837.0,43838.0,43839.0,10.043840.0,6.05080.478843841.0,43842.0,43843.0,43844.0,15.043845.0,43846.0,43847.0,18.05.27880.4843848.0,19.043849.0,20.043850.0,21.043851.0,22.043852.0,23.04.67460.48343853.0,24.04.55040.20843854.0,25.03.203943855.0,26.056.024.20321.915243856.0,27.043857.0,28.043858.0,29.043859.0,30.043860.0,31.043861.0,32.043862.0,33.043863.0,34.043864.0,35.043865.0,36.043866.0,37.043867.0,38.043868.0,39.03.41280.15643869.0,40.043870.0,41.043871.0,42.00.46960.069843872.0,43.043873.0,44.043874.0,45.043875.0,46.043876.0,47.043877.0,48.043878.0,49.043879.0,50.043880.0,51.010.25440.83243881.0,52.043882.0,53.043883.0,54.043884.0,55.043885.0,56.043886.0,57.03.99160.593343887.0,58.03.03920.220843888.0,59.04.19930.404643889.0,60.03.14910.259243890.0,61.043891.0,62.043892.0,63.043893.0,64.022.013.19781.271643894.0,65.043895.0,66.04.49950.26543896.0,67.011.04320.89643897.0,68.043898.0,69.043899.0,70.04.75420.376243900.0,71.043901.0,72.043902.0,73.02.27940.165643903.0,74.043904.0,75.043905.0,76.07.19880.693643906.0,77.043907.0,78.043908.0,79.043909.0,80.043910.0,81.043911.0,82.043912.0,83.043913.0,84.043914.0,85.043915.0,86.043916.0,87.043917.0,88.043918.0,89.043919.0,90.043920.0,91.00.271643921.0,92.03.670443922.0,93.07.47830.6843923.0,94.02.12940.329443924.0,95.043925.0,96.010.79880.63643926.0,97.043927.0,98.043928.0,99.043929.0,100.02.288543930.0,101.06.05080.478843931.0,102.043932.0,103.043933.0,104.043934.0,105.043935.0,106.043936.0,107.09.59840.924843937.0,108.043938.0,109.043939.0,110.043940.0,111.043941.0,112.043942.0,113.043943.0,114.043944.0,115.043945.0,116.043946.0,117.043947.0,118.043948.0,119.043949.0,120.043950.0,121.043951.0,122.043952.0,123.06.15860.5643953.0,124.043954.0,125.04.82160.2843955.0,126.07.19920.42443956.0,127.05.52160.44843957.0,128.019.012.68821.31143958.0,129.043959.0,130.043960.0,131.043961.0,132.00.46960.069843962.0,133.043963.0,134.015.08.99850.86743964.0,135.043965.0,136.043966.0,137.043967.0,138.043968.0,139.05.95010.3943969.0,140.043970.0,141.05.39940.31843971.0,142.043972.0,143.03.3390.34543973.0,144.043974.0,145.043975.0,146.043976.0,147.043977.0,148.043978.0,149.043979.0,150.043980.0,151.043981.0,152.043982.0,153.043983.0,154.043984.0,155.043985.0,156.05.50560.3643986.0,157.043987.0,158.03.3390.34543988.0,159.00.18243989.0,160.03.661643990.0,161.06.29930.37143991.0,162.02.11320.314143992.0,163.043993.0,164.043994.0,165.043995.0,166.043996.0,167.043997.0,168.02.199543998.0,169.043999.0,170.05.61860.444644000.0,171.044001.0,172.044002.0,173.044003.0,174.044004.0,175.02.74620.1844005.0,176.08.39860.809244006.0,177.044007.0,178.044008.0,179.044009.0,180.044010.0,181.044011.0,182.044012.0,183.044013.0,184.044014.0,185.044015.0,186.044016.0,187.07.39440.504444017.0,188.044018.0,189.044019.0,190.044020.0,191.01.72880.136844021.0,192.044022.0,193.02.65930.193244023.0,194.07.19920.42444024.0,195.02.44930.201644025.0,196.05.11920.349244026.0,197.044027.0,198.044028.0,199.044029.0,200.05.18640.410444030.0,201.044031.0,202.044032.0,203.044033.0,204.044034.0,205.044035.0,206.03.84890.316844036.0,207.044037.0,208.044038.0,209.03.59940.346844039.0,210.044040.0,211.00.19444041.0,212.044042.0,213.044043.0,214.044044.0,215.044045.0,216.044046.0,217.044047.0,218.044048.0,219.044049.0,220.044050.0,221.044051.0,222.09.46560.76844052.0,223.01.13970.082844053.0,224.044054.0,225.044055.0,226.044056.0,227.03.211644057.0,228.03.519244058.0,229.01.65620.256244059.0,230.06.19920.3644060.0,231.044061.0,232.044062.0,233.044063.0,234.044064.0,235.044065.0,236.044066.0,237.044067.0,238.01.13970.082844068.0,239.044069.0,240.00.028844070.0,241.044071.0,242.044072.0,243.02.639444073.0,244.044074.0,245.03.44444075.0,246.02.83920.439244076.0,247.044077.0,248.044078.0,249.044079.0,250.044080.0,251.044081.0,252.044082.0,253.044083.0,254.044084.0,255.011.69870.68944085.0,256.044086.0,257.044087.0,258.044088.0,259.044089.0,260.03.44444090.0,261.03.02540.239444091.0,262.06.31040.51244092.0,263.04.67460.48344093.0,264.05.11920.23444094.0,265.044095.0,266.044096.0,267.044097.0,268.044098.0,269.044099.0,270.044100.0,271.044101.0,272.044102.0,273.044103.0,274.00.036644104.0,275.044105.0,276.044106.0,277.02.75280.1844107.0,278.044108.0,279.00.1344109.0,280.044110.0,281.00.034244111.0,282.044112.0,283.044113.0,284.07.34580.75944114.0,285.044115.0,286.044116.0,287.044117.0,288.02.27940.165644118.0,289.044119.0,290.044120.0,291.02.69970.15944121.0,292.044122.0,293.044123.0,294.00.1344124.0,295.03.203944125.0,296.03.45760.273644126.0,297.01.64360.244344127.0,298.03.41910.248444128.0,299.044129.0,300.044130.0,301.044131.0,302.044132.0,303.044133.0,304.044134.0,305.044135.0,306.044136.0,307.044137.0,308.00.06944138.0,309.044139.0,310.044140.0,311.02.59320.205244141.0,312.044142.0,313.01.899544143.0,314.044144.0,315.00.028844145.0,316.044146.0,317.044147.0,318.044148.0,319.044149.0,320.044150.0,321.044151.0,322.06.59890.635844152.0,323.044153.0,324.044154.0,325.044155.0,326.044156.0,327.044157.0,328.01.899544158.0,329.04.19930.404644159.0,330.02.79920.230444160.0,331.00.271644161.0,332.04.12920.2744162.0,333.044163.0,334.044164.0,335.044165.0,336.044166.0,337.044167.0,338.044168.0,339.044169.0,340.044170.0,341.09.46560.76844171.0,342.044172.0,343.07.39440.504444173.0,344.044174.0,345.02.09940.172844175.0,346.044176.0,347.044177.0,348.044178.0,349.02.58280.383944179.0,350.044180.0,351.044181.0,352.044182.0,353.044183.0,354.044184.0,355.044185.0,356.00.034244186.0,357.044187.0,358.044188.0,359.044189.0,360.044190.0,361.044191.0,362.044192.0,363.03.211644193.0,364.03.519244194.0,365.00.036644195.0,366.02.69970.15944195.0, ,,公司员工信息维护表,序号姓名性别身份证号码年龄入职时间所属门店工作年限年销量目标年销售额目标年利润目标累计销售量累计销售额累计利润性别选项门店选项销售渠道, 卢俊义39449.017.015.63081.2724线上, 林冲340123198304020129837.039815.01.714.40451.252线下, 柴进40180.045.01.645.021.91481.6028, 武松1.738.019.78671.5618, 索超340123199704020129815.98621.2728, 史进340123199704020129816.43141.1393, 张横15.25071.218, 杨雄340123199904020129842006.0136.015.14391.2842, 燕青340123198804020129842371.016.88821.2748, 吴用340123198704020129888.09.64930.858, 秦明19.99941.6822, 李应34012319790402012981.4413.39931.0756,13.0 张清340123196004020129843832.00.014.04081.147, 戴宗340123196904020129851.039449.016.37621.321, 雷横340123198504020129839815.044.019.01.4208.0114.02459.1515, 阮小五340123198404020129840180.09.00270.7608,17.0 石秀24.014.02511.0272, 公孙胜34012319910402012981.116.07991.1176,19.0 呼延灼340123199204020129813.65991.0788, 朱仝340123199304020129820.68851.7416, 杨志42006.043.013.31230.72, 刘唐340123199404020129842371.043.018.46541.4716, 李俊340123199504020129888.03.698.048.35173.8484,24.0 张顺340123198804020129844.022.55981.5855, 解珍340123198704020129899.04.546.020.19221.7591, 关胜340123198604020129843832.00.02.415.3971.2012, 花荣3401231985040201298150.015.1531.3665, 鲁智深340123198404020129825.96132.0202, 徐宁340123198304020129837.054.02.453.030.16472.3674, 李逵340123197904020129852.024.60691.7369, 阮小二47.01.917.74291.4276, 阮小七1.46.96910.5714, 解宝15.6221.1502,耗崽23819819891878981751.6322.0174.751614.6549,,在售商品信息维护表,品牌型号单价进价品牌对应型号,稻为dova 7 Pro5688.05300.0稻为dova 7 Pro稻果Phone 11稻米10 ProWPS Deno4 Pro,4588.04288.0稻米10青春版WPS Dind X2 Pro,稻为Date30 Pro4399.03999.0稻为Date30 Pro稻果Phone XS Max,稻为畅享Z2366.02000.0稻为畅享Z稻果Phone SE 2稻米9 SE(全网通),稻果Phone 116888.06488.0,8999.08469.0,稻果Phone XS Max7888.07248.0,稻果Phone SE 26678.05988.0,稻米10 Pro5688.05428.0,稻米10青春版4577.04277.0,4322.03980.0,稻米9 SE(全网通)2348.01999.0,WPS Deno4 Pro3799.03523.0,WPS Dind X2 Pro5999.05421.0,3499.03211.0,,                             看板使用说明,1.关于数据刷新,【日常销售数据记录】表中某个数据发生修改后,请在看板页随便选中一个图表,WPS用户请在上方的菜单栏中选择【分析】-【刷新】-【全部刷新】,微软用户 请选择【数据透视图工具】-【分析】-【全部刷新】后,所有看板都会更新。,2.关于新增员工,首先直接在【员工维护】表格中【门店选项】卡中按照顺序依次向下新增门店5,6,7,。。。。新增后就可以在表格中录入员工名称了。,注意:已有的门店名称请不要删除,直接修改覆盖即可。,3.关于商品维护,如需新增品牌名称,请在【商品维护】表格中【品牌】选项【WPS】下方依次录入新的品牌名,新的品牌名录入完成后,请在表格绿色区域新增品牌商品列表,并修改表名称为刚刚新增的品牌名称。并套用一下系统自带的表格样式。注意:已有的商品信息请不要删除,直接修改覆盖即可。,WPS用户请在【表格工具】-【表名称】中修改表名称,举个例子:新增一个品牌【稻壳儿】,所有步骤完成后就可以新增商品信息了。,推荐使用WPS最新版编辑,微软用户请使用OFFICE2010及以上版本进行编辑,稻壳儿平台:耗崽原创设计  2020年8月
公司运营情况可视化看板-表格模板
公司运营情况可视化看板-表格模板
公司运营情况可视化看板-表格模板
公司运营情况可视化看板-表格模板
    版权声明: 1. 本站为纯属学习资源分享站点 ,资源均来源于网络搜集经整理而成, 仅限个人测试学习之用, 版权归原作者及开发商所有,请勿用作商业用途。如果喜欢,请支持正版,谢谢。2.本站资源下载地址均为网盘链接或外链,本站的主机服务器不储存任何可供下载 资源 , 不确保所有网盘下载链接或外链资源的安全性、可用性, 对用户下载及使用过程中造成的损失由下载使用者自负 ,本站不对任何网络资源负法律责任。3.因时间与精力有限,对网络来源的资源未能做到一一确认版权权属,若无意中侵犯到您的版权利益,请来信联系我们,我们会在收到版权权属信息后三个工作日内核实并进行立即删除处理。4.本站所有文章资源,未经允许,禁止转发,谢谢合作。5.联系方式:pla73121@qq.com