An Analytical And Numerical Investigation Of Auxeticity In Cubic Crystals And Frameworks