Excel-Compatible VBA for Vapor-Liquid Diagrams
Budget: $10 – $30 CAD
I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components.
The following skills and experience are required:
- Proficient in VBA code in Excel
- In-depth understanding of Thermodynamics
Key requirements include:
- Usage of the Wagner equation
- equation for the saturated pressure : p_i^* (T)=exp((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c.
- bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr)))
- dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb)
- Ridders method to find the right temperature for dew point and bull point
- The code must be compatible with Microsoft Excel
- Flexibility of the code to handle any two selected components for the vapor-liquid diagram
Your knowledge and application of thermodynamics in the generation of the code will be crucial for the successful completion of this task.
The following skills and experience are required:
- Proficient in VBA code in Excel
- In-depth understanding of Thermodynamics
Key requirements include:
- Usage of the Wagner equation
- equation for the saturated pressure : p_i^* (T)=exp((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c.
- bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr)))
- dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb)
- Ridders method to find the right temperature for dew point and bull point
- The code must be compatible with Microsoft Excel
- Flexibility of the code to handle any two selected components for the vapor-liquid diagram
Your knowledge and application of thermodynamics in the generation of the code will be crucial for the successful completion of this task.