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/file
Friends I am not selecting a valve, the valve already is there. I am in rating mode you can say. So I just want to know that is my generated curve from nameplate information is OK. Because I want to know at say 40% what amount of Cl2 this valve can throughput