Tr Calculator / ?豢閮???

Developed by ?寧??€?箇憭批飛?璈撌亦?摮貊頂 ?亳??嚚eb implementation assisted by ChatGPT 5.4 and Codex

?€極?瑟?撘菔??豢閮??湔?賊??極雿”嚗??亙???Rv & Tr ??Tr_calc ?撘?鈭?閮???

原始檔 / Source files StomataResistance.xlsx Tr_calc.xlsx

Worksheet Mode

?豢?撌乩?蝪踹極雿”

Workbook / 工作簿

Sheet 1: Rlv / 氣孔阻力

This worksheet maps stomatal resistance against PAR and crop light type. It uses the workbook logic from StomataResistance.xlsx to convert sunlight PPFD into PAR and then estimate Rlv. / 此工作表依據 StomataResistance.xlsx 的邏輯，先將 sunlight PPFD 轉換為 PAR，再依植物需光類型估算 Rlv。

  • PAR = PPFD / 4.57 for the sunlight case used in the workbook.
  • Three crop light types are provided: low, std., and high.

Formula Summary / 公式摘要

Rlv Equations

PAR = PPFD / 4.57
When type = low, if PAR <= 80, Rlv = (100 - 1000) / 80 x PAR + 1000 else Rlv = 100
When type = std., if PAR <= 80, Rlv = (200 - 1200) / 80 x PAR + 1200 else Rlv = 200
When type = high, if PAR <= 80, Rlv = (300 - 1400) / 80 x PAR + 1400 else Rlv = 300

Workbook / 工作簿

Sheet 2: Rav / 邊界層阻力

This worksheet isolates aerodynamic resistance as a direct function of wind speed. / 此工作表將空氣動力阻力單獨抽出，直接用風速計算 Rav。

  • Rav.min = 100 s/m, Rav.max = 200 s/m
  • Wrmin = 1 m/s is the wind speed that causes minimum Rav.

Formula Summary / 公式摘要

Rav Equations

If wind <= 1, Rav = (100 - 200) / 1 x wind + 200
If wind > 1, Rav = 100
Compact form: IF(wind<=1, Rav=(100-200)/1*wind+200, 100)

Workbook / 工作簿

Sheet 3: Rvc / CO2 濃度造成的氣孔阻力

This worksheet converts CO2 from ppm into mg/m³ and then estimates the CO2-induced stomatal resistance. / 此工作表先將 CO2 由 ppm 轉換成 mg/m³，再估算 CO2 濃度造成的氣孔阻力 Rvc。

  • Two crop CO2 response types are used: Low and Std.
  • Rvcmax equals 200 or 400 s/m depending on crop type.

Formula Summary / 公式摘要

Rvc Equations

CO2mgm-3 = CO2ppm x 44.01 / 22.4 x 273 / (273 + T)
CO2crmax = 1200 x 44.01 / 22.4 x 273 / (273 + T)
When type = Low, if CO2ppm <= 1200, Rvc = 200 x CO2mgm-3 / CO2crmax else Rvc = 200
When type = Std., if CO2ppm <= 1200, Rvc = 400 x CO2mgm-3 / CO2crmax else Rvc = 400

Workbook Context

Sheet 1: Rv & Tr

?撐撌乩?銵其蜓閬???芋?葉?葉隞??詻€???株??豢除撖漲撌殷??拙??函?雿?豢閮??具€?

  • 頛詨?澈?撠?摨艾€AR?◢?? CO2嚗隡啁? Tr??code>VDD ??Rv??
  • 靽???workbook 銝剔??餃??圾嚗?code>Rav??code>Rlv??code>Rvc ?蜇?餃? Rv??

Core Equations

Formula Summary

Vds = 2166 x Vps / (273.16 + TL); where Vds is saturated vapor density (g/m³), Vps is saturated vapor pressure, and TL is leaf temperature (°C)
Vd = Vds x RH / 100; where Vd is vapor density (g/m³) and RH is relative humidity (%)
Rv = Rav + Rlv + Rvc; where Rv is total vapor resistance (s/m), composed of aerodynamic, leaf, and CO2-related resistance terms
VDD = Vds - Vd; where VDD is vapor density deficit (g/m³)
Tr = VDD / Rv x 1000; where Tr is transpiration rate (mg/m²/s)
Rav = 100 when wind >= 1; here Rav is aerodynamic resistance (s/m) and wind is air velocity (m/s)
Rav = 200 - 100 x wind when wind < 1; this is the low-wind aerodynamic-resistance relation
Rlv = (200 - 1200) / 80 x PAR + 1200 when PAR <= 80; here Rlv is leaf vapor resistance (s/m) and PAR is photosynthetically active radiation
Rlv = 200 when PAR > 80; this is the high-light limit of leaf vapor resistance
Rvc = 400 x CO2mg / 2352 when CO2mg < 2352; here Rvc is the CO2-related resistance increment (s/m) and CO2mg is CO2 concentration in mg/m³
Rvc = 400 when CO2mg >= 2352; this is the upper limit of the CO2-related resistance increment

Workbook Context

Sheet 2: Tr_calc

?撐撌乩?銵其???Tr_calc.xlsx嚗誑雿?€???€??拚? CO2 憿??澈摨艾€?摨艾€◢?€AR ??CO2 ?箄撓?伐?閮??豢????????柴€?

  • 頛詨?€??€???€? CO2 憿??澈摨艾€?摨艾€◢?€AR ??CO2 瞈漲??
  • 頛詨?€?臬???CO2mg??code>SVP??code>El??code>Ea??code>Rvs??code>Rvc??code>Rlv??code>Rav ??Tr??

Core Equations

Formula Summary

Tr = (El - Ea) / (Rlv + Rav) = (El - Ea) / (Rvs + Rvc + Rav); where Tr is transpiration rate, El and Ea are leaf-surface and ambient vapor-density terms, and Rlv, Rvs, Rvc, and Rav are resistance terms
Rlv = Rvs + Rvc; where Rlv is total leaf resistance, Rvs is stomatal/light-related resistance, and Rvc is the CO2-related increment
CO2mg = CO2ppm x 44.01 / 22.4 x 273 / (273 + T); where CO2mg is CO2 concentration in mg/m³, CO2ppm is concentration in ppm, and T is air temperature (°C)
Rvs: changed by PAR and crop light type
Rvc: changed by CO2 concentration and crop CO2 type
Rav: changed by wind speed
RH in this worksheet follows the original workbook style as a 0-1 fraction.

Worksheet Mode

Select Interactive Sheet

Inputs / 輸入

Sheet 1 Inputs / Rlv

Sheet 1 Rlv calculator is ready. / 工作表 1 Rlv 計算器已就緒。

Outputs / 輸出

Primary Results / 主要結果

PAR (W/m2)0.00
Rlv (s/m)0.00

Derived Values / 推導值

Rlv Outputs

SymbolMeaning / 意義UnitValue

Reference Visual / 參考圖

Rlv vs PAR

Inputs / 輸入

Sheet 2 Inputs / Rav

Sheet 2 Rav calculator is ready. / 工作表 2 Rav 計算器已就緒。

Outputs / 輸出

Primary Results / 主要結果

Wind (m/s)0.00
Rav (s/m)0.00

Derived Values / 推導值

Rav Outputs

SymbolMeaning / 意義UnitValue

Reference Visual / 參考圖

Rav vs Wind

Inputs / 輸入

Sheet 3 Inputs / Rvc

Sheet 3 Rvc calculator is ready. / 工作表 3 Rvc 計算器已就緒。

Outputs / 輸出

Primary Results / 主要結果

CO2mgm-30.00
CO2crmax0.00
Rvc (s/m)0.00

Derived Values / 推導值

Rvc Outputs

SymbolMeaning / 意義UnitValue

Reference Visual / 參考圖

Rvc vs CO2

Inputs

Sheet 1 Inputs

撌乩?銵?1 ????蝞撌脣停蝺€?

Outputs

Primary Results

Tr (mg/m2/s) 0.0000
VDD (g/m3) 0.0000
Rv (s/m) 0.0000

Derived Values

Derived Parameters

Symbol Meaning Unit Value

Reference Visual

Resistance Balance

撠?Rav?lv?vc ??Rv ?曉??撘萄?銝哨?靘踵瑼Ｚ??豢?餃?蝯???

Inputs

Sheet 2 Inputs

撌乩?銵?2 ??Tr_calc 閮??典歇撠梁???

Outputs

Primary Results

CO2 (mg/m3) 0.0000
Tr (mg/(m2s)) 0.0000
El - Ea (mg/m3) 0.0000
Rlv + Rav (s/m) 0.0000
Rlv (s/m) 0.0000
Rav (s/m) 0.0000

Derived Values

Worksheet 2 Outputs

Symbol Meaning Unit Value

Reference Visual

Resistance Components

瘥? Rvs?vc?lv ??Rav嚗翰?炎閬極雿” 2 ????€?