Python data levelling up calculation

I have a list of items e.g

• Springfield Squad * 10 (ItemA1)
• Tommy gun squad * 5 (ItemA6)
• QF6-Pounder Mk IV * 2 (ItemB2)
• A13 Covenanter Mk III * 1 (ItemC2)

.... ....

My data sheet is as below

https://docs.google.com/spreadsheets/d/1S5QdxQongeVjEaAZp0lDbI6VMnfWle0nRRPdpW7cYv0/edit?usp=sharing

The progression of data is based on the level table below.

Level1	Level 2	Level3	Level 4	Level5	Level 6	Level7	Level 8	Level 9
ItemA1	ItemA2	ItemA3	ItemA4	ItemA5	ItemA6	ItemA7	ItemA8	ItemA9
ItemB1	ItemB2	ItemB3	ItemB4	ItemB5	ItemB6	ItemB7	ItemB8	ItemB9
ItemC1	ItemC2	ItemC3	ItemC4	ItemC5	ItemC6	ItemC7	ItemC8	ItemC9

Rules:

1. Level 1,Level 7 -- > 3 Similar items on combine to make level 2 item( 3 * ItemA1 = ItemA2 , 3*ItemA7 = ItemA8 )

2. Level 2,4,6,8 --> any 3 items can combine to make next level item (i.e at level2 ItemA2ItemB2ItemC2 = ItemA3)

3. Level 3,5 --> 2 similar items can combine to make next level item ( e.g 2 * ItemA3 = ItemA4)

How can I read the list using python and find the best way to progress items, instead of progressing a random item and finding out that it can't reach level9.

This is doing my head in. Happy to answer additional questions if the information provided in not clear.

Currently I am manually reading the data and progressing the same on google sheets.

from Python data levelling up calculation