{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Select Macro","Convert M1 Extns Advance Ftrs","Convert M1 Extns Basic Ftrs","Meridian ACD","Meridian Networking","Meridian DNB","CLID listings","Meridian Routes","DID Call Screening","Network Manager(multiple Sites)","BTeX Extensions","BTeX Networking","DX Extensions","SX2000 Extensions","SX2000 Networking","CDR Import"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Select Macro","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Excel Tool for converting System switch listings to spread sheets for Office 2007 onwards Version 30th January 2013"]
[null,null,null,null,null,null,null,"This version runs OK in Office 2010 and Windows 7, but you need to create a folder C:\\temp"]
[null,null,null,null,null,null,null,"Please contact via",null,"email David Bromley",null," for the latest updates"]
[null,null,null,null,null,null,null,"Copies of this worksheet have been sent over to Gene Trouteaud."]
[false,null,null,null,null,null,null,"Ongoing improvements are being made to it's design & layout."]
[null,null,null,null,null,null,null,"THIS PROGRAM MUST BE RENAMED AS Conversion Utility.xlsm THE MACROS REQUIRE IT!"]
[null,null,null,null,null,null,null,"  If any bugs are found, then please zip up "]
[null,null,null,null,null,null,null,"the raw data & email it to me with the  "]
[null,null,null,null,null,null,null,"problem description."]
[null,null,null,null,null,null,null,"  This workbook must keep the file name of "]
[null,null,null,null,null,null,null,"Conversion Utility.xlsm, Otherwise the macro's "]
[null,null,null,null,null,null,null,"contained within it, will not work."]
[]
[null,null,null,null,null,null,null,"The \"Convert M1 Extns Basic Ftrs\" box will give you most of the"]
[null,null,null,null,null,null,null,"required data to view the results."]
[null,null,null,null,null,null,null," However it's best to use the \"TNB\" in LD 20 with \"REQ\" added at the end "]
[null,null,null,null,null,null,null,"& the \"Convert M1 Extns Advance Ftrs\" box for full system listings"]
[]
["When obtaining any \"Capture\" / \"Log\" files, It's best to remove \"BUG\", \"TRF\" & \"MTC\" from your TTY first!"]
["Remember to put them back in after you have finished collecting the listings."]
[]
[null,"Also make sure that your computer Macro's are enabled for the conversion to work correctly!."]
["For the sheets to work convert correctly, (except the Convert Meridian DNB) keep the file name as Conversion Utility.xlsm!"]
[null,null,null,"Check out this web site http://www.ghtrout.com/files/ConversionUtility(BARS-TNB-More)_by_DB.zip for any updates"]

{"sheet":"Convert M1 Extns Advance Ftrs","index":1,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Captured data should be from a Meridian / Succession system using  \"PRT\" = \"TNB\", \"500\" or \"ARIE\" etc."]
[null,null,"For best results, Use a \"TNB\" capture file in LD 20 to list out most of the systems data and have \"REQ\" at the end!."]
[null,null,"It's now possible to use a \"DSL\" capture file to list out most of the BRI info in LD 27!."]
["Save your TNB",null,null,null,null,null,null,"  When obtaining any \"Capture\" / \"Log\" files, It's best to remove "]
[null,null,null,null,null,null,null,"  BUG, \"TRF\" & \"MTC\" from your TTY first!"]
["Then click here  ----->",null,null,null,null,null,null,"  Remember to put them back in after you have finished collecting"]
[null,null,null,null,null,null,null," the listings."]
["Extn Sets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISM Licence Totals"]
["500 sets",null,null,null,"500 Phntm",null,null,null,"500 Wrls",null,null,null,"Consoles",null,null,null,"PWR TN's",null,null,null,"TN's",null,{"$f":"SUM(C9+G9+K9+S9+C10+G10+K10+O10+G11+K11+O11+S11+C12+G12+K12+O12+S12+C13+G13+K13+O13+S13+C14+G14+K14+O14+S14+C15+G15+K15+O15+S15+C16+G16+K16+O16+S16+C17+G17+K17+O17+S17+C18+G18+K18+O18+S18+C19+G19+K19+O19+S19+C21+G21+K21+O21+S21+C22+G22+K22+S22+C23+G23+K23+O23+S23+O24)","v":0}]
["2006 sets",null,null,null,"2008 sets",null,null,null,"2216 sets",null,null,null,"2616 sets",null,null,null,"Aom fitted",null,null,null,"Digital sets",null,{"$f":"SUM(C10+G10+K10+O10+G11+K11+O11+S11+C12+G12+K12+O12+S12+G13)","v":0}]
["SL1 sets",null,null,null,"2009 sets",null,null,null,"2018 sets",null,null,null,"2112 sets",null,null,null,"2317 sets",null,null,null,"500 sets",null,{"$f":"SUM(C9+G9+K9)","v":0}]
["3901 sets",null,null,null,"3902 sets",null,null,null,"3903 sets",null,null,null,"3904 sets",null,null,null,"3905 sets",null,null,null,"IP Phones",null,{"$f":"SUM(C14+G14+K14+O14+S14+C15+G15+K15+O15+S15+C16+G16+K16+O16+S16+C17+G17+K17+O17+S17+C18+G18+K18+O18+S18+C19+G19+K19+O19)","v":0}]
[null,null,null,null,"390x Host",null,null,null,"390x Virtual",null,null,null,"BRI sets",null,null,null,"PCA sets"]
["I2001 sets",null,null,null,"I2002 sets",null,null,null,null,null,null,null,"I2004 sets",null,null,null,"I2050 sets"]
["2001P2",null,null,null,"2002P1",null,null,null,"2002P2",null,null,null,"2004P1",null,null,null,"2004P2"]
[2007,null,null,null,2033,null,null,null,null,null,null,null,"2050MC",null,null,null,"2050PC",null,null,null,"Digital Trunks",null,{"$f":"SUM(C21+G21+O21)","v":0}]
["2210 WLAN",null,null,null,"2211 WLAN",null,null,null,"2212 WLAN",null,null,null,null,null,null,null,null,null,null,null,"IP Trunks",null,{"$f":"SUM(C22+G22)","v":0}]
[1110,null,null,null,1120,null,null,null,1140,null,null,null,"1150 IPACD",null,null,null,"Uext sets",null,null,null,"Bri Tks/sets",null,{"$f":"SUM(O13+O24)","v":0}]
[1210,null,null,null,1220,null,null,null,1230]
["Trunks"]
["DID",null,null,null,"TIE",null,null,null,"COT",null,null,null,"RDC",null,null,null,"VDC"]
["IPTI",null,null,null,"VGW",null,null,null,"ISA",null,null,null,"DTR or XTD",null,null,null,"VAC"]
["Music",null,null,null,"Ran",null,null,null,"Auto Wake",null,null,null,"Paging",null,null,null,"RCD"]
[null,null,null,null,null,null,null,null,null,null,null,null,"BRI Tks"]
[]
["If you have rls 25 onwards, save the info below in the same file",null,null,null,null,null,null,null,null,null,null,"Save your TNB as a txt or cap file, and off you go"]
["as your TNB. Then you will have tele serial numbers included.",null,null,null,null,null,null,null,null,null,null,"Remember, garbage in, will be garbage out!."]
["This version runs OK in Office 2010 and Windows 7, but you need to create a folder called \"temp\" on the C Drive"]
[">LD 117"]
["=> inv generate sets"]
["Generate set inventory",null,null,null,null,null,null,"Please check this website",null,null,null,null,"http://www.ghtrout.com/ghtrout/index",null,null,null,null,"for updates"]
["Started successfully"]
["MAT011 Inventory sets generation complete"]
["inv prt sets"]

{"sheet":"Convert M1 Extns Basic Ftrs","index":2,"n_rows":27,"n_cols":23,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["email: Dave Bromley",null,null,null,"www.ghtrout.com"]
[]
["Save your TNB",null,null,null,"Captured data should be from a Meridian system using \"PRT\" = \"500\",\"ARIE\" or \"TNB\" etc. Also have \"REQ\" at the end "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Remember, garbage in, garbage out."]
["Then click here  ------------------------------>"]
[]
[]
["Or here for keys suitable for printing--->",null,null,null,null,null,null,null,null,null,null,null,"Do not use this for printing Taurus Sets !"]
["(Use 2216,2616,2006, or 2008 Arie sets only!)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ISM Licence Totals"]
["You may have to experiment with cell height and width to make the labels suitable for printing out the Arie Labels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TN's",null,{"$f":"SUM(C12+G12+K12+O12+S12+C13+G13+K13+O13+S13+C14+G14+K14+O14+S14+C15+G15+K15+O15+S15+C16+G16+K16+O16+S16+C17+G17+K17+O17+S17+C18+G18+K18+O18+S18+C19+G19+K19+O19+S19+C20+G20+K20+O20+S20+C21+G21+K21+O21+S21+C22+G22+K22+O22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Digital sets",null,{"$f":"SUM(C13+G13+K13+O13+S13+G14+K14+O14+S14+C15+G15+K15+O15+S15)","v":0}]
["500 sets",null,null,null,"500 Phntm",null,null,null,"500 Wrls",null,null,null,"Consoles",null,null,null,"PWR TN's",null,null,null,"500 sets",null,{"$f":"SUM(C12+G12+K12)","v":0}]
["2006 sets",null,null,null,"2008 sets",null,null,null,"2216 sets",null,null,null,"2616 sets",null,null,null,null,null,null,null,"IP Phones",null,{"$f":"SUM(C16+G16+K16+O16+S16+C17+G17+K17+O17+C18+G18+K18+O18+S18+C19+G19+K19+O19+S19+C20+G20+K20+O20+S20+C21+G21+K21+O21+S21+C22+G22+K22+O22)","v":0}]
["SL1 sets",null,null,null,"2009 sets",null,null,null,"2018 sets",null,null,null,"2112 sets",null,null,null,"2317 sets"]
["3901 sets",null,null,null,"3902 sets",null,null,null,"3903 sets",null,null,null,"3904 sets",null,null,null,"3905 sets"]
["I2001 sets",null,null,null,"I2002 sets",null,null,null,null,null,null,null,"I2004 sets",null,null,null,"I2050 sets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PCA sets"]
["2001P2",null,null,null,"2002P1",null,null,null,"2002P2",null,null,null,"2004P1",null,null,null,"2004P2"]
[2007,null,null,null,2033,null,null,null,null,null,null,null,"2050MC",null,null,null,"2050PC"]
["2210 WLAN",null,null,null,"2211 WLAN",null,null,null,"2212 WLAN"]
[1110,null,null,null,1120,null,null,null,1140,null,null,null,"1150 IPACD"]
[1210,null,null,null,1220,null,null,null,1230]
[]
[]
[]
["When obtaining any \"Capture\" / \"Log\" files, It's best to remove BUG, \"TRF\" & \"MTC\" from your TTY first!"]
["Remember to put them back in after you have finished collecting the listings."]

{"sheet":"Meridian ACD","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,3,3,5]]}
[]
["This version runs OK in Office 2010 and Windows 7, but you need to create a folder called \"temp\" on the C Drive"]
[]
["Enter Filename Here (in cell A5) or use browse button",null,null,"Number of Queues"]
["C:\\Temp",null,null,"ACD"]
[]
[null,null,null,"CDN"]
[]
["This will turn a LD 23 ACD and CDN capture file into a Excel spreadsheet"]
[]
["If there are other messages elsewhere, the program will mostly cope & just small parts of the data will be missing."]
[]
["Please check out this web site","http://www.ghtrout.com/ghtrout/index.hmtl",null,null,null,"for updates"]
[]
["When obtaining any \"Capture\" / \"Log\" files, It's best to remove \"BUG\", \"TRF\" & \"MTC\" from your TTY first!"]
["Remember to put them back in after you have finished collecting the listings."]

{"sheet":"Meridian Networking","index":4,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["email: Dave Bromley","www.ghtrout.com",null,null,null,"Now names work sheet with file name"]
["This version runs OK in Office 2010 and Windows 7, but you need to create a folder called \"temp\" on the C Drive"]
["Enter Filename Here (in cell A5)"]
["C:\\Temp"]
[]
[]
["This program will pull together dmi, rli, cdp, etc into a one line per code file that can be imported into Excel."]
["File capture (into one file) dmi, rli, lsc, dsc, tsc, loc, hloc, & spn.",null,null,"\"TYPE ALL\" does not work"]
["This version will only work correctly up to ENTR 5 (inserts on DMI will lose leading 0 after that)"]
["If you have over 5 entries, Then you must manually import temp.prn, setting all columns to text"]
["Note that the program relies on 2 things -"]
["1 The part where the user prompts are typed in must be without spurious characters, i.e. "]
["TYPE BUG ????????????????????"]
["???????????????SPN"]
["would not be acceptable."]
["If this happens, type *(return) to redo the prompt."]
["2 There must be REQ at the end of each section, including one right at the end of the file."]
[]
["If there are other messages elsewhere, Then the program will mostly cope with just small parts of data missing."]
[]
["When obtaining any \"Capture\" / \"Log\" files, It's best to remove \"BUG\", \"TRF\" & \"MTC\" from your TTY first!"]
["Remember to put them back in after you have finished collecting the listings."]
[]
[]
["LD 86 ESN Listings 1","Dmi's",null,null,null,"Rte Lists"]
["LD 87 ESN Listings 2","DSC's",null,null,null,"TSC's",null,null,null,"LSC's"]
["LD 90 ESN Listings 3","SPN's",null,null,null,"HLOC's",null,null,null,"LOC's",null,null,null,"NPA's"]
["LD 90 ESN Listings 3",null,null,null,null,null,null,null,null,null,null,null,null,"NXX's"]

{"sheet":"Meridian DNB","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["This version runs OK in Office 2010 and Windows 7, but you need to create a folder called \"temp\" on the C Drive"]
[]
["Save your DNB"]
[]
["Then click here  --------------------->"]
[]
[null,"This DNB programme will now do IP & PCA Phones!, But \"ES\" may be shown under the \"DES\" column!"]
["You will find a error message with a \"TEMP\" worksheet name after the conversion. Just rename the worksheet to e.g. Directory Number Block.  "]
[null,null,null,null,"Check my website",null,"www.ghtrout.com","For updates"]
["Remember. If garbage goes in, Then garbage will come out!."]
["When obtaining any \"Capture\" / \"Log\" files, It's best to remove BUG, \"TRF\" & \"MTC\" from your TTY first!"]
["Remember to put them back in after you have finished collecting the listings."]
["Example of listings produced are shown below."]
[]
[null,"DN","TYPE","TN","DES","DATE","NAME","MARP"]
[null,12,"SFP"]
[null,"265844","500","007 0 00 10","DECT32","2003-06-09","Micky Mouse \"Just in case\"","MARP"]
[null,"265845","(I2050 )","090 0 00 18","ES I2050","2002-11-16","George Bush I2050","MARP"]
[null,"265846","(2616)","016 0 00 07","M3310","2000-02-04","Johnny Depp","MARP"]
[null,"265847","(PCA )","098 0 00 02","ES PCA","2002-11-05","Shania Twain"]
[null,"265848","DISA"]
[null,"265849","CDP"]
[null,"265850","ACDN"]
[null,"265851","RDB",null,null,null,"The White House Fan Club"]
[null,"265853","ATT"]
[null,"265854"]
[null,"265855"]
[null,"9","NARS"]
[null,"*8","FFC"]

{"sheet":"CLID listings","index":6,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"CLID Format Version for Meridian 1 / Succesion / CS1000 systems"]
["This version runs OK in Office 2010 and Windows 7, but you need to create a folder called \"temp\" on the C Drive"]
[]
[]
[null,"To produce a formatted Excel document of CLID table entries."]
[null,"Save print output from LD 21, PRT, CLID as a text file."]
[null,"Then click here  ----------------------------------------->"]
[]
[]
[null,"An example of what is produced is shown below"]
[]
[]
["ENTRY","HNTN","ESA_HLCL","ESA_INHN","ESA_APDN","HLCL","DIDN"]
[0,2038,null,"NO","NO",798000,"YES"]
[1,3332,null,"NO","NO",666940,"NO"]
[2,2925,null,"NO","NO",867592,"NO"]
[3,3332,null,"NO","NO",707101,"NO"]
[4,3332,null,"NO","NO",666941,"NO"]
[5,3332,null,"NO","NO",666942,"NO"]
[6,3332,null,"NO","NO",666944,"NO"]
[7,2786,null,"NO","NO",816249,"NO"]
[8,3332,null,"NO","NO",666945,"NO"]
[9,2038,null,"NO","NO",798500,"YES"]
[10,3332,null,"NO","NO",666946,"NO"]

{"sheet":"Meridian Routes","index":7,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"V1.1"]
["This Sheet is under development!"]
[]
["Enter Filename Here (in cell A5) or use browse button"]
["C:\\Documents and Settings\\davidbr\\My Documents\\VF ONE\\MCLAREN\\McLaren pre listings 3rd December 2009\\Route Data Block.DOC"]
[]
[]
[]
["This will turn a LD 16 RDB capture file into a Excel spreadsheet"]
[]
["If there are other messages elsewhere, the program will mostly cope & just small parts of the data will be missing."]
["email: Dave Higham      Please check my web site","http://www.pepedog.com/meridian/",null,null,null,"for updates"]
[]
["When obtaining any \"Capture\" / \"Log\" files, It's best to remove \"BUG\", \"TRF\" & \"MTC\" from your TTY first!"]
["Remember to put them back in after you have finished collecting the listings."]

{"sheet":"DID Call Screening","index":8,"n_rows":99,"n_cols":5,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["USING DID CALL SCREENING  ",null,null,null,"(Thanks to Neil Partidge)"]
["THIS IS AN EXAMPLE"]
["CUSTOMER HAS NETWORK  -  LINKED USING NARS. REQUIRED TO ROUTE CALL OVER PSTN "]
["IF NETWORK BUSY.  CUSTOMER HAS HUNDREDS OF SITES."]
["EXAMPLE 1 OF ONE LOCATION CODE (750)"]
["THIS OFFICE IS IN BIRMINGHAM - 2 SITES SERVED BY TWO DIFFERENT EXCHANGES "]
["(230 & 455)"]
["NETWORK EXTNS AGAINST THIS LOC ARE 0121 230 2500 - 2999 AND 0121 455 4000 - 4599"]
["THEY HAVE A MAIN NUMBER  ",null,null,"0121 455 1620 (NON DDI)"]
[]
["IN LD 86"]
["BUILD RLI WITH DEFAULT VALUES EXCEPT THE FOLLOWING"]
["EXAMPLE"]
["PROMPT ","RESPONSE"]
["RLI = 10"]
["ENTR= 1"]
["ROUT= 20 (PRIVATE LINK)"]
["CNV=NO"]
["DMI=1","DEL 0","INST NONE"]
[]
["ENTR=2"]
["ROUTE=110(O/G PSTN)"]
["CNV=YES"]
["DMI=110","DEL 0","INST '0'"]
[]
["NARS CODE (AC2) =7"]
["IN LD 90 "]
[]
["TYPE = LOC"]
["LOC=750"]
["FLEN=7"]
["RLI=10"]
["LDN=1214551620 (MAIN NUMBER). NOTE MAX DIG LENGTH IS 10. THE LDN ASSUMES THE FIRST"]
["3 DIGITS ARE THE AREA CODE - THE DMI TABLE INSERTS THE LEADING '0' (EG 0121). THIS  "]
["AREA CODE IS USED FOR ALL OFFC ENTRIES AGAINST THIS LOC. THEREFORE A LOC CODE"]
["CANNOT ROUTE TO MULTI SITES SERVED BY EXCHANGES IN MORE THEN ONE DIAL AREA "]
["(EG 'BIRMINGHAM')"]
[]
[]
["DID=YES (ARE EXTNS ON THIS LOC DDI?)"]
["MNXX=YES (IS THERE MORE THEN ONE EXCHANGE SERVING DDI WITHIN THE BIRMINGHAM "]
[null,"       AREA -  THIS WILL PROMPT YOU WITH OFFC MORE THAN ONCE)"]
["SAVE=4 (NUMBER OF LAST DIGITS TO BE INSERTED FOR ROUTING) "]
["OFFC=230 (EXCHANGE IN BIRMINGHAM)"]
["RNGE=2500 2999 (DDI EXTNS ON THIS EXCHANGE)"]
["OFFC=455"]
["RNGE=4000 4599"]
[]
["WHEN THE USER IN LONDON DIALS 7 750 2555 THE CALL WILL ATTEMPT TO ROUTE ON "]
["PRIVATE LINK (ROUTE 20). IF THIS IS BUSY IT WILL LOOK AT SECOND CHOICE (110) IF"]
["CONV= YES IT WILL CHECK THE MATRIX TABLE AGAINST THIS LOC. IT WILL FIND A MATCH"]
["AND SAVE THE LAST 4 DIGITS (2555) IT WILL INSERT '0' (DMI 110) THEN THE AREA CODE "]
["FROM THE LDN (121) THEN THE OFFC CODE (230). 0121 230 2555 SENT TO PSTN."]
["IF A MATCH WAS UNSUCCESSFUL THEN THE MERIDIAN INSERTS '0' (DMI 110) THEN THE LDN. "]
["THE CALL WILL BE ROUTED TO THE MAIN ATTENDANT IN BIRMINGHAM."]
[]
["###############################################################################"]
[]
[]
[]
["LOCATION:","HOUSTON"]
["IN LD 86"]
["PROMPT ","RESPONSE"]
["RLI = 10"]
["ENTR= 1"]
["ROUT= 120 (PRIVATE LINK)"]
["CNV=NO"]
["DMI=1","DEL 0","INST NONE"]
[]
["ENTR=2"]
["ROUTE=100 (O/G PSTN)"]
["CNV=YES"]
["DMI=1","DEL 0","INST '0'"]
[]
["ENTR=3"]
["ROUTE=110 (O/G BT)"]
["CNV=?"]
["DM1=1","DEL 0","INST '0'"]
[]
["NARS CODE (AC2) =6"]
["IN LD 90 "]
[]
["TYPE = LOC"]
["LOC=",219]
["FLEN=",8]
["RLI=10"," "]
["LDN=0171321951 (MAIN NUMBER). NOTE MAX DIG LENGTH IS 10. THE LDN ASSUMES THE FIRST"]
["3 DIGITS ARE THE AREA CODE - THE DMI TABLE INSERTS THE LEADING '0' (EG 0121). THIS  "]
["AREA CODE IS USED FOR ALL OFFC ENTRIES AGAINST THIS LOC. THEREFORE A LOC CODE"]
["CANNOT ROUTE TO MULTI SITES SERVED BY EXCHANGES IN MORE THEN ONE DIAL AREA ."]
["DID=YES (ARE EXTNS ON THIS LOC DDI?)"]
["MNXX=YES "]
["SAVE=4 (NUMBER OF LAST DIGITS TO BE INSERTED FOR ROUTING) "]
["OFFC=","219"]
["RNGE=","5100-5399(DDI EXTNS ON THIS EXCHANGE)"]
["OFFC="]
["RNGE="]
[]
["##########################################################################################"]

{"sheet":"Network Manager(multiple Sites)","index":9,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,0,7,4]]}
[]
[]
[]
[null,null,null,"v1.1e",null,"Doing Site 1"]
[null,null,null,"CONTROL BREAK TO STOP",null,null,"Step 3:Please fill out these"]
[null,null,null,null,null,null,"Three cells"]
["Step 1:Make a new folder, and place this macro in it",null,null,null,null,"Lowest Extension Number","20000"]
["Step 2:Capture the information\nand place the files in that same folder",null,null,null,null,"Highest Extension Number","50000"]
["& place the files in that same folder",null,null,null,null,"Number of Sites",1]
["Save site 1 as 1.TXT",null,null,null,null,"(because there are only 65536 cells in a spreadsheet)"]
["Save site 2 as 2.TXT"]
["so on",null,null,null,null,"Number of DN's covered =",{"$f":"G8-G7+1","v":30001}]
["so on"]
["Save site 8 as 8.TXT"]
["Save site 9 as 9.TXT"]
["And so on"]
["MERIDIAN PRINTS ARE LD 20, DNB  &  LD 87, DSC, TSC"]
["Step 4: Click the process button"]
["What this macro does - It is for multiple sites, where the numbers are portable across all sites."]
["Each cell will show either the TYPE of local TN, or give the RLI number."]
["Sorting by the \"Used By\" column may help in checking out problems."]
[]
["email: Dave Higham ",null,"Check my web site",null,"http://www.pepedog.com/meridian/",null,"for updates"]

{"sheet":"BTeX Extensions","index":10,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["email: Dave Higham",null,null,"www.pepedog@pepedog.com",null,null,"V1.2a"]
[]
["Save your TNB",null,null,"(at the CCSP prompt, it's best to say YES)"]
[]
["Then click here  ----------------------------------------->"]
[]
["Remember. If garbage goes in, Then garbage will come out!."]
[]
[]
["500 sets"]
["AFP sets"]
["IFP sets"]
["SL1 Sets"]

{"sheet":"BTeX Networking","index":11,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["email: Dave Higham",null,null,"www.pepedog@pepedog.com"]
[]
["The BTEX File should have SCB & LOCD and UACN"]
[]
[]
[]
["Then click here  ---->"]
[]
["Remember. If garbage goes in, Then garbage will come out!."]

{"sheet":"DX Extensions","index":12,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["email: Dave Higham",null,null,"www.pepedog@pepedog.com",null,null,"V1.2"]
[]
["Capture your DX printouts"]
[]
["Then click here  ----------------------------------------->"]
[]
["Remember. If garbage goes in, Then garbage will come out!."]
[]
[]
["500 sets",null,null,null,null,"PRINT OUTS REQUIRED FOR DX"]
["Dig sets",null,null,null,null,"LEX FOR EACH EXTN"]
[null,null,null,null,null,"LTP A"]
[null,null,null,null,null,"LIVU A"]

{"sheet":"SX2000 Extensions","index":13,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["email: Dave Higham",null,null,"www.pepedog@pepedog.com"]
[]
["No apologies for resulting output spreadsheet being in \"Meridian Speak\""]
[null,null,null,null,null,"PRINT OUTS REQUIRED FOR SX2000"]
[]
[null,null,null,null,null,"MULTILINE SET ASSIGNMENT"]
[null,null,null,null,null,"SINGLELINE SET KEY ASSIGNMENT"]
[null,null,null,null,null,"MULTILINE SET KEY ASSIGNMENT"]
[null,null,null,null,null,"PICKUP GROUP ASSIGNMENT"]
[null,null,null,null,null,"CALL REROUTING ALWAYS ALTERNATIVE ASSIGNMENT"]
[null,null,null,null,null,"CALL REROUTING ASSIGNMENT"]
[null,null,null,null,null,"CALL REROUTING FIRST ALTERNATIVE ASSIGNMENT"]
[null,null,null,null,null,"CALL REROUTING SECOND ALTERNATIVE ASSIGNMENT"]
[null,null,null,null,null,"TELEPHONE DIRECTORY"]
["Remember. If garbage goes in, Then garbage will come out!."]
[null,null,null,null,null,"It may be simpler to -"]
[null,null,null,null,null,"Log into terminal,"]
[null,null,null,null,null,"PF6 for maintenance mode,"]
[null,null,null,null,null,"Formprint all \\lpr2"]
[null,null,null,null,null,"Now turn capture on PC on"]
[null,null,null,null,null,"enable print"]

{"sheet":"SX2000 Networking","index":14,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["email: Dave Higham","www.pepedog@pepedog.com"]
[]
["Remember. If garbage goes in, Then garbage will come out!."]
[null,null,"It may be simpler to -"]
[null,null,"Log into terminal,"]
[null,null,"PF6 for maintenance mode,"]
[null,null,"Formprint all \\lpr2"]
[null,null,"Now turn capture on PC on"]
[null,null,"enable print"]
[]
[]
[]
["SX2000 Should have\nDigit Modification Assignmemt\nRoute Assignment\nRoute List Assignment\nand Automatic Route Selection Assignment"]

{"sheet":"CDR Import","index":15,"n_rows":1,"n_cols":24,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Type","Call Reference","Customer Number","Originating","Terminating","Time","Duration","Digit Type","Digits","CLID","CHGINFO","CALLCHG","FGDANI","DNIS","Orig Aux ID","Term Aux Id","TTA","REDIR","TWT","BLID","ABANDON","100 hour diversion","NPI","TON"]