Here are the links for the first version of the two Excel files I created for script generation of D-shaped culverts. They're still not fully functional, as the results retrieval are not working yet, but the scripts generated seem to work fine.
Still struglling with my decision to do it in Excel with all those CHAR(34) functions to include quotation marks. Maybe I should have just created the scripts directly and defined some additional variables...
https://www.dropbox.com/s/lgd82rw6pmsribf/AdonisDShapedCulvertGen_v2.0_Beams.xlsm?dl=0https://www.dropbox.com/s/w06ylk9buyttkgb/AdonisDShapedCulvertGen_v2.0_LinerInterface.xlsm?dl=0These files generate two different versions:
- Beams - Model with two different beam sections, one for the invert and another one for walls and crown, and rigid interface with enveloping soil;
- LinerInterface - Model with a single liner section and an interface.
I tried to use the element getter functions but I couldn't find a way to get nodes and coordinates from structural elements to apply normal stresses representing hydrostatic forces, so I did it the brute force way, assigning pressures to the boundaries.
By the way, is it possible to, in some way, represent different boundary pressure values with different lengths in the GUI, scaling them with some factor? That would help to check the input.
Thank you again for your help.