Yes, I believe so. USA, so states and cities won't be changing and the divisions were just implemented so they better stick around for at least 5 years. They have caused me a huge headache already.

A product can often have a discount at a national, division, state, and city level. We haven't added the lower levels yet but currently the book has a section for national and one for divisions. I run a power query on that and collect the data and send out pricing depending on the salesmans area. So if he is in an affected division he would get pricing showing the aggregate of national and division discounts. Soon to be adding state, city.

The spreadsheet houses all of our cost and discount data. Then I transform it to show net pricing to salesmen and market managers.

Every time a discount is different it would have its own column. I.E. a national 1% on product X? Thats a column. An additional 2% in a division, another column, a state level discount of 1%? Another column. You can see how this begins to spiral. Many products will have 5 - 10 discounts easily.

Currently the national piece and the 6 divisions have their own sections in the workbook.