{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INSTRUCTIONS","1 - Infrastructure Status Log","2 - Equipment List","3 -Penetration Test Remediation","4 - Test Plan","5 - Test Log","Lookup"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":20,"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":"INSTRUCTIONS","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,0,1,2],[2,0,2,2],[3,0,3,2],[0,0,0,2],[0,3,0,7],[1,3,1,7],[2,3,2,7],[3,3,3,7]]}
["Workbook ID: ",null,null,"DSS-0009-01"]
["Student First Name: "]
["Student Surname: "]
["Student ID: "]

{"sheet":"1 - Infrastructure Status Log","index":1,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Device Name","Type","Location","Status","State","Notes"]
["WS001","Physical","Administration","Green","Connected","Any notes in relation to the device's status or state can be included here"]

{"sheet":"2 - Equipment List","index":2,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,11,2,12],[3,11,3,12],[4,11,4,12],[10,10,10,11],[11,10,11,11]]}
["Type","Vendor","Name","Serial No.","MAC Address","IP Address","Status","State"]
["Desktop","Dell","ADM-001","ABC12345","df:76:8f:c8:00:be","N/A DHCP Assigned","Green","Connected",null,null,"Note: status has the following values and meanings:"]
["Desktop","Dell","ADM-002","ABC12346","08:99:8d:e0:7f:ad","N/A DHCP Assigned","Amber","Connected",null,null,"Red","Critical issues"]
["Desktop","Dell","CONS-003","ABC12355","e5:8c:ab:04:36:c9","N/A DHCP Assigned","Green","Connected",null,null,"Amber","Some issues"]
["Desktop","Dell","CONS-004","ABC12356","4b:00:e2:b1:10:63","N/A DHCP Assigned","Amber","Connected",null,null,"Green","No issues"]
["Desktop","Dell","CONS-005","ABC12357","ed:1b:ef:82:e3:b8","N/A DHCP Assigned","Green","Connected"]
["Desktop","Dell","CONS-006","ABC12358","5c:ff:9a:bc:2d:5e","N/A DHCP Assigned","Red","Disconnected"]
["Desktop","Dell","NUR-007","ABC12375","1c:b1:f7:a7:3d:2a","N/A DHCP Assigned","Green","Connected",null,null,"Note: business departments are:"]
["Desktop","Dell","NUR-008","ABC12376","8b:09:02:b9:10:68","N/A DHCP Assigned","Red","Disconnected",null,null,"Administration",null,"ADM"]
["Desktop","Dell","IT-009","ABC12385","3d:2a:bc:b1:ea:76","N/A DHCP Assigned","Green","Connected",null,null,"Consultation (doctors)",null,"CONS"]
["Desktop","Dell","IT-010","ABC12386","2a:b2:60:17:a5:c1","N/A DHCP Assigned","Green","Connected",null,null,"Nursing",null,"NUR"]
["Mobile Device","Android","MD-001","ABC12390","d2:59:c3:cc:fd:9c","N/A DHCP Assigned","Green","Connected",null,null,"IT Support",null,"IT"]
["Mobile Device","Android","MD-002","ABC12391","df:76:8f:c8:00:be","N/A DHCP Assigned","Green","Connected"]
["Mobile Device","Android","MD-003","ABC12392","8e:aa:3e:de:ed:0d","N/A DHCP Assigned","Green","Connected"]
["Mobile Device","Android","MD-004","ABC12393","b2:f8:94:5c:8d:31","N/A DHCP Assigned","Green","Connected"]
["Remote Laptop","Lenovo","RL-001","ABC12395","53:dd:ee:30:16:e7","N/A DHCP Assigned","Green","Connected"]
["Remote Laptop","Lenovo","RL-002","ABC12396","8d:f8:c6:9f:fd:22","N/A DHCP Assigned","Red","Disconnected"]
["Remote Laptop","Lenovo","RL-003","ABC12397","e5:8c:ab:04:36:c10","N/A DHCP Assigned","Green","Connected"]
["Remote Laptop","Lenovo","RL-004","ABC12398","4b:00:e2:b1:10:64","N/A DHCP Assigned","Green","Connected"]
["Server","Dell","Server01","ABC12425","2f:fd:27:3d:f8:5e","192.168.220.10","Green","Connected"]
["VoIP Server","Dell","VoIP_Server","ABC12426","00:1b:44:a5:1f:e11","192.168.220.16","Green","Connected"]
["Switch","Cisco","Switch01","ABC12427","3d:2a:bc:b1:ea:77","192.168.220.30","Green","Connected"]
["Switch","Cisco","Switch02","ABC12428","2a:b2:60:17:a5:c2","192.168.220.31","Green","Connected"]
["Printer","HP","Printer01","ABC12431","a1:b2:c3:d4:e5:f7","192.168.220.35","Green","Connected"]
["Router","Cisco","Router01","ABC12432","4d:2a:dc:b1:ea:78","192.168.220.1","Green","Connected"]

{"sheet":"3 -Penetration Test Remediation","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Action Owner","Total Actions","CVSS Ratings Summary","Total"]
["Administration",{"$f":"COUNTIF(G12:G50,A2)","v":0},"Critical",{"$f":"COUNTIF(E12:E50,\"Critical\")","v":0}]
["Consultation",{"$f":"COUNTIF(G12:G50,A3)","v":0},"High",{"$f":"COUNTIF(E12:E50,\"High\")","v":1}]
["Nursing",{"$f":"COUNTIF(G12:G50,A4)","v":0},"Medium",{"$f":"COUNTIF(E12:E50,\"Medium\")","v":0}]
["IT Support",{"$f":"COUNTIF(G12:G50,A5)","v":0},"Low",{"$f":"COUNTIF(E12:E50,\"Low\")","v":0}]
["Quality Assurance",{"$f":"COUNTIF(G12:G50,A6)","v":0},"Information",{"$f":"COUNTIF(E12:E50,\"Information\")","v":0}]
["Senior Management",{"$f":"COUNTIF(G12:G50,A7)","v":0},"Total:",{"$f":"SUM(D2:D6)","v":1}]
["Executive Team",{"$f":"COUNTIF(G12:G50,A8)","v":0}]
["TOTAL: ",{"$f":"SUM(B2:B5)","v":0}]
[]
["Ref","Vulnerability Description","Action/Comment","Status","CVSS Rating","CVSS Score","Action Owner","Deadline","Comments"]
[10001,"KB****** for *** Critical Update missing from all ***********","Download, install, test etc","Open","High",8.1,"Server and Storage","2020-05-29","deadline based on…."]

{"sheet":"4 - Test Plan","index":4,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ID","Area Name","Notes"]
[1,"Test 1 - OS has been installed ","OS installation complete and machine boots"]
[2,"Test 2 - "]
[3,"Test 3 -"]
[4,"Test 4 -"]
[5,"Test 5 -"]
[6,"Test 6 -"]
[7,"Test 7 -"]
[8,"Test 8 -"]
[9,"Test 9 -"]
[10,"Test 10 -"]
[null,"General comments"]

{"sheet":"5 - Test Log","index":5,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[109,0,109,5],[126,0,126,5]]}
[]
[]
[]
[]
["Device Name",{"$f":"'4 - Test Plan'!B13","v":"Test 1 - OS has been installed "},{"$f":"'4 - Test Plan'!B14","v":"Test 2 - "},{"$f":"'4 - Test Plan'!B15","v":"Test 3 -"},{"$f":"'4 - Test Plan'!B16","v":"Test 4 -"},{"$f":"'4 - Test Plan'!B17","v":"Test 5 -"},{"$f":"'4 - Test Plan'!B18","v":"Test 6 -"},{"$f":"'4 - Test Plan'!B19","v":"Test 7 -"},{"$f":"'4 - Test Plan'!B20","v":"Test 8 -"},{"$f":"'4 - Test Plan'!B21","v":"Test 9 -"},{"$f":"'4 - Test Plan'!B22","v":"Test 10 -"},{"$f":"'4 - Test Plan'!B23","v":"General comments"}]
["Computer name"]

{"sheet":"Lookup","index":6,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,0,21,0]]}
["ID","Lookup1","Lookup2","Lookup3","Lookup4","Lookup5","Lookup6","Lookup7","Lookup8","Lookup9","Lookup10","Lookup11","Lookup12","Lookup13","Lookup14","Lookup15","Lookup16","Lookup17","Lookup18","Lookup19","Lookup20"]
["Name","Status","Type","State","Status","CVSS Rating","Pass/Fail","Action Owner","Lookup8","Lookup9","Lookup10","Lookup11","Lookup12","Lookup13","Lookup14","Lookup15","Lookup16","Lookup17","Lookup18","Lookup19","Lookup20"]
["ELEMENTS","Red","Physical","Connected","Open","Critical","Pass","Administration","Lookup8","Lookup9","Lookup10","Lookup11","Lookup12","Lookup13","Lookup14","Lookup15","Lookup16","Lookup17","Lookup18","Lookup19","Lookup20"]
[null,"Amber","Virtual","Disconnected","Close","High","Fail","Consultation"]
[null,"Green",null,null,null,"Medium",null,"Nursing"]
[null,null,null,null,null,"Low",null,"IT Support"]
[null,null,null,null,null,"Information",null,"Quality Assurance"]
[null,null,null,null,null,null,null,"Senior Management"]
[null,null,null,null,null,null,null,"Executive Team"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TEST"]
[]
["NOTE"]
["This is a dynamic lookup grid; adding additional items in the Elements rows will make them available to the associated drop-down menus"]
["To test, click the TEST cell under the lookup and the list should show the new elements."]