Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 7419|回复: 23

[待分类] 毕业作品:库存报表(V预3期 08119号)

[复制链接]
发表于 2010-9-8 10:02 | 显示全部楼层 |阅读模式
<p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span style="FONT-SIZE: 9pt; COLOR: #0834e7; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 学员学号和论坛</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; COLOR: #0834e7; FONT-FAMILY: Arial;">ID</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">:</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">119</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">号</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;</span><font face="宋体"><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">主机</span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><br/>&nbsp;&nbsp;&nbsp;&nbsp;<p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><font face="宋体"><span style="FONT-SIZE: 9pt; COLOR: #0808e7; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">学习班名称</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">:</span></font><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">V</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">预</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">3</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">期</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">1</span><font face="宋体"><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">班</span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><br/>&nbsp;&nbsp;&nbsp;&nbsp;<p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><font face="宋体"><span style="FONT-SIZE: 9pt; COLOR: #3910de; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">毕业作品名称</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">:库存报表</span></font><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><font face="宋体"><span style="FONT-SIZE: 9pt; COLOR: #0f0fce; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">讲师</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">:<span style="COLOR: #0c4e7c;">兰色幻想</span></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><br/>&nbsp;&nbsp;&nbsp;&nbsp;<p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><font face="宋体"><span style="FONT-SIZE: 9pt; COLOR: #1111ee; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">班管</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">:班主任</span></font><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">:</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">鱼、班长</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">:</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">水之歌、学习委员</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">:</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">搁浅、苦丁茶、<span style="COLOR: black;">雨狐</span></font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp; <p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><font face="宋体"><span style="FONT-SIZE: 9pt; COLOR: #0808e7; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">毕业作品简介</span><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;">:通过出入库单的录入,实现自动生成本期报表。</span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><br/>&nbsp;&nbsp;&nbsp;&nbsp;<p></p></span></font></p><p></p><p></p><p></p><p></p><p></p><p></p><p style="WORD-BREAK: break-all; TEXT-INDENT: 18pt;"><span style="FONT-SIZE: 9pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial;"><font face="宋体">使用说明:进入界面后,按照备注顺序进行操作。首先进行出入库单据的录入。然后点击计算生成各部门报表。备份期初数和本期录入表到本目录下的文件夹中,最后进行初始化设置。【本表只适合产品较固定,每月数据不是很多的企业】本作品设计还很多不完善的地方,代码写的比较幼稚!请高手不要见笑。多提宝贵意见!</font></span><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Arial;"><br/>&nbsp;&nbsp;&nbsp;<p></p></span></p><p></p><p></p><p></p><p></p><p></p><p></p><br/>
[此贴子已经被兰色幻想于2010-9-11 15:21:03编辑过]

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?注册

x
发表于 2010-9-8 10:09 | 显示全部楼层

<p>不懂库存,不过看了代码,缩进的挺好,赞一个[em17]</p>
回复

使用道具 举报

发表于 2010-9-8 10:32 | 显示全部楼层
回复

使用道具 举报

发表于 2010-9-8 19:17 | 显示全部楼层

学习一下~<br/>
回复

使用道具 举报

发表于 2010-9-10 22:27 | 显示全部楼层

学习一下,我正需这方面的资料,参考
回复

使用道具 举报

发表于 2010-9-11 20:14 | 显示全部楼层

<p>可以看看吗?</p><p></p>
回复

使用道具 举报

发表于 2010-9-12 23:14 | 显示全部楼层

[em17]
回复

使用道具 举报

发表于 2010-9-13 12:41 | 显示全部楼层

<p>学习.</p>
回复

使用道具 举报

发表于 2010-9-15 21:34 | 显示全部楼层

下试看看 正在搞库存表 看看LZ分享出来的方法如何
回复

使用道具 举报

发表于 2010-10-11 09:25 | 显示全部楼层

<p>不好意思,怎么下载?</p>
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-12 03:44 , Processed in 0.301226 second(s), 6 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表