{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["TemplateVersion","Introduction","Pricing","Contact Details","Account Details","BAU Details","Category","Service Details","S2SVPN","C2SVPN","SSLVPN","IPVAS Firewall Rules Extract","Customer Firewall Rules Extract","Firewall Rules","Services","IPS","Final Summary","QoS","IP Allocation","Network Routes","VLANs","HW (Dedicated)","DropDowns"],"not_rendered":{"charts":0,"images":25,"macros":1,"external_links":0,"defined_names":158,"comments":5,"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":"TemplateVersion","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Template Version History"]
[]
[null,"Version","Date","Author","Description"]
[null,0.1,"2014-10-26","Greg Smith","Initial"]
[null,0.2,"2014-11-05","Greg Smith","Fixed issues with VPN pages"]
[null,0.3,"2014-11-07","Greg Smith","Added version sheet, changed labels, removed list of services from CG Questionaire"]
[null,0.4,"2014-11-28","Greg Smith","Fixed minor bugs, added Introduction, FAQ and Sign-off worksheets"]
[null,0.5,"2015-01-08","Greg Smith","Major amendments - addition of pricing quotes"]
[null,0.7,"2015-02-04","Greg Smith","Amendments for Daniel Valente"]
[null,0.8,"2015-02-19","Greg Smith","Major revision with feedback incorporated"]

{"sheet":"Introduction","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Cloud Gateway - Introduction",null,null,null,null,{"$f":"CONCATENATE(\"Template Version: \",MAX(TemplateVersion!B4:B22))","v":"Template Version: 0.8"}]
[]
[null,"IMPORTANT: Ensure you \"enable Macros\""]
[null,"This application form will be used to apply for Telstra Cloud Gateway services. Cloud Gateway is a solution comprising of Firewall, Public Network and Private Network without any compute products."]
[null,"The purpose of this document is to accurately capture the scope and requirements of the Cloud Gateway to be deployed and will subsequently be utilised to design and build the Cloud Gateway."]
[]
[null,"Please refer to the accompanying Cloud Gateway Solution Guide document for product information. This application form must be completed by the Technical Pre-Sales consultant in conjunction "]
[null,"with the customer and it must be shared and signed-off by the customer prior to submission."]
[]
[null,null,null,"If you are experiencing issues clicking the 'Next' button, see fix: ","http://support.microsoft.com/kb/3025036/EN-US"]
[]
[null,"Version","Date","Author","Amendment Description"]
[null,0.8,"2015-02-27",null,"Initial Version - Release for Sales Catalogue"]

{"sheet":"Pricing","index":2,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"Cloud Gateway - Pricing Reference"]
[null,"All pricing provided is GST exclusive"]
[]
[null,"Cutovers - Time & Material Rates (Minimum 3 hours)",null,null,"Business Hours (per Hour)","After Hours (per hour)"]
[null,"Project Manager",null,null,200,400]
[null,"Network Designer",null,null,200,400]
[]
[null,"For Dedicated firewall purchases, 2 cutover windows are included up to a maximum of 3 hours. Thereafter, Time & Material rates apply"]
[null,"For Virtual firewall purchases, 1 cutover window is included up to a maximum of 3 hours. Thereafter, Time & Material rates apply"]
[]
[null,"Firewall",null,null,"Setup Fee","Monthly Fee"]
[null,"Virtual","Basic",{"$f":"CONCATENATE(B12, \" - \", C12)","v":"Virtual - Basic"},750,750]
[null,"Virtual","Advance",{"$f":"CONCATENATE(B13, \" - \", C13)","v":"Virtual - Advance"},1600,1600]
[null,"Dedicated","Small Bundle - Basic Management (Cisco ASA5515-X)","Dedicated - Small Bundle - Basic Management (Cisco ASA5515-X)",5042,1705]
[null,"Dedicated","Medium Bundle - Basic Management (Cisco ASA5525-X)","Dedicated - Medium Bundle - Basic Management (Cisco ASA5525-X)",5042,2104]
[null,"Dedicated","Large Bundle - Basic Management (Cisco ASA5545-X)","Dedicated - Large Bundle - Basic Management (Cisco ASA5545-X)",5042,2999]
[null,"Dedicated","Small Bundle - Advanced Management (Cisco ASA5515-X)","Dedicated - Small Bundle - Advanced Management (Cisco ASA5515-X)",7328,3631]
[null,"Dedicated","Medium Bundle - Advanced Management (Cisco ASA5525-X)","Dedicated - Medium Bundle - Advanced Management (Cisco ASA5525-X)",7328,4030]
[null,"Dedicated","Large Bundle - Advanced Management (Cisco ASA5545-X)","Dedicated - Large Bundle - Advanced Management (Cisco ASA5545-X)",7328,4925]
[]
[null,"Scansafe",null,null,"Setup fee","Monthly fee (per User)"]
[null,"Internet Protection Mail","1 to 25 Users",null,75,3.94]
[null,"Internet Protection Mail","26 to 100 Users",null,75,3.71]
[null,"Internet Protection Mail","101 to 500 Users",null,75,3.1]
[null,"Internet Protection Mail","501 to 2500 Users",null,75,2.29]
[null,"Internet Protection Mail","2501+ Users",null,75,1.68]
[null,"Internet Protection Web","1 to 250 Users",null,1015,6.16]
[null,"Internet Protection Web","251 to 400 Users",null,1810,4.17]
[null,"Internet Protection Web","401 to 750 Users",null,1810,3.77]
[null,"Internet Protection Web","751 to 2500 Users",null,3225,3.61]
[null,"Internet Protection Web","2501+ Users",null,"TBC","TBC"]
[null,"Internet Protection Web and Mail","1 to 250 Users",null,1187,7.88]
[null,"Internet Protection Web and Mail","251 to 400 Users",null,2025,5.65]
[null,"Internet Protection Web and Mail","401 to 750 Users",null,1966,5.0599999999999996]
[null,"Internet Protection Web and Mail","751 to 2000 Users",null,3500,4.8499999999999996]
[null,"Internet Protection Web and Mail","2001+ Users",null,"TBC","TBC"]
[]
[null,"Miscellaneous",null,null,"Setup Fee","Monthly Fee"]
[null,"Private Network Connection (Next IP)",null,null,1000,0]
[null,"IP Addresses",null,null,0,5,"per IP Address"]
[null,"QoS",null,null,200,0]
[null,"IPS","Virtual Intrusion Protection Security",null,1200,1200]
[null,"VLAN",null,null,200,0]
[null,"Reverse DNS PTR Record",null,null,100,0]
[]
[null,"Public Internet Connection",null,null,"Setup Fee","Monthly Fee"]
[null,"PAYG",null,null,0,0.15,"per GB in/out"]
[]
[null,"Public Internet Connection",null,null,"Setup Fee","Plan Monthly Fee","Excess Usage"]
[null,"15TB Plan",null,null,0,2250,0.14000000000000001,"per GB in/out"]
[null,"50TB Plan",null,null,0,7150,0.12,"per GB in/out"]
[null,"150 TB Plan",null,null,0,19150,0.1,"per GB in/out"]
[null,"450TB Plan",null,null,0,49150,0.08,"per GB in/out"]

{"sheet":"Contact Details","index":3,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Customer & Integrator Contact Details"]
[null,"Fill out all details below and click Next"]
[null,"Customer Details"]
[null,"Company name*"]
[null,"ACN or ABN"]
[]
[null,"Registered address*"]
[]
[]
[null,"Trading/business name"]
[]
[null,"Business Contact Details"]
[null,"Contact name*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]
[null,"Fax"]
[]
[null,"Customer Onsite Technical Contact Details"]
[null,"Contact name*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]
[null,"Fax"]
[]
[null,"Alternate Customer Onsite Technical Contact Details"]
[null,"Contact name*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]
[]
[null,"IT Integrator / 3rd Party?","No"]
[]
[null,"3rd Party/Integrator Technical Contact Details"]
[null,"3rd Party/Integrator Company name*"]
[null,"Contact name*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]
[null,"Fax"]
[]
[null,"Alternate 3rd Party/Integrator Technical Contact Details"]
[null,"Contact name*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]

{"sheet":"Account Details","index":4,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Telstra Account/Dealer Details/Billing"]
[null,"Fill out all details below"]
[null," Telstra Account Executive Details"]
[null,"Contact name*"]
[null,"D-Account Number*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]
[]
[null,"Telstra Technical Sales Specialist Details"]
[null,"Contact name*"]
[null,"D-Account Number*"]
[null,"Phone (work)*"]
[null,"Phone (mobile)*"]
[null,"Email*"]
[]
[null,"Service",null,null,{"$f":"IF(C18=\"Change service\", \"Change service description\", \"\")","v":""}]
[null,"Status*"]
[null,"Minimum term*","24 months"]
[null,"Early termination charge: 25% of your fees and charges multiplied by the number of remaining months in your minimum term plus any set-up fees (if there are any set-up fees which you have not already paid)"]
[]
[null,"Do you have any existing Telstra Cloud Services?"]
[]
[null,"Billing"]
[null,"CIDN*",null,null,{"$f":"IF(C26=\"New account\",\"Billing address*\", \"\")","v":""}]
[null,"Bill services to*"]
[null,{"$f":"IF(C26=\"Existing account\",\"Existing account number*\", \"\")","v":""}]
[]
[null,"Dealer Office Use (if applicable)"]
[null,"Ordered through Dealer?","No"]
[null,{"$f":"IF(C30=\"Yes\", \"Dealer name*\", \"\")","v":""}]
[null,{"$f":"IF(C30=\"Yes\", \"Dealer codes\", \"\")","v":""}]
[null,{"$f":"IF(C30=\"Yes\", \"Rep name*\", \"\")","v":""}]
[null,{"$f":"IF(C30=\"Yes\", \"Rep ID*\", \"\")","v":""}]
[null,{"$f":"IF(C30 = \"Yes\", \"Phone (work)*\", \"\")","v":""}]
[null,{"$f":"IF(C30=\"Yes\", \"Phone (mobile)\", \"\")","v":""}]
[null,{"$f":"IF(C30=\"Yes\", \"Email*\", \"\")","v":""}]

{"sheet":"BAU Details","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Customer BAU Details"]
[null,"Fill in all details below. At least one contact must be provided"]
[]
[null,"1. Contact(s) that are authorised to submit and approve change requests for your service."]
[null,"2. Contact(s) that are notified via email or SMS on all changes including faults or technical issue with your service."]
[null,"3. Contact(s) that will be contacted via phone or mobile (24x7) in the event of a fault or technical issue with your service."]
[]
[]
[null,"Contact Name","Phone","Mobile","Email Address","1Authorisation","2Notification","3Escalation"]

{"sheet":"Category","index":6,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[[17,1,24,8],[2,4,2,5]]}
[null,"Cloud Gateway - Categorisation"]
[null,"Answer the questions below, click the Categorise Button, then click the Next"]
[null,null,null,null,"Indicative Costs"]
[null,"Is this a Government or non-consenting customer?","No",null,"Setup","Monthly"]
[]
[null,"Firewall Type Purchase?","Please select",null,{"$f":"VLOOKUP(CGQ_FirewallType, Pricing!D:F, 2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(CGQ_FirewallType, Pricing!D:F, 3, FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"Are one or more VPN services required?","No"]
[null,"How many Site to Site VPNs are required?",null,null,{"$f":"IF(AND(CGQ_FirewallType=\"Virtual - Basic\", CGQ_VPNYN=\"Yes\", CGQ_S2S>2), \"The requested Firewall supports a maximum of 2 Site to Site VPNs\", IF(AND(CGQ_FirewallType=\"Virtual - Advance\", CGQ_VPNYN = \"Yes\", CGQ_S2S>10), \"The requested Firewall supports a maximum of 10 Site to Site VPNs\", \"\"))","v":""}]
[null,"How many Client to Site VPNs are required?",null,null,{"$f":"IF(AND(CGQ_FirewallType=\"Virtual - Advance\", CGQ_VPNYN=\"Yes\", CGQ_C2S>10), \"The requested Firewall supports a maximum of 10 Client to Site VPNs\", \"\")","v":""}]
[null,"How many SSL sessions are required?",null,null,null,null,null,null,{"$f":"IF(Category=0, \"\", Category)","v":""}]
[]
[null,"Customer preferred target Cloud Gateway implementation/cutover date (dd/mm/yyyy)?"]
[]
[null,"How many sites will use the Cloud Gateway?"]
[]
[null,"Provide a high level general overview of the customers current network infrastructure and general description of their requirements for the Cloud Gateway:"]

{"sheet":"Service Details","index":7,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":true,"merged":[[15,4,15,6]]}
[null,"Cloud Gateway - Technical Details"]
[null,"Fill in all details below"]
[]
[null,"Preferred Cloud Gateway Location","Please select"]
[]
[null,"Customer Network Prefered Maintenance Window Day(s)","Please select"]
[null,"Customer Network Prefered Maintenance Window Time","Please select",null,{"$f":"IF(OR(C7=\"19:00 - 23:00 (OOH)\", DetailsCustDay=\"Weekend (OOH)\"), \"Note, there is an additional charge for Out of Hours cutovers\", \"\")","v":""}]
[]
[null,"Will this be a migration from an existing Telstra Internet Service or an independent connection?","Please select",null,{"$f":"IF(DetailsisMigration=\"Migration from IPVAS\", \"Please be aware that your existing IPVAS public IP addresses cannot be transferred to\", \"\")","v":""}]
[null,{"$f":"IF(DetailsisMigration=\"Migration from IPVAS\",\"Please provide the existing IPVAS VPN FNN\",\"Please provide the new FNN related to this order\")","v":"Please provide the new FNN related to this order"},".",null,{"$f":"IF(DetailsisMigration=\"Migration from IPVAS\", \"the Cloud Gateway service. New Telstra public IP addresses will be allocated.\", \"\")","v":""}]
[null,"Additionally, please provide the existing TID reference number","."]
[]
[null,"Does the customer own a Public IP range they wish to migrate from an existing provider?","Please select",{"$f":"IF(DetailsPublicIPsby=\"Yes\", \"Please be aware that advertising public IP addressing internally within the Cloud Gateway\", IF(DetailsPublicIPsby=\"No\", \"New Public IP addresses from the Testra owned range will be allocated where required\", \"\"))","v":""}]
[null,"Please specify all Customer owned Public IP ranges they wish to redeploy",".",{"$f":"IF(DetailsPublicIPsby=\"Yes\",\"service is not supported\",\"\")","v":""}]
[]
[null,null,null,null,"Indicative Costs"]
[null,null,null,null,"Setup",null,"Monthly"]
[null,"Public Internet Connection Plan","Please select",null,{"$f":"VLOOKUP(C18,Pricing!B:F, 4, FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(C18,Pricing!B:F, 5, FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(C18=\"PAYG\", \"per GB in/out\", \"\")","v":""}]
[]
[null,"Is Intrusion Prevention Service (IPS) required?","Please select",null,{"$f":"IF(DetailsIPS=\"Yes\",VLOOKUP(\"IPS\",Pricing!B:F,4,FALSE), \"\")","v":""},null,{"$f":"IF(DetailsIPS=\"Yes\",VLOOKUP(\"IPS\",Pricing!B:F,5,FALSE), \"\")","v":""}]
[]
[{"$f":"IF(DetailsScansafeEmail=0, \"\", IF(DetailsScansafeEmail<26,\"1 to 25 Users\",IF(DetailsScansafeEmail>2501,\"2501+ Users\",IF(DetailsScansafeEmail<101,\"26 to 100 Users\",IF(DetailsScansafeEmail<501,\"101 to 500 Users\",IF(DetailsScansafeEmail<2501,\"501 to 2500 Users\",\"2500+ Users\"))))))","v":""},"How many Scansafe Email security accounts are required?",0,null,{"$f":"IF(DetailsScansafeEmail>2500,\"Contact Sales Rep\",IF(DetailsScansafeEmail=0,\"\",VLOOKUP(A22,Pricing!$C$22:$F$26,3,FALSE)))","v":""},null,{"$f":"IF(DetailsScansafeEmail>2500,\"Contact Sales Rep\",IF(DetailsScansafeEmail=0,\"\",VLOOKUP(A22,Pricing!$C$22:$F$26,4,FALSE)*DetailsScansafeEmail))","v":""}]
[{"$f":"IF(DetailsScansafeWeb=0, \"\", IF(DetailsScansafeWeb<251,\"1 to 250 Users\",IF(DetailsScansafeWeb>2501,\"2501+ Users\",IF(DetailsScansafeWeb<401,\"251 to 400 Users\",IF(DetailsScansafeWeb<751,\"401 to 750 Users\",IF(DetailsScansafeWeb<2501,\"751 to 2500 Users\",\"2500+ Users\"))))))","v":""},"How many Scansafe Web security accounts are required?",0,null,{"$f":"IF(DetailsScansafeWeb>2500,\"Contact Sales Rep\",IF(DetailsScansafeWeb=0, \"\", VLOOKUP(A23,Pricing!$C$27:$F$31,3,FALSE)))","v":""},null,{"$f":"IF(DetailsScansafeWeb>2500,\"Contact Sales Rep\",IF(DetailsScansafeWeb=0,\"\",VLOOKUP(A23,Pricing!$C$27:$F$31,4,FALSE)*DetailsScansafeWeb))","v":""}]
[{"$f":"IF(DetailsScansafeEmailWeb=0, \"\", IF(DetailsScansafeEmailWeb<251,\"1 to 250 Users\",IF(DetailsScansafeEmailWeb>2501,\"2501+ Users\",IF(DetailsScansafeEmailWeb<401,\"251 to 400 Users\",IF(DetailsScansafeEmailWeb<751,\"401 to 750 Users\",IF(DetailsScansafeEmailWeb<2001,\"751 to 2000 Users\",\"2001+ Users\"))))))","v":""},"How many Scansafe Email and Web security accounts are required?",0,null,{"$f":"IF(DetailsScansafeEmailWeb>2000,\"Contact Sales Rep\",IF(DetailsScansafeEmailWeb=0,\"\",VLOOKUP(A24,Pricing!$C$32:$F$36,3,FALSE)))","v":""},null,{"$f":"IF(DetailsScansafeEmailWeb>2000,\"Contact Sales Rep\",IF(DetailsScansafeEmailWeb=0,\"\",VLOOKUP(A24,Pricing!$C$32:$F$36,4,FALSE)*DetailsScansafeEmailWeb))","v":""}]
[]
[null,{"$f":"IF(AND(LEFT(CGQ_FirewallType, 7)=\"Virtual\", DetailsIPAddressCount > 32), \"A maximum of 32 IP Addresses are supported with a Virtual firewall\", \"How many IP Addresses are required?\")","v":"How many IP Addresses are required?"},1,null,{"$f":"IF(DetailsIPAddressCount > 0,VLOOKUP(\"IP Addresses\", Pricing!B:F, 4, FALSE)*DetailsIPAddressCount, \"\")","v":0},null,{"$f":"IF(DetailsIPAddressCount > 0, VLOOKUP(\"IP Addresses\", Pricing!B:F, 5, FALSE)*DetailsIPAddressCount, \"\")","v":5}]
[]
[null,"Private Network Connection - Next IP (required)",1,null,{"$f":"VLOOKUP(\"Private Network Connection (Next IP)\", Pricing!B:F, 4, FALSE)","v":1000},null,{"$f":"VLOOKUP(\"Private Network Connection (Next IP)\", Pricing!B:F, 5, FALSE)","v":0}]
[]
[null,"VLAN (required)",1,null,{"$f":"VLOOKUP(\"VLAN\", Pricing!B:F, 4, FALSE)","v":200},null,{"$f":"VLOOKUP(\"Private Network Connection (Next IP)\", Pricing!B:F, 5, FALSE)","v":0}]
[]
[null,"QoS will be provided with a standard policy (refer to Cloud Gateway Solution Guide)","Yes",null,{"$f":"IF(DetailsQoS=\"Yes\",VLOOKUP(\"QoS\",Pricing!B:F,4,FALSE), \"\")","v":200},null,{"$f":"IF(DetailsQoS=\"Yes\",VLOOKUP(\"QoS\",Pricing!B:F,5,FALSE), \"\")","v":0}]
[]
[null,"If you are hosting an externally accessible mail service (eg. SMTP), do you require a reverse DNS PTR Record?","No",null,{"$f":"IF(DetailsReversePTR=\"Yes\",VLOOKUP(\"Reverse DNS PTR Record\",Pricing!B:F,4,FALSE), \"\")","v":""},null,{"$f":"IF(DetailsReversePTR=\"Yes\",VLOOKUP(\"Reverse DNS PTR Record\",Pricing!B:F,5,FALSE), \"\")","v":""}]
[null,null,"IP Address",null,"FQDN",null,"MX Record (if applicable)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"S2SVPN","index":8,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"CONCATENATE(\"Cloud Gateway - Site to Site IPSEC VPN: \", CGQ_S2S)","v":"Cloud Gateway - Site to Site IPSEC VPN: "}]
[null,"Fill out all details below"]
[]
[]
[]
[null,"VPN Parameter",null,"VPN1"]
[null,"Termination Equipment (Telstra)",null,{"$f":"IF(Category = 4, \"Cisco ASA\", \"Juniper Netscreen\")","v":"Juniper Netscreen"}]
[null,"Software Version (Telstra)",null,{"$f":"IF(Category = 4, \"OS 9.1\", \"12.4(15)T\")","v":"12.4(15)T"}]
[null,"Local VPN Gateway (Telstra)",null,"x.x.x.x (Telstra to provide)"]
[null,"Customer Site Name/Location",null,"Customer to provide"]
[null,"Termination Equipment",null,"Customer to provide"]
[null,"Software Version",null,"Customer to provide"]
[null,"Remote VPN Gateway IP",null,"x.x.x.x/32 (Customer to provide) "]
[null,"Pre Shared Key",null,"TO BE CONFIRMED WITH TELSTRA NETWORK DESIGNER"]
[null,"NextIP Networks (Telstra)",null,"x.x.x.x/28 (Telstra to provide)"]
[null,null,null,"x.x.x.x/29 etc (Telstra to provide)"]
[null,"Remote Networks (Customer)",null,"x.x.x.x/28 (Customer to provide)"]
[null,null,null,"x.x.x.x/29 etc (Customer to provide)"]
[null,"Phase 1 Parameters"]
[null,"Authentication Mode",null,"Shared Secret"]
[null,"IPSec Mode",null,"Tunnel"]
[null,"IKE Encryption",null,"AES128"]
[null,"IKE Hash",null,"SHA1"]
[null,"Diffie Hellman Group",null,"1"]
[null,"IKE Lifetime (seconds)",null,28800]
[null,"Phase 2 Parameters"]
[null,"Mode",null,"AH"]
[null,"ESP Encryption",null,"AES128"]
[null,"ESP Hash",null,"SHA1"]
[null,"Perfect Forward Secrecy (PFS)",null,"No PFS"]
[null,"IPSec Lifetime (seconds)",null,3600]

{"sheet":"C2SVPN","index":9,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"CONCATENATE(\"Cloud Gateway - Client to Site IPSEC VPN: \", CGQ_C2S)","v":"Cloud Gateway - Client to Site IPSEC VPN: "}]
[null,"Fill out all details below"]
[]
[]
[]
[null,"VPN Parameter",null,"VPN1"]
[null,"Termination Equipment (Telstra)",null,{"$f":"IF(Category = 4, \"Cisco ASA\", \"Juniper Netscreen\")","v":"Juniper Netscreen"}]
[null,"Software Version (Telstra)",null,{"$f":"IF(Category=4, \"OS 9.1\", \"12.4(15)T\")","v":"12.4(15)T"}]
[null,"Local VPN Gateway (Telstra)",null,"x.x.x.x (Telstra to provide)"]
[null,"Pre Shared Key",null,"TO BE CONFIRMED WITH TELSTRA NETWORK DESIGNER"]
[null,"NextIP Networks (Telstra)",null,"x.x.x.x/28 (Telstra to provide)"]
[null,null,null,"x.x.x.x/29 etc (Telstra to provide)"]
[null,"Remote Networks",null,"x.x.x.x/28 (Customer to provide)"]
[null,null,null,"x.x.x.x/29 etc  (Customer to provide)"]
[]
[null,"Client",null,"Shrewsoft/NCP etc"]
[null,"Number Of User Groups",null,1]
[null,"Authentication",null,"RADIUS"]
[null,"Authentication Details",null,"Primary RADIUS = x.x.x.x (Customer to provide)"]
[null,null,null,"Secondary RADIUS = x.x.x.x (Customer to provide)"]
[null,null,null,"Server UDP ports - 1812"]
[null,null,null,"Radius key  - TO BE CONFIRMED WITH TELSTRA NETWORK DESIGNER"]
[null,"VPN Address Pool/s",null,"x.x.x.x/xx (Customer to provide) "]
[null,"VPN DNS Server",null,"x.x.x.x - Primary (Customer to provide)"]
[null,null,null,"x.x.x.x - Secondary (Customer to provide)"]
[null,"VPN DNS Suffix (if required)",null,"Configure Manually in Shrewsoft/NCP etc"]
[null,"User FQDN (only required for Shresoft users)",null,"Customer to provide"]
[null,"Number Of Simultaneous Logins (from same user)",null,1]
[null,"Idle Timeout (seconds)",null,60]
[null,"VPN Session Timeout (seconds)",null,"None"]
[null,"Split Tunnelling Required",null,"Yes"]
[null,"Split Tunnelling Details (if applicable)",null,"Traffic to x.x.x.x/xx to be encrypted (Customer to provide)"]
[null,null,null,"x.x.x.x/xx to be encrypted (Telstra Cloud)"]
[null,"Phase 1 Parameters"]
[null,"User Fully Qualified Domain Name (u-fqdn)"]
[null,"Authentication Mode",null,"Shared Secret"]
[null,"Pre Shared Key",null,"TO BE CONFIRMED WITH TELSTRA NETWORK DESIGNER"]
[null,"IPSec Mode",null,"Tunnel - Aggressive Mode"]
[null,"IKE Encryption",null,"AES128"]
[null,"IKE Hash",null,"SHA1"]
[null,"Diffie Hellman Group",null,"1"]
[null,"IKE Lifetime (seconds)",null,28800]
[null,"Phase 2 Parameters"]
[null,"Mode",null,"AH"]
[null,"ESP Encryption",null,"AES128"]
[null,"ESP Hash",null,"SHA1"]
[null,"Perfect Forward Secrecy (PFS)",null,"No PFS"]
[null,"IPSec Lifetime (seconds)",null,"3600"]

{"sheet":"SSLVPN","index":10,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"CONCATENATE(\"Cloud Gateway - SSL VPN: \", CGQ_SSL)","v":"Cloud Gateway - SSL VPN: "}]
[null,"Fill out all details below. Remove text from fields that are not required or applicable"]
[]
[]
[]
[null,"VPN Parameter",null,"VPN1"]
[null,"Termination Equipment",null,"Cisco ASA"]
[null,"Software Version",null,"OS 9.1"]
[null,"Telstra Cloud VPN Endpoint (Telstra)",null,"x.x.x.x (Telstra to provide)"]
[null,"Client",null,"Cisco AnyConnect"]
[null,"Push Out Client To Users",null,"No"]
[null,"Number Of User Groups",null,1]
[null,"Keep Client Installed/Uninstall",null,"No"]
[null,"Authentication",null,"RADIUS (MS-CHAPv2 only supported)"]
[null,"Authentication Details",null,"Primary RADIUS = x.x.x.x (Customer to provide)"]
[null,null,null,"Secondary RADIUS = x.x.x.x (Customer to provide)"]
[null,null,null,"Server UDP ports - 1812"]
[null,null,null,"Radius key  - TO BE CONFIRMED WITH TELSTRA NETWORK DESIGNER"]
[null,"VPN Address Pool/s",null,"x.x.x.x/xx (Customer to provide)"]
[null,"VPN DNS Servers (Handed out with IP Address by ASAs)",null,"x.x.x.x - Primary (Customer to provide)"]
[null,null,null,"x.x.x.x - Secondary (Customer to provide)"]
[null,"VPN DNS Suffix (if required)",null,"Customer to provide"]
[null,"Number Of Simultaneous Logins (from same user)",null,"1"]
[null,"Idle Timeout (seconds)",null,60]
[null,"VPN Session Timeout (seconds)",null,"None"]
[null,"Split Tunnelling Required",null,"No"]
[null,"Split Tunnelling Details (if applicable)",null,"Traffic to x.x.x.x/xx to be encrypted (Customer to provide)"]
[null,null,null,"x.x.x.x/xx to be encrypted (Telstra Cloud)"]
[]
[null,"Push Proxy Details To User When They Connect",null,"No"]
[null,"Proxy Details (if applicable)"]
[]
[null,"DNS Name For VPN",null,"Customer to provide"]

{"sheet":"IPVAS Firewall Rules Extract","index":11,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[[13,3,18,4]]}
[null,"Cloud Gateway - IPVAS Firewall Rules Config Extract"]
[]
[]
[]
[]
[null,"You have indicated the Cloud Gateway will be a migration from the IPVAS product.  The firewall rules will be a like-for-like transfer from the existing IPVAS product."]
[null,"If you wish to amend any rules, you can do so post implementation either via the MSS portal or a MAC request."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"1) Click \"Insert File\" button"]
[null,null,null,null,null,"2) Click the \"Create from File\" tab"]
[null,null,"A Network Designer will embed the existing IPVAS Firewall Config Text File here -->",null,null,"3) \"Browse\", locate and select the file"]
[null,null,null,null,null,"4) Tick the \"Display as Icon\" checkbox"]
[null,null,null,null,null,"5) Click \"Insert\""]
[null,null,null,null,null,"6) Click \"OK\" to embed the firewall rules file"]

{"sheet":"Customer Firewall Rules Extract","index":12,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[[13,3,18,4],[8,3,8,4],[9,3,9,4]]}
[null,"Cloud Gateway - Customer Firewall Rules Config Extract"]
[]
[]
[]
[]
[null,"You have indicated that the existing gateway connectivity is terminated with a non-Telstra managed firewall. Please attach the firewall configuration (text file) below and complete the questions."]
[null,"If you wish to amend any rules, you can do so post implementation either via the MSS portal or a MAC request."]
[]
[null,null,"What is the make of the existing firewall (Cisco, Juniper F5, etc)?"]
[null,null,"What is the model of the existing firewall?"]
[]
[]
[]
[null,null,null,null,null,"1) Click \"Insert File\" button"]
[null,null,null,null,null,"2) Click the \"Create from File\" tab"]
[null,null,"Embed the existing Customer Firewall Config Text File here -->",null,null,"3) \"Browse\", locate and select the file"]
[null,null,null,null,null,"4) Tick the \"Display as Icon\" checkbox"]
[null,null,null,null,null,"5) Click \"Insert\""]
[null,null,null,null,null,"6) Click \"OK\" to embed the firewall rules file"]

{"sheet":"Firewall Rules","index":13,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":true,"merged":[[1,3,1,4],[1,5,1,6],[1,2,2,2]]}
["Cloud Gateway - Firewall Rules"]
[null,null,"Internet Outbound / Inbound","Source",null,"Destination"]
["Rule No","Translation Type",null,"Host Name / Network","IP Address / Subnet\n(do not enter DNS names)","Host Name / Network","IP Address / Subnet\n(do not enter DNS names)","Protocol","IP Service Type","Action Required","Comment / Description"]
[1,"PAT / NAT","Outbound / Inbound","NextIP / Internet","All RFC-1918 addresses (add in actual IPs)","Internet","Any","TCP / UDP","http/80\nhttps/443\nDNS\nPING\nTRACEROUTE","Permit","Example rule for illustrative purposes"]

{"sheet":"Services","index":14,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Externally Accessable Services"]
[null,"Fill in all details below related to services hosted within your existing environment that should be accessable externally through the firewall"]
[null,"Site Location","Name of Server","Service Type (mail, web, https, etc)","Current Internal facing IP address","Current External IP (NAT'd address)"]

{"sheet":"IPS","index":15,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - IPS"]
[null,"Fill in the Intrusion Prevention Service (IPS) requirements below"]
[null,"Host Name","IP Address Of Critical Server","OS and Service Pack of Host","Application(s) on Host","Ports","Function Of Host"]
[null,"-or-","-or-","-or-","-or-","(if known)","-or-"]
[null,"Network Description","Network Address(s) & Netmask of Protected Network","OS(s) found on network","Applications on Network","For Host and/or Network","Purpose Of Network"]
["eg.","IPMAN","XXX.XXX.XXX.XXX/XX","Windows 2008","Various","All","Web Services Example"]
["eg.","IPMAN","XXX.XXX.XXX.XXX/XX","Linux","Various","All","Mail Services Example"]

{"sheet":"Final Summary","index":16,"n_rows":95,"n_cols":24,"rows_kept":95,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Customer Final Review"]
[]
[null,"Please take time to review and ensure the information you have provided in each tab of this application is complete and accurate before clicking the Submit button below."]
[null,"Once this application has been submitted, no further scope amendments will be entertained and your application will need to be re-submitted if amendments are required."]
[]
[null,"Your Application"]
[null,"I apply for the service(s) described in this form and acknowledge that if my application is accepted it will be provided on:"]
[null,null,"- The terms and conditions set out in this form"]
[null,null,"- Telstra's general terms for corporate customers"]
[null,null,"- Telstra's Cloud Services section in Our Customer Terms"]
[null,null,"- My separate agreement with Telstra (if applicable)"]
[]
[null,"If there is inconsistancy between this application form and any of the above, the order of precendence set out in the Cloud Services section of Our Customer Terms will apply. Where I have a separate"]
[null,"agreement with Telstra, the order of precendence set out in that agreement will apply."]
[]
[null,"I acknowledge that any recommendations made to me by Telstra concerning the suitability of a package in this application form to meet my specific performance requirements have"]
[null,"been based on the information provided by me. I'm satisfied that the products provided under my chosen package meet my requirements."]
[]
[null,null,"I've either received or had the opportunity to review a copy of Our Customer Terms."]
[]
[null,"Privacy"]
[null,"I agree, and will ensure that any of our related bodies corporate which receive services connected with this application form and our representatives are aware, that Telstra may:"]
[null,"(a) collect, use and disclose information about us and our related bodies corporate (including for marketing purposes) in accordance with Telstra's Privacy Statement (as amended from time to time); and"]
[null,"(b) give to, seek and obtain from, a credit reporting agency, information (including personal and credit information) about us and our personnel to assess our credit worthiness."]
[]
[null,"Cost Summary - Total of fixed fees only (variable usage costs not included). Excludes GST."]
[null,null,"Setup fee","Monthly fee (recurring)","Total contract value"]
[null,null,{"$f":"SUM(Category!E6, 'Service Details'!E18:E34)","v":{"$error":"#N/A"}},{"$f":"SUM(Category!F6, 'Service Details'!G18:G34)","v":{"$error":"#N/A"}},{"$f":"C28+D28*LEFT(SD_S2, 2)","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(LEFT(CGQ_FirewallType, 7)=\"Virtual\", \"A single Cutover event window (in business hours) of 3 hours is included in the overall cost of service. Any additional Cutovers will induce a charge. Please refer to the Pricing tab.\", \"A maximum of x2 Cutover event windows (in business hours) of 3 hours each are included in the overall cost of service. Any additional Cutovers will induce a charge. Please refer to the Pricing tab.\")","v":"A maximum of x2 Cutover event windows (in business hours) of 3 hours each are included in the overall cost of service. Any additional Cutovers will induce a charge. Please refer to the Pricing tab."}]
[null,"Please ensure you have read the Cloud Gateway Solution Document and understand the product limitations."]
[null,"(for example: existing Public IP addresses cannot be migrated from an existing service; Port Forwarding is not supported and only 1-to-1 NAT allowed, etc)"]
[]
[null,null,"I agree that I have read the accompanying Cloud Gateway Solution Document and understand the limitations of the product."]
[null,null,"I agree that the details I have provided in this workbook are complete and any amendments will not be permitted under this order."]
[]
[null,null,null,null,"Signed by Customer",null,"Position"]
[]
[null,null,null,null,{"$f":"IF(ISBLANK(D_SignedDate), \"\", D_SignedDate)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Category","FW","CTS/TSS Name","CTS/TSS Number","Customer Technical Contact Name","Customer Technical Contact Number","3rd Party Contact Name","3rd Party Contact Number","Migration Type","No. Site to Site VPN","No. Client to Site VPN","SSL VPN","IPS","SSWeb","SSMail","QoS","RevDNS","Services","PublicIPs","NonConsent?","CutoverDate","IPAddressCount","SetupFee","MonthlyFee"]
[{"$f":"CGQ_Category","v":""},{"$f":"IF(A95>3, \"Ded\", IF(CGQ_FirewallType=\"Virtual (Shared - Basic)\", \"vFW\", \"vFW+\"))","v":"Ded"},{"$f":"SD_TS1","v":0},{"$f":"CD_29","v":0},{"$f":"CD_20","v":0},{"$f":"CD_22","v":0},{"$f":"CD_27","v":0},{"$f":"CD_29","v":0},{"$f":"DetailsisMigration","v":"Please select"},{"$f":"CGQ_S2S","v":0},{"$f":"CGQ_C2S","v":0},{"$f":"CGQ_SSL","v":0},{"$f":"DetailsIPS","v":"Please select"},{"$f":"DetailsScansafeWeb","v":0},{"$f":"DetailsScansafeEmail","v":0},{"$f":"DetailsQoS","v":"Yes"},{"$f":"DetailsReversePTR","v":"No"},{"$f":"COUNTA(Services!D4:D50)","v":0},{"$f":"DetailsPublicIPsby","v":"Please select"},{"$f":"CGQ_GovYN","v":"No"},{"$f":"CGQ_PrefDate","v":0},{"$f":"DetailsIPAddressCount","v":1},{"$f":"FS_setupfee","v":{"$error":"#N/A"}},{"$f":"FS_monthlyfee","v":{"$error":"#N/A"}}]

{"sheet":"QoS","index":17,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - QoS"]
[null,"Below are the default QoS Policy values that will be configured"]
[null,"Service Level","Protocol","Source IP & Mask","Source Ports","Destination IP & Mask","Destination Ports","ICMP Type","Comments"]
[null,"IP Precedence 5 (Voice/Highest)","RTSP","Any","TCP/UDP-554","Any","TCP/UDP-554",null,"Voice & Video Traffic"]
[null,"IP Precedence 4"]
[null,"IP Precedence 3","RDP","Any",3389,"Any",3389,null,"Remote Desktop"]
[null,"IP Precedence 2","Citrix","Any",1494,"Any",1494,null,"Citrix"]
[null,"IP Precedence 1"]
[null,"IP Precedence 0 (default/none)"]

{"sheet":"IP Allocation","index":18,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - IP Allocations"]
[null,"This worksheet is to be completed by the Cloud Gateway Network Designer"]
["No.","IP/Network","Owner","Netmask","Status","Comment/Usage","Change record - ITAM","Change Record - Date","Request Owner","Change Record - Comment"]

{"sheet":"Network Routes","index":19,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Network Routes"]
[null,"This worksheet is to be completed by the Cloud Gateway Network Designer"]
[null,"Roles","Route","Gateway","Description","Change record - ITAM","Change Record - Date","Request Owner","Change Record - Comment"]

{"sheet":"VLANs","index":20,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - VLANs"]
[null,"This worksheet is to be completed by the Cloud Gateway Network Designer"]
[null,"Roles","Route","Gateway","Description","Change record - ITAM","Change Record - Date","Request Owner","Change Record - Comment"]

{"sheet":"HW (Dedicated)","index":21,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,"Cloud Gateway - Dedicated Hardware"]
[null,"This worksheet is to be completed by the Cloud Gateway Network Designer"]
[null,"Device Name","Location","Hardware","Serial Number\nand Firmware","Comment"]

{"sheet":"DropDowns","index":22,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["D_SiteType","D_GatewaySite","D_FirewallType","D_Existing","D_PublicIPs","D_NextIP","D_IPS","D_IPSType","D_TypeofVPN","D_ReverseDNS","D_ScansafeWeb","D_ScansafeEmail","fValidate"]
["Please select","Please select","Please select","Please select","Please select","Please select","Please select","Please select","Please select","Please select","Please select","Please select","True"]
["Single","Melbourne","Virtual - Basic","New Connection","Yes","Yes","No","Virtual","IPSEC","No","No","No"]
["Dual","Sydney","Virtual - Advance","Migration from IPVAS","No","No","Yes","On the Firewall","SSL","Yes","Yes","Yes"]
[null,null,"Dedicated - Small Bundle - Basic Management (Cisco ASA5515-X)","Migration from TID"]
[null,null,"Dedicated - Medium Bundle - Basic Management (Cisco ASA5525-X)"]
[null,null,"Dedicated - Large Bundle - Basic Management (Cisco ASA5545-X)"]
["D_CGQ2",null,"Dedicated - Small Bundle - Advanced Management (Cisco ASA5515-X)"]
["No",null,"Dedicated - Medium Bundle - Advanced Management (Cisco ASA5525-X)"]
["Yes",null,"Dedicated - Large Bundle - Advanced Management (Cisco ASA5545-X)"]
[]
[]
[]
[]
[]
["D_FWModel",null,"D_Days","D_Time","Category","D_Billing","D_Internet","D_OutboundCount","D_SignedDate"]
["Please select",null,"Please select","Please select",null,"New account","Please select",{"$f":"COUNTIF('Firewall Rules'!C5:C200, \"Outbound\")","v":0}]
["Dedicated - Small Bundle - Basic Management (Cisco ASA5515-X)",null,"Any","Anytime",null,"Existing account","PAYG"]
["Dedicated - Medium Bundle - Basic Management (Cisco ASA5525-X)",null,"Mon","09:00 - 17:00",null,null,"15TB Plan"]
["Dedicated - Large Bundle - Basic Management (Cisco ASA5545-X)",null,"Tues","19:00 - 23:00 (OOH)",null,null,"50TB Plan"]
["Dedicated - Small Bundle - Advanced Management (Cisco ASA5515-X)",null,"Wed",null,null,null,"150 TB Plan"]
["Dedicated - Medium Bundle - Advanced Management (Cisco ASA5525-X)",null,"Thurs",null,null,null,"450TB Plan"]
["Dedicated - Large Bundle - Advanced Management (Cisco ASA5545-X)",null,"Fri"]
[null,null,"Weekend (OOH)"]
[]
[]
[]
[]
[]
["Final Summary","Contact Details","Account Details","BAU Details","Category","ServiceDetails","IPVAS Firewall Rules Extract","Customer Firewall Rules Extract","Firewall Rules","Services","QoS","IPS","Site to Site","Client to Site","SSL"]
[false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]