尊敬的 微信汇率:1円 ≈ 0.046166 元 支付宝汇率:1円 ≈ 0.046257元 [退出登录]
SlideShare a Scribd company logo
ANEXOS
ORGANIGRAMA DE LA EMPRESA
PRESIDENTE DEL
DIRECTORIO
GERENTE GENERAL
CONSULTORIA
INTERNA
JEFE DE
LABORATORIOS
JEFE DE PLANTA
LATEX
GERENTE
PRODUCCION
JEFE DE PLANTA
RESINAS
GERENTE DE VENTAS
RESINAS
SUPERINTENDENTE
DE PROD. HOGAR,
ADHESIVOS Y
SOLVENTES
GERENTE DE
MARKETING
JEFE DE PLANTA
PINTURAS VARIAS
CAJA
SERVICIO AL
CLIENTE
CREDITOS
GERENCIA DE
LOGISTICA GERENTE DE VENTAS
COMERCIO Y
SEGURIDAD
GERENTE DE VENTAS
PRODUCTOS DEL
HOGAR Y PROVINCIA
GERENTE DE VENTAS
INDUSTRIAS
JEFE DE
ALMACENES
JEFE DE
LABORATORIO
ADHESIVOS
JEFE DE
LABORATORIO
PINTURAS
JEFE DE CONTROL
DE CALIDAD
JEFE
LABORATORIO DE
PROD. HOGAR Y
SECRETARIA
GERENTE
FINANCIERO
ASISTENTE
RR.II
JEFE DE SISTEMAS
JEFE DE SOPORTE
DATA ENTRADA VIA MICROSOFT QRY 32
Numero Documento
Referencia
Motivo IS Articulo Planta Codigo Linea Codigo Articulo Codigo Presentacion Tipo
Articulo
Ano
Registro
Mes
Registro
Dia Registro Cantidad
Atendida
Formula
Base
Proceso
TOTAL
0159530 PR R01 MPR K16445 UNI PI 2001 1 5 380 R85 0
0159522 PR R01 MPR R70028 UNI PI 2001 1 5 630 A03 0
0159658 PR R01 MPR R70037 UNI PI 2001 1 5 3257 A13 0
0159773 PR R01 MPR K16180 UNI PI 2001 1 5 2215 R66 0
0159780 PR R01 MPR R30416 UNI PI 2001 1 5 9288 R17 0
0159739 PR R01 MPR R30536 UNI PI 2001 1 6 12084 R71 0
0159778 PR R01 MPR R30894 UNI PI 2001 1 6 7190 R71 0
0159734 PR R01 054 0015 001 PT 2001 1 6 66 R78 13200
0159808 PR R01 MPR R70013 UNI PI 2001 1 6 4139 A02 0
0159807 PR R01 MPR R30874 UNI PI 2001 1 8 8456 R17 0
0159884 PR R01 051 0007 001 PT 2001 1 8 1 P99 200
0159899 PR R01 126 0069 002 PT 2001 1 8 11 P99 2200
0159898 PR R01 126 0070 002 PT 2001 1 8 5 P99 1000
0159660 PR R01 051 0032 001 PT 2001 1 8 40 R79 8000
0159660 PR R01 051 0032 010 PT 2001 1 8 2 R79 40
0159893 PR R01 MPR R30886 UNI PI 2001 1 8 53 P99 0
0159911 PR R01 054 0068 001 PT 2001 1 8 5 P99 1000
OBTENCION DE RESULTADOS DE DATA ENTRADA VIA MICROSOFT QRY 32
u Unida
des
Total(
Lt-Kg)
Extr
aer
Decision
_1
Decisio
n_2
Articul
o
LA LAP_1 LAP Factor
Proce
so
Factor
Envas
ado
UEQ
PROC_1
UEQ
PROCESO
UEQ
ENVASA
D
TOTAL
UEQ
STD
PROCES
O
STD
ENVA
SA
HR
PROCE
SO
HR
ENVA
SADO
1.9 380 K16 K16445 K16445 K16445 K16445 K16445 K16445 17.684 21.711 6,720.00 1,680.00 41.25 1,721.25 84.44 12.00 4.50 0.16
3.15 630 R70 R70028 R70028 R70028 R70028 R70028 R70028 16.800 41.684 10,584.00 2,646.00 131.31 2,777.31 88.89 6.25 7.09 0.50
16.285 3257 R70 R70037 R70037 R70037 R70037 R70037 R70037 6.922 41.684 22,545.68 5,636.42 678.83 6,315.25 215.73 6.25 15.10 2.61
11.075 2215 K16 K16180 K16180 K16180 K16180 K16180 K16180 4.779 41.684 10,584.75 2,646.19 461.65 3,107.84 312.50 6.25 7.09 1.77
46.44 9288 R30 R30416 R30416 R30416 R30416 R30416 R30416 3.787 41.684 35,177.74 8,794.43 1,935.82 10,730.25 394.29 6.25 23.56 7.43
60.42 12084 R30 R30536 R30536 R30536 R30536 R30536 R30536 9.707 41.684 117,295.36 29,323.84 2,518.56 31,842.40 153.85 6.25 78.55 9.67
35.95 7190 R30 R30894 R30894 R30894 R30894 R30894 R30894 0.747 20.842 5,368.53 1,342.13 749.27 2,091.41 2,000.00 12.50 3.60 2.88
66 13200 001 FALSO FALSO 0015 0540015 0540015001 0540015001 5.206 72.369 68,717.67 17,179.42 4,776.32 21,955.74 286.85 3.60 46.02 18.33
20.695 4139 R70 R70013 R70013 R70013 R70013 R70013 R70013 7.467 41.684 30,904.53 7,726.13 862.66 8,588.79 200.00 6.25 20.70 3.31
42.28 8456 R30 R30874 R30874 R30874 R30874 R30874 R30874 3.052 41.684 25,806.46 6,451.61 1,762.41 8,214.03 489.32 6.25 17.28 6.76
1 200 000 FALSO FALSO 0007 0510007 0510007001 0510007001 6.922 41.684 1,384.43 346.11 41.68 387.79 215.73 6.25 0.93 0.16
11 2200 006 FALSO FALSO 0069 1260069 1260069002 1260069002 2.489 45.706 5,475.56 1,368.89 502.77 1,871.66 600.00 5.70 3.67 1.93
5 1000 007 FALSO FALSO 0070 1260070 1260070002 1260070002 7.467 41.684 7,466.67 1,866.67 208.42 2,075.09 200.00 6.25 5.00 0.80
40 8000 003 FALSO FALSO 0032 0510032 0510032001 0510032001 3.289 41.684 26,311.11 6,577.78 1,667.37 8,245.15 454.05 6.25 17.62 6.40
2 40 003 FALSO FALSO 0032 0510032 0510032010 0510032010 3.289 5.531 131.56 32.89 11.06 43.95 454.05 47.10 0.09 0.04
0.265 53 R30 R30886 R30886 R30886 R30886 R30886 R30886 0.000 41.684 0.00 0.00 11.05 11.05 0.00 6.25 0.00 0.04
5 1000 006 FALSO FALSO 0068 0540068 0540068001 0540068001 5.204 43.421 5,204.04 1,301.01 217.11 1,518.12 286.96 6.00 3.48 0.83
MUESTRA DE FORMULACION PARA OBTENCION DE RESULTADOS VIA EXCEL
grup Unidades Total(Lt-Kg) Extraer Decision_1 Decision_2
"R01","RE", =SI(G2="PI",K2/200,K2) =SI(G2="PI",K2,M2) =EXTRAE(E2,1,3) =SI(G2="PI",SI(Q2="A10",E2,SI(Q2="K16",E2,SI(Q2="K70",E2,SI(Q2="M77",E2,SI(Q2="O13",E2,SI(Q2="R30",E2,SI(Q2
="R70",E2,"ELIMINAR"))))))))
=SI(G2="PI",SI(Q2="S21",E2,SI(Q2="Z60",E2,SI(Q2="Z70",E2,R2))))
"R01","RE", =SI(G3="PI",K3/200,K3) =SI(G3="PI",K3,M3) =EXTRAE(E3,1,3) =SI(G3="PI",SI(Q3="A10",E3,SI(Q3="K16",E3,SI(Q3="K70",E3,SI(Q3="M77",E3,SI(Q3="O13",E3,SI(Q3="R30",E3,SI(Q3
="R70",E3,"ELIMINAR"))))))))
=SI(G3="PI",SI(Q3="S21",E3,SI(Q3="Z60",E3,SI(Q3="Z70",E3,R3))))
"R01","RE", =SI(G4="PI",K4/200,K4) =SI(G4="PI",K4,M4) =EXTRAE(E4,1,3) =SI(G4="PI",SI(Q4="A10",E4,SI(Q4="K16",E4,SI(Q4="K70",E4,SI(Q4="M77",E4,SI(Q4="O13",E4,SI(Q4="R30",E4,SI(Q4
="R70",E4,"ELIMINAR"))))))))
=SI(G4="PI",SI(Q4="S21",E4,SI(Q4="Z60",E4,SI(Q4="Z70",E4,R4))))
"R01","RE", =SI(G5="PI",K5/200,K5) =SI(G5="PI",K5,M5) =EXTRAE(E5,1,3) =SI(G5="PI",SI(Q5="A10",E5,SI(Q5="K16",E5,SI(Q5="K70",E5,SI(Q5="M77",E5,SI(Q5="O13",E5,SI(Q5="R30",E5,SI(Q5
="R70",E5,"ELIMINAR"))))))))
=SI(G5="PI",SI(Q5="S21",E5,SI(Q5="Z60",E5,SI(Q5="Z70",E5,R5))))
"R01","RE", =SI(G6="PI",K6/200,K6) =SI(G6="PI",K6,M6) =EXTRAE(E6,1,3) =SI(G6="PI",SI(Q6="A10",E6,SI(Q6="K16",E6,SI(Q6="K70",E6,SI(Q6="M77",E6,SI(Q6="O13",E6,SI(Q6="R30",E6,SI(Q6
="R70",E6,"ELIMINAR"))))))))
=SI(G6="PI",SI(Q6="S21",E6,SI(Q6="Z60",E6,SI(Q6="Z70",E6,R6))))
"R01","RE", =SI(G7="PI",K7/200,K7) =SI(G7="PI",K7,M7) =EXTRAE(E7,1,3) =SI(G7="PI",SI(Q7="A10",E7,SI(Q7="K16",E7,SI(Q7="K70",E7,SI(Q7="M77",E7,SI(Q7="O13",E7,SI(Q7="R30",E7,SI(Q7
="R70",E7,"ELIMINAR"))))))))
=SI(G7="PI",SI(Q7="S21",E7,SI(Q7="Z60",E7,SI(Q7="Z70",E7,R7))))
"R01","RE", =SI(G8="PI",K8/200,K8) =SI(G8="PI",K8,M8) =EXTRAE(E8,1,3) =SI(G8="PI",SI(Q8="A10",E8,SI(Q8="K16",E8,SI(Q8="K70",E8,SI(Q8="M77",E8,SI(Q8="O13",E8,SI(Q8="R30",E8,SI(Q8
="R70",E8,"ELIMINAR"))))))))
=SI(G8="PI",SI(Q8="S21",E8,SI(Q8="Z60",E8,SI(Q8="Z70",E8,R8))))
"R01","RE", =SI(G9="PI",K9/200,K9) =SI(G9="PI",K9,M9) =EXTRAE(E9,1,3) =SI(G9="PI",SI(Q9="A10",E9,SI(Q9="K16",E9,SI(Q9="K70",E9,SI(Q9="M77",E9,SI(Q9="O13",E9,SI(Q9="R30",E9,SI(Q9
="R70",E9,"ELIMINAR"))))))))
=SI(G9="PI",SI(Q9="S21",E9,SI(Q9="Z60",E9,SI(Q9="Z70",E9,R9))))
="R01","RE =SI(G10="PI",K10/200,K10) =SI(G10="PI",K10,M10) =EXTRAE(E10,1,3) =SI(G10="PI",SI(Q10="A10",E10,SI(Q10="K16",E10,SI(Q10="K70",E10,SI(Q10="M77",E10,SI(Q10="O13",E10,SI(Q10="
R30",E10,SI(Q10="R70",E10,"ELIMINAR"))))))))
=SI(G10="PI",SI(Q10="S21",E10,SI(Q10="Z60",E10,SI(Q10="Z70",E10
="R01","RE =SI(G11="PI",K11/200,K11) =SI(G11="PI",K11,M11) =EXTRAE(E11,1,3) =SI(G11="PI",SI(Q11="A10",E11,SI(Q11="K16",E11,SI(Q11="K70",E11,SI(Q11="M77",E11,SI(Q11="O13",E11,SI(Q11="
R30",E11,SI(Q11="R70",E11,"ELIMINAR"))))))))
=SI(G11="PI",SI(Q11="S21",E11,SI(Q11="Z60",E11,SI(Q11="Z70",E11
="R01","RE =SI(G12="PI",K12/200,K12) =SI(G12="PI",K12,M12) =EXTRAE(E12,1,3) =SI(G12="PI",SI(Q12="A10",E12,SI(Q12="K16",E12,SI(Q12="K70",E12,SI(Q12="M77",E12,SI(Q12="O13",E12,SI(Q12="
R30",E12,SI(Q12="R70",E12,"ELIMINAR"))))))))
=SI(G12="PI",SI(Q12="S21",E12,SI(Q12="Z60",E12,SI(Q12="Z70",E12
="R01","RE =SI(G13="PI",K13/200,K13) =SI(G13="PI",K13,M13) =EXTRAE(E13,1,3) =SI(G13="PI",SI(Q13="A10",E13,SI(Q13="K16",E13,SI(Q13="K70",E13,SI(Q13="M77",E13,SI(Q13="O13",E13,SI(Q13="
R30",E13,SI(Q13="R70",E13,"ELIMINAR"))))))))
=SI(G13="PI",SI(Q13="S21",E13,SI(Q13="Z60",E13,SI(Q13="Z70",E13
="R01","RE =SI(G14="PI",K14/200,K14) =SI(G14="PI",K14,M14) =EXTRAE(E14,1,3) =SI(G14="PI",SI(Q14="A10",E14,SI(Q14="K16",E14,SI(Q14="K70",E14,SI(Q14="M77",E14,SI(Q14="O13",E14,SI(Q14="
R30",E14,SI(Q14="R70",E14,"ELIMINAR"))))))))
=SI(G14="PI",SI(Q14="S21",E14,SI(Q14="Z60",E14,SI(Q14="Z70",E14
="R01","RE =SI(G15="PI",K15/200,K15) =SI(G15="PI",K15,M15) =EXTRAE(E15,1,3) =SI(G15="PI",SI(Q15="A10",E15,SI(Q15="K16",E15,SI(Q15="K70",E15,SI(Q15="M77",E15,SI(Q15="O13",E15,SI(Q15="
R30",E15,SI(Q15="R70",E15,"ELIMINAR"))))))))
=SI(G15="PI",SI(Q15="S21",E15,SI(Q15="Z60",E15,SI(Q15="Z70",E15
="R01","RE =SI(G16="PI",K16/200,K16) =SI(G16="PI",K16,M16) =EXTRAE(E16,1,3) =SI(G16="PI",SI(Q16="A10",E16,SI(Q16="K16",E16,SI(Q16="K70",E16,SI(Q16="M77",E16,SI(Q16="O13",E16,SI(Q16="
R30",E16,SI(Q16="R70",E16,"ELIMINAR"))))))))
=SI(G16="PI",SI(Q16="S21",E16,SI(Q16="Z60",E16,SI(Q16="Z70",E16
="R01","RE =SI(G17="PI",K17/200,K17) =SI(G17="PI",K17,M17) =EXTRAE(E17,1,3) =SI(G17="PI",SI(Q17="A10",E17,SI(Q17="K16",E17,SI(Q17="K70",E17,SI(Q17="M77",E17,SI(Q17="O13",E17,SI(Q17="
R30",E17,SI(Q17="R70",E17,"ELIMINAR"))))))))
=SI(G17="PI",SI(Q17="S21",E17,SI(Q17="Z60",E17,SI(Q17="Z70",E17
="R01","RE =SI(G18="PI",K18/200,K18) =SI(G18="PI",K18,M18) =EXTRAE(E18,1,3) =SI(G18="PI",SI(Q18="A10",E18,SI(Q18="K16",E18,SI(Q18="K70",E18,SI(Q18="M77",E18,SI(Q18="O13",E18,SI(Q18="
R30",E18,SI(Q18="R70",E18,"ELIMINAR"))))))))
=SI(G18="PI",SI(Q18="S21",E18,SI(Q18="Z60",E18,SI(Q18="Z70",E18
MUESTRA DE FORMULACION PARA OBTENCION DE RESULTADOS VIA EXCEL
r Proceso Factor Envasado UEQ PROC_1 UEQ PROCESO UEQ ENVASAD TOTAL UEQ STD PROCESO STD ENVASA HR PROCESO HR ENVASADO TOTAL HR UEQ
2="ELIMINAR",0,BUS
(U2,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W2="ELIMINAR",0
,BUSCARV(W2,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X2=0,0,P2*X2) =+Z2/4 =SI(Y2=0,0,Y2*O2) =+AA2+AB2 =SI(X2<>0,1493.333333/X2,0) =SI(Y2<>0,260.5267/Y2,
0)
=SI(AD2<>0,P2/
AD2,0)
=SI(AE2<>0,O2/AE2,0) =+AF2+AG2
3="ELIMINAR",0,BUS
(U3,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W3="ELIMINAR",0
,BUSCARV(W3,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X3=0,0,P3*X3) =+Z3/4 =SI(Y3=0,0,Y3*O3) =+AA3+AB3 =SI(X3<>0,1493.333333/X3,0) =SI(Y3<>0,260.5267/Y3,
0)
=SI(AD3<>0,P3/
AD3,0)
=SI(AE3<>0,O3/AE3,0) =+AF3+AG3
4="ELIMINAR",0,BUS
(U4,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W4="ELIMINAR",0
,BUSCARV(W4,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X4=0,0,P4*X4) =+Z4/4 =SI(Y4=0,0,Y4*O4) =+AA4+AB4 =SI(X4<>0,1493.333333/X4,0) =SI(Y4<>0,260.5267/Y4,
0)
=SI(AD4<>0,P4/
AD4,0)
=SI(AE4<>0,O4/AE4,0) =+AF4+AG4
5="ELIMINAR",0,BUS
(U5,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W5="ELIMINAR",0
,BUSCARV(W5,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X5=0,0,P5*X5) =+Z5/4 =SI(Y5=0,0,Y5*O5) =+AA5+AB5 =SI(X5<>0,1493.333333/X5,0) =SI(Y5<>0,260.5267/Y5,
0)
=SI(AD5<>0,P5/
AD5,0)
=SI(AE5<>0,O5/AE5,0) =+AF5+AG5
6="ELIMINAR",0,BUS
(U6,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W6="ELIMINAR",0
,BUSCARV(W6,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X6=0,0,P6*X6) =+Z6/4 =SI(Y6=0,0,Y6*O6) =+AA6+AB6 =SI(X6<>0,1493.333333/X6,0) =SI(Y6<>0,260.5267/Y6,
0)
=SI(AD6<>0,P6/
AD6,0)
=SI(AE6<>0,O6/AE6,0) =+AF6+AG6
7="ELIMINAR",0,BUS
(U7,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W7="ELIMINAR",0
,BUSCARV(W7,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X7=0,0,P7*X7) =+Z7/4 =SI(Y7=0,0,Y7*O7) =+AA7+AB7 =SI(X7<>0,1493.333333/X7,0) =SI(Y7<>0,260.5267/Y7,
0)
=SI(AD7<>0,P7/
AD7,0)
=SI(AE7<>0,O7/AE7,0) =+AF7+AG7
8="ELIMINAR",0,BUS
(U8,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W8="ELIMINAR",0
,BUSCARV(W8,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X8=0,0,P8*X8) =+Z8/4 =SI(Y8=0,0,Y8*O8) =+AA8+AB8 =SI(X8<>0,1493.333333/X8,0) =SI(Y8<>0,260.5267/Y8,
0)
=SI(AD8<>0,P8/
AD8,0)
=SI(AE8<>0,O8/AE8,0) =+AF8+AG8
9="ELIMINAR",0,BUS
(U9,'C:Edwardtekno
ador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W9="ELIMINAR",0
,BUSCARV(W9,'C:Ed
wardtekno[Indicador
Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X9=0,0,P9*X9) =+Z9/4 =SI(Y9=0,0,Y9*O9) =+AA9+AB9 =SI(X9<>0,1493.333333/X9,0) =SI(Y9<>0,260.5267/Y9,
0)
=SI(AD9<>0,P9/
AD9,0)
=SI(AE9<>0,O9/AE9,0) =+AF9+AG9
10="ELIMINAR",0,BU
V(U10,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W10="ELIMINAR",
0,BUSCARV(W10,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X10=0,0,P10*X10) =+Z10/4 =SI(Y10=0,0,Y10*O10) =+AA10+AB10 =SI(X10<>0,1493.333333/X10,
0)
=SI(Y10<>0,260.5267/Y1
0,0)
=SI(AD10<>0,P1
0/AD10,0)
=SI(AE10<>0,O10/AE10,
0)
=+AF10+AG10
11="ELIMINAR",0,BU
V(U11,'C:Edwardtek
dicador
=SI(W11="ELIMINAR",
0,BUSCARV(W11,'C:
Edwardtekno[Indicad
=SI(X11=0,0,P11*X11) =+Z11/4 =SI(Y11=0,0,Y11*O11) =+AA11+AB11 =SI(X11<>0,1493.333333/X11,
0)
=SI(Y11<>0,260.5267/Y1
1,0)
=SI(AD11<>0,P1
1/AD11,0)
=SI(AE11<>0,O11/AE11,
0)
=+AF11+AG11
as.xls]BASE
$D$3:$T$4172,17,0))
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
12="ELIMINAR",0,BU
V(U12,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W12="ELIMINAR",
0,BUSCARV(W12,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X12=0,0,P12*X12) =+Z12/4 =SI(Y12=0,0,Y12*O12) =+AA12+AB12 =SI(X12<>0,1493.333333/X12,
0)
=SI(Y12<>0,260.5267/Y1
2,0)
=SI(AD12<>0,P1
2/AD12,0)
=SI(AE12<>0,O12/AE12,
0)
=+AF12+AG12
13="ELIMINAR",0,BU
V(U13,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W13="ELIMINAR",
0,BUSCARV(W13,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X13=0,0,P13*X13) =+Z13/4 =SI(Y13=0,0,Y13*O13) =+AA13+AB13 =SI(X13<>0,1493.333333/X13,
0)
=SI(Y13<>0,260.5267/Y1
3,0)
=SI(AD13<>0,P1
3/AD13,0)
=SI(AE13<>0,O13/AE13,
0)
=+AF13+AG13
14="ELIMINAR",0,BU
V(U14,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W14="ELIMINAR",
0,BUSCARV(W14,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X14=0,0,P14*X14) =+Z14/4 =SI(Y14=0,0,Y14*O14) =+AA14+AB14 =SI(X14<>0,1493.333333/X14,
0)
=SI(Y14<>0,260.5267/Y1
4,0)
=SI(AD14<>0,P1
4/AD14,0)
=SI(AE14<>0,O14/AE14,
0)
=+AF14+AG14
15="ELIMINAR",0,BU
V(U15,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W15="ELIMINAR",
0,BUSCARV(W15,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X15=0,0,P15*X15) =+Z15/4 =SI(Y15=0,0,Y15*O15) =+AA15+AB15 =SI(X15<>0,1493.333333/X15,
0)
=SI(Y15<>0,260.5267/Y1
5,0)
=SI(AD15<>0,P1
5/AD15,0)
=SI(AE15<>0,O15/AE15,
0)
=+AF15+AG15
16="ELIMINAR",0,BU
V(U16,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W16="ELIMINAR",
0,BUSCARV(W16,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X16=0,0,P16*X16) =+Z16/4 =SI(Y16=0,0,Y16*O16) =+AA16+AB16 =SI(X16<>0,1493.333333/X16,
0)
=SI(Y16<>0,260.5267/Y1
6,0)
=SI(AD16<>0,P1
6/AD16,0)
=SI(AE16<>0,O16/AE16,
0)
=+AF16+AG16
17="ELIMINAR",0,BU
V(U17,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W17="ELIMINAR",
0,BUSCARV(W17,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X17=0,0,P17*X17) =+Z17/4 =SI(Y17=0,0,Y17*O17) =+AA17+AB17 =SI(X17<>0,1493.333333/X17,
0)
=SI(Y17<>0,260.5267/Y1
7,0)
=SI(AD17<>0,P1
7/AD17,0)
=SI(AE17<>0,O17/AE17,
0)
=+AF17+AG17
18="ELIMINAR",0,BU
V(U18,'C:Edwardtek
dicador
as.xls]BASE
$D$3:$T$4172,17,0))
=SI(W18="ELIMINAR",
0,BUSCARV(W18,'C:
Edwardtekno[Indicad
or Resinas.xls]BASE
UEQ'!$F$3:$X$4172,1
9,0))
=SI(X18=0,0,P18*X18) =+Z18/4 =SI(Y18=0,0,Y18*O18) =+AA18+AB18 =SI(X18<>0,1493.333333/X18,
0)
=SI(Y18<>0,260.5267/Y1
8,0)
=SI(AD18<>0,P1
8/AD18,0)
=SI(AE18<>0,O18/AE18,
0)
=+AF18+AG18

More Related Content

Similar to anexos.pdf

Presentación energía linea industrial
Presentación energía linea industrialPresentación energía linea industrial
Presentación energía linea industrial
GUSTAVO HURTADO
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
fusjekmdjdud3e
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
f8usjekdkdmmd
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
fjksekmmdm
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
jjkdmsmmd
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
f8usejdkddmmd
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
f8suejjdkddmmd
 
SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2
SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2
SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2
Reinaldo Leopoldo
 
JDA Analyst Guidance
JDA Analyst GuidanceJDA Analyst Guidance
JDA Analyst Guidance
Scott Pickering
 
Cp 24062018 2241
Cp 24062018 2241Cp 24062018 2241
Cp 24062018 2241
Shze Hwa Lee
 
Beauty clinic (Business Loan) urdu
Beauty clinic (Business Loan) urduBeauty clinic (Business Loan) urdu
Beauty clinic (Business Loan) urdu
kmjahanger
 
Harmonic csg lw_spechseet
Harmonic csg lw_spechseetHarmonic csg lw_spechseet
Harmonic csg lw_spechseet
Electromate
 
Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...
Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...
Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...
aniruudha banhatti
 
Gpz bearing catalogue
Gpz bearing catalogueGpz bearing catalogue
Gpz bearing catalogue
Bearings Gpz
 
1999 infiniti qx4 service repair manual
1999 infiniti qx4 service repair manual1999 infiniti qx4 service repair manual
1999 infiniti qx4 service repair manual
fjjksekksemm
 
CATALOGO YUPP versión PDF
CATALOGO YUPP versión PDFCATALOGO YUPP versión PDF
CATALOGO YUPP versión PDF
Ronald Camacho Archila
 
Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...
Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...
Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...
Mercer Capital
 
Production forecast and fuel 2020 rev00.pdf
Production forecast and fuel 2020 rev00.pdfProduction forecast and fuel 2020 rev00.pdf
Production forecast and fuel 2020 rev00.pdf
ssuserb71d4d
 
Samsung Twin rotary compressor R-410A / R-22
Samsung Twin rotary compressor R-410A / R-22Samsung Twin rotary compressor R-410A / R-22
Samsung Twin rotary compressor R-410A / R-22
Haluk TOSUN
 
Unite steel drill pipe and tool joints
Unite steel drill pipe and tool jointsUnite steel drill pipe and tool joints
Unite steel drill pipe and tool joints
Shanghai Unite Steel
 

Similar to anexos.pdf (20)

Presentación energía linea industrial
Presentación energía linea industrialPresentación energía linea industrial
Presentación energía linea industrial
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
 
2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf2001 Infiniti G20 Service Repair Manual.pdf
2001 Infiniti G20 Service Repair Manual.pdf
 
SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2
SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2
SUPPLY CHAIN AND SOURCING_PROCUREMENT RAISING rev 2
 
JDA Analyst Guidance
JDA Analyst GuidanceJDA Analyst Guidance
JDA Analyst Guidance
 
Cp 24062018 2241
Cp 24062018 2241Cp 24062018 2241
Cp 24062018 2241
 
Beauty clinic (Business Loan) urdu
Beauty clinic (Business Loan) urduBeauty clinic (Business Loan) urdu
Beauty clinic (Business Loan) urdu
 
Harmonic csg lw_spechseet
Harmonic csg lw_spechseetHarmonic csg lw_spechseet
Harmonic csg lw_spechseet
 
Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...
Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...
Time Series Flow Forecasting Using Artificial Neural Networks for Brahmaputra...
 
Gpz bearing catalogue
Gpz bearing catalogueGpz bearing catalogue
Gpz bearing catalogue
 
1999 infiniti qx4 service repair manual
1999 infiniti qx4 service repair manual1999 infiniti qx4 service repair manual
1999 infiniti qx4 service repair manual
 
CATALOGO YUPP versión PDF
CATALOGO YUPP versión PDFCATALOGO YUPP versión PDF
CATALOGO YUPP versión PDF
 
Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...
Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...
Mercer Capital's Value Focus: FinTech Industry | Q1 2014 | Segment Focus: Tec...
 
Production forecast and fuel 2020 rev00.pdf
Production forecast and fuel 2020 rev00.pdfProduction forecast and fuel 2020 rev00.pdf
Production forecast and fuel 2020 rev00.pdf
 
Samsung Twin rotary compressor R-410A / R-22
Samsung Twin rotary compressor R-410A / R-22Samsung Twin rotary compressor R-410A / R-22
Samsung Twin rotary compressor R-410A / R-22
 
Unite steel drill pipe and tool joints
Unite steel drill pipe and tool jointsUnite steel drill pipe and tool joints
Unite steel drill pipe and tool joints
 

Recently uploaded

一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理
一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理
一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理
dykqbe
 
Self Discipline in life of a Salesperson.pptx
Self Discipline in life of a Salesperson.pptxSelf Discipline in life of a Salesperson.pptx
Self Discipline in life of a Salesperson.pptx
Sanjay Singh
 
Call Girls Hebbal 9880176850 Independent Escorts in Hebbal
Call Girls Hebbal 9880176850 Independent Escorts in HebbalCall Girls Hebbal 9880176850 Independent Escorts in Hebbal
Call Girls Hebbal 9880176850 Independent Escorts in Hebbal
ShinaKapoor
 
Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7
Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7
Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7
yashika sharman06
 
Zirconius -Corporate PPT FL Smidth- 2018 (1).pptx
Zirconius -Corporate PPT  FL Smidth- 2018 (1).pptxZirconius -Corporate PPT  FL Smidth- 2018 (1).pptx
Zirconius -Corporate PPT FL Smidth- 2018 (1).pptx
ShaliniChaudhary70
 
💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...
💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...
💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...
mishraaadhya326
 
🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available
🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available
🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available
janvi sharman06
 
169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You
169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You
169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You
gitachadda4 #v08
 
Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...
Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...
Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...
kavyasharma8889
 
Buy T-Shirts for Men Online at Best Price
Buy T-Shirts for Men Online at Best PriceBuy T-Shirts for Men Online at Best Price
Buy T-Shirts for Men Online at Best Price
janvi$L14
 
Reliable Online Power Tools Store - Shop Now
Reliable Online Power Tools Store - Shop NowReliable Online Power Tools Store - Shop Now
Reliable Online Power Tools Store - Shop Now
selco1985marketing
 
169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You
169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You
169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You
seemachadda260 #v08
 
Kalyan chart DP boss satta matka guessing
Kalyan chart DP boss satta matka guessingKalyan chart DP boss satta matka guessing
Kalyan chart DP boss satta matka guessing
➑➌➋➑➒➎➑➑➊➍
 
High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...
High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...
High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...
sonioberoi94
 
169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You
169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You
169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You
sivanichadda76 #v08
 
Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7
Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7
Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7
sexytaniya455
 
Escorts Service MG Road 9113698327 Independent Escorts in MG Road
Escorts Service MG Road 9113698327 Independent Escorts in MG RoadEscorts Service MG Road 9113698327 Independent Escorts in MG Road
Escorts Service MG Road 9113698327 Independent Escorts in MG Road
aroanasingh
 
Call Girls Yelahanka 9113698327 Independent Escorts in Yelahanka
Call Girls Yelahanka 9113698327 Independent Escorts in YelahankaCall Girls Yelahanka 9113698327 Independent Escorts in Yelahanka
Call Girls Yelahanka 9113698327 Independent Escorts in Yelahanka
ShinaKapoor
 
Sensory Toys: Fun and Educational Tools for Kids
Sensory Toys: Fun and Educational Tools for KidsSensory Toys: Fun and Educational Tools for Kids
Sensory Toys: Fun and Educational Tools for Kids
Diversity In Toys
 
Escorts Service Whitefield 9900341264 Independent Escorts in Whitefield
Escorts Service Whitefield 9900341264 Independent Escorts in WhitefieldEscorts Service Whitefield 9900341264 Independent Escorts in Whitefield
Escorts Service Whitefield 9900341264 Independent Escorts in Whitefield
aroanasingh
 

Recently uploaded (20)

一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理
一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理
一比一原版纽约理工大学毕业证(NYIT毕业证书)学历如何办理
 
Self Discipline in life of a Salesperson.pptx
Self Discipline in life of a Salesperson.pptxSelf Discipline in life of a Salesperson.pptx
Self Discipline in life of a Salesperson.pptx
 
Call Girls Hebbal 9880176850 Independent Escorts in Hebbal
Call Girls Hebbal 9880176850 Independent Escorts in HebbalCall Girls Hebbal 9880176850 Independent Escorts in Hebbal
Call Girls Hebbal 9880176850 Independent Escorts in Hebbal
 
Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7
Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7
Call Girls Gurgaon🔥9873777170🔥Luxury Escorts in Gurgaon Available 24/7
 
Zirconius -Corporate PPT FL Smidth- 2018 (1).pptx
Zirconius -Corporate PPT  FL Smidth- 2018 (1).pptxZirconius -Corporate PPT  FL Smidth- 2018 (1).pptx
Zirconius -Corporate PPT FL Smidth- 2018 (1).pptx
 
💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...
💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...
💚High Class Call Girls Delhi 💯Call Us 🔝 9873940964 🔝💃Top Class Call Girl Serv...
 
🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available
🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available
🔥Agra Call Girls 🫱 7023059433 🫲 High Class Independent Escorts Service Available
 
169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You
169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You
169+ Call Girls In Pune | 8824825030 | Reliability Escort Service Near You
 
Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...
Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...
Nehru Place Call Girls ~!☎️ 9899900591≼ (Call Girls Delhi) At Your Doorstep D...
 
Buy T-Shirts for Men Online at Best Price
Buy T-Shirts for Men Online at Best PriceBuy T-Shirts for Men Online at Best Price
Buy T-Shirts for Men Online at Best Price
 
Reliable Online Power Tools Store - Shop Now
Reliable Online Power Tools Store - Shop NowReliable Online Power Tools Store - Shop Now
Reliable Online Power Tools Store - Shop Now
 
169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You
169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You
169+ Call Girls In Mumbai | 9833363713 | Reliability Escort Service Near You
 
Kalyan chart DP boss satta matka guessing
Kalyan chart DP boss satta matka guessingKalyan chart DP boss satta matka guessing
Kalyan chart DP boss satta matka guessing
 
High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...
High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...
High Class Call Girls Chandigarh 🔥 7737669865 🔥 Real Fun With Sexual Girl Ava...
 
169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You
169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You
169+ Call Girls In Thane | 9920874524 | Reliability Escort Service Near You
 
Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7
Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7
Call Girls Vadodara 8824825030 Escort In Vadodara service 24X7
 
Escorts Service MG Road 9113698327 Independent Escorts in MG Road
Escorts Service MG Road 9113698327 Independent Escorts in MG RoadEscorts Service MG Road 9113698327 Independent Escorts in MG Road
Escorts Service MG Road 9113698327 Independent Escorts in MG Road
 
Call Girls Yelahanka 9113698327 Independent Escorts in Yelahanka
Call Girls Yelahanka 9113698327 Independent Escorts in YelahankaCall Girls Yelahanka 9113698327 Independent Escorts in Yelahanka
Call Girls Yelahanka 9113698327 Independent Escorts in Yelahanka
 
Sensory Toys: Fun and Educational Tools for Kids
Sensory Toys: Fun and Educational Tools for KidsSensory Toys: Fun and Educational Tools for Kids
Sensory Toys: Fun and Educational Tools for Kids
 
Escorts Service Whitefield 9900341264 Independent Escorts in Whitefield
Escorts Service Whitefield 9900341264 Independent Escorts in WhitefieldEscorts Service Whitefield 9900341264 Independent Escorts in Whitefield
Escorts Service Whitefield 9900341264 Independent Escorts in Whitefield
 

anexos.pdf

  • 1. ANEXOS ORGANIGRAMA DE LA EMPRESA PRESIDENTE DEL DIRECTORIO GERENTE GENERAL CONSULTORIA INTERNA JEFE DE LABORATORIOS JEFE DE PLANTA LATEX GERENTE PRODUCCION JEFE DE PLANTA RESINAS GERENTE DE VENTAS RESINAS SUPERINTENDENTE DE PROD. HOGAR, ADHESIVOS Y SOLVENTES GERENTE DE MARKETING JEFE DE PLANTA PINTURAS VARIAS CAJA SERVICIO AL CLIENTE CREDITOS GERENCIA DE LOGISTICA GERENTE DE VENTAS COMERCIO Y SEGURIDAD GERENTE DE VENTAS PRODUCTOS DEL HOGAR Y PROVINCIA GERENTE DE VENTAS INDUSTRIAS JEFE DE ALMACENES JEFE DE LABORATORIO ADHESIVOS JEFE DE LABORATORIO PINTURAS JEFE DE CONTROL DE CALIDAD JEFE LABORATORIO DE PROD. HOGAR Y SECRETARIA GERENTE FINANCIERO ASISTENTE RR.II JEFE DE SISTEMAS JEFE DE SOPORTE
  • 2. DATA ENTRADA VIA MICROSOFT QRY 32 Numero Documento Referencia Motivo IS Articulo Planta Codigo Linea Codigo Articulo Codigo Presentacion Tipo Articulo Ano Registro Mes Registro Dia Registro Cantidad Atendida Formula Base Proceso TOTAL 0159530 PR R01 MPR K16445 UNI PI 2001 1 5 380 R85 0 0159522 PR R01 MPR R70028 UNI PI 2001 1 5 630 A03 0 0159658 PR R01 MPR R70037 UNI PI 2001 1 5 3257 A13 0 0159773 PR R01 MPR K16180 UNI PI 2001 1 5 2215 R66 0 0159780 PR R01 MPR R30416 UNI PI 2001 1 5 9288 R17 0 0159739 PR R01 MPR R30536 UNI PI 2001 1 6 12084 R71 0 0159778 PR R01 MPR R30894 UNI PI 2001 1 6 7190 R71 0 0159734 PR R01 054 0015 001 PT 2001 1 6 66 R78 13200 0159808 PR R01 MPR R70013 UNI PI 2001 1 6 4139 A02 0 0159807 PR R01 MPR R30874 UNI PI 2001 1 8 8456 R17 0 0159884 PR R01 051 0007 001 PT 2001 1 8 1 P99 200 0159899 PR R01 126 0069 002 PT 2001 1 8 11 P99 2200 0159898 PR R01 126 0070 002 PT 2001 1 8 5 P99 1000 0159660 PR R01 051 0032 001 PT 2001 1 8 40 R79 8000 0159660 PR R01 051 0032 010 PT 2001 1 8 2 R79 40 0159893 PR R01 MPR R30886 UNI PI 2001 1 8 53 P99 0 0159911 PR R01 054 0068 001 PT 2001 1 8 5 P99 1000
  • 3. OBTENCION DE RESULTADOS DE DATA ENTRADA VIA MICROSOFT QRY 32 u Unida des Total( Lt-Kg) Extr aer Decision _1 Decisio n_2 Articul o LA LAP_1 LAP Factor Proce so Factor Envas ado UEQ PROC_1 UEQ PROCESO UEQ ENVASA D TOTAL UEQ STD PROCES O STD ENVA SA HR PROCE SO HR ENVA SADO 1.9 380 K16 K16445 K16445 K16445 K16445 K16445 K16445 17.684 21.711 6,720.00 1,680.00 41.25 1,721.25 84.44 12.00 4.50 0.16 3.15 630 R70 R70028 R70028 R70028 R70028 R70028 R70028 16.800 41.684 10,584.00 2,646.00 131.31 2,777.31 88.89 6.25 7.09 0.50 16.285 3257 R70 R70037 R70037 R70037 R70037 R70037 R70037 6.922 41.684 22,545.68 5,636.42 678.83 6,315.25 215.73 6.25 15.10 2.61 11.075 2215 K16 K16180 K16180 K16180 K16180 K16180 K16180 4.779 41.684 10,584.75 2,646.19 461.65 3,107.84 312.50 6.25 7.09 1.77 46.44 9288 R30 R30416 R30416 R30416 R30416 R30416 R30416 3.787 41.684 35,177.74 8,794.43 1,935.82 10,730.25 394.29 6.25 23.56 7.43 60.42 12084 R30 R30536 R30536 R30536 R30536 R30536 R30536 9.707 41.684 117,295.36 29,323.84 2,518.56 31,842.40 153.85 6.25 78.55 9.67 35.95 7190 R30 R30894 R30894 R30894 R30894 R30894 R30894 0.747 20.842 5,368.53 1,342.13 749.27 2,091.41 2,000.00 12.50 3.60 2.88 66 13200 001 FALSO FALSO 0015 0540015 0540015001 0540015001 5.206 72.369 68,717.67 17,179.42 4,776.32 21,955.74 286.85 3.60 46.02 18.33 20.695 4139 R70 R70013 R70013 R70013 R70013 R70013 R70013 7.467 41.684 30,904.53 7,726.13 862.66 8,588.79 200.00 6.25 20.70 3.31 42.28 8456 R30 R30874 R30874 R30874 R30874 R30874 R30874 3.052 41.684 25,806.46 6,451.61 1,762.41 8,214.03 489.32 6.25 17.28 6.76 1 200 000 FALSO FALSO 0007 0510007 0510007001 0510007001 6.922 41.684 1,384.43 346.11 41.68 387.79 215.73 6.25 0.93 0.16 11 2200 006 FALSO FALSO 0069 1260069 1260069002 1260069002 2.489 45.706 5,475.56 1,368.89 502.77 1,871.66 600.00 5.70 3.67 1.93 5 1000 007 FALSO FALSO 0070 1260070 1260070002 1260070002 7.467 41.684 7,466.67 1,866.67 208.42 2,075.09 200.00 6.25 5.00 0.80 40 8000 003 FALSO FALSO 0032 0510032 0510032001 0510032001 3.289 41.684 26,311.11 6,577.78 1,667.37 8,245.15 454.05 6.25 17.62 6.40 2 40 003 FALSO FALSO 0032 0510032 0510032010 0510032010 3.289 5.531 131.56 32.89 11.06 43.95 454.05 47.10 0.09 0.04 0.265 53 R30 R30886 R30886 R30886 R30886 R30886 R30886 0.000 41.684 0.00 0.00 11.05 11.05 0.00 6.25 0.00 0.04 5 1000 006 FALSO FALSO 0068 0540068 0540068001 0540068001 5.204 43.421 5,204.04 1,301.01 217.11 1,518.12 286.96 6.00 3.48 0.83
  • 4. MUESTRA DE FORMULACION PARA OBTENCION DE RESULTADOS VIA EXCEL grup Unidades Total(Lt-Kg) Extraer Decision_1 Decision_2 "R01","RE", =SI(G2="PI",K2/200,K2) =SI(G2="PI",K2,M2) =EXTRAE(E2,1,3) =SI(G2="PI",SI(Q2="A10",E2,SI(Q2="K16",E2,SI(Q2="K70",E2,SI(Q2="M77",E2,SI(Q2="O13",E2,SI(Q2="R30",E2,SI(Q2 ="R70",E2,"ELIMINAR")))))))) =SI(G2="PI",SI(Q2="S21",E2,SI(Q2="Z60",E2,SI(Q2="Z70",E2,R2)))) "R01","RE", =SI(G3="PI",K3/200,K3) =SI(G3="PI",K3,M3) =EXTRAE(E3,1,3) =SI(G3="PI",SI(Q3="A10",E3,SI(Q3="K16",E3,SI(Q3="K70",E3,SI(Q3="M77",E3,SI(Q3="O13",E3,SI(Q3="R30",E3,SI(Q3 ="R70",E3,"ELIMINAR")))))))) =SI(G3="PI",SI(Q3="S21",E3,SI(Q3="Z60",E3,SI(Q3="Z70",E3,R3)))) "R01","RE", =SI(G4="PI",K4/200,K4) =SI(G4="PI",K4,M4) =EXTRAE(E4,1,3) =SI(G4="PI",SI(Q4="A10",E4,SI(Q4="K16",E4,SI(Q4="K70",E4,SI(Q4="M77",E4,SI(Q4="O13",E4,SI(Q4="R30",E4,SI(Q4 ="R70",E4,"ELIMINAR")))))))) =SI(G4="PI",SI(Q4="S21",E4,SI(Q4="Z60",E4,SI(Q4="Z70",E4,R4)))) "R01","RE", =SI(G5="PI",K5/200,K5) =SI(G5="PI",K5,M5) =EXTRAE(E5,1,3) =SI(G5="PI",SI(Q5="A10",E5,SI(Q5="K16",E5,SI(Q5="K70",E5,SI(Q5="M77",E5,SI(Q5="O13",E5,SI(Q5="R30",E5,SI(Q5 ="R70",E5,"ELIMINAR")))))))) =SI(G5="PI",SI(Q5="S21",E5,SI(Q5="Z60",E5,SI(Q5="Z70",E5,R5)))) "R01","RE", =SI(G6="PI",K6/200,K6) =SI(G6="PI",K6,M6) =EXTRAE(E6,1,3) =SI(G6="PI",SI(Q6="A10",E6,SI(Q6="K16",E6,SI(Q6="K70",E6,SI(Q6="M77",E6,SI(Q6="O13",E6,SI(Q6="R30",E6,SI(Q6 ="R70",E6,"ELIMINAR")))))))) =SI(G6="PI",SI(Q6="S21",E6,SI(Q6="Z60",E6,SI(Q6="Z70",E6,R6)))) "R01","RE", =SI(G7="PI",K7/200,K7) =SI(G7="PI",K7,M7) =EXTRAE(E7,1,3) =SI(G7="PI",SI(Q7="A10",E7,SI(Q7="K16",E7,SI(Q7="K70",E7,SI(Q7="M77",E7,SI(Q7="O13",E7,SI(Q7="R30",E7,SI(Q7 ="R70",E7,"ELIMINAR")))))))) =SI(G7="PI",SI(Q7="S21",E7,SI(Q7="Z60",E7,SI(Q7="Z70",E7,R7)))) "R01","RE", =SI(G8="PI",K8/200,K8) =SI(G8="PI",K8,M8) =EXTRAE(E8,1,3) =SI(G8="PI",SI(Q8="A10",E8,SI(Q8="K16",E8,SI(Q8="K70",E8,SI(Q8="M77",E8,SI(Q8="O13",E8,SI(Q8="R30",E8,SI(Q8 ="R70",E8,"ELIMINAR")))))))) =SI(G8="PI",SI(Q8="S21",E8,SI(Q8="Z60",E8,SI(Q8="Z70",E8,R8)))) "R01","RE", =SI(G9="PI",K9/200,K9) =SI(G9="PI",K9,M9) =EXTRAE(E9,1,3) =SI(G9="PI",SI(Q9="A10",E9,SI(Q9="K16",E9,SI(Q9="K70",E9,SI(Q9="M77",E9,SI(Q9="O13",E9,SI(Q9="R30",E9,SI(Q9 ="R70",E9,"ELIMINAR")))))))) =SI(G9="PI",SI(Q9="S21",E9,SI(Q9="Z60",E9,SI(Q9="Z70",E9,R9)))) ="R01","RE =SI(G10="PI",K10/200,K10) =SI(G10="PI",K10,M10) =EXTRAE(E10,1,3) =SI(G10="PI",SI(Q10="A10",E10,SI(Q10="K16",E10,SI(Q10="K70",E10,SI(Q10="M77",E10,SI(Q10="O13",E10,SI(Q10=" R30",E10,SI(Q10="R70",E10,"ELIMINAR")))))))) =SI(G10="PI",SI(Q10="S21",E10,SI(Q10="Z60",E10,SI(Q10="Z70",E10 ="R01","RE =SI(G11="PI",K11/200,K11) =SI(G11="PI",K11,M11) =EXTRAE(E11,1,3) =SI(G11="PI",SI(Q11="A10",E11,SI(Q11="K16",E11,SI(Q11="K70",E11,SI(Q11="M77",E11,SI(Q11="O13",E11,SI(Q11=" R30",E11,SI(Q11="R70",E11,"ELIMINAR")))))))) =SI(G11="PI",SI(Q11="S21",E11,SI(Q11="Z60",E11,SI(Q11="Z70",E11 ="R01","RE =SI(G12="PI",K12/200,K12) =SI(G12="PI",K12,M12) =EXTRAE(E12,1,3) =SI(G12="PI",SI(Q12="A10",E12,SI(Q12="K16",E12,SI(Q12="K70",E12,SI(Q12="M77",E12,SI(Q12="O13",E12,SI(Q12=" R30",E12,SI(Q12="R70",E12,"ELIMINAR")))))))) =SI(G12="PI",SI(Q12="S21",E12,SI(Q12="Z60",E12,SI(Q12="Z70",E12 ="R01","RE =SI(G13="PI",K13/200,K13) =SI(G13="PI",K13,M13) =EXTRAE(E13,1,3) =SI(G13="PI",SI(Q13="A10",E13,SI(Q13="K16",E13,SI(Q13="K70",E13,SI(Q13="M77",E13,SI(Q13="O13",E13,SI(Q13=" R30",E13,SI(Q13="R70",E13,"ELIMINAR")))))))) =SI(G13="PI",SI(Q13="S21",E13,SI(Q13="Z60",E13,SI(Q13="Z70",E13 ="R01","RE =SI(G14="PI",K14/200,K14) =SI(G14="PI",K14,M14) =EXTRAE(E14,1,3) =SI(G14="PI",SI(Q14="A10",E14,SI(Q14="K16",E14,SI(Q14="K70",E14,SI(Q14="M77",E14,SI(Q14="O13",E14,SI(Q14=" R30",E14,SI(Q14="R70",E14,"ELIMINAR")))))))) =SI(G14="PI",SI(Q14="S21",E14,SI(Q14="Z60",E14,SI(Q14="Z70",E14 ="R01","RE =SI(G15="PI",K15/200,K15) =SI(G15="PI",K15,M15) =EXTRAE(E15,1,3) =SI(G15="PI",SI(Q15="A10",E15,SI(Q15="K16",E15,SI(Q15="K70",E15,SI(Q15="M77",E15,SI(Q15="O13",E15,SI(Q15=" R30",E15,SI(Q15="R70",E15,"ELIMINAR")))))))) =SI(G15="PI",SI(Q15="S21",E15,SI(Q15="Z60",E15,SI(Q15="Z70",E15 ="R01","RE =SI(G16="PI",K16/200,K16) =SI(G16="PI",K16,M16) =EXTRAE(E16,1,3) =SI(G16="PI",SI(Q16="A10",E16,SI(Q16="K16",E16,SI(Q16="K70",E16,SI(Q16="M77",E16,SI(Q16="O13",E16,SI(Q16=" R30",E16,SI(Q16="R70",E16,"ELIMINAR")))))))) =SI(G16="PI",SI(Q16="S21",E16,SI(Q16="Z60",E16,SI(Q16="Z70",E16 ="R01","RE =SI(G17="PI",K17/200,K17) =SI(G17="PI",K17,M17) =EXTRAE(E17,1,3) =SI(G17="PI",SI(Q17="A10",E17,SI(Q17="K16",E17,SI(Q17="K70",E17,SI(Q17="M77",E17,SI(Q17="O13",E17,SI(Q17=" R30",E17,SI(Q17="R70",E17,"ELIMINAR")))))))) =SI(G17="PI",SI(Q17="S21",E17,SI(Q17="Z60",E17,SI(Q17="Z70",E17 ="R01","RE =SI(G18="PI",K18/200,K18) =SI(G18="PI",K18,M18) =EXTRAE(E18,1,3) =SI(G18="PI",SI(Q18="A10",E18,SI(Q18="K16",E18,SI(Q18="K70",E18,SI(Q18="M77",E18,SI(Q18="O13",E18,SI(Q18=" R30",E18,SI(Q18="R70",E18,"ELIMINAR")))))))) =SI(G18="PI",SI(Q18="S21",E18,SI(Q18="Z60",E18,SI(Q18="Z70",E18
  • 5. MUESTRA DE FORMULACION PARA OBTENCION DE RESULTADOS VIA EXCEL r Proceso Factor Envasado UEQ PROC_1 UEQ PROCESO UEQ ENVASAD TOTAL UEQ STD PROCESO STD ENVASA HR PROCESO HR ENVASADO TOTAL HR UEQ 2="ELIMINAR",0,BUS (U2,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W2="ELIMINAR",0 ,BUSCARV(W2,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X2=0,0,P2*X2) =+Z2/4 =SI(Y2=0,0,Y2*O2) =+AA2+AB2 =SI(X2<>0,1493.333333/X2,0) =SI(Y2<>0,260.5267/Y2, 0) =SI(AD2<>0,P2/ AD2,0) =SI(AE2<>0,O2/AE2,0) =+AF2+AG2 3="ELIMINAR",0,BUS (U3,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W3="ELIMINAR",0 ,BUSCARV(W3,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X3=0,0,P3*X3) =+Z3/4 =SI(Y3=0,0,Y3*O3) =+AA3+AB3 =SI(X3<>0,1493.333333/X3,0) =SI(Y3<>0,260.5267/Y3, 0) =SI(AD3<>0,P3/ AD3,0) =SI(AE3<>0,O3/AE3,0) =+AF3+AG3 4="ELIMINAR",0,BUS (U4,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W4="ELIMINAR",0 ,BUSCARV(W4,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X4=0,0,P4*X4) =+Z4/4 =SI(Y4=0,0,Y4*O4) =+AA4+AB4 =SI(X4<>0,1493.333333/X4,0) =SI(Y4<>0,260.5267/Y4, 0) =SI(AD4<>0,P4/ AD4,0) =SI(AE4<>0,O4/AE4,0) =+AF4+AG4 5="ELIMINAR",0,BUS (U5,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W5="ELIMINAR",0 ,BUSCARV(W5,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X5=0,0,P5*X5) =+Z5/4 =SI(Y5=0,0,Y5*O5) =+AA5+AB5 =SI(X5<>0,1493.333333/X5,0) =SI(Y5<>0,260.5267/Y5, 0) =SI(AD5<>0,P5/ AD5,0) =SI(AE5<>0,O5/AE5,0) =+AF5+AG5 6="ELIMINAR",0,BUS (U6,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W6="ELIMINAR",0 ,BUSCARV(W6,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X6=0,0,P6*X6) =+Z6/4 =SI(Y6=0,0,Y6*O6) =+AA6+AB6 =SI(X6<>0,1493.333333/X6,0) =SI(Y6<>0,260.5267/Y6, 0) =SI(AD6<>0,P6/ AD6,0) =SI(AE6<>0,O6/AE6,0) =+AF6+AG6 7="ELIMINAR",0,BUS (U7,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W7="ELIMINAR",0 ,BUSCARV(W7,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X7=0,0,P7*X7) =+Z7/4 =SI(Y7=0,0,Y7*O7) =+AA7+AB7 =SI(X7<>0,1493.333333/X7,0) =SI(Y7<>0,260.5267/Y7, 0) =SI(AD7<>0,P7/ AD7,0) =SI(AE7<>0,O7/AE7,0) =+AF7+AG7 8="ELIMINAR",0,BUS (U8,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W8="ELIMINAR",0 ,BUSCARV(W8,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X8=0,0,P8*X8) =+Z8/4 =SI(Y8=0,0,Y8*O8) =+AA8+AB8 =SI(X8<>0,1493.333333/X8,0) =SI(Y8<>0,260.5267/Y8, 0) =SI(AD8<>0,P8/ AD8,0) =SI(AE8<>0,O8/AE8,0) =+AF8+AG8 9="ELIMINAR",0,BUS (U9,'C:Edwardtekno ador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W9="ELIMINAR",0 ,BUSCARV(W9,'C:Ed wardtekno[Indicador Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X9=0,0,P9*X9) =+Z9/4 =SI(Y9=0,0,Y9*O9) =+AA9+AB9 =SI(X9<>0,1493.333333/X9,0) =SI(Y9<>0,260.5267/Y9, 0) =SI(AD9<>0,P9/ AD9,0) =SI(AE9<>0,O9/AE9,0) =+AF9+AG9 10="ELIMINAR",0,BU V(U10,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W10="ELIMINAR", 0,BUSCARV(W10,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X10=0,0,P10*X10) =+Z10/4 =SI(Y10=0,0,Y10*O10) =+AA10+AB10 =SI(X10<>0,1493.333333/X10, 0) =SI(Y10<>0,260.5267/Y1 0,0) =SI(AD10<>0,P1 0/AD10,0) =SI(AE10<>0,O10/AE10, 0) =+AF10+AG10 11="ELIMINAR",0,BU V(U11,'C:Edwardtek dicador =SI(W11="ELIMINAR", 0,BUSCARV(W11,'C: Edwardtekno[Indicad =SI(X11=0,0,P11*X11) =+Z11/4 =SI(Y11=0,0,Y11*O11) =+AA11+AB11 =SI(X11<>0,1493.333333/X11, 0) =SI(Y11<>0,260.5267/Y1 1,0) =SI(AD11<>0,P1 1/AD11,0) =SI(AE11<>0,O11/AE11, 0) =+AF11+AG11
  • 6. as.xls]BASE $D$3:$T$4172,17,0)) or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) 12="ELIMINAR",0,BU V(U12,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W12="ELIMINAR", 0,BUSCARV(W12,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X12=0,0,P12*X12) =+Z12/4 =SI(Y12=0,0,Y12*O12) =+AA12+AB12 =SI(X12<>0,1493.333333/X12, 0) =SI(Y12<>0,260.5267/Y1 2,0) =SI(AD12<>0,P1 2/AD12,0) =SI(AE12<>0,O12/AE12, 0) =+AF12+AG12 13="ELIMINAR",0,BU V(U13,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W13="ELIMINAR", 0,BUSCARV(W13,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X13=0,0,P13*X13) =+Z13/4 =SI(Y13=0,0,Y13*O13) =+AA13+AB13 =SI(X13<>0,1493.333333/X13, 0) =SI(Y13<>0,260.5267/Y1 3,0) =SI(AD13<>0,P1 3/AD13,0) =SI(AE13<>0,O13/AE13, 0) =+AF13+AG13 14="ELIMINAR",0,BU V(U14,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W14="ELIMINAR", 0,BUSCARV(W14,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X14=0,0,P14*X14) =+Z14/4 =SI(Y14=0,0,Y14*O14) =+AA14+AB14 =SI(X14<>0,1493.333333/X14, 0) =SI(Y14<>0,260.5267/Y1 4,0) =SI(AD14<>0,P1 4/AD14,0) =SI(AE14<>0,O14/AE14, 0) =+AF14+AG14 15="ELIMINAR",0,BU V(U15,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W15="ELIMINAR", 0,BUSCARV(W15,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X15=0,0,P15*X15) =+Z15/4 =SI(Y15=0,0,Y15*O15) =+AA15+AB15 =SI(X15<>0,1493.333333/X15, 0) =SI(Y15<>0,260.5267/Y1 5,0) =SI(AD15<>0,P1 5/AD15,0) =SI(AE15<>0,O15/AE15, 0) =+AF15+AG15 16="ELIMINAR",0,BU V(U16,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W16="ELIMINAR", 0,BUSCARV(W16,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X16=0,0,P16*X16) =+Z16/4 =SI(Y16=0,0,Y16*O16) =+AA16+AB16 =SI(X16<>0,1493.333333/X16, 0) =SI(Y16<>0,260.5267/Y1 6,0) =SI(AD16<>0,P1 6/AD16,0) =SI(AE16<>0,O16/AE16, 0) =+AF16+AG16 17="ELIMINAR",0,BU V(U17,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W17="ELIMINAR", 0,BUSCARV(W17,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X17=0,0,P17*X17) =+Z17/4 =SI(Y17=0,0,Y17*O17) =+AA17+AB17 =SI(X17<>0,1493.333333/X17, 0) =SI(Y17<>0,260.5267/Y1 7,0) =SI(AD17<>0,P1 7/AD17,0) =SI(AE17<>0,O17/AE17, 0) =+AF17+AG17 18="ELIMINAR",0,BU V(U18,'C:Edwardtek dicador as.xls]BASE $D$3:$T$4172,17,0)) =SI(W18="ELIMINAR", 0,BUSCARV(W18,'C: Edwardtekno[Indicad or Resinas.xls]BASE UEQ'!$F$3:$X$4172,1 9,0)) =SI(X18=0,0,P18*X18) =+Z18/4 =SI(Y18=0,0,Y18*O18) =+AA18+AB18 =SI(X18<>0,1493.333333/X18, 0) =SI(Y18<>0,260.5267/Y1 8,0) =SI(AD18<>0,P1 8/AD18,0) =SI(AE18<>0,O18/AE18, 0) =+AF18+AG18
  翻译: