young engineer
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 100
<TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=256 border=0><COLGROUP><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" span=4 width=64><TBODY><TR style="HEIGHT: 35.25pt" height=47><TD class=xl65 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 48pt; BORDER-BOTTOM: #95b3d7 1pt solid; HEIGHT: 35.25pt; BACKGROUND-COLOR: transparent" width=64 height=47>Brix Read UnDiluted</TD><TD class=xl65 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=xl65 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=xl66 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></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
Hi All
I want to link the frucpurity function to all the other functions mentioned above.
I want the function to look like =frucpurity(D2)(E2)(F2)
rather than:
=Frucpurity(fruc(brixcor(E2)+E2*+SG(E2),F2),brixcor(E2)+E2*+SG(E2))
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
Hi All
I want to link the frucpurity function to all the other functions mentioned above.
I want the function to look like =frucpurity(D2)(E2)(F2)
rather than:
=Frucpurity(fruc(brixcor(E2)+E2*+SG(E2),F2),brixcor(E2)+E2*+SG(E2))