I am looking to build an app to help window tinting companies calculate the proper amount of window film based on given measurements. This app must find the best way to cut film from boxes and produce linear footage for each film type. To start I'd like to make sure someone can produce a formula that can produce the proper results. Once that is accomplished I'd like to then go forward with making a fully functional app. I've attached a hand drawn example of a real world calculation. Please email me for any questions.
*We order film from these roll sizes 36",48",60",72" and 100ft long
*The rolls may be cut or divided into three pieces i.e. 72" cut 1 time in the middle is 36", or 60" cut 2 times produces 3 15" pieces
*We enter the window measurements (W x H x Panes) and the formula must produce the best roll size to pull from, the amount of cuts and the linear footage.
You may find the attachments useful.
Good luck and thank you!