yes there is saw kerf but I am trying to keep things simple. my goal is an Excel file that can do the analysis and that I can use to enter various widths and see the resulting waste percentage. Ignore saw kerf for this question.

yes, the data will be entered in a table - the length and width of every board in the bundle. What I am asking here is how to set up the file that will analyze the data in that table.