Excel Cu Formule Stat Plata

download Excel Cu Formule Stat Plata

of 8

description

GG

Transcript of Excel Cu Formule Stat Plata

stat plataLUNA - noi/2013nr de pers in intret01234 +deducere pers250350450550650functiedanubaza10nr. zile lucratoare21valoare tichet masa9.35NRfunctpersoanezileoreNUMELE SI PRENUMELESALARIUSALARIULSALARIUCASSOMAJCONTRIBVENITDEDUCDEDUCDEDUCDEDUCDEDUCTICHETEore suplimore suplimsuma oreVENITIMPOZITSALARIUCRTbazain intretinerelucratelucrateSALARIATULUIINCADRAREREALIZATBRUTSALARIATSALARIATSANATATEBRUTPERSPERSPERSPERS NEROTPERS ROTMASA75%100%suplimentBAZA CALC.SALARIUNET111168ALEXE1675231323132431212719313503503501201203263818112901642210BAJNA17500000002502500000000300BALOGH10000000000250000000041021BIVOLARU2705000000250250000196000051021BULMEZ16750000002502500001960000610BURLA2120000000250250000000071021168CALOTA160022692465238111251895250250250677019672966920213231571810CATANA8250825082508664145468892502500000688911025787910CATANOIU4990499049905242527441672502500000416766735001010CHIS1970197019702071010816452502502501291300151524214031110CIOCA1675167516751768921399250250250166170012291971202121121CIRA21152311250824312127193035035035086861960204032616041310CIURTIN1970197019702071010816452502502501291300151524214031410COHAN16751675167517689213992502502501661700122919712021510COLDEA2120212021202231111717702502502501101100166026615051610CONSTANTINIU1970197019702071010816452502502501291300151524214031710CSAVDARI16751675167517689213992502502501661700122919712021810DOMSA1970197019702071010816452502502501291300151524214031911DUMITRACHE240524052405253121322008350350350104100019083051703201021DUMITRU19752171236822811119181325025025079791960193030915042110ENACHE25602560256026913141213825025025055600207833218052210FLORESCU4990499049905242527441672502500000416766735002310GAVRILA6300630063006623234752612502500000526184244192410GHERGHINOIU151501515015150159176833126502502500000126502024106262510GRECU800800800844446682502502502502500418676012610HAN212021202120223111171770250250250110110016602661505271118ION C167518432012194910115393503503501731701680153724612932810ION F1380138013801457761152250250250203200095215210002910KOPE7130713071307493639259542502500000595495350013010LUKACS17501750175018499614612502502501561600130120812533110MATEI86258625862590643474720225025000007202115260503210MONDICI211521152115222111161766250250250111110016562651501331015MORUN21152255239623711124188325025025076801400194331115723410NICULESCU105851058510585111153582883825025000008838141474243510NITA211521152115222111161766250250250111110016562651501361218OANA1600176819371869971477450450450239240168014052251252371121OPREA167518712068196910315633503503501631601960159925613073810PETCU17501750175018499614612502502501561600130120812533910POP F16751675167517689213992502502501661700122919712024010POP R356535653565374181962977250250000029774762500411021PRECUP19752171236822811119181325025025079791960193030915044210PRIPON197019701970207101081645250250250129130015152421403431021PUT330034963693367171922919250250000196031164992421441221RAUT2115231125082431212719304504504501111101960201632316074510SABOU16751675167517689213992502502501661700122919712024610SOPORAN2120212021202231111717702502502501101100166026615054710STRUGARU515051505150541262834300250250000043006883612481021TOMA21202316251324312127193425025025061601960207133116034910URSU1970197019702071010816452502502501291300151524214035010VARADI2560256025602691314121382502502505560020783321805511021VARNAV300031963393336161762669250250000196028654582211521121VASILIU-DOBRE335035463743372181952961350350000196031585052456531016VICOL390040504199425202233381250250000150035315652816541117ZAVOIANU167518341993193910115313503503501761801590151024212905500ZELENKA8558558559044771402500000714114600TOTAL1646950000000000CONTRIBUTII SALARIATISALARIULCAS SALSOMAJ SALCASSIMPOZITREALIZAT10.50%0.50%5.50%SALARIU00000CONTRIBUTIIANGAJATORSALARIULCASCASSSOMAJFD ACCIDCCIGAR.CRREALIZAT20.80%5.20%0.50%0.260%0.85%0.25%0000000