DialPlan generator

[Leo Salcie Tejeda]

Hi everyone,

This question is maybe a kind of out this forum topic but this is my last resort. I have been searching for application or excel macro to help me to generate a dialplan based on a list of DN or Pstn number. When I said "generate a dialplan" it means decrease the amount of number that can be in a list putting together the number as in a range. For example:

I have all this number:

DN + PST Numbers List

-----------

4001

4002

4003

5001

5002

7004

18002262727

18002262728

18002262729

Result expected:

---------

4001-4003

5001-5002

7004

18002262727 - 18002262729

In real world, I have to do the same but with more than 7,000 number that's why asking for help...

Regards

Please rate all useful posts
Favor calificar todos las respuestas útiles.
_____________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie
MDGDP, CCNA, CCNA Voice certified       

[will.alvord]

I'm not familiar with an automated tool, but what about a route plan report export to excel with sorting followed by manually identifying ranges.  Unless someone else has found or developed something automagic, that's as good as you're going to get.

[Leo Salcie Tejeda]

Hi Will, thanks for the answer but at the end what I don't want to do is identifiyng range automatly...

Please rate all useful posts
Favor calificar todos las respuestas útiles.
_____________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie
MDGDP, CCNA, CCNA Voice certified

[Leo Salcie Tejeda]

Any thought?

Please rate all useful posts
Favor calificar todos las respuestas útiles.
_____________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie
MDGDP, CCNA, CCNA Voice certified

[Leo Salcie Tejeda]

Any help? Look like I will have to spend my weekend playing with number

Please rate all useful posts
Favor calificar todos las respuestas útiles.
_____________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie
MDGDP, CCNA, CCNA Voice certified

[will.alvord]

I was thinking about this over the weekend and it seems like you could do it programmatically - maybe even an excel macro.  You basically just run down the pattern column of a route plan report csv output and compare the current value with the previous value to see if the current value is previous+1 to signify number ranges (if that makes sense).  There will be special cases for square brackets, dots, x's, bangs, etc.  I just don't have the time to try it.  Might be enough to get you started though.  Sorry I couldn't be more help.

[Leo Salcie Tejeda]

I already found a solution. This two formula make the trick:

=IF(ROWS($A$1:A1)=1,INDEX(List,1),INDEX($A$2:$A$228,SMALL(IF($A$3:$A$228-$A$2:$A$227>1,ROW($A$3:$A$228)-MIN(ROW($A$3:$A$228))+2,""),ROW(A1)-1)))

=IF(SUM(IF($A$3:$A$228-$A$2:$A$227>1,1,""))=ROW(A1)-1,INDEX(List,COUNT(List)),INDEX($A$2:$A$227,SMALL(IF($A$3:$A$228-$A$2:$A$227>1,ROW($A$3:$A$228)-MIN(ROW($A$3:$A$228))+1,""),ROW(A1))))

Can I give me a +5?

Regards

Please rate all useful posts
Favor calificar todos las respuestas útiles.
_____________________________
LinkedIn Profile: do.linkedin.com/in/leosalcie
MDGDP, CCNA, CCNA Voice certified