Need to generate new code and new no. from given L column

FederationNo FederationCode FederationName
3 F3-001 001-Singampunari vattara vayalaga kootamaippu
1 F1-001 001-Kottampatti vattara vayalaga kootamaippu
2 F2-001 001-Nattarampalli uzhavar mamandram
4 F4-022 022-Bodi vattara kalanjiam
4 F4-022 022-Bodi vattara kalanjiam
5 F5-002 002-Mudhukulathur vattara vayalaga koottamaippu

If Fed. name is 001-Singampunari vattara vayalaga kootamaippu then fed. no. should be 1 and fed. code is F1-001 suppose it have 3 federation names starts with code 001 means then it should 2, F2-001 & 3, F3-001 etc.
if another for new fede. is new means then it should be come like 4-F4-___ here what is the federation name code it should be display.. it should be go like this