2025国庆业绩指标追踪-公式汇总

2025年客户回款登记表-单数汇总 - Sheet1 Unnamed: 0 Unnamed: 1 客户回款登记表-单数汇总总合同金额序号123456789101112Unnamed: 2 49420入账日期2020-12-01 00:00:002020-12-02 00:00:002020-12-03 00:00:002020-12-04 00:00:002020-12-05 00:00:002020-12-06 00:00:002020-11-07 00:00:002020-11-08 00:00:002020-11-09 00:00:002020-11-10 00:00:002020-11-11 00:00:002020-11-12 00:00:00Unnamed: 3 待还款单数合同金额560045003500560045003500560045003500220018904530Unnamed: 4 7客户名称KH1KH2KH3KH4KH5KH6KH1KH2KH3KH4KH5KH6Unnamed: 5 已还款单数收款方式FZ1FZ

2025年销售明细统计表-查询-汇总 - Sheet1 Unnamed: 0 Unnamed: 1 账单查询序号678111314161718192021222324Unnamed: 2 开始时间结束时间账单 日期2019-04-09 00:00:002019-04-09 00:00:002019-04-09 00:00:002019-04-09 00:00:002019-04-12 00:00:002019-04-12 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:002019-04-15 00:00:00销售明细统计表-查询-汇总 2019-04-01 00:00:002019-04-15 00:00:00账单编号HZ190409005HZ190409006HZ190409007HZ19040

2025年财务收支明细表-智能汇总 - Sheet1 Unnamed: 0 财务收支明细表 序号123456Unnamed: 2 日期2019-01-04 00:00:002019-01-09 00:00:002019-01-13 00:00:002019-02-04 00:00:002019-05-01 00:00:002019-05-04 00:00:00Unnamed: 3 摘要投资收益付材料费用付税金费用收工程款买生活用品还款Unnamed: 4 Unnamed: 5 对方科目投资收益工程施工应交税费工程结算工程施工其他应收款Unnamed: 6 收入200050003000Unnamed: 7 支出240300300Unnamed: 8 余额200017601460646061609160Unnamed: 9 备注Unnamed: 10 项目明细期初金额8000收入汇总10000支出汇总840余额汇总17160

2025年采购申请记录表自动汇总数据 - Sheet1 日期 2019-07-01 00:00:002019-07-02 00:00:002017-07-03 00:00:002019-07-04 00:00:00合计采购记录 土豆14白菜8元牛肉(凉拌)31元土豆14白菜8元牛肉(凉拌)32元土豆14白菜8元牛肉(凉拌)33元B级火锅调料33元鱼55元250备注 1.02.03.04.0

2025年收入支出明细表-月度汇总 - 月度汇总 Unnamed: 0 Unnamed: 1 收入支出月度汇总 月份 项目收入金额支出金额支出占比Unnamed: 2 1.01000.0820.00.82Unnamed: 3 2.01340.0900.00.6716417910447762Unnamed: 4 3.01200.0910.00.7583333333333333Unnamed: 5 4.02100.01480.00.7047619047619048Unnamed: 6 5.01840.01320.00.717391304347826Unnamed: 7 6.01500.01080.00.72Unnamed: 8 7.01890.01450.00.7671957671957672Unnamed: 9 8.02540.02100.00.8267716535433071Unnamed: 10 9.01820.01440.00.7912087912087912Unnamed: 11 10.02450.01900.00.7755102040816326

2025年工资表-年度全年工资汇总表 - 使用说明 Unnamed: 0 使用说明 1、本表为可以长期使用，无需更换。2、不需要填写的地方已经用灰色标示出来。3、【总工资表】只需要在B列手动输入员工姓名，即可自动汇总出员工全年工资情况。4、【1月】至中【12月】，12张月份工资表，上方设置了快捷点击其他工作表条形框，表头设置了自动计算，辞职人数需要手动填写即可。5、建议使用本工资系统的时候，先把单位工资表整理好再填写至每个对应的月份，尽量不要修改本表的样式，否则会破坏部分公式。6、需要其他作品，可直接在此进入店铺，寻找更多的工资模板。总工资表 Unnamed: 0 Unnamed: 1 工资表-年度全年工资汇总表

2025年财务收支记账表-分类汇总 - Sheet1 Unnamed: 0 Unnamed: 1 财务收入支出日记账-分类汇总收入明细表日期2021-01-01 00:00:002021-01-05 00:00:002021-01-09 00:00:002021-02-01 00:00:002021-02-06 00:00:002021-02-12 00:00:002021-03-12 00:00:002021-04-13 00:00:002021-05-16 00:00:002021-05-17 00:00:002021-06-14 00:00:002021-07-01 00:00:002021-08-16 00:00:002021-09-15 00:00:002021-10-19 00:00:002021-11-06 00:00:002021-12-17 00:00:002021-07-01 00:00:002021-07-02 00:00:002021-07-03 00:00:002021-07-04 00:00:002021-07-05 00:00:002021-07-06 0

2025年家庭记账收支表-每日汇总 - Sheet1 (2) Unnamed: 0 Unnamed: 1 Unnamed: 2 家庭记账收支表日 统 计每日统计日期2021-01-01 00:00:002021-01-02 00:00:002021-01-03 00:00:002021-01-04 00:00:002021-01-05 00:00:002021-01-06 00:00:002021-01-07 00:00:002021-01-08 00:00:002021-01-09 00:00:002021-01-10 00:00:002021-01-11 00:00:002021-01-12 00:00:002021-01-13 00:00:002021-01-14 00:00:002021-01-15 00:00:002021-01-16 00:00:002021-01-17 00:00:002021-01-18 00:00:002021-01-19 00:00:002021-01-20 00:00:002021-01-21 00:00:002021-01-22 00:00:0020212025国庆业绩指标追踪-公式汇总

2025年年度收支明细表-每月汇总 - Sheet1 Unnamed: 0 Unnamed: 1 万年日历表2021-01-11 08:55:29日2021-01-03 00:00:002021-01-10 00:00:002021-01-17 00:00:002021-01-24 00:00:002021-01-31 00:00:00万年日历表2021-02-10 08:55:29日2021-02-07 00:00:002021-02-14 00:00:002021-02-21 00:00:002021-02-28 00:00:00Unnamed: 2 一2021-01-04 00:00:002021-01-11 00:00:002021-01-18 00:00:002021-01-25 00:00:00一2021-02-01 00:00:002021-02-08 00:00:002021-02-15 00:00:002021-02-22 00:00:00Unnamed: 3 二2021-01-05 00:00:002021-01-12 00:00:002021-01-19 00:00:002

2025年现金收支明细表-每月汇总 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 月 份1月2月3月4月5月6月7月8月9月10月11月12月合计Unnamed: 3 收 入20091002100310042012100010011002100310041005100614051Unnamed: 4 支 出100950250350410125005015025035045055067051Unnamed: 5 结 余100050050050010005005005005005005005007000Unnamed: 6 Unnamed: 7 现金收支明细表日 期2020-01-03 00:00:002020-02-04 00:00:002020-03-01 00:00:002020-04-01 00:00:002020-05-03 00:00:002020-06-04 00:00:002020-07-06 00:00:002020-08-07 00:00:002020-09-08 00:00:002020-10-10

2025年家庭收支记账表-自动汇总查询 - 家庭收支记账表 Unnamed: 0 Unnamed: 1 Unnamed: 2 家庭收支记账表序号123456Unnamed: 3 日期2021-01-01 00:00:002021-01-02 00:00:002021-01-03 00:00:002021-01-04 00:00:002021-01-05 00:00:002021-01-06 00:00:00Unnamed: 4 收入收入项目工资收入二手售卖红包Unnamed: 5 摘要二手手机售卖微信红包Unnamed: 6 金额20000800100Unnamed: 7 Unnamed: 8 日期查询 DATE账户查询 ACCOUNT支出支出项目生活购物娱乐零食Unnamed: 9 日期（起）：日期（止）：查询账户：收:摘要衣服KTV消费Unnamed: 10 2021-01-01 00:00:002021-01-04 00:00:00微信100金

2025年电商收支明细表-查询汇总分析 - 淘宝明细表 Unnamed: 0 Unnamed: 1 查询汇总-图表分析销售总额平台电商收支明细表日期2020-12-01 00:00:002020-12-02 00:00:002020-12-03 00:00:002020-12-04 00:00:002020-12-05 00:00:002020-12-06 00:00:002020-12-07 00:00:002020-12-08 00:00:002020-12-09 00:00:00Unnamed: 2 1089淘宝平台淘宝京东唯品会拼多多淘宝京东唯品会拼多多淘宝Unnamed: 3 535京东商品名称化妆品衣服鞋子包包代理面膜鞋子衣服化妆品Unnamed: 4 728唯品会数量214111131Unnamed: 5 1031拼多多单价20360585125325112532352562Unnamed: 6 销售总额4066053401253

2025年财务收支日记账-分类汇总 - Sheet1 Unnamed: 0 Unnamed: 1 收入支出明细表日期2020-12-01 00:00:002020-12-02 00:00:002020-12-03 00:00:002020-12-04 00:00:002020-12-05 00:00:002020-12-06 00:00:002020-12-07 00:00:002020-12-08 00:00:002020-12-09 00:00:002020-12-10 00:00:002020-12-11 00:00:002020-12-12 00:00:002020-12-13 00:00:002020-12-14 00:00:002020-12-15 00:00:002020-12-16 00:00:00Unnamed: 2 摘要xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxUnname

2025年财务收支日记账-按月汇总 - 汇总查询表 Unnamed: 0 Unnamed: 1 收入支出汇总表月份收入金额支出金额账户名称支付宝微信现金中行1254招行3698建行3489交行8908合计金额Unnamed: 2 1月40002800期初余额150024003000450045003600150021000Unnamed: 3 2月59003300收入金额9000132001350092002210011700260000081300Unnamed: 4 3月59002600支出金额1900113002000970011001200060000038600Unnamed: 5 4月84003000结余金额86004300145004000255003300350063700Unnamed: 6 5月87004700Unnamed: 7 6月73002000Unnamed: 8 7月80004600Unnamed: 9 8月68004300Unnamed: 10 9月570

2025年日历收支记账表-按天汇总 - 一月 Unnamed: 0 2021年1月收支表Unnamed: 1 2020-12-15 00:00:00日002021-01-03 00:00:001201102021-01-10 00:00:00170952021-01-17 00:00:00120802021-01-24 00:00:001501002021-01-31 00:00:0000开始日期结束日期Unnamed: 2 2020-12-15 00:00:00一002021-01-04 00:00:00130802021-01-11 00:00:001501002021-01-18 00:00:00180952021-01-25 00:00:00220120002021-01-15 00:00:002021-01-25 00:00:00Unnamed: 3 44180二002021-01-05 00:00:00150952021-01-12 00:00:002201202021-01-19 00:00:001501052021-01-26 00:00:001709500收入金额

2025年学生成绩统计表-分类汇总 - Sheet1 Unnamed: 0 Unnamed: 1 学生成绩表（图表分析）序号12345678910111213141516Unnamed: 2 年级：学号2020010401202001040220200104032020010404202001040520200104062020010407202001040820200104092020010410202001041120200104122020010413202001041420200104152020010416Unnamed: 3 姓名学生1学生2学生3学生4学生5学生6学生7学生8学生9学生10学生11学生12学生13学生14学生15学生16Unnamed: 4 语文121115120871059212877119851151061211079882Unnamed: 5 数学125131851311281181257582121108998388102118Unnamed: 6 英语12086121118112025国庆业绩指标追踪-公式汇总

2025年收支表-年度收支利润汇总 - Sheet1 (2) Unnamed: 0 Unnamed: 1 收支表-年度收支利润汇总收支明细表日期2020-01-01 00:00:002020-01-01 00:00:002020-02-01 00:00:002020-02-01 00:00:002020-03-01 00:00:002020-03-01 00:00:002020-04-01 00:00:002020-04-01 00:00:002020-05-01 00:00:002020-05-01 00:00:002020-06-01 00:00:002020-06-01 00:00:00Unnamed: 2 资金类型收入支出收入支出收入支出收入支出收入支出收入支出Unnamed: 3 品名面霜洁泡面霜洁泡面霜洁泡面霜洁泡面霜洁泡面霜洁泡Unnamed: 4 数量1055256315642Unnamed: 5 单价89779432798977943279897794327

2025年收支明细表-多项计算汇总 - 1 Unnamed: 0 Unnamed: 1 开始时间收入结余每月结余汇总1月290收入表日期2020-01-01 00:00:002020-02-01 00:00:002020-03-01 00:00:002020-04-01 00:00:002020-05-01 00:00:002020-06-01 00:00:00Unnamed: 2 2020-11-01 00:00:00002月190类别Unnamed: 3 截止时间支出3月390摘要Unnamed: 4 2020-11-14 00:00:0004月270收入310220430320500320Unnamed: 5 5月500账户Unnamed: 6 账户收入支出6月320备注Unnamed: 7 支付宝007月0支出表日期2020-01-01 00:00:002020-02-01 00:00:002020-03-01 00:00:002020-04-01 00:00:00Unnamed: 8 微信008月0

2025年部门考勤统计表-自动汇总统计 - 考勤表 Unnamed: 0 部门考勤统计表 Unnamed: 2 姓名段小姐王小姐陈小姐李小姐刘小姐唐小姐Unnamed: 3 工作日222222222222Unnamed: 4 出勤221918221921Unnamed: 5 缺勤034031Unnamed: 6 出勤率10.86363636363636360.818181818181818210.86363636363636360.9545454545454546Unnamed: 7 Unnamed: 8 Unnamed: 9 Unnamed: 10 年1439222020-04-01 00:00:00√√√√√√Unnamed: 11 20202439232020-04-02 00:00:00√√√√√√Unnamed: 12 3439242020-04-03 00:00:00√√√√√√Unnamed: 13 4439252020-04-04 00:00:00Unnamed: 14 月5439262020-04-05 00:00:00Unna

2025年员工排班表（班次自动汇总） - Sheet1 员工排班表（班次自动汇总） 班次汇总员工姓名员工1员工2员工3员工4员工5员工6员工7员工8员工9Unnamed: 1 岗位名称Unnamed: 2 班次早中晚早中晚早中晚早中晚早中晚早中晚早中晚早中晚早中晚Unnamed: 3 11√Unnamed: 4 32√√√Unnamed: 5 13√Unnamed: 6 34√√√Unnamed: 7 45√√√√Unnamed: 8 26√√Unnamed: 9 27√√Unnamed: 10 18√Unnamed: 11 19√Unnamed: 12 0.010.0Unnamed: 13 0.011.0Unnamed: 14 212√√Unnamed: 15 213√√Unnamed: 16 0.014.0Unnamed: 17 115√Unnamed: 18 0.016.0Unnamed: 19 0.017.0Unnamed: 20 0.018.0Unnamed: 21 119√Un