DOES ANYONE KNOW THE FORMULA SUITABLE FOR SPREADSHEET USE FOR CALCULATING A PAVEMENT SN (STRUCTURAL NUMBER) KNOWING THE TF (TRAFFIC FACTOR) AND CBR/IBR (CALIFORNIA/ILLINOIS BEARING RATIO?
You'll need several more factors. There is an "equation" for SN once you have all factors, but it is a whopper. I wouldn't try to write a spreadsheet for it. There is a nomograph for SN here:
Flexible Pavement Design Nomograph from American Association of State Highway and Transportation Officials, (1993). “AASHTO Guide for Design of Pavement Structures”.
As LHA says, it's a whopper....I did a spreadsheet for it, but it essentially required that I break down the nomograph equation into three parts so that Excel could take it.
Use the AASHTO equation and keep it general with flexible input. That way you can design the pavement section based on a variety of input factors, not just CBR or other stability criteria.