2025excel水平分析垂直分析
2025年营销分析团队年度业绩表 - Sheet1 Unnamed: 0 营销分析团队年度业绩表 团队A团队B团队C团队总业绩Unnamed: 2 一月260161151572Unnamed: 3 二月113268158539Unnamed: 4 三月116297255668Unnamed: 5 四月52160144356Unnamed: 6 五月29225185628Unnamed: 7 六月137251113501Unnamed: 8 七月115136134385Unnamed: 9 八月210248164622Unnamed: 10 九月30022072592Unnamed: 11 十月279299146724Unnamed: 12 十一月272117257646Unnamed: 13 单位：十二月284153209646Unnamed: 14 万小计2430256118886879
2025年销售一周数据分析表 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 销售数据一周分析表产品名称产品1产品2产品3产品4产品5产品6产品7产品8产品9产品10合 计Unnamed: 3 星期一50602101601701901801501301201420Unnamed: 4 星期二150901801901401701502201802101680Unnamed: 5 星期三1502402101601501301501501901901720Unnamed: 6 星期四30210240140250130150220120401530Unnamed: 7 星期五8050230150501401101701801501310Unnamed: 8 星期六15070190160170140120100130211251Unnamed: 9 星期日170901701601501201502101801101510Unnamed: 10 总计数量780810143
2025年年度人员流动分析表 - Sheet1 年度人员流动分析表 月度1月2月3月4月5月6月7月8月9月10月11月12月年度统计Unnamed: 1 月初人数1321361391471561561571591611591541451023Unnamed: 2 期间新增128172310735935615112Unnamed: 3 期间减少辞职5351294214258659Unnamed: 4 辞退213212112356222Unnamed: 5 退休1110001100114Unnamed: 6 其它0000000000000Unnamed: 7 年末人数1361391471561561571591611591541451511050Unnamed: 8 实际增（减）人数43890122-2-5-9627Unnamed: 9 增长率0.03030303030303030.02205882352941180.05755395683453240.061224489795918400.0.....
2025年营销分析销售季度数据统计表 - Sheet1 Unnamed: 0 营销分析销售季度数据统计表 姓名马勇福张册青韦彬沈宗月郎宗姜涵风黄礼涛Unnamed: 2 一季度2446508227366682278557213858Unnamed: 3 二季度2190621351715629604660912449Unnamed: 4 三季度4664585543504853327936712938Unnamed: 5 四季度3326675023273250650543732928Unnamed: 6 合计126262390014584204141861519856121730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000......
2025年费用预算对比分析表 - Sheet1 Unnamed: 0 Unnamed: 1 20XX年费用预算对比分析表序号1234567合计Unnamed: 2 项目财务部销售部人事部企划部生产部招商部技术部Unnamed: 3 金额5062516000207365062590963906262500248644Unnamed: 4 单位：万元占比0.20.060.080.20.040.160.250.99
2025年销售分析业务员年度业绩表 - Sheet2 Unnamed: 0 销售分析业务员年度业绩表 姓名邱琛怀金间琳谢豪盈王曲钱龙邱胜奚会厚钟可姜政钟易行Unnamed: 2 所属团队A团队A团队A团队A团队B团队B团队B团队B团队B团队B团队Unnamed: 3 2019年业绩363527454630469045489033531667465844579974320430321443411252Unnamed: 4 2020年业绩691710524426510057588141568550767452556426569938898706511954Unnamed: 5 比去年增加32818369796410129910836883301608-23548249508577263100702000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2025年销售业绩对比分析表 - Sheet1 销售业绩对比分析表 月份姓名1月2月3月4月5月6月7月8月9月10月11月12月合计目标销售额完成比未完成超额完成Unnamed: 1 张一20080240220280163250160270118210156234725000.93880.06120Unnamed: 2 张二180160201223245220190210180190270310257925001.031600.0316000000000001Unnamed: 3 张三210200199165201223240250126227280300262125001.048400.0484Unnamed: 4 张四23024050229240180160170280290300320268925001.075600.0755999999999999Unnamed: 5 张五190280257210220260270255245260270280299725001.198800.1988Unnamed: 6
2025年年终销售出库分析表 - 分析 Unnamed: 0 Unnamed: 1 年终销售出库分析表序号1001100210031004100510061007100810091010101110121013TotalUnnamed: 2 原材料名称泵转子132AW泵转子133AW泵转子134AW泵转子135AW泵转子136AW泵转子137AW泵转子138AW泵转子139AW泵转子140AW泵转子141AW泵转子142AW泵转子143AW泵转子144AWUnnamed: 3 规格型号1200H1201H1202H1203H1204H1205H1206H1207H1208H1209H1210H1211H1212HUnnamed: 4 2019年销售量303263960151501060300020765409777031Unnamed: 5 单价222.213.6205205.117353.819.597.46536.125.925.925.8Unnamed: 6 金额66664352025excel水平分析垂直分析
2025年学生考试成绩分析图表 - 图表分析 Unnamed: 0 Unnamed: 1 学生考试成绩分析图表课目语文数学英语政治历史化学物理体育Unnamed: 2 实际及格率10.9400196495858360.9656566910807040.780.6752517927534770.5893308074603390.4883792010524510.387427594644562Unnamed: 3 目标及格率0.950.90.90.90.850.840.90.8Unnamed: 4 一般0.70.70.70.70.70.70.70.7Unnamed: 5 良好0.150.150.150.150.150.150.150.15Unnamed: 6 优秀0.150.150.150.150.150.150.150.15
2025年应收账款明细分析 - Sheet1 Unnamed: 0 Unnamed: 1 应收账款明细分析编制单位：序号123456789101112131415Unnamed: 2 客户名称****有限公司****有限公司Unnamed: 3 业务内容合同业务合同业务Unnamed: 4 业务日期2020.1.202020.7.8Unnamed: 5 期末账面余额 （本位币）7800052000Unnamed: 6 其中按业务发生时间划分1个月内Unnamed: 7 1-3个月内Unnamed: 8 3-6个月内52000Unnamed: 9 半年以上78000Unnamed: 10 应计提的坏账准备1个月内Unnamed: 11 1-3个月内Unnamed: 12 3-6个月内Unnamed: 13 半年以上00Unnamed: 14 截止年终 回款总额3900026000Unnamed: 15 未收回
2025年库存盘点统计分析表自动红字填充 - Sheet1 Unnamed: 0 Unnamed: 1 库存盘点统计分析表 序号123456Unnamed: 3 产品名称牛仔裤牛仔裤男加绒牛仔裤女加绒牛仔裤小脚牛仔裤薄绒牛仔裤Unnamed: 4 产品编码A001A002A003A004A005A006Unnamed: 5 单位条条条条条条Unnamed: 6 产品单价404288986878Unnamed: 7 实盘数量65135140180220500Unnamed: 8 账面数量63138136182216503Unnamed: 9 差异数量-23-42-43Unnamed: 10 实盘金额2600567012320176401496039000000000Unnamed: 11 账面金额2520579611968178361468839234000000Unnamed: 12 差额80-126352-196272-234000000Unnamed: 13 备注
2025年目标完成情况分析统计表 - Sheet1 目标完成情况分析统计表 小组领导人奚伟昌詹文花林国汇Unnamed: 1 成员昌缓梁韩仲莹戚坚沈芳姓名姓名姓名姓名姓名姓名姓名姓名Unnamed: 2 月目标700007000070000700007000050000500005000070000600006000060000Unnamed: 3 实际完成数据432288323064485519316349532605297387136565507499406228778170Unnamed: 4 超额完成 （比目标多出）1323021365228718170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
2025年相亲对象汇总分析表 - Sheet1 相亲对象汇总表 序号1234Unnamed: 1 姓名赵一钱二孙三吕四Unnamed: 2 联系方式159****5656156****3636153****3535135****3939Unnamed: 3 意向愿意不愿意待定待定Unnamed: 4 备注Unnamed: 5 基本资料年龄28272625Unnamed: 6 属相龙猪蛇牛Unnamed: 7 星座狮子座双鱼座蝎子座处女座Unnamed: 8 属地上海北京西安南京Unnamed: 9 身高（CM）180178185175Unnamed: 10 体重(KG)85657064Unnamed: 11 帅否帅一般丑一般Unnamed: 12 教育院校XX大学XX大学XX大学XX大学Unnamed: 13 专业电子机械金融法律Unnamed: 14 学历博士研究生本科大专Unnamed
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-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:00Unnamed: 2 名称18001380商品编号K001K001K002K002K003K003K001K001K002K002K003K003K002K003K002K003Unnamed: 3 名称290
2025年收支分析表 - 收支明细表 Unnamed: 0 收 支 明 细 表 序号1234567891011121314151617181920212223242526272829303132333435363738Unnamed: 2 日期2020-01-01 00:00:002020-01-01 00:00:002020-01-02 00:00:002020-02-01 00:00:002020-03-02 00:00:002020-03-02 00:00:002020-04-03 00:00:002020-04-03 00:00:002020-05-04 00:00:002020-05-04 00:00:002020-06-14 00:00:002020-06-15 00:00:002020-06-16 00:00:002020-06-17 00:00:002020-06-18 00:00:002020-07-02 00:00:002020-07-03 00:00:002020-07-04 00:00:002020-07-05 00:00:002020-07-06 00:00
2025年销售数据动态分析表 - Sheet1 Unnamed: 0 Unnamed: 1 Unnamed: 2 Unnamed: 3 销售数据动态分析表 Sales data analysis table姓名5姓名姓名1姓名2姓名3姓名4姓名5姓名6姓名7姓名8姓名9姓名10姓名11姓名12姓名13姓名14姓名15姓名16姓名17姓名18姓名19姓名20Unnamed: 4 显示长度1月781月686690907875120202071977411275105111811109796Unnamed: 5 102月772月707270115771021202020775067601041051067111463104Unnamed: 6 显示月度3月783月8795701177810812060102101756810281100608110910874Unnamed: 7 1月4月934月5482686893941009072916053716483542025excel水平分析垂直分析
2025年销售业绩完成分析总结 - Sheet1 销售业绩完成分析总结 小组人数：小组吴元组完成业绩总计：Unnamed: 1 8成员邱悦量姜琛世钱百赵栏旭戚岁盈陈谱戚康清韩智涵Unnamed: 2 达标人数：目标业绩5005005005005005005005003702Unnamed: 3 3完成业绩879375535452256315210680Unnamed: 4 完成比例1.7580.751.070.9040.5120.630.421.36Unnamed: 5 Unnamed: 6 小组人数：小组黄婷组完成业绩总计：Unnamed: 7 11成员鲁毅健张民美骆里金博谱喻百海徐雪智王红郎艺古沈六应黄申沈沫元Unnamed: 8 达标人数：目标业绩5005005005005005005005005005005005108Unnamed: 9 5完成业绩8022293686
2025年排班表-可视化分析 - Sheet1 Unnamed: 0 Unnamed: 1 员工排班表2020 星期 姓名小小1小小2小小3小小4Unnamed: 2 年早班A15121712Unnamed: 3 10晚班B78913Unnamed: 4 夜班C4454Unnamed: 5 月休息X5702Unnamed: 6 2020-10-01 00:00:00四AXAAUnnamed: 7 2020-10-02 00:00:00五AABBUnnamed: 8 早班2020-10-03 00:00:00六CBCBUnnamed: 9 2020-10-04 00:00:00日ACAAUnnamed: 10 2020-10-05 00:00:00一AABBUnnamed: 11 562020-10-06 00:00:00二XBCCUnnamed: 12 2020-10-07 00:00:00三XCABUnnamed: 13 2020-10-08 00:00:00四BBABUnnamed: 14
2025年利润分析表 - Sheet1 Unnamed: 0 Unnamed: 1 利润分析表项 目一、主营业务收入 减：主营业务支出 税金及附加 二、主营业务利润 加：其他业务利润 减：存货跌价损失 销售费用 管理费用 财务费用三、营业利润 加：投资收益 营业外收入 减：营业外支出四、利润总额 减：所得税以前年度损益调整五、净利润Unnamed: 2 本年利润行次1234567891011121314151617Unnamed: 3 本月数502262212221227221301227Unnamed: 4 10511月3282222252411452182115Unnamed: 5 10月223
2025年销售收支利润分析 - Sheet1 销售收支利润分析 月1212121212121212121212Unnamed: 1 日1234567891011Unnamed: 2 收入53964839521258874830597749715133541157305983Unnamed: 3 支出85487711211094120111441185127511711039943Unnamed: 4 当天盈利454239624091479336294833378638584240469150400000000000000000000000000000000000000Unnamed: 5 Unnamed: 6 汇总收入总计支出总计利润总计Unnamed: 7 59369.011904.047465.0
