Date post: | 02-Apr-2018 |
Category: |
Documents |
Upload: | nallecitaj |
View: | 258 times |
Download: | 0 times |
of 25
7/27/2019 Validacion Hoja clculo Excel
1/25
_g`bagdbh al `g
mkig al d`du`k
7/27/2019 Validacion Hoja clculo Excel
2/25
Lxdl` ls uhk al `ks prkergjgsbhokrjtbdks js dkjhjlhtlutb`bzgaks pgrg rlg`bzgr d`du`ksgutkjtbdks k sljbgutkjtbdg y
vbsug`bzgdbh al agtks(
Vgrg mkigs al d`du`k al ergho`lxbcb`baga l` Alsgrrk``k y
`g _g`bagdbh rlqublrl uh tbljpkdkhsbalrgc`l
\hg mkig al d`du`k abslgag
pgrg uhg sk`g tgrlg hk pulal slrtgh pkalrksk dkjk uhg mkig al
d`du`k js o`lxbc`l, plrk lsjudmk js odb` al drlgr y
vg`bagr(
Dgag vlz qul uh d`du`k tblhlqul slr rlpltbak aurghtl uh
`grek plrkak al tbljpk,sl alcl dkhsbalrgr `g elhlrgdbhal uhg mkig al d`du`k vg`bagak
7/27/2019 Validacion Hoja clculo Excel
3/25
Alclh tlhlr prkpsbtk d`grk y agtks lstrudturgaks(
Vrkpkrdbkhgr uhg culhg vbsbh dkhiuhtg al subhtlhdbh(
L` abslk al `g mkig al d`du`k alcl slr cblhkralhgak, pkr slddbkhls lspldobdgs(
@gs orju`gs qul sl utb`bzgh pgrg l` d`du`k alclhutb`bzgr dl`ags bhabvbaug`ls(
7/27/2019 Validacion Hoja clculo Excel
4/25
Tl gsleurg qul9@g mkig al d`du`k ls
o`lxbc`l g utb`bzgr pgrgktrks prkaudtks(
@g mkig ald`du`k
ls o`lxbc`llh su usk sb`ks vg`krlsdgjcbgh(
@g mkig al d`du`k lskralhgag
y `ks vg`krls utb`bzgakspgrg l` d`du`k al `ks
rlsu`tgaks skh odb`jlhtlvbsbc`ls(
@gvg`bagdbh yrlvg`bagdbh
sl pulalrlg`bzgr dkh
ogdb`baga(
7/27/2019 Validacion Hoja clculo Excel
5/25
@g vg`bagdbh al mkigs al d`du`k alcl egrghtbzgr qul tkaks`ks agtks elhlrgaks y tkags `gs kplrgdbkhls y dkhtrk`ls
rlg`bzgaks dkh `g mkig al d`du`k y ergobdks, skh v`baks((
@gs dl`ags qul dkhtblhlh vg`krls drtbdks alclh slr
prktlebaks dkhtrg l` dgjcbk alspus al `g lhtrgag al agtks(
Mkigs al d`du`k qul skh utb`bzgaks pkr uhg sk`g vlz y hk sl
g`jgdlhgh pgrg su usk pkstlrbkr hk hldlsbtgh slr vg`bagakplrk alclh slr dkjprkcgags sb sl utb`bzgh lh l` jcbtk al`gs culhgs prdtbdgs(
7/27/2019 Validacion Hoja clculo Excel
6/25
_g`bagdbh almkig al d`du`k
V`gh alvg`bagdbh
Lildudbh
al` p`gh
Akdujlhtksal
vg`bagdbh-Vrktkdk`k"
7/27/2019 Validacion Hoja clculo Excel
7/25
V@GH AL _G@BAGDBH
Hkjcrl al` grdmbvk al mkig al d`du`k, bhd`uylhak l` hjlrk alvlrsbh al `g mkig al d`du`k
\cbdgdbh al g`jgdlhgjblhtk al `g mkig al d`du`k
Mkigs al d`du`k bhabvbaug`ls lh l` grdmbvk y sus bhtlrgddbkhls kdkhlxbkhls
Tbstljg kplrgtbvk y skotwgrl ^pkr liljp`k, Ubhakws 3666 vlrsbh
7/27/2019 Validacion Hoja clculo Excel
8/25
Tb `g vg`bagdbh sl rlg`bzg g pkstlrbkrb, `ks agtks qul sl mgcghelhlrgak dkh `g mkig al d`du`k ghtls al `g vg`bagdbh y `g oldmgal qul sl utb`bz `g mkig al d`du`k(
Hkjcrls al usugrbk -s" qul alsgrrk``grkh `g mkig al d`du`k y `gsprulcgs al vg`bagdbh(
7/27/2019 Validacion Hoja clculo Excel
9/25
7/27/2019 Validacion Hoja clculo Excel
10/25
SLW\BTBQKT
@ks rlqubsbtks tblhlh qul slr l`lebaks al uhgjghlrg qul plrjbtl qul `gs prulcgs s slgh
alsgrrk``gags y rlg`bzgags pgrg dkjprkcgr sb `gmkig al d`du`k dujp`l sus ouhdbkhls(
Vgrg dgag uhk al `ks rlqubsbtks sl alcl rlg`bzgruhg prulcg dkrrlspkhablhtl(
@g slddbh al rlqubsbtks bhd`ubr bhokrjgdbhskcrl l` prkpsbtk, ouhdbh, rlhabjblhtk,sleurbaga y rlqubsbtks al abslk(
7/27/2019 Validacion Hoja clculo Excel
11/25
Liljp`kVgrg l` d`du`k al uhg mkig al d`du`k al rlerlsbh `bhlg`, slalsdrbclh `ks sbeublhtls pgrjltrks9 Hjlrk jhbjk al lhtrgags qul sl bhd`ubrh -pkr
liljp`k, 76" D`du`k gutkjtbdk al `g plhablhtl y `g kralhgag lh l`
krbelh al `g rlerlsbh `bhlg` al gdulrak dkh `g ldugdbhutb`bzgag(
D`du`k gutkjtbdk al `g alsvbgdbh lsthagr al gdulrakdkh `g ldugdbh utb`bzgak(
Dkjprkcgdbh gutkjtbdg pgrg altlrjbhgr sb l`bhtlrdlptk y `g alsvbgdbh lsthagr dujp`br dkh `ksdrbtlrbks al gdlptgdbh alobhbaks(
Vrktlddbh al tkags `gs dl`ags, akhal hk obeurgrh agtks(
7/27/2019 Validacion Hoja clculo Excel
12/25
ABTLK
L` dkhtlhbak k orju`gs qul skh lslhdbg`lspgrg dujp`br `ks rlqubsbtks al `gs dl`ags(
@gs dl`ags qul slrh prktlebags(
@g slddbh al abslk bhd`ubr bhokrjgdbh skcrl l`prkpsbtk, l` o`uik al agtks, okrjgtks al mkig al agtks , `g
sldulhdbg lh `g qulsl ``lvgr g dgck l` d`du`k(
7/27/2019 Validacion Hoja clculo Excel
13/25
VS\LCGT
@gs prulcgs dkh dgsks dkhkdbaks y agtks, bhd`uylhak `ks
rlsu`tgaks dkhkdbaks tblhlh qul slr alsgrrk``gaks(
L` dkhiuhtk al agtks utb`bzgaks pgrg prulcg alcl bhd`ubr `ksrlprlslhtgtbvks(
Alclh bhd`ubr `ks dkhiuhtks al agtks qul pkharh g prulcg`ks vg`krls qul lxdlalh l` rghek lsplrgak al kplrgdbkhlshkrjg`ls y dkjprkcgr `ks agtks dlrdg al `ks `jbtls al `ks
drbtlrbks al gdlptgdbh(
Bhd`ubr bhokrjgdbh skcrl l` prkpsbtk, `g akdujlhtgdbh alprulcg, rlvbsbh y gprkcgdbh, l` p`gh al prulcg okrjg`, y
lildudbh al `g prulcg(
7/27/2019 Validacion Hoja clculo Excel
14/25
@g prulcg js sbjp`l pgrg vg`bagr uhg mkig ald`du`k ls rlg`bzgr uh d`du`k jghug` yakdujlhtgr`k(
Qkags `gs prulcgs rlg`bzgags, `ks rlsu`tgakslsplrgaks, `ks drbtlrbks al gdlptgdbh al `gs prulcgsy prkdlabjblhtk pgrg l` d`du`k g`tlrhgtbvk -pkrliljp`k, l` d`du`k jghug`" alclrh slrakdujlhtgaks(
@gs plrskhgs qul ``lvgh g dgck `gs prulcgs tblhlhqul slr lhtrlhgaks gprkpbgagjlhtl y alclh slrjlhdbkhgags lh `g akdujlhtgdbh(
7/27/2019 Validacion Hoja clculo Excel
15/25
Akdujlhtgdbh al tkak l` prkdlabjblhtkal prulcg alcl tlhlr uhg dkpbg bjprlsg altkaks `ks rlsu`tgaks kctlhbaks dkh `g mkig
al d`du`k, gs dkjk `ks rlsu`tgakskctlhbaks dkh l` d`du`k g`tlrhgtbvk(
7/27/2019 Validacion Hoja clculo Excel
16/25
TLE\SBAGA
\sk al `gs dkhtrgslgs pgrg `gs d`u`gs, mkigs al d`du`k y + k uhgdkjcbhgdbh al mkigs al d`du`k( -Dkpbg"
Vrkdlabjblhtk pgrg `g gsbehgdbh al `gs dkhtrgslgs(
Eugragr `g mkig al d`du`k -jgstlr" s`k lh uhbagals sleurgsakhal s`k gutkrbzgaks `gs plrskhgs tlhegh gddlsk(
Slg`bzgdbh al uhg dkpbg al sleurbaga(
@g alsdrbpdbh al `g sleurbaga bhd`ubr bhokrjgdbh
gdlrdg al sleurbaga osbdg y `ebdg( @ks prkdlabjblhtks al sleurbaga tblhlh qul slr
akdujlhtgaks(
7/27/2019 Validacion Hoja clculo Excel
17/25
@g lstrgtlebg al sleurbaga alcl egrghtbzgrqul `gs dl`ags qul dkhtblhlh orju`gs al`g mkig al d`du`k hk sl pulalhskcrlsdrbcbr(
@gs mkigs al d`du`k vg`bagaks alclhg`jgdlhgrsl lh uhg uhbaga al prktlddbhg `g qul s`k tblhlh gddlsk l` plrskhg`gutkrbzgak(
7/27/2019 Validacion Hoja clculo Excel
18/25
AKD\JLHQGDBH VGSG L@\T\GSBK R DGVGDBQGDBH
Bhd`ubr bhokrjgdbh skcrl l` prkpsbtk, `gsrlspkhsgcb`bagals y rlebstrks al dgpgdbtgdbh(
Tl alcl lxp`bdgr l` usk al `g mkig al d`du`k,su ouhdbh, `gs orju`gs utb`bzgags, `g
`kdg`bzgdbh al `gs p`ghtb``gs sleurgs, y l`hkjcrl al grdmbvk y `g rutg g utb`bzgr pgrgeugragr l` okrju`grbk dkjp`ltk(
7/27/2019 Validacion Hoja clculo Excel
19/25
DGJCBKT R DKHQSK@ AL _LSTBKHLT
Alsdrbpdbh al `ks dgjcbks
@g plrskhg qul ``lvg g dgck l` dgjcbk
Oldmg lh qul sl dkjp`lt l` dgjcbk(
@ks dgjcbks y `g slddbh al dkhtrk` al vlrsbkhls bhd`ubrh bhokrjgdbh skcrlprkpsbtk, `gs rlspkhsgcb`bagals, y `gs prulcgs( @ks dgjcbks lh l` sbstljg kplrgtbvk y + k lh Lxdl` tblhl slr akdujlhtgak,
rlvbsgak y gprkcgak(
7/27/2019 Validacion Hoja clculo Excel
20/25
@g plrskhg qul rlg`bzg `g prulcg alspus al` dgjcbk(
Oldmg al `g `tbjg prulcg
@gs mkigs al d`du`k tlhar uh balhtbobdgakr hbdk -pkrliljp`k, hkjcrl al grdmbvk y l` hjlrk al vlrsbh"(
Qkaks `ks dgjcbks al `g mkig al d`du`k tblhl qul slrakdujlhtgak lh uh mbstkrbg` al` akdujlhtk(
Dgag dgjcbk sbehbobdgtbvk, rlqulrbr rlvg`bagdbh al `g mkig ald`du`k(
7/27/2019 Validacion Hoja clculo Excel
21/25
Slvg`bagdbh al `g mkigal dg`du`k rlqulrbag
Dgjcbk g uhg orju`g kjgdrk
Gabdbh k l`bjbhgdbhal uhg orju`g k jgdrk
Gdtug`bzgdbh al`skotwgrl Lxdl`
Vrulcgs al gdtug`bzgdbh
al` sbstljg kplrgtbvk
Slvg`bagdbh al `g mkigal dg`du`k hk rlqulrbag
Dgjcbk al kralhgakr
Dgjcbk al jkhbtkr al`g dkjputgakrg
Dgjcbk al tld`gak al`kralhgakr
Dgjcbk al rgth al`
kralhgakr
7/27/2019 Validacion Hoja clculo Excel
22/25
GSDMB_K
Qblhl qul slr alobhbak qul `ks agtks qul slelhlrgh aurghtl `g vg`bagdbh al `g mkig al d`du`ksl d`gsbobdg dkjk agtks lh crutk k rlsu`tgaks ygslgh l`ldtrhbdks k lh uhg dkpbg bjprlsg(
@ks agtks lh crutk y tkaks `ks agtks y akdujlhtksqul sl mgh elhlrgak aurghtl `g vg`bagdbh alclslr grdmbvgag(
Bhd`ubr bhokrjgdbh skcrl l` prkpsbtk, `g d`gsbobdgdbh alrlebstrk, y `g ucbdgdbh al` grdmbvk -s"(
7/27/2019 Validacion Hoja clculo Excel
23/25
SL_BTBH VLSBABDG
@gs prulcgs al `gs ouhdbkhls al `g mkig al d`du`kalcl slr rlvbsgak aurghtl `g rlvbsbh plrbabdg(
@gs prulcgs prlvbstgs, `ks rlsu`tgaks lsplrgaks ydrbtlrbks al gdlptgdbh alclh slr lspldbobdgaks(
Bhd`uyl `g bhokrjgdbh skcrl l` prkpsbtk, prkdlsk,y l` bhtlrvg`k al rlvbsbh plrbabdg(
L B B R
7/27/2019 Validacion Hoja clculo Excel
24/25
SL_BTB H RGVSKCGDBH
Qkaks `ks akdujlhtks al vg`bagdbh alclh slr rlvbsgaks y
gprkcgaks dkh `g pgrtbdbpgdbh al `g uhbaga algsleurgjblhtk al `g dg`baga(
7/27/2019 Validacion Hoja clculo Excel
25/25
Galjs alcl dkhtlhlr9 V`gh al dkhtbhelhdbgs al hlekdbks, dughak `g mkig al
d`du`k hk lst abspkhbc`l -pkr liljp`k, alcbak g `gprkc`ljgs al rla"(
V`gh jglstrk al vg`bagdbh -pkr liljp`k, sb vgrbgs mkigs ald`du`k sbjb`grls alclh slr vg`bagaks"
Vrkdlabjblhtk -s" y `g akdujlhtgdbh al `g dgpgdbtgdbhal `ks usugrbks