Unprotected file is now attached.
You can keep this file opened with macro enabled and select the cells in any spreadsheet you want to cloud and use short cut keys suggested to draw cloud.http://files.engineering.com/getfile.aspx?folder=709aa3d4-2e40-44bc-9a1b-ef259e680a0c&file=MakeCloud1.xls
Attached file helps you to draw cloud in sinusoidal wave. But you can modify the code to have actual cloud.
Razookhttp://files.engineering.com/getfile.aspx?folder=4522faeb-ff6f-49ff-b603-a38aa636a6b7&file=MakeCloud.xls
Thank you BigInch and pleckner for your valuable suggestions and reference from codes. Though we could not fully conclude, I think I shall infer that pipe line area definetly has to be taken for fire wetted area if below 25 feet.
Regrding PSV on pipeline, although there is refernce about having...
Hi, Cummings54,
That is an excellent solution given. Small hitch is it doesnt work if your primary list is unsorted. to overcome this use 0 as third argument for Match function for exact search. Now the source will read
=CHOOSE(MATCH(A1,A2:D2,0),A3:A5,B3:B7,C3:C8,D3:D11)
But still it doesnt...
Easy way to add drop down list is as follows:
select Data->Validation from menu and in "Setting" Tab select List in the Allow column and in source assign the source.
Excel will create drop down automatically
bye
Razook
We have pipilines of sizes 8 to 10 inches containing hydrocarbon liquids which also contain valves at both ends. ( Can be isolated). Should we consider fire case for this isolated pipe and provide PSV or is it that we consider PSV for the connected vessel.
