So you need an additional column to keep it together as a set for the large bods, if you want to sort in a spreadsheet. Maybe a number to keep the records together like the time stamp when it was read would be simple enough.
On the other hand, if it listed as a single record for small or large, then it wouldn't require that ID column.
A lot of the data is fluff (like the "A bulk order deed" and "blessed"). If the price were moved before any of the items that make up the deed, then it would be able to pull into a spreadsheet and keep all the data for the individual BOD intact - even if you wanted to sift and sort the information.
So just kicking around ideas on how the data would be useful...
Large : Material : Normal|Exceptional : Qty : Price : item1 : item1 qty : item2 : item2 qty : item 3 : item3 qty : item4 : item4 qty : item5 : item5 qty : item6 : item6 qty
Small : Material : Normal|Exceptional : Qty : Price : item1 : item1 qty
The one missing thing would be linking up matches of small with large to allow filling a large.
Artificial ID (time stamp) : Large : Material : Normal|Exceptional : Qty : Price : item1 : item1 qty
Artificial ID (time stamp) : Large : Material : Normal|Exceptional : Qty : Price : item2 : item2 qty
Artificial ID (time stamp) : Large : Material : Normal|Exceptional : Qty : Price : item3 : item3 qty
Artificial ID (time stamp) : Large : Material : Normal|Exceptional : Qty : Price : item4 : item4 qty
Artificial ID (time stamp) : Large : Material : Normal|Exceptional : Qty : Price : item5 : item5 qty
Artificial ID (time stamp) : Large : Material : Normal|Exceptional : Qty : Price : item6 : item6 qty
Artificial ID (time stamp) : Small : Material : Normal|Exceptional : Qty : Price : item1 : item1 qty
This organization would allow sorting by the original book order, or making a set out of the Large items together, but also sorting by the Item# column which would bring the large and small together which could be used to fill a bod. I think that would be a more useful format.
Think about what you want to accomplish using the spreadsheet and let me know.
Gaderian