No, I created the water profile from a text file.
I was thinking to export all 3 profile to excel, calculate (Water Level - Surface Profile 1 + Surface Profile 2) and import the result as profile into C3D. Unfortunately the three profile does not have the same vertice for the caluculation in Excel
Oh, that's easy. You just set up your spreadsheet to calc grades between PVI's and interpolate elevations for any needed vertex.
Your engineer should be able to quickly handle that in Excel if you supply him/her with the data. Then you can put the resultant profile they produce in Excel, into CAD.
Sorry fcernst I do not understand terms like kick out profiles of crank on data.
Neither with xml export or with incremental stationing report I get vertices at the same station for the different profiles which is necessary for calculation in Excel
Oh ok. That's just a little friendly calculation slang for getting things done here Hi there, what country are you from?
Again, you don't need to have every PVI match at first!
Pick a base control profile for your convention... I'm guessing it would be the water surface profile for your case.
So, you have to interpolate elevations for the Water Surface PVI stationing on the other two surface profiles because they may not have those PVI stations. Then you can compute your equation above as you stated for the resultant profile.
This can all be easily done simultaneously in Excel.
If you're more comfortable working in C3D than Excel, there is still a way to use my suggestion. First you have to make a corridor from your water level profile. Make it flat and narrow, just wide enough to be useful.
Then you can make a surface from the corridor, and proceed to use the volume surfaces method I described. Finish off by making a surface profile of the new water level surface.
The one advantage of doing it inside Civil 3D is that it will be dynamic. If you update surface1 or surface2 or the exisitng water surface, in all cases the new water level surface will update according to the calculations built in.
Credit where credit is due! Give kudos or accept as solution whenever you can.