[原创]公司“离职率”分析月报模板

wolf520000

<p>上了这个网站我才知道excle是如此的强大</p><p>谢谢各位</p>

老烟抢

真是强人

dsmhy

非常不错呀！！！！谢谢分享！！！

莲花香片

<p>高手啊</p>

ivy_dai2003

看看,是否可以套入我公司的模式,如果可以的话,就好啦

ivy_dai2003

<p>好东西,但我是莱鸟.....不知道里面是实际是怎么设置的.....</p><p>楼主:可以把你做这个表格的步骤写下来吗?</p>[em04][em04][em04]

offe_offi

<p><font color="#ff0000" size="4">很高兴有一些朋友喜欢这个模板。我一直没有时间、也是拖拉偷懒的缘故，没有去总结制作这个模板的步骤。现应版主Xolf要求，简单地写了一些，也顺便放在这里分享：</font></p><p>&nbsp;<font face="Times New Roman"> ua7QvZRC.rar (76.83 KB, 下载次数: 482)

2007-7-10 07:32 上传

点击文件名下载附件

</p><p class="MsoNormal" style="MARGIN: 12pt 0cm 0pt; mso-para-margin-top: 1.0gd;"></p><p class="MsoNormal" style="MARGIN: 12pt 0cm 0pt; mso-para-margin-top: 1.0gd;"><span style="FONT-SIZE: 12pt; BACKGROUND: yellow; COLOR: blue; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-highlight: yellow;"><font size="5">该模板制作关键步骤：</font></span><span lang="EN-US" style="FONT-SIZE: 12pt; COLOR: blue;"><p></p></span></p><p></p><p></p><p class="MsoNormal" style="MARGIN: 6pt 0cm 0pt 44.95pt; TEXT-INDENT: -17.95pt; mso-char-indent-count: -1.71; mso-para-margin-top: .5gd; mso-para-margin-right: 0cm; mso-para-margin-bottom: .0001pt; mso-para-margin-left: 2.57gd;"><font size="4"><u><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、数据透视</span></u></font></p><p class="MsoNormal" style="MARGIN: 6pt 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-top: .5gd; mso-para-margin-right: 0cm; mso-para-margin-bottom: .0001pt; mso-para-margin-left: 4.27gd;"><font size="4"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">为使报表分析适应每月输入清单之数据动态变化，透视表必须设置为“自动刷新”。数据透视表数据源也使用了动态名称。名称采用</span><span lang="EN-US"><font face="Times New Roman">offset</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">函数来写，自动识别</span><span lang="EN-US"><font face="Times New Roman">5</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个输入清单表格的长和宽。</span></font><span lang="EN-US"></span></p><p><font size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.95pt; TEXT-INDENT: -17.95pt; mso-char-indent-count: -1.71; mso-para-margin-left: 2.57gd;"><font size="4"><u><span lang="EN-US"><font face="Times New Roman">2</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、窗体控件设置</span></u></font></p><p class="MsoNormal" style="MARGIN: 12pt 0cm 0pt 44.85pt; mso-para-margin-top: 1.0gd; mso-para-margin-right: 0cm; mso-para-margin-bottom: .0001pt; mso-para-margin-left: 4.27gd;"><font size="4"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">该模板设置了</span><span lang="EN-US"><font face="Times New Roman">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">组单选框，分别用来选择“分析对象”、“分析方案”（数据维度）、“排序方式”；</span><span lang="EN-US"><font face="Times New Roman">1</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个复选框，用于开</span><span lang="EN-US"><font face="Times New Roman">/</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">关控制提示文本框；和一个滚动条微调，用于调整饼图切割。</span></font><span lang="EN-US"></span></p><p><font size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.95pt; TEXT-INDENT: -17.95pt; mso-char-indent-count: -1.71; mso-para-margin-left: 2.57gd;"><font size="4"><u><span lang="EN-US"><font face="Times New Roman">3</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、名称定义</span></u></font></p><p class="MsoNormal" style="MARGIN: 12pt 0cm 0pt 44.85pt; mso-para-margin-top: 1.0gd; mso-para-margin-right: 0cm; mso-para-margin-bottom: .0001pt; mso-para-margin-left: 4.27gd;"><font size="4"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">除了数据透视表需要动态数据源之外，报表的图表，也需要动态数据源。这里就另外设置了</span><span lang="EN-US"><font face="Times New Roman">7</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">个自定义名称，以</span><span lang="EN-US"><font face="Times New Roman">offset</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">函数编写了动态值域。</span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><font size="4"></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><font size="4"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">采用名称做为图表动态值域后，就可以修改图表“系列”值域。比如，模板中柏拉图百分比比率系列值域是：</span><span lang="EN-US"><font face="Times New Roman">=SERIES(func!$W$21,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">离职率分析月报模板</span><span lang="EN-US"><font face="Times New Roman">1!x,</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">离职率分析月报模板</span><span lang="EN-US"><font face="Times New Roman">1!pareto,3)</font></span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><font size="4"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">表达式中的</span><span lang="EN-US"><font face="Times New Roman">x</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，就是自定义的名称之一。</span></font><span lang="EN-US"></span></p><p><font size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.95pt; TEXT-INDENT: -17.95pt; mso-char-indent-count: -1.71; mso-para-margin-left: 2.57gd;"><font size="4"><u><span lang="EN-US"><font face="Times New Roman">4</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">、函数设置与图表后台数据源编列</span></u></font><span lang="EN-US"></span></p><p><font size="4"></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><font size="4"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">动态数据分析模板的函数设置，一般包含这几个部分：数据检测、窗体控件链接值处理、动态文本控制、数据查找</span><span lang="EN-US"><font face="Times New Roman">/</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">统计</span><span lang="EN-US"><font face="Times New Roman">/</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">分类</span><span lang="EN-US"><font face="Times New Roman">/</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">汇总、数据之静态动态转换等。</span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><font size="4">该模板主要为实现动态图表数据源的编列，逐步编写函数。</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><font size="4"></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><font size="4"></font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 44.85pt; TEXT-INDENT: 0.05pt; mso-para-margin-left: 4.27gd;"><span style="COLOR: red; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';"><font size="4">关于数据排序，是因为柏拉图的柱子，必须是从高到低排列。饼图也是一样，上面的每一块“小饼”，也是按照大小顺序排列的。应此要求，图表的后台数据，必须事先按照大小顺序排列。</font></span><span lang="EN-US" style="COLOR: red;"><font size="4">
                        </font></span><br/><br/></p>

[此贴子已经被作者于2007-7-10 7:34:23编辑过]

renying

<p>真是厉害啊！崇拜</p>

yangyh3

<p>没有看懂表达的是什么？</p><p>是离职率报表格式吗？</p><p>其实这个表不尽完美！</p>

啊啦叮

超强[em02]