{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["UDP","Users","SIP Standup Template"],"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":"UDP","index":0,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DEVICE PROFILE NAME","DESCRIPTION","User ID 1","DIRECTORY NUMBER  1","Call Pickup Group 1","LINE TEXT LABEL  1","Line Description 1","ALERTING NAME  1","ASCII Alerting Name 1","DISPLAY  1","ASCII Display 1","ASCII Line Text Label 1"]

{"sheet":"Users","index":1,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["FIRSTNAME","LASTNAME","USERID","PASSWORD","PIN","TELEPHONENUMBER","PRIMARYEXTENSION","CONTROLLEDPROFILE1",null,null,"Selectyourcolumnstosort,thenclickabuttonbelow"]

{"sheet":"SIP Standup Template","index":2,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Standing up a SIP site"]
[]
[null,"Call Manager Activities"]
[]
[null,"1) PARTITION SETUP"]
[]
[null,{"$f":"\"PA-[YOUR PARTITION]-GB-\"&V14&\"-CFLOC, GB-\"&V14&\" CF Local\"","v":"PA-[YOUR PARTITION]-GB--CFLOC, GB- CF Local"}]
[null,{"$f":"\"PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT, GB-\"&V14&\" Local Translations\"","v":"PA-[YOUR PARTITION]-GB--LOCXLT, GB- Local Translations"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Variables"]
[null,"2) CALLING SEARCH SPACE (CSS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partition, CSS Route & Location Scripting"]
[null,{"$f":"\"CS-[YOUR PARTITION]-GB-\"&V14&\"-CFBASIC\"","v":"CS-[YOUR PARTITION]-GB--CFBASIC"},null,null,null,{"$f":"\"(PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT, PA-[YOUR PARTITION]-OWNET)\"","v":"(PA-[YOUR PARTITION]-GB--LOCXLT, PA-[YOUR PARTITION]-OWNET)"},null,null,null,null,null,null,null,null,null,null,null,"Enter Full site name"]
[null,{"$f":"\"CS-[YOUR PARTITION]-GB-\"&V14&\"-CFSTAND\"","v":"CS-[YOUR PARTITION]-GB--CFSTAND"},null,null,null,{"$f":"\"(PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT, PA-[YOUR PARTITION]-OWNET, PA-[YOUR PARTITION]-GB-\"&V14&\"-CFLOC, PA-[YOUR PARTITION]-\"&V14&\"-CFNAT)\"","v":"(PA-[YOUR PARTITION]-GB--LOCXLT, PA-[YOUR PARTITION]-OWNET, PA-[YOUR PARTITION]-GB--CFLOC, PA-[YOUR PARTITION]--CFNAT)"},null,null,null,null,null,null,null,null,null,null,null,"Enter the appropriate site code here >"]
[null,{"$f":"\"CS-[YOUR PARTITION]-GB-\"&V14&\"-CFSUPER\"","v":"CS-[YOUR PARTITION]-GB--CFSUPER"},null,null,null,{"$f":"\"(PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT, PA-[YOUR PARTITION]-OWNET, PA-[YOUR PARTITION]-GB-\"&V14&\"-CFLOC, PA-[YOUR PARTITION]-\"&V14&\"-CFNAT, PA-[YOUR PARTITION]-GB-CFINTERNAT)\"","v":"(PA-[YOUR PARTITION]-GB--LOCXLT, PA-[YOUR PARTITION]-OWNET, PA-[YOUR PARTITION]-GB--CFLOC, PA-[YOUR PARTITION]--CFNAT, PA-[YOUR PARTITION]-GB-CFINTERNAT)"},null,null,null,null,null,null,null,null,null,null,null,"©2013 Mario DeCristofano"]
[null,{"$f":"\"CS-[YOUR PARTITION]-GB-\"&V14&\"-DEVICE\"","v":"CS-[YOUR PARTITION]-GB--DEVICE"},null,null,null,{"$f":"\"(PA-[YOUR PARTITION]-GB-EMG, PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT, PA-[YOUR PARTITION]-GB-GLOBALXLT, PA-[YOUR PARTITION]-GB-LIV-CFLOC)\"","v":"(PA-[YOUR PARTITION]-GB-EMG, PA-[YOUR PARTITION]-GB--LOCXLT, PA-[YOUR PARTITION]-GB-GLOBALXLT, PA-[YOUR PARTITION]-GB-LIV-CFLOC)"}]
[]
[null,"3) ROUTE PATTERN (CALL FORWARD ONLY) NB: This will reset SIP trunks, be advised",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bandwidth (QoS) EF Calulcator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Insert MPLS EF Bandwidth Figure here >"]
[null,{"$f":"\"9.@ GB CF \"&V13&\" Local\"","v":"9.@ GB CF  Local"},null,null,{"$f":"\"- PA-[YOUR PARTITION]-GB-\"&V14&\"-CFLOC, GBCFLocal6, RL-[YOUR PARTITION]-GB-SBC\"","v":"- PA-[YOUR PARTITION]-GB--CFLOC, GBCFLocal6, RL-[YOUR PARTITION]-GB-SBC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V19/32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Put this figure into Cisco Call Manager >",null,null,null,{"$f":"TRUNC(V20)*24","v":0}]
[null,"4) LOCATION (set bandwidth as per EF and value from EF calc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"©2013 Mario DeCristofano"]
[null,"Put this figure into Cisco Call Manager >",null,null,null,{"$f":"TRUNC(V20)*24","v":0}]
[null,{"$f":"\"LO-[YOUR LOCATION]-GB-\"&V14&\"\"","v":"LO-[YOUR LOCATION]-GB-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Telephony & Numbering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the Reception number here Inc zero >"]
[null,"5) REIGON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"©2013 Mario DeCristofano"]
[]
[null,{"$f":"\"RE-[YOUR REIGON]-GB-\"&V14&\"\"","v":"RE-[YOUR REIGON]-GB-"}]
[]
[null,"6) MEDIA RESOURCE GROUP LIST"]
[]
[null,{"$f":"\"MRGL-[YOUR MRG]-GB-\"&V14&\"-REMOTE\"","v":"MRGL-[YOUR MRG]-GB--REMOTE"},null,null,"(Copy an existing one, uses Leeds resources)"]
[]
[null,"7) DEVICE POOL (They have reversed CM Groups)"]
[]
[null,{"$f":"\"DP-[YOUR DEVICE POOL]-GB-\"&V14&\"-CP1\"","v":"DP-[YOUR DEVICE POOL]-GB--CP1"}]
[null,{"$f":"\"DP-[YOUR DEVICE POOL]-GB-\"&V14&\"-CP2\"","v":"DP-[YOUR DEVICE POOL]-GB--CP2"}]
[]
[null,"8) Translation Patterns (per site)"]
[]
[null,{"$f":"\"\\+44\"&V25&\"XX Calling party 90XXXXXXXXXX Called transform: 44\"&V25&\" PA-[YOUR PARTITION]-GB-SBC\"","v":"\\+44XX Calling party 90XXXXXXXXXX Called transform: 44 PA-[YOUR PARTITION]-GB-SBC"}]
[null,{"$f":"\"2XXX  PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT\"","v":"2XXX  PA-[YOUR PARTITION]-GB--LOCXLT"}]
[null,{"$f":"\"0 PA-[YOUR PARTITION]-GB-\"&V14&\"-LOCXLT\"","v":"0 PA-[YOUR PARTITION]-GB--LOCXLT"}]
[null,{"$f":"\"90\"&V25&\"X translates to 44\"&V25&\"X PA-[YOUR PARTITION]-GB-GLOBALXLT\"","v":"90X translates to 44X PA-[YOUR PARTITION]-GB-GLOBALXLT"}]
[]
[null,"9) SUBSCRIBE ALL PHONES WITH EXTENSION MOBILITY"]
[]
[null,"10) ADD USER AND UDP PROFILES NB: Ensure you populate the UDP Template and User Template workbooks first"]
[null,"Click to export the UDP & Users workbooks"]
[null,"as .CSV"]