Skip to main content
M
markg90430338
Participant
July 21, 2018
Question

can these formulas (excel) be converted to calculate on a pdf form

  • July 21, 2018
  • 1 reply
  • 822 views

these are the formulas

3 separate cells

=ROUND((10^7.96427)*10^((-1628.445/(T24+273.15)))*10^((-100151/(T24+273.15)^2)),2)

=ROUND((10^7.96427)*10^((-1628.445/(T25+273.15)))*10^((-100151/(T25+273.15)^2)),2)

=(Y27-(0.00066*760*(T24-T25)*(1+(0.00115*T25))))/Y26

Thanks in advance

This topic has been closed for replies.

1 reply

G
gkaiseril
Inspiring
July 21, 2018

Yes they can. JavaScript uses the same symbols for the 4 basic arithmetic operations, uses the Math.exp() method for all exponentiation. JavaScript even includes the "if ... else" statement for conditional execution of blocks of code. Unlike Excel which has an error condition for division by zero, JavaScript does not, so one must test for a zero divisor and skip the action..

M
markg90430338Author
Participant
July 21, 2018

i unfortunately have no experience writing javascript.

i tired a in the example below but could not get the proper calculation

event.value=Math.exp((10^7.96427)*10^((-1628.445/(WBC+273.15)))*10^((-100151/(WBC+273.15)^2)),2)

event.value=Math.exp((10^7.96427)*10^((-1628.445/(DBC+273.15)))*10^((-100151/(DBC+273.15)^2)),2)

Y27-(0.00066*760*(T24-T25)*(1+(0.00115*T25))))/Y26

Where have i gone wrong?

M
markg90430338Author
Participant
July 21, 2018

ultimately i would like to calculate relative humidity from dry bulb and wet bulb temperature. there are a couple different ways to calculate, however can not get any proper calculation as i am javascript illiterate. attached original formulas and an excel sheet that does what i need (formulas imbedded)

https://www.sksato.co.jp/html_e/files/Psychrometer1.1E.xls

any help would be muchly appreciated.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices