young engineer
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 100
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 brixFG(brixcorr, dil)
brixFG = brixcorr + angle
End Function
Function bxcorr2(brixFG, SG)
bxcorr2 = brixFG * SG
End Function
Function SG(dil)
SG = 1 + [(dil ^ 2 + 200 * dil) / 54000]
End Function
Function Gdil(bxcorr2, fruc)
Gdil = bxcorr2 - fruc
End Function
Function fruc(bxcorr2, angle1)
A = 52.5
B = 143.8
C = 50
fruc = ((A * bxcorr2) / B) - ((C * angle1) / B)
End Function
Function Gconc(Gdil)
Gconc = Gdil * 5 * 25 / 100
End Function
Function Fconc(fruc)
Fconc = fruc * 5 * 25 / 100
End Function
Function Frucpurity(fruc, bxcorr2)
Frucpurity = (fruc / bxcorr2) * 100
End Function
Hi All
I would like to know how to call functions. I would like the Frucpurity function to call all the other functions above before it runs.
Also when calling a function in a cell is, =Fruc(G2)(H2) the same as =Fruc(G2,H2)
Thanks
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 brixFG(brixcorr, dil)
brixFG = brixcorr + angle
End Function
Function bxcorr2(brixFG, SG)
bxcorr2 = brixFG * SG
End Function
Function SG(dil)
SG = 1 + [(dil ^ 2 + 200 * dil) / 54000]
End Function
Function Gdil(bxcorr2, fruc)
Gdil = bxcorr2 - fruc
End Function
Function fruc(bxcorr2, angle1)
A = 52.5
B = 143.8
C = 50
fruc = ((A * bxcorr2) / B) - ((C * angle1) / B)
End Function
Function Gconc(Gdil)
Gconc = Gdil * 5 * 25 / 100
End Function
Function Fconc(fruc)
Fconc = fruc * 5 * 25 / 100
End Function
Function Frucpurity(fruc, bxcorr2)
Frucpurity = (fruc / bxcorr2) * 100
End Function
Hi All
I would like to know how to call functions. I would like the Frucpurity function to call all the other functions above before it runs.
Also when calling a function in a cell is, =Fruc(G2)(H2) the same as =Fruc(G2,H2)
Thanks