1. It will be better use for your problem not ceil but Ceil function. The Ceil function works with units - see the picture.
2. It will be good to have not only a program but the description!
Olubukola,
The revised function I provided was based on the variable h.skirt.
I don't know how you decide what section heights to use (though I see what you did in the programs); however I would provide that criteria as input also, unless it never changes.
However, normally when I write a standard calculation like you have, I assign an argument list and include every variable used in the function in the argument list. That way I can reuse the functions in the same file for different designs, do studies with respect to the variables or whatever.
Actually, if something is going to be used for many designs, I will then put all the functions in a separate file and just reference that file into the working file. That way if you refine or change (or correct
something) it will be reflected in all designs. (of course, if a correction, you would need to go back and review the previous designs). As a further note, as the standard designs evolve, the newer versions may not work in the previous designs so keep copies of previous versions of the referenced files.
I added an argument list to the function for L() as an example.
See help "Including One Worksheet Inside Another" for Reverenced Files
