Please see the attachment. The xls sheet has two sheets, one for BGA pin list and their net names and the other one is an already created ball map.
What I am looking for is a script of software that converts the pin list to the ball map because we do not always receive the ball map so we have to create the ball map from the pin list
True. However, it does not have to be fully automated. I mean the macro can be edited in a way every time according to the BGA size. I did have a macro in the past and it was not a complicated one. unfortunately i lost it :-(
There is a software out there called BallMap Converter but its super expensive for the purpose i need it for!