I’m encountering overflow in utilizing your macro to calculate the # of lines needed @ p.01. Could you send an example .xls sheet w/ the macros & your output?
George, is there any way that you can share that example of that spreadsheet. Im encountering the same problem and I need to report blockage below 1% with MCI and ATT.
Also you may find the theory behind the Erlang’s formula in the book of Theodore S. Rappaport which has name of Wireless Communications in part of Appendix A ( Trunking Theory).
Hi JJ:
Thanks a lot for your help. I will try to read your code to get out the formula from it, but if you have the formual, would it be possilbe for you to mail to me directly? My mail address is: zhongqi_zhang@163.net