Calculo Mezcla Aceite
Calculo Mezcla Aceite
Calculo Mezcla Aceite
Porcentaje
Indice de % ACIDO
de palmite Diferencia I. Iodo Diferencia
Refracciòn LAURICO
adicionado
0% 1.45126 - 55.19 - 0.009
1% 1.45113 0.00008 54.79 0.4 0.511
2.5% 1.45105 0.00021 54.22 0.97 0.845
5.0% 1.45085 0.00020 53.21 1.01 1.642
7.5% 1.45065 0.00020 52.10 1.11 2.439
10.0% 1.45045 0.00020 51.10 49.99 3.235
% Laúrico del RBD 0.16%
% ACIDO % Palmiste
INGRESAR IR RESULTADO DE YODO
LAURICO PKO
1.45122 55.10 0.17 0.28
IR %Acido Laurico 4.000
1.45126 0.304
3.500
1.45105 0.675
1.45085 1.282 3.000 f(x) = − 3
1.45065 2.475 R² = 0.95
1.45045 3.434 2.500
2.000
1.500
1.000
0.500
0.000
1.4504 1.450
IR % PKO adicionado
1.45126 0
1.451134 1
1.45105 2.5
12
1.45085 5
1.45065 7.5
1.45045 10 10
f(x) = − 12627.8064720181 x + 18
R² = 0.997457944185031
8
0
1. 1. 1. 1. 1. 1. 1
% Palmiste
PKO
-0.225
1.366
2.427
4.952 56
7.478 55 f(x) = 5191.04037103561 x − 7478.2402832952
10.003 54 R² = 0.997262466767536
53
52
51
50
49
1.45040 1.45060 1.45080 1.45100 1.45120 1.45
4.000
3.500
2.000 Column C
Linear (Column C)
1.500
1.000
0.500
0.000
1.4504 1.4506 1.4508 1.451 1.4512 1.4514
Column C
Linear (Column C)
1. 1. 1. 1. 1. 1 1. 1. 1. 1.
61 x − 7478.2402832952
36
Column D
Linear (Column
D)
% ACIDO % Palmiste
INGRESAR IR RESULTADO DE YODO
LAURICO PKO
1.45214
61.12 -1.245 -3.93
4
3.5
0.5
0
1.4 1.4 1.4 1.4 1.4 1.4 1.4 1
12
IR % PKO adicionado
1.45180 0 10
1.45171 1 f(x) = − 11515.4588696075 x
R² = 0.999946769095483
1.45158 3 8
1.45136 5
1.45115 8 6
1.45093 10
4
0
1.45080 1.45100 1.45120 1.45140
% Palmiste PKO
-0.02
0.99
2.51 60
59 f(x) = 4929.73559037222 x − 7097.54169004923
5.05
58 R² = 0.999099411841413
7.47
57
10.00
56
55
54
53
52
1.45080 1.45100 1.45120 1.45140 1.45160 1.45180 1.45200
3709.68062516169 x + 5385.73085085717
958545256498072
Column C
Linear (Column C)
) = − 11515.4588696075 x + 16718.1236767768
= 0.999946769095483
Column C
Linear (Column C)
% ACIDO % Palmiste
INGRESAR IR RESULTADO DE YODO
LAURICO PKO
1.45172 60.40 1.989 6.10
IR %Acido Laurico
1.45224 0.3035
1.45203 0.6754 4
1.45181 1.2816
3.5
1.45160 2.4752
1.45139 3.434 3 f(x) = − 3781.31402627416 x + 5491
R² = 0.959546129747879
2.5
1.5
0.5
0
1.45120 1.45140 1.45160 1.45180 1.4520
IR % PKO adicionado 12
1.45224 0
1.452156 1 10
f(x) = − 11729.1678
1.45203 2.5 R² = 0.9999437779
1.45181 5 8
1.4516 7.5
1.45139 10 6
0
1.4512 1.4514 1.4516 1.
almiste
% ACIDO % Palmiste
LAURICO PKO
0.02 0.01
0.34 0.99
0.82 2.47 64
1.65 5.05 63
2.44 7.51 f(x) = 5144.61437979727 x − 7408.136424210
62 R² = 0.998328671590231
3.24 9.98
61
60
59
58
57
56
1.45120 1.45140 1.45160 1.45180 1.45200 1.45220 1.45
f(x) = − 3781.31402627416 x + 5491.39858174119
R² = 0.959546129747879
Column C
Linear (Column C)
12
10
f(x) = − 11729.1678005788 x + 17033.5719171275
R² = 0.99994377798765
8
6 Column C
Linear (Column C)
4
0
1.4512 1.4514 1.4516 1.4518 1.452 1.4522 1.4524
44.61437979727 x − 7408.13642421065
8328671590231
Column D
Linear (Column
D)
62
60
mètodo mètodo a
estandar validar 58
62.929 62.89 62.93
56
66.506 66.53 66.51 1.45200 1.45220 1.45240 1.45260 1.45280
70.169 70.24 70.17
86.095 73.69 73.75
120%
1.45224 0%
1.45257 5.0% 100%
f(x) = 127.272910051764 x − 184
1.45300 10.0% R² = 0.999866916509292
1.45342 15.0% 80%
1.45458 30.0%
1.46004 100.0% 60%
1.45481 33.3%
40%
20%
0%
1.45000 1.45200 1.45400 1.45600 1.45800 1.460
130 0.3 39
62 0.7 43.4
82.4
27.272910051764 x − 184.820387019145
999866916509292
Column D
Linear (Column D)
IR
%SOYA
IR ESTANDARIZADO CORREGIDO
1.45211 0% 1.45213
1.45253 5.0% 1.45253
1.45296 10.0% 1.45293
1.45338 15.0% 1.45333
1.45454 30.0% 1.45453
1.46000 100.0% 1.46030
1.45213
IR inicial
IR final 1.45430 26.77%
% de Soya
ALCULO PARA AGREGAR SOYA
%SOYA
Factor de corrección
0.00040
f(x) = 122.26672256465 x − 177.544809
R² = 0.999960870846138
80%
40%
20%
PENDIENTE INTERCEPTO
0%
122.27 -177.54 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4 1.4
Soya
%SOYA
6672256465 x − 177.544809069749
60870846138
%SOYA
Linear (%SOYA)
58
mètodo mètodo a
estandar validar 56
60.289 62.89 62.93
54
63.951 66.53 66.51 1.45160 1.45180 1.45200 1.45220 1.45240
67.614 70.24 70.17
87.117 73.69 73.75
120%
1.45211 0%
1.45253 5.0% 100%
f(x) = 127.272910051764 x − 184
1.45296 10.0% R² = 0.999866916509292
1.45338 15.0% 80%
1.45454 30.0%
1.46000 100.0% 60%
1.45465 31.3%
40%
20%
0%
1.45000 1.45200 1.45400 1.45600 1.45800 1.460
130 0.3 39
62 0.7 43.4
82.4
27.272910051764 x − 184.820387019145
999866916509292
Column D
Linear (Column D)
5 2.12
0.3
Poner % Láurico 0.6
% Palmiste 0.71
FECHA DIA HORAS MOTIVO
1/1/2019 MARTES
1/2/2019 MIÉRCOLES
1/3/2019 JUEVES
1/4/2019 VIERNES
1/5/2019 SÁBADO
1/6/2019 DOMINGO 4 BIODIESEL PENDIENTE DE DICIEMBRE
1/7/2019 LUNES
1/8/2019 MARTES
1/9/2019 MIÉRCOLES
1/10/2019 JUEVES
1/11/2019 VIERNES
1/12/2019 SÁBADO
1/13/2019 DOMINGO 8 3er TURNO ANALISTA
1/14/2019 LUNES
1/15/2019 MARTES
1/16/2019 MIÉRCOLES
1/17/2019 JUEVES
1/18/2019 VIERNES
1/19/2019 SÁBADO
1/20/2019 DOMINGO 12 3er TURNO PESOS
1/21/2019 LUNES
1/22/2019 MARTES 4 BIODIESEL
1/23/2019 MIÉRCOLES 4 BIODIESEL
1/24/2019 JUEVES 4 BIODIESEL
1/25/2019 VIERNES 4 BIODIESEL
1/26/2019 SÁBADO 4 BIODIESEL
1/27/2019 DOMINGO 5 1er TURNO PESOS