2024excel函数公式大全统计表格
2025年销售业绩数据统计表(自动计算) - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 销售数据统计表工号100110021003100410051006100710081009101010111012合计Unnamed: 3 姓名段飞小宝小白小黑小黄小亮小鹿小陈小周小小小明小静Unnamed: 4 目标10001000100010001000100010001000100020002000200015000Unnamed: 5 完成5006008009006007505608009806002000180010890Unnamed: 6 完成率0.50.6
2025年销售业绩月统计表(自动计算) - Sheet1 Unnamed: 0 Unnamed: 1 销售业绩月统计表(自动计算)日期 姓名合计:2019-01-01 00:00:002019-01-02 00:00:002019-01-03 00:00:002019-01-04 00:00:002019-01-05 00:00:002019-01-06 00:00:002019-01-07 00:00:002019-01-08 00:00:002019-01-09 00:00:002019-01-10 00:00:002019-01-11 00:00:002019-01-12 00:00:002019-01-13 00:00:002019-01-14 00:00:002019-01-15 00:00:002019-01-16 00:00:002019-01-17 00:00:002019-01-18 00:00:002019-01-19 00:00:002019-01-20 00:00:002019-01-21 00:00:002019-01-22 00:00:002019-01-23
2025年仓库出入库统计表-自动计算 - Sheet1 Unnamed: 0 仓库出入货统计表( 5月份) 序号冷冻品类1234567891011121314151617181920212223242526272829Unnamed: 2 产品名称产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一产品一Unnamed: 3 规格Unnamed: 4 单位件件件件......
2025年员工绩效奖罚统计表-自动计算 - Sheet1 Unnamed: 0 员工绩效奖罚统计表-自动计算 所在部门: 场地: 填表日期: 年 月 日时间考勤员: 部门负责人: 人事专员: 人事主管: 人事经理:Unnamed: 2 员工姓名Unnamed: 3 奖罚事由Unnamed: 4 奖罚依据Unnamed: 5 绩效奖金(元)Unnamed: 6 奖励金额(元)Unnamed: 7 处罚金额 (元)Unnamed: 8 累计金额0000000000000000Unnamed: 9 签名Unnamed: 10 备注
2025年考勤天数统计表-自动计算 - 考勤统计表 Unnamed: 0 考勤天数统计表-自动计算 考勤单位:员工姓名 考勤单位负责人(签字):Unnamed: 2 本月 应 出勤天数27272727272727272727272727272727Unnamed: 3 年 月 日本月实际 出勤天数26252525252527272727272727272727Unnamed: 4 本月缺勤 天 数2442220010020100Unnamed: 5 备 注Unnamed: 6 事假1211Unnamed: 7 病假022统计人员(签字):Unnamed: 8 迟到早退0Unnamed: 9 应扣金额Unnamed: 10 备 注
2025年短期工统计表-自动计算 - 短期工统计 Unnamed: 0 Unnamed: 1 短期工统计序号12345678910Unnamed: 2 部门生产部销售部品质部Unnamed: 3 分配人力523Unnamed: 4 短期工人力322Unnamed: 5 占比0.610.666666666666667Unnamed: 6 月度离职人数统计1000Unnamed: 7 2.00.00.00.0Unnamed: 8 3.00.00.00.0Unnamed: 9 4.03.02.02.0Unnamed: 10 5.00.00.00.0Unnamed: 11 6.00.00.00.0Unnamed: 12 7.00.00.00.0Unnamed: 13 8.00.00.00.0Unnamed: 14 9.00.00.00.0Unnamed: 15 10.00.00.00.0Unnamed: 16 11.00.00.00.0Unnamed: 17 12.00.00.00.0人员基本信息 Unnamed: 0 Unnamed:
2025年节日招待费用统计表-自动计算 - Sheet1 Unnamed: 0 节日招待费用统计表-自动计算 统计:序号1234567891011121314合 计:Unnamed: 2 住宿费用时间2020-08-20 00:00:002020-08-21 00:00:002020-08-22 00:00:002020-08-23 00:00:002020-08-24 00:00:002020-08-25 00:00:002020-08-26 00:00:002020-08-27 00:00:002020-08-28 00:00:002020-08-29 00:00:002020-08-30 00:00:002020-08-31 00:00:002020-09-01 00:00:002020-09-02 00:00:00Unnamed: 3 5000项目名称或部门行政接待部工程接待Unnamed: 4 交通费用姓名或职务李建军(行政总监)李减减(工程总监)Unnamed: 5 700住宿费
2025年公司辞退人员统计表-自动计算 - Sheet1 Unnamed: 0 公司辞退人员统计表 序号1234Unnamed: 2 姓名张三张思佳王亮Unnamed: 3 部门生产部生产部生产部Unnamed: 4 入职日期2017-08-06 00:00:002018-02-05 00:00:002013-06-07 00:00:00Unnamed: 5 入职年数226----------------Unnamed: 6 入职月数9311----------------Unnamed: 7 应赔偿月数438----------------2024excel函数公式大全统计表格
2025年进货统计表(自动计算) - Sheet1 Unnamed: 0 Unnamed: 1 进货单/统计表序号123456789101112131415161718192021222324252627282930Unnamed: 2 类别Unnamed: 3 名称Unnamed: 4 规格Unnamed: 5 供应商Unnamed: 6 供应商地址Unnamed: 7 单价Unnamed: 8 数量Unnamed: 9 金额000000000000000000000000000000Unnamed: 10 备注Sheet2 Sheet3
2025年销售数据统计表(自动计算) - Sheet1 销售登记表-数据统计表 所属日期:序号12345678910111213141516171819202122合计Unnamed: 1 物资编号Unnamed: 2 物资名称Unnamed: 3 规格型号Unnamed: 4 单位Unnamed: 5 应收数量0Unnamed: 6 实收数量0Unnamed: 7 发票单价0Unnamed: 8 发票金额0Unnamed: 9 物资税额0Unnamed: 10 运杂费0Unnamed: 11 运杂费税额0Unnamed: 12 总税额0Unnamed: 13 含税总金额0Unnamed: 14 业务员Unnamed: 15 备注Sheet2 Sheet3
2025年个人理财支出统计表—自动计算 - Sheet1 个人理财支出统计表 项目明细每日明细123456789101112131415161718192021222324252627282930合计备注Unnamed: 1 五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六Unnamed: 2 衣0Unnamed: 3 食0Unnamed: 4 住0Unnamed: 5 行0Unnamed: 6 学习0Unnamed: 7 娱乐0Unnamed: 8 保险0Unnamed: 9 医疗0Unnamed: 10 投资0Unnamed: 11 借贷0Unnamed: 12 公关交际0Unnamed: 13 税金0Unnamed: 14 杂费0Unnamed: 15 其它0Sheet2 Sheet3
2025年出入库统计表—自动计算 - Sheet1 出入库统计表—自动计算 单位: 盘点时间:序号12345678910111213141516171819202122232425库存合计Unnamed: 1 物品名称Unnamed: 2 编号Unnamed: 3 规格Unnamed: 4 单位Unnamed: 5 单价Unnamed: 6 原始库存500000000000000000000000000500Unnamed: 7 出库数量200000000000000000000000000200Unnamed: 8 入库数量1001001001001001001001001001001001001001001001001001001001001001001001001002500Unnamed: 9 结余库存4001
2025年仓库进出库统计表-自动计算 - Sheet1 Unnamed: 0 年 月 进出库明细表 序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139Unnamed: 2 产品 系列合计Unnamed: 3 产品名称......
2025年仓库库存统计表(自动计算、库存预警) - 物控订货点计算表单 Unnamed: 0 物控订货点计算表单 序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146
2025年商品库存统计表,自动计算 - Sheet1 商品库存统计表 序号1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253Unnamed: 1 品名Unnamed: 2 编号Unnamed: 3 分类Unnamed: 4 规格Unnamed: 5 单位Unnamed: 6 上月结存Unnamed: 7 入库合计Unnamed: 8 出库合计Unnamed: 9 本月结存00000000000000000000000000000000000000000000000000000Unnamed: 10 备注Sheet2 Sheet32024excel函数公式大全统计表格
2025年进销存管理-出入库统计表(自动计算) - 代码表 序号 1.02.03.04.05.06.07.08.09.010.011.012.013.014.015.016.017.018.019.020.021.022.023.024.025.026.027.028.029.030.031.032.033.034.035.036.037.038.039.040.041.042.043.044.045.046.047.048.049.050.051.052.053.054.055.056.057.058.059.060.061.062.063.064.065.066.067.068.069.070.071.072.073.074.075.076.077.078.079.080.081.082.083.084.085.086.087.088.089.090.091.092.093.094.095.096.097.098.099.0100.0101.0102.0103.0104.0105.0106.0107.0代码 100001.0100002.0100003.0100011.0100012.0100013.0100021.0
2025年销售统计表(自动计算) - Sheet1 统计表-销售统计表 采购项目冷链物流合计Unnamed: 1 序号1Unnamed: 2 采购次数5Unnamed: 3 项目预算预算资金5000050000Unnamed: 4 自筹资金1000010000Unnamed: 5 合计6000000000000000000000000000000060000Unnamed: 6 合同价Unnamed: 7 实际支付价预算资金0Unnamed: 8 自筹资金0Unnamed: 9 合计00000000000000000000000000000Unnamed: 10 节约资金预算资金0Unnamed: 11 自筹资金0Unnamed: 12 合计00000000000000000000000000000Unnamed: 13 备注
2025年出入库统计表-自动计算 - Sheet1 Unnamed: 0 出入库表-自动计算 序号123456789101112131415161718Unnamed: 2 物资名称Unnamed: 3 规格/型号Unnamed: 4 单位Unnamed: 5 入库情况入库时间Unnamed: 6 入库数量Unnamed: 7 出库情况出库时间Unnamed: 8 出库数量Unnamed: 9 剩余库存00000000000000000Unnamed: 10 备注Sheet2 Sheet3
2025年费用支出申报统计表(自动计算) - Sheet1 Unnamed: 0 Unnamed: 1 费 用 支 出 申 报 统 计 表今天是:序号12345678910111213141516171819202122232425 制表人: 审核人:Unnamed: 2 日 期Unnamed: 3 2018-04-23 00:00:00支出类别Unnamed: 4 内 容 描 述温馨提示:为保证格式及公式的完整可行,请您扩展时选择插入行或列Unnamed: 5 支出总计:费用金额Unnamed: 6 0申报部门Unnamed: 7 申报人Unnamed: 8 经办人Unnamed: 9 备注说明