I have Chinese valves where from nameplate I can get Cv @100% open & that its Equal%.
Now I generated a spreadsheet model which is fairly simple & then used 'Goal Seek' feature to iterate values such that I get stated Cv at 100% opening.
I am uploading procedure that I followed (this document also has a small video file)
I am also attaching spreadsheet file as well.
External server zip file:
https://www.mediafire.com/file/8qhwt7riweby457/Characteristic+Curve+Generation.zip/fileThe idea is to generate a curve like the one attached