{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Perth Example","Perth - Student work sheet","Sydney - Student work sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Perth Example","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Hotel California – Site IP Addressing Planner"]
[]
["Hotel Site Name",null,"Perth",null,"Mask"]
["Hotel Site number",null,1]
["Hotel Site Summary Address",null,null,"10.1.0.0","/16"]
[]
["LAN Subnets"]
["Staff",null,"VLAN ID",1000]
[null,null,"Network","10.1.128.0","/24"]
[null,null,"First IP address","10.1.128.1","/24","(use will be revealed later)"]
[null,null,"PERDL1 SVI","10.1.128.2","/24","Second usable address (gateway for this exercise)"]
[null,null,"PERDL2 SVI","10.1.128.3","/24","Third usable address"]
[]
[null,null,"PerStaff1 PC IP addr","10.1.128.10","/24","Tenth usable address"]
[null,null,"PerStaff1 PC gateway","10.1.128.2",null,"(same as SVI on DL1)"]
[null,null,"PerStaff2 PC IP addr","10.1.128.11","/24","Eleventh usable address"]
[null,null,"PerStaff2 PC gateway","10.1.128.2",null,"(same as SVI on DL1)"]
[]
["Guests ",null,"Summary","10.1.0.0","/17"]
[]
["Floor",20,"VLAN ID",20]
[null,null,"Network","10.1.20.0","/24"]
[null,null,"First IP address","10.1.20.1","/24","(use will be revealed later)"]
[null,null,"PERDL1 SVI","10.1.20.2","/24","Second usable address (gateway for this exercise)"]
[null,null,"PERDL2 SVI","10.1.20.3","/24","Third usable address"]
[]
[null,null,"PerGuest1 PC IP addr","10.1.20.10","/24","Tenth usable address"]
[null,null,"PerGuest1 PC gateway","10.1.20.2",null,"(same as SVI on DL1)"]
[]
["Floor",25,"VLAN ID",25,null,"(Example only showing level 25. You will have a different floor)"]
[null,null,"Network","10.1.25.0","/24"]
[null,null,"First IP address","10.1.25.1","/24"]
[null,null,"PERDL1 SVI","10.1.25.2","/24","Second usable address (gateway for this exercise)"]
[null,null,"PERDL2 SVI","10.1.25.3","/24","Third usable address"]
[]
[null,null,"PerGuest2 PC IP addr","10.1.25.10","/24","Tenth usable address"]
[null,null,"PerGuest2 PC gateway","10.1.25.2",null,"(same as SVI on DL1)"]
[]
["Point-to-point links"]
["PERDL1-PERCORE",null,"Network","10.1.255.0","/30"]
[null,null,"PERDL1 e0/0","10.1.255.1","/30","First usable address"]
[null,null,"PERCORE e0/0","10.1.255.2","/30","Second usable address"]
[]
["PERDL2-PERCORE",null,"Network","10.1.255.4","/30"]
[null,null,"PERDL2 e0/0","10.1.255.5","/30","First usable address"]
[null,null,"PERCORE e0/1","10.1.255.6","/30","Second usable address"]

{"sheet":"Perth - Student work sheet","index":1,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Hotel California – Site IP Addressing Planner"]
[]
["Hotel Site Name",null,"Perth",null,"Mask"]
["Hotel Site number",null,1]
["Hotel Site Summary Address",null,null,"10.1.0.0","/16"]
[]
["LAN Subnets"]
["Staff",null,"VLAN ID",1000]
[null,null,"Network","10.1.128.0","/24"]
[null,null,"First IP address","10.1.128.1","/24","(use will be revealed later)"]
[null,null,"PERDL1 SVI","10.1.128.2","/24","Second usable address (gateway for this exercise)"]
[null,null,"PERDL2 SVI","10.1.128.3","/24","Third usable address"]
[]
[null,null,"PerStaff1 PC IP addr","10.1.128.10","/24","Tenth usable address"]
[null,null,"PerStaff1 PC gateway","10.1.128.2",null,"(same as SVI on DL1)"]
[null,null,"PerStaff2 PC IP addr","10.1.128.11","/24","Eleventh usable address"]
[null,null,"PerStaff2 PC gateway","10.1.128.2",null,"(same as SVI on DL1)"]
[]
["Guests ",null,"Summary","10.1.0.0","/17"]
[]
["Floor",20,"VLAN ID",20]
[null,null,"Network","10.1.20.0","/24"]
[null,null,"First IP address","10.1.20.1","/24","(use will be revealed later)"]
[null,null,"PERDL1 SVI","10.1.20.2","/24","Second usable address (gateway for this exercise)"]
[null,null,"PERDL2 SVI","10.1.20.3","/24","Third usable address"]
[]
[null,null,"PerGuest1 PC IP addr","10.1.20.10","/24","Tenth usable address"]
[null,null,"PerGuest1 PC gateway","10.1.20.2",null,"(same as SVI on DL1)"]
[]
["Floor",null,"VLAN ID",null,null,"Use the floor you determined from your student number in the VLAN section."]
[null,null,"Network",null,"/24"]
[null,null,"First IP address",null,"/24","(use will be revealed later)"]
[null,null,"PERDL1 SVI",null,"/24","Second usable address (gateway for this exercise)"]
[null,null,"PERDL2 SVI",null,"/24","Third usable address"]
[]
[null,null,"PerGuest2 PC IP addr",null,"/24","Tenth usable address"]
[null,null,"PerGuest2 PC gateway",null,null,"(same as SVI on DL1)"]
[]
["Point-to-point links"]
["PERDL1-PERCORE",null,"Network","10.1.255.0","/30"]
[null,null,"PERDL1 e0/0","10.1.255.1","/30","First usable address"]
[null,null,"PERCORE e0/0","10.1.255.2","/30","Second usable address"]
[]
["PERDL2-PERCORE",null,"Network","10.1.255.4","/30"]
[null,null,"PERDL2 e0/0","10.1.255.5","/30","First usable address"]
[null,null,"PERCORE e0/1","10.1.255.6","/30","Second usable address"]

{"sheet":"Sydney - Student work sheet","index":2,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Hotel California – Site IP Addressing Planner"]
[]
["Hotel Site Name",null,"Sydney",null,"Mask"]
["Hotel Site number"]
["Hotel Site Summary Address",null,null,null,"/16"]
[]
["LAN Subnets"]
["Staff",null,"VLAN ID",1000]
[null,null,"Network",null,"/24"]
[null,null,"First IP address",null,"/24","(use will be revealed later)"]
[null,null,"SydDL1 SVI",null,"/24","Second usable address (gateway for this exercise)"]
[null,null,"SydDL2 SVI",null,"/24","Third usable address"]
[]
[null,null,"SydStaff1 PC IP addr",null,"/24","Tenth usable address"]
[null,null,"SydStaff1 PC gateway",null,null,"(same as SVI on DL1)"]
[null,null,"SydStaff2 PC IP addr",null,"/24","Eleventh usable address"]
[null,null,"SydStaff2 PC gateway",null,null,"(same as SVI on DL1)"]
[]
["Guests ",null,"Summary",null,"/17"]
[]
["Floor",20,"VLAN ID"]
[null,null,"Network",null,"/24"]
[null,null,"First IP address",null,"/24","(use will be revealed later)"]
[null,null,"SydDL1 SVI",null,"/24","Second usable address (gateway for this exercise)"]
[null,null,"SydDL2 SVI",null,"/24","Third usable address"]
[]
[null,null,"SydGuest1 PC IP addr",null,"/24","Tenth usable address"]
[null,null,"SydGuest1 PC gateway",null,null,"(same as SVI on DL1)"]
[]
["Floor",null,"VLAN ID",null,null,"Use the floor you determined from your student number in the VLAN section."]
[null,null,"Network",null,"/24"]
[null,null,"First IP address",null,"/24","(use will be revealed later)"]
[null,null,"SydDL1 SVI",null,"/24","Second usable address (gateway for this exercise)"]
[null,null,"SydDL2 SVI",null,"/24","Third usable address"]
[]
[null,null,"SydGuest2 PC IP addr",null,"/24","Tenth usable address"]
[null,null,"SydGuest2 PC gateway",null,null,"(same as SVI on DL1)"]
[]
["Point-to-point links"]
["SYDDL1-SYDCORE",null,"Network",null,"/30"]
[null,null,"SYDDL1 e0/0",null,"/30","First usable address"]
[null,null,"SYDCORE e0/0",null,"/30","Second usable address"]
[null,null,"'"]
["SYDDL2-SYDCORE",null,"Network",null,"/30"]
[null,null,"SYDDL2 e0/0",null,"/30","First usable address"]
[null,null,"SYDCORE e0/1",null,"/30","Second usable address"]