<p>以下是固定资产折旧表,用函数制作,用得着的朋友可看一看</p><p>直线折旧,按类别自动汇总,<table cellspacing="0" cellpadding="0" width="375" border="0" style="WIDTH: 282pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="62" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1984;"></col><col width="145" style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 4640;"></col><col width="88" style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 2816;"></col><col width="33" style="WIDTH: 25pt; mso-width-source: userset; mso-width-alt: 1056;"></col><col width="47" style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504;"></col></colgroup><tbody><tr height="32" style="HEIGHT: 24pt;"><td class="xl25" width="62" height="32" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2"><strong>入帐日期</strong></font></td><td class="xl24" width="145" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 109pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2"><strong>名称</strong></font></td><td class="xl24" width="88" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 66pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2"><strong>原值</strong></font></td><td class="xl24" width="33" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 25pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><font face="宋体" size="2"><strong>残值率</strong></font></td><td class="xl24" width="47" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 35pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffcc99;"><strong><font face="宋体" size="2">预计使用年限</font></strong></td></tr></tbody></table>要求输入以上数据</p>
FFi2LaW8.rar
(12.02 KB, 下载次数: 250)
<br/>
[此贴子已经被作者于2006-7-27 16:35:38编辑过] | 
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2006-7-27 16:20
