Excel在财务工作中的应用(上)教程

在高压缸排汽的总管上装有动力控制止回阀，以便在事故情况下切断，防止蒸汽返回到汽轮机，引起汽轮机超速。在高压缸排汽总管的端头有蒸汽冲洗接口，以供在管道安装完毕后进行冲洗，在管道冲洗完成后用堵头堵死。centerpinchecksandanchoringtheinnercylinder.AccordingtoWhilecouplingalignmentshouldkeepoiloutofcavityandlocatetherotoraxisneckraisedarewithintheprescribedlimits,thereshouldbenogaps,Horn,HornandHorn0.05mmfeelergaugesfitinto.Centercoupling,condenserwaterfillingandwater-filledaccordingtofactoryrequirement.ForcouplingthreesupportedrotorCenter,themouthunderthecouplingbetweenthevalueshouldbeasstipulatedinthemanufacturer,usually0.15~0.25mm.Inthecaseofcouplingconnection,ifpossible,liftingonlyonebearingendofthesupportbearingoftherotor,removethebearing,fittedwithspecialtilesandspecialliftingtools,discrotors,checkthejournalfluttertile,shouldgenerallybelessthan0.10MM.Whenthecouplingsandrotorcomeswhenthereisaconflict,thecouplingCentreshallprevail.6.4.5.2.2shaftlookingfor:...6.4.5.3.Provisionalboltconfirmedthepositioningoftherotorsize,aswellasthecouplingbetweentheadjustmentshimthicknessaccuracy,drawingstomeetthetechnicalrequirements.Plane,cylindricalandcleanthecouplingboltholesshouldbecleanandwithoutburrs,scrapironandgrease-free,relativepositionofthecouplingaccordingtothedrawingrequirementsare.Couplingtopscrews,rounddistanceapart,indicatorstomonitormovementoftheaircraft,itsvalueisallowedtopassthevalueaxismoving,mountedadjustmentpads,notepadsinstallationdirectionguidepincouplingwithprocessendclosed.Thebackwheelsslowlytightened,when2mmorso,withstandardwhitebarswheretwobackwheelboltholemeasurementaboveandbelow,confirmtwobackwheelboltholeconcentricity.Then,thesymmetricalhorizontalmounttwotemporaryboltstightened,attentiontomonitordialindicator,theninstallthesymmetricaltemporarybolts,thistimesitesslowlymovingrotor,inthemeasuredcircumferenceof8equalpartsbackwheelrimrock,eachmeasuringrelativechangesinvalueshouldbelessthan0.02mm.6.4.5.4couplingreamedandpairedboltreamingdiereamer,adjustablereamers,boringmill,inseveralways.6.4.5.4.1Generalrequirementsbeforereamingorboring,EXCEL在财务工作中的应用固定资产折旧（上）固定资产折旧方法3加速折旧法—双倍余额递减法双倍余额递减法：指在不考虑固定资产预计净残值的情况下，根据每期期初固定资产账面净值（原值减去累计折旧后的余额）和两倍的直线折旧率计算固定资产折旧的一种方法。计算公式：年折旧率=2/预计使用年限*100%月折旧率=年折旧率*12月折旧额=固定资产账面净值*月折旧率固定资产账面净值=固定资产原值-累计折旧Excel操作—双倍余额递减法【例3】某企业外购一台生产设备，价格10万元，预计使用年限10年，预计净残值率为5%，假设该公司没有对该设备计提减值准备。问：按双倍余额递减法计提折旧，各年的折旧额是多少？在高压缸排汽的总管上装有动力控制止回阀，以便在事故情况下切断，防止蒸汽返回到汽轮机，引起汽轮机超速。在高压缸排汽总管的端头有蒸汽冲洗接口，以供在管道安装完毕后进行冲洗，在管道冲洗完成后用堵头堵死。centerpinchecksandanchoringtheinnercylinder.AccordingtoWhilecouplingalignmentshouldkeepoiloutofcavityandlocatetherotoraxisneckraisedarewithintheprescribedlimits,thereshouldbenogaps,Horn,HornandHorn0.05mmfeelergaugesfitinto.Centercoupling,condenserwaterfillingandwater-filledaccordingtofactoryrequirement.ForcouplingthreesupportedrotorCenter,themouthunderthecouplingbetweenthevalueshouldbeasstipulatedinthemanufacturer,usually0.15~0.25mm.Inthecaseofcouplingconnection,ifpossible,liftingonlyonebearingendofthesupportbearingoftherotor,removethebearing,fittedwithspecialtilesandspecialliftingtools,discrotors,checkthejournalfluttertile,shouldgenerallybelessthan0.10MM.Whenthecouplingsandrotorcomeswhenthereisaconflict,thecouplingCentreshallprevail.6.4.5.2.2shaftlookingfor:...6.4.5.3.Provisionalboltconfirmedthepositioningoftherotorsize,aswellasthecouplingbetweentheadjustmentshimthicknessaccuracy,drawingstomeetthetechnicalrequirements.Plane,cylindricalandcleanthecouplingboltholesshouldbecleanandwithoutburrs,scrapironandgrease-free,relativepositionofthecouplingaccordingtothedrawingrequirementsare.Couplingtopscrews,rounddistanceapart,indicatorstomonitormovementoftheaircraft,itsvalueisallowedtopassthevalueaxismoving,mountedadjustmentpads,notepadsinstallationdirectionguidepincouplingwithprocessendclosed.Thebackwheelsslowlytightened,when2mmorso,withstandardwhitebarswheretwobackwheelboltholemeasurementaboveandbelow,confirmtwobackwheelboltholeconcentricity.Then,thesymmetricalhorizontalmounttwotemporaryboltstightened,attentiontomonitordialindicator,theninstallthesymmetricaltemporarybolts,thistimesitesslowlymovingrotor,inthemeasuredcircumferenceof8equalpartsbackwheelrimrock,eachmeasuringrelativechangesinvalueshouldbelessthan0.02mm.6.4.5.4couplingreamedandpairedboltreamingdiereamer,adjustablereamers,boringmill,inseveralways.6.4.5.4.1Generalrequirementsbeforereamingorboring,在高压缸排汽的总管上装有动力控制止回阀，以便在事故情况下切断，防止蒸汽返回到汽轮机，引起汽轮机超速。在高压缸排汽总管的端头有蒸汽冲洗接口，以供在管道安装完毕后进行冲洗，在管道冲洗完成后用堵头堵死。centerpinchecksandanchoringtheinnercylinder.AccordingtoWhilecouplingalignmentshouldkeepoiloutofcavityandlocatetherotoraxisneckraisedarewithintheprescribedlimits,thereshouldbenogaps,Horn,HornandHorn0.05mmfeelergaugesfitinto.Centercoupling,condenserwaterfillingandwater-filledaccordingtofactoryrequirement.ForcouplingthreesupportedrotorCenter,themouthunderthecouplingbetweenthevalueshouldbeasstipulatedinthemanufacturer,usually0.15~0.25mm.Inthecaseofcouplingconnection,ifpossible,liftingonlyonebearingendofthesupportbearingoftherotor,removethebearing,fittedwithspecialtilesandspecialliftingtools,discrotors,checkthejournalfluttertile,shouldgenerallybe