Count data to a limit and increment counter

I have a list of data and I'm trying to assign a numberical value to each line of code up to the number 30. Once I've reached 30 I'd like to increment the counter by one. For example, I have the code "APL" and it is replicated 62 times. I would like to have a counter that starts at 101 and every 30 iterations, the count will increase to 102, and finally the remaining two would be assigned to 103. Once the next unique value is reached the counter would increase to 104.

I know this sounds a little confusing so I've attached a sample sheet. The first tab is the data as I recieve it, and the second tab shows the data as I would like to see it.

Please note that the data will always be grouped together and in alphabetical order.