住房公积金管理系统

!!!橄榄树 · 发表于 2008-1-5 16:30

<table cellspacing="0" cellpadding="0" width="367" border="0" style="WIDTH: 275pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="367" style="WIDTH: 275pt; mso-width-source: userset; mso-width-alt: 11750;"></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col><col></col></colgroup><tbody><tr height="27" style="HEIGHT: 20.4pt;"><td class="xl27" width="367" height="27" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 275pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 20.4pt; BACKGROUND-COLOR: #99ccff;">使用说明</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">1.增加职工必须使用复制粘贴方法, 然后修改数据。</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">2.增加、调动职工及修改数据后要存盘, 否则无效。</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">3."历年累计支取"截止时间为上年年底。</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">4."单位统计"可以在汇总后使用, 方法为点单位列</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">标右三角形, 再选取需要统计的单位 (不要点有汇</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">总的哪行),即可单独列出某单位的公积金。</td></tr><tr height="22" style="HEIGHT: 16.2pt;"><td class="xl25" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.2pt; BACKGROUND-COLOR: #99ccff;">5."本期缴存"统计应在增加、调动职工及修改数据</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">存盘后进行,点"本期缴存"后,可从汇总表内复制数</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">据, 再粘贴到"本期缴存"表中修改。不应有重复数。</td></tr><tr height="22" style="HEIGHT: 16.2pt;"><td class="xl25" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.2pt; BACKGROUND-COLOR: #99ccff;">6."并入汇总表"是将"本期缴存"数据补充到 "汇总</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">表"中, 应在两表非汇总状态下进行,补充后请存盘。</td></tr><tr height="22" style="HEIGHT: 16.2pt;"><td class="xl25" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.2pt; BACKGROUND-COLOR: #99ccff;">7."准备年度库"为年初的"历年累计支取" 加上"当</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">年支取","当年支取"清零, "月缴存"清零,"上年底</td></tr><tr height="21" style="HEIGHT: 15.6pt;"><td class="xl24" height="21" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.6pt; BACKGROUND-COLOR: #99ccff;">余额"等于"本期总余额"等,慎用, 试用时不要保存。</td></tr><tr height="22" style="HEIGHT: 16.2pt;"><td class="xl26" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.2pt; BACKGROUND-COLOR: #99ccff;">8.必须将公积金统计.RAR文件解压到磁盘运行。</td></tr><tr height="22" style="HEIGHT: 16.2pt;"><td class="xl26" height="22" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 16.2pt; BACKGROUND-COLOR: #99ccff;">9.先关闭EXCEL,再运行公积金统计.exe。</td></tr></tbody></table>

KapCUCSh.rar (32.16 KB, 下载次数: 191)

[此贴子已经被作者于2008-1-5 16:38:03编辑过]

		自动登录	找回密码
密码			免费注册

[求助] 住房公积金管理系统