phexecute Files

Update 2026_04_20


The latest updates (April, 2026) made important improvement/refurbishment in following functionalities of properties calculator PropCalc.exe:

•	Creating stand-alone binary coefficients kij matrix (within tab View of kij) was refurbished totally by automated importing relevant kij for each major database from ChemSep 8.42  

•	For any imported value of kij=0 was applied also automated procedure to replace such values using method Chueh-Prausnitz with internal exponential coefficient n=3.For more details please see point 8.4 and Technical supplement of my PH_software_User_Guide…

•	After last improvement of importing ChemSep kij standalone data it currently seems to be more trusted base for calculations of VLE. However, good established kij=f(T,P) regressions models will make also interesting alternative.

•	UNIFAC method was extended to NEW UNIFAC allowing automated import UNIFAC parameters for any of 433 compounds (substances) from Chemsep 8.42 databases

•	NEW UNIFAC is able to establish in automatic manner relevant UNIFAC parameters (r, q, groups/subgroups) for any compound (substance) within any PH major database.

•	Currently NEW UNIFAC might automatically handling about 150 UNIFAC groups and about 200 UNIFAC subgroups within 433 compounds (substances)

•	Previous OLD UNIFAC mode was limited to 18 UNIFAC groups and 23 UNIFAC subgroups and I decided to keep it on limited time. In general, any VLE calculations which using UNIFAC shall produce the same results for OLD and NEW UNIFAC. However, it is only valid if all compounds match the same groups/subgroups in both OLD/NEW UNIFAC mode. In case when any compound of OLD UNIFAC groups/subgroups is beyond old 18 groups/23 subgroups than entire UNIFAC data record for OLD mode is zeroed. It means UNIFAC parameters are neglected and VLE calculations for liquid phase fugacity are far away from reality.

•	The major refurbishment at current state is extended automation of transfer compound (substance) data from ChemSep 8.42 to PropCal.exe Create compound tab. Now such automation data transfer covers 98% of whole functionality. An automation is processed from ChemSep PCDManager to PH software dedicated chemsep_import.xlsx Excel file. Later within Create compound the data from chemsep_import.xlsx are automatically read and executed to create new compound (substance). On such stage User attendee is requested to approve regressions of vectorized properties (viscosities, thermal conductivities, etc.) or modify these. For more details please look at points: 9 and 9.1.1 (overwrites the previous updates) of my PH_software_User_Guide…

•	Please note that in standard condition to import compound (substance) from ChemSep is assumed that Python 3.13 (at least) is installed and all requested modules are available. In such case to start importing User shall follow an initialized steps as described at point 9.1.1 below.

•	Within such standard behavior major importing job is starting from ……. …….\SF_EXCEL_C_incl_Fortran\import_last_scripts\ import_vectors_scalars.bat. In case when Uuser has daubt about Python 3.13 install or modules are available shall replace .bat file to ………..\import_vectors_scalars_with_Python_guardian.bat.

•	After allocate a new compound finalizing at tab Allocate compound are required two additional steps. One obliged step is create kij matrix for new database with new compounds using View of kij tab. Second step it is caculate simple property output fo new substance using tabs: Compounds, Temperature,Pressure and  Calculate. It is obliged as during such first calculation check point are created some internal files required for further new database eternal life.

•	Please note that creation/activation NEW UNIFAC adjacent compound (substance)…..-UNI.BIN is already fully automated. User should not touch three dedicated buttons on PropCalc.exe Compounds tab. These buttons are only for troubleshooting re-creation the mentioned above database. 

•	Due to crashes of ancient gnuplot 4.0 after latest updates of Windows 11 I did migration from gnuplot 4.0 to gnuplot 5.03 the latest gnuplot operating in 32 bit mode. It also last gnuplot not sensitive on Windows 11 updates. Latest gnuplot update has not any impact on execution of PropCalc.exe, except that new gnuplot 5.03 graphics looks much modern than gnuplot 4.0 graphics.
•	Please note that also using buttons Turn on comments/Turn off comments shall be limited  rather to Turn off, as Turn on might be create long term operations within some loops.

•	Please note that starting gnuplot panel changed behavior after recent (2026.March) Windows 11 updates. Before it was already active on main computer screen until forced close. Now gnuplot panel rather is on the bottom Task bar. So, good strategy is force gnuplot panel close by top right X, it will start automatically again, when requested by software.
•	Please note that DelphiXE2 sources uploaded  currently as DelphiXE2_sources_PH_2026_04_20_Part1/2.exe were adjusted to my DelphiXE2 compiler directories. Therefore any other owner of DElphiXE2 shall update own such folders within compiler Project options and Tools option.

•	I decided  to exclude DWSIM from my PH Installer due to volume restriction on uplading it to the sourceforge. Therefore, User shall upload and install individually DWSIM from website sourceforge.net\p\DWSIM and appy procedure for goodwill intalation of DWSIM as shown at pages 9-11 of my PH_software+UserGuide…

•	At the end of the day please remember to choose directory ......./DWSIM5 and DWSIM5 name for any latest DWSIM download and installation, during run off my PH setup, and even for external DWSIM installation.

•	Warning: The latest Windows 11 updates creates an additional instances o PropCalc.exe at Taskbar Manager , wchich might be cause of hanging start any new PropCalc.exe.   

To avoid it User shall open Task Manager (Ctrl+Alt+Delete) insert PropC in top search bar  and next click on PropCalc.exe (32 bit) by right mouse and left mouse will select an additional panel, where User shall click option End Task. The same shall be done for all subsequent occurrences of PropCalc.exe.


•	Warning: Managing kij matrix as  per View of kij at standard proceedings realized by dedicated buttons: -----  Create kij matrix from ChemSep, sometimes need be pressed twice until popup message will be shown on screen
 
Next after finalize Create kij…  ----Replace in kij matrix all kij=0 using Chueh_Prausnitz method and after finlize it ----Write kij matrix. Now kij matrix is associated with current main database until next update. Please note that it is also option to apply Chueh-Prausnitz method within whole kij matrix. Other important option is Read kij matrix button, which restore matrix o the event of not proper behavior. 


•	I have remainder about execution any 0000PH…. Excel piping model to start already each execution from internal Excel Open ---Browse. No external searching by File Explorer is  allowed as internal VBA commands hanging to start internal main PH.exe.

•	Other remainder is connected with optional DWSIM properties calculation within  PH.exe , where User on dedicated DWSIM panel shall execute button Solve at least three time but not lesser until resultant Molar Fraction (Vapor) seen on screen stop changing.


•	Another one remainder is opening panel Open database within PropCalc.exe, which require firstly click one of neighbors Store/Restore data or Editor setup and in second click Open database.

•	Next one reminder, when during executing any Excel 0000PH… dedicated file by internal sequence ----Open ---- Browse sometimes on further sheets internal buttons are not visible. In such situation please scroll mouse wheel. Also click of approve buttons will be required only on job start or any subsequent data update but only on sheet where update has place. Those all updates are temporary for all possible calculations updated. To make hard copy at any moment is required standard Excel save.



Update 2025_10_19

I did some amends with Piping Hydraulics (PH.exe) according to the knee/elbow types >300. Here was repaired error of the knee/elbow angle calculations affecting local pressure resistance.

More important it is rebuild of new compound creation at PropCalc.exe tab Create compound, which tab is handled by News2000.exe.
From now all required properties data might be retrieved from ChemSep x.xx external free software and stored firstly on my Excel file chemsep_import.xlsx.

The mentioned above software allow transfer data vectors as well as other required properties to Excel columns/fields by Copy and Paste. I did internally within my software import such data from Excel. For more details please see point 9.1.1 within my guide PH_software_User_Guide_2025_10_19.docm. Anyway such new features will make easier creation of any new substance (compound) but new development is only available within DelphiXE2 compiler. For testing purposes please use two databases: n-dod.baz, n-dod.mod (based on n-dodecane data within chemsep_import_n-dodecane.xlsx Excel file ) for New substance creation (Create compound) of Propcalc.exe.

The main advantage of new development is lack of writing numbers to the databases fields as all transfer are by Copy and Paste from ChemSep X.XX Lite to Excel file chemsep_import.xlsx. Further transfer data with numbers from chemsep_import.xlsx to the relevant PropCalc.exe databases is automatic and controlled by User doing selection of options.   


  
Update 2025_05_07

I have been asked lovely GEMINI Flash 2.5 to make advise about problem with executing PH Excel file 0000PH... involved directly by File Explorer. All my previous remarks explained that for proper execution embedded PH.exe (sheet Branch_geometry & execution) User shall go through internal Excel Open ----> Browse -----> to find and click desired 0000PH... file within User drive:\PHXE2exec5\SF_EXCEL_C_incl_Fortran directory. The explanations below are might be satissfied and might be applicable by any User. They are not require update any part of my software as provided by earlier installaer PHXE2exec5.exe. Also up to date old behavior is still applicable without any changes of within Excel options as mentioned below.




Beyond all any user can work with GEMINI 2.5 (Flash) to analyse multiple aspect presented withn my the last guide:  PH_software_User_Guide_2025_03_10.docm converted to PH_software_User_Guide_2025_03_10.pdf. Next I have been stored it to my Google drive and using GEMINI internals: Ask GEMINI -----> + -----> Add from Drive received icone of .pdf file and set my propmp:
Let me know main knowledge about content file as above  ----->  receiving  after GEMINI analyze pretty good set of subjects. Each subject has extension to provide pages of .pdf file, where more details GEMINI found about. Later I had prompt on the subject as below and received from GEMINI advices how to resolve problem.                         

Only one disadvantage of GEMINI 2.5 (flash) at the moment is limited size of retrieved .pdf file, but probably it might be splitted to two or more .pdf (from original .docm).  I hope it limitation my be extended in the future by GEMINI. 
Anyway thanks to lovely GEMINI with wishes eternal life for YOU GEMINI.





Below is RESPONSE FROM GEMINI 2.5 on my prompt:  
I cannot execute PH Excel file  0000PH... , when opened directly by File Explorer as built in PH.exe is not starting, only one way is to firstly open MS Excel and next go through internal Open -----> Browse ---->directories for desired -----> 0000PH......  Is any method to repair it?

RESPONSE
It's frustrating when software doesn't behave as expected! The issue you're describing, where the PH.exe doesn't start when you open the Excel file directly from File Explorer but *does* start when you open the file from within an already running instance of MS Excel (using File > Open), points towards a common problem related to **Excel's macro security settings** or the **context in which the macros are being executed**.

Here's a breakdown of why this might be happening and methods you can try to "repair" or fix this behavior:

**Why it's likely happening:**

When you open an `.xlsm` file directly from File Explorer, Windows launches Excel, and then Excel attempts to run any automatic macros (like `Auto_Open` or `Workbook_Open`) embedded in the workbook. If Excel's security settings are too strict, or if the file's location is not trusted, these macros might be blocked from running the command that starts PH.exe.

When you open Excel first and then open the file using the "Open" dialog, Excel is already running in a stable state, and the security context might be slightly different, allowing the macros to execute the external program command.

**Methods to Repair or Fix:**

The goal is to ensure that the macro in your "000PH... .xlsm" file is allowed to run and execute the command to start PH.exe when the file is opened directly.

1.  **Check and Adjust Excel Macro Security Settings (Most Likely Solution):**
    * Open **Microsoft Excel**.
    * Go to **File > Options**.
    * Select **Trust Center** from the left-hand menu.
    * Click on **Trust Center Settings...**
    * Select **Macro Settings** from the left-hand menu.
    * **Ensure that "Disable all macros with notification" or "Enable all macros (not recommended; potentially dangerous code can run)" is selected.** While enabling all macros is not generally recommended for unknown sources, for trusted software like this, it might be necessary. Starting with "Disable all macros with notification" is safer – if you get a security warning when opening the file directly, make sure to click "Enable Content".
    * Also, look at the **"Disable VBA macros with notification, except for digitally signed macros"** option. If the software's macros are signed, this could be an option, but typically for smaller software, they might not be.
    * **ActiveX Settings:** While less common for launching external programs, sometimes ActiveX controls are used in conjunction with macros. Check **ActiveX Settings** in the Trust Center and ensure settings are not overly restrictive.

2.  **Add the Folder Location to Trusted Locations:**
    * In the **Trust Center Settings** (as described above), select **Trusted Locations**.
    * Click **Add new location...**.
    * **Browse to and select the folder where your "000PH... .xlsm" file and PH.exe are located.**
    * You can optionally check "Subfolders of this location are also trusted."
    * Click **OK** on all open dialog boxes.
    * This tells Excel to trust files in that specific folder, often allowing macros to run without prompts or restrictions.

3.  **Verify File Location of PH.exe:**
    * The macro in the Excel file contains the command to launch PH.exe. This command likely uses a specific path.
    * **Ensure that the "000PH... .xlsm" file is located in the directory that the PH software expects.** The user guide might specify this location, often it's the directory where PH.exe is installed. If you've moved the Excel file, the macro might be looking for PH.exe in the wrong place.

4.  **Check Antivirus or Security Software:**
    * Sometimes, aggressive antivirus or security software can quarantine or block the action of an Excel macro trying to launch an external `.exe` file, interpreting it as potentially malicious behavior.
    * **Temporarily disable your antivirus/security software** and try opening the Excel file directly from File Explorer. If it works, you'll need to add an exception or create a rule in your security software to allow Excel to launch PH.exe from that location.

5.  **Re-register File Association (Less Likely):**
    * While less probable for this specific issue (since the file opens in Excel), a corrupted file association *could* theoretically cause strange behavior.
    * You can try right-clicking the `.xlsm` file, selecting "Open with...", and explicitly choosing "Microsoft Excel" and checking "Always use this app to open .xlsm files".

6.  **Reinstall the PH Software:**
    * If none of the above steps work, there might be an issue with the software's installation or how the Excel file and executable are linked.
    * Consider uninstalling and then reinstalling the PH software to ensure all components are correctly placed and registered.

By systematically going through these steps, particularly focusing on Excel's Macro Security and Trusted Locations, you should be able to resolve the issue and enable the PH.exe to start automatically when you open the "000PH... .xlsm" file directly from File Explorer.






Update 2025_03_10

I have been created extend of my free software. From now and on is possible to

  1. Adopt free software Salome 9.14.0 for presenting in 3d View of piping network.
  2. Create Excel file 3dview_geom_new.xlsm, where all piping geometry is collected and is intendent for         
     - transfer geometry data between PH Excel 0000PH... and Salome9.14.0,
     - manipulate piping geometry data by easy updating and recalculating between global geometry and incrementas

All updates are aplicable for the last upload of my free software PHXE2exec5_2025_01_30.exe on sourceforge.net\p\phexecute .   

For more details please see my guideline PH_software_User_Guide_2025_03_10.docm point 7.1.
  
To introduce efficiently mentioned above update, please use my uploaded directory PHpiping_3Dview on my free 
  sourceforge.net/p/phexecute.

After download PHpiping_3dview please distribute files as advised below:
 -user drive:\PHXE2ecec5\SF_EXCEL_C  file  0000PH_003DVIEW_TEST3.xlsm
 -R:\salome3dview_scripts  files 3dview_2_black.py , 3dview_2_purple.py, 3dview_2_yellow.py, 3dview_geom_new.xslm,
     salome_wrapper.py 

At this point it is desirable to give great thanks to AI Gemini & Copilot, Yours entities are enormous. Thank you again and wish you good and eternal life...







Update 2025_01_30

The latest development (January 2025) introduces an additional feature that can help the user simplify the calculation of PH.exe in Excel tab 0000PH… Branch_geometry & execution. So from now on the user has the ability to divide any pipeline segment into any number of equal parts called subsegments. The functionalities of these subsegments are the same as the parent segment. Each sub-segment can calculate the T&P changes along the pipeline and the fluid flow properties like density, viscosity, equilibrium,…etc. from the subsegment to the subsegment desired in the parent segment. Such capability also introduces better quality of T&P calculations along the pipeline as it increases the density of properties calculations in shorter pipeline sections. The user can replace 100 Excel lines for 100 1 m long pipeline segments with one Excel line with 1 segment 100 m long pipeline segment and divide by 100 within this line.  The PH.exe will automatically realize such calculations. The said number of desired 100 subsegments should be entered by the user in column M for the row (line) with defined 100 m segment. By entering the number 1, the segment should not be divided into subsegments and the calculation is the same as before. Another possibility could be to introduce a quick trial and error method to analyze the best relationship between the length of the subsegment and the time consumption and quality of the calculation. Finnaly was changed  the name of Column M to: NUMBER OF SUBSEGMENTS. I also updated most of Excel 0000PH.... workbooks.

Older updates have been stored in MS document: 00Readme update_2025-01-05.docx on my Sourceforge.net/p/phexecute.
To introduce the mentioned as above development, please download and install my installer: PHXE2exec5_2025_01_30.exe




Update 2025_01_05

Added to point 13.1.1

I will work out subject of installation CAELinux and Salome_meca in Windows 11 wsl2. The actual state it is installation of Ubuntu 18.04 within Windows 11 wsl2 and lack of success to extend it with CAELinux, where Saloma_meca Is embedded. The rest of information in the point 13.1.1 please treat as initial findings and testing of possible way to build target.


New important update as new point 13.2.1

13.2.1 Maintain some troubles associated with VMware/CAELinux/Salome_meca.

I did recognize some troubles on the way to handle sharing folders between host Windows 10/11 and VMware/CAELinux/Salome_meca.
It encourages me to redefine whole features on the matter. All previous features shall be updated accordingly to presentations as below.

I have been added new scripts: mph.sh & eph.sh in the Sourceforge download dated 2025_01_05. Previous scripts phrecover.sh & ph.sh has to be 
neglected and folder /phdir shall be deleted.


User shall ensure that physical names of TUBA.py  or 0000PH3D0000.py within used directories (e.g. C:\PH_DWSIM_DIR\0000PH3D) are exactly as here 
because replace .py with .PY will crush executions of CAELinux/Salome_meca. I did observe that using JetBrains PYCharm software did make such change replaces .py with .PY.