Custom MS Excel Formula

I need a custom formula created for MS Excel, compatible with 2007 and newer. This formula will determine total material usage based on the following: 1. Material units are 10' sticks. The returned value will be in number of units. 2. The material is used to build a frame: minimum dimensions is 4' x 4', with no maximum size, using 2' increments. 3. The formula will optimize material usage and use waste as applicable. 4. The formula will factor is waste due to 45 degree cuts at the corners. 5. A joint cannot fall within 4' of the frame corner. Please let me know of any questions or clarifications. Thank you