young engineer
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 100
<TABLE style="WIDTH: 581pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=774 border=0><COLGROUP><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=4 width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 46.5pt" height=62><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; HEIGHT: 46.5pt; BACKGROUND-COLOR: transparent" width=64 height=62>Brix Read UnDiluted</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Brix Read Diluted solution</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Angle Diluted solution</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Brixcorr</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 53pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=70>Brixxcorr [F &G]</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Brix Corr 2 [g/cm3]</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>SG</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>G[g] in 100cm3 Diluted solution</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>F[g] in 100 cm3 Diluted solution</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>G[g] in 25cm3</TD><TD class=xl63 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>F[g] in 25cm3</TD><TD class=xl64 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; BACKGROUND-COLOR: transparent" width=64>Fructose Purity [%]</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; HEIGHT: 15pt; BACKGROUND-COLOR: #dbe5f1" height=20>0.1</TD><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #dbe5f1">0.02</TD><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #dbe5f1">0.01</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl68 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.02</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">1.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl67 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: #ffc7ce">0.0</TD><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; BORDER-BOTTOM: #f0f0f0; BACKGROUND-COLOR: transparent"> 19.23 </TD></TR></TBODY></TABLE>
Function brixcor(Brix As Double)
A = 0.006222
B = 0.00023725
C = -0.0000018165
D = 0.000000018906
E = 0.00002328
brixcor = A * Brix + B * Brix ^ 2 + C * Brix ^ 3 + D * Brix ^ 4 + E * Brix ^ 2
End Function
Function SG(dil)
SG = 1 + [(dil ^ 2 + 200 * dil) / 54000]
End Function
Function fruc(bxcorr2, angle1)
A = 52.5
B = 143.8
C = 50
fruc = ((A * bxcorr2) / B) - ((C * angle1) / B)
End Function
Function Frucpurity(fruc, bxcorr2)
Frucpurity = (fruc / bxcorr2) * 100
End Function
Brixcorr F&G: H2+F2
Brixcorr2: I2*K2
G[g]in 100: J2-M2
G[g]in25cm: L2*5*25/100
F[g]in25cm: M2*5*25/100
Frucpurity(fruc(brixcor(F2)+F2*+SG(F2),G2),brixcor(F2)+F2*+SG(F2))
Required:
Frucpurity(D2)(E2)(F2)
Hi All
I have calculated the fructose purity in the last cell using a combination of functions and cell based calculations. I have listed all the functions used aswell as the cell based calculations. The fructose purity now only uses the blue shaded entries for the final answer. the final equation for the fructose purity is
Frucpurity(fruc(brixcor(F2)+F2*+SG(F2),G2),brixcor(F2)+F2*+SG(F2))
but i would like to link my frucpuity function to all the other functions and the cells so that my final fructose equation is simply a single function with 3 variables like
Frucpurity(D2)(E2)(F2)
Please help
Function brixcor(Brix As Double)
A = 0.006222
B = 0.00023725
C = -0.0000018165
D = 0.000000018906
E = 0.00002328
brixcor = A * Brix + B * Brix ^ 2 + C * Brix ^ 3 + D * Brix ^ 4 + E * Brix ^ 2
End Function
Function SG(dil)
SG = 1 + [(dil ^ 2 + 200 * dil) / 54000]
End Function
Function fruc(bxcorr2, angle1)
A = 52.5
B = 143.8
C = 50
fruc = ((A * bxcorr2) / B) - ((C * angle1) / B)
End Function
Function Frucpurity(fruc, bxcorr2)
Frucpurity = (fruc / bxcorr2) * 100
End Function
Brixcorr F&G: H2+F2
Brixcorr2: I2*K2
G[g]in 100: J2-M2
G[g]in25cm: L2*5*25/100
F[g]in25cm: M2*5*25/100
Frucpurity(fruc(brixcor(F2)+F2*+SG(F2),G2),brixcor(F2)+F2*+SG(F2))
Required:
Frucpurity(D2)(E2)(F2)
Hi All
I have calculated the fructose purity in the last cell using a combination of functions and cell based calculations. I have listed all the functions used aswell as the cell based calculations. The fructose purity now only uses the blue shaded entries for the final answer. the final equation for the fructose purity is
Frucpurity(fruc(brixcor(F2)+F2*+SG(F2),G2),brixcor(F2)+F2*+SG(F2))
but i would like to link my frucpuity function to all the other functions and the cells so that my final fructose equation is simply a single function with 3 variables like
Frucpurity(D2)(E2)(F2)
Please help