{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INSTRUCTIONS","1 - Infrastructure Status Log","2 - Penetration Test Remediati","3 - Test Plan","4 - Test Log","5 - Equipment List","Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":21,"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":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Device Name","Type","Location","Status","Assigned to","Authorise by","Last Updated","State","Notes"]
["WS001","Physical","Example line","Amber","J. Smith","S. John","2020-06-19","Connected"]

{"sheet":"2 - Penetration Test Remediati","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Action Owner","Total Actions","CVSS Ratings Summary","Total"]
["Management",{"$f":"COUNTIF(G12:G50,A2)","v":0},"Critical",{"$f":"COUNTIF(E12:E50,\"Critical\")","v":1}]
["Networking",{"$f":"COUNTIF(G12:G50,A3)","v":0},"High",{"$f":"COUNTIF(E12:E50,\"High\")","v":0}]
["Server and Storage",{"$f":"COUNTIF(G12:G50,A4)","v":0},"Medium",{"$f":"COUNTIF(E12:E50,\"Medium\")","v":0}]
["Security",{"$f":"COUNTIF(G12:G50,A5)","v":0},"Low",{"$f":"COUNTIF(E12:E50,\"Low\")","v":0}]
["Area 1",{"$f":"COUNTIF(G12:G50,A6)","v":0},"Information",{"$f":"COUNTIF(E12:E50,\"Information\")","v":0}]
["Area 2",{"$f":"COUNTIF(G12:G50,A7)","v":0},"Total:",{"$f":"SUM(D2:D6)","v":1}]
["Area 3",{"$f":"COUNTIF(G12:G50,A8)","v":0}]
["TOTAL: ",{"$f":"SUM(B2:B5)","v":0}]
[]
["Ref","Vulnerability Description","Action/Comment","Status","CVVS Rating","CVSS Score","Action Owner","Escalate to RAID","RAID Ref","Deadline","Comments"]
[1234,"Vulnerability 1","Action1","Open","Critical",9.8000000000000007,"Desktop Support","Yes","R1","2020-07-30","Example - delete before completing"]

{"sheet":"3 - Test Plan","index":3,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ID","Area Name"]
[1,"Area 1"]
[2,"Area 2"]
[3,"Area 3"]
[4,"Area 4"]
[5,"Area 5"]
[6,"Area 6"]
[7,"Area 7"]
[8,"Area 8"]
[9,"Area 9"]
[10,"Area 10"]
[11,"Area 11"]
[12,"Area 12"]
[13,"Area 13"]
[14,"Area 14"]
[15,"Area 15"]
[16,"Area 16"]
[17,"Area 17"]
[18,"Area 18"]
[19,"Area 19"]
[20,"Area 20"]

{"sheet":"4 - Test Log","index":4,"n_rows":5,"n_cols":21,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Device Name",{"$f":"'3 - Test Plan'!B12","v":"Area 1"},{"$f":"'3 - Test Plan'!B13","v":"Area 2"},{"$f":"'3 - Test Plan'!B14","v":"Area 3"},{"$f":"'3 - Test Plan'!B15","v":"Area 4"},{"$f":"'3 - Test Plan'!B16","v":"Area 5"},{"$f":"'3 - Test Plan'!B17","v":"Area 6"},{"$f":"'3 - Test Plan'!B18","v":"Area 7"},{"$f":"'3 - Test Plan'!B19","v":"Area 8"},{"$f":"'3 - Test Plan'!B20","v":"Area 9"},{"$f":"'3 - Test Plan'!B21","v":"Area 10"},{"$f":"'3 - Test Plan'!B22","v":"Area 11"},{"$f":"'3 - Test Plan'!B23","v":"Area 12"},{"$f":"'3 - Test Plan'!B24","v":"Area 13"},{"$f":"'3 - Test Plan'!B25","v":"Area 14"},{"$f":"'3 - Test Plan'!B26","v":"Area 15"},{"$f":"'3 - Test Plan'!B27","v":"Area 16"},{"$f":"'3 - Test Plan'!B28","v":"Area 17"},{"$f":"'3 - Test Plan'!B29","v":"Area 18"},{"$f":"'3 - Test Plan'!B30","v":"Area 19"},{"$f":"'3 - Test Plan'!B31","v":"Area 20"}]
["PC1","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail"]
[null,"Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail"]
[null,"Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail"]
[null,"Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail","Fail"]

{"sheet":"5 - Equipment List","index":5,"n_rows":116,"n_cols":12,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Type","Vendor","Name","Serial No.","MAC Address","IP Address","Status","State"]
["Workstation","Dell","WS001","ABC12345","df:76:8f:c8:00:be","N/A DHCP Assigned","Green","Connected",null,null,"NOTE, status has the following values and meanings"]
["Workstation","Dell","WS002","ABC12346","08:99:8d:e0:7f:ad","N/A DHCP Assigned","Green","Connected",null,null,"Red","Critical isses(s)"]
["Workstation","Dell","WS003","ABC12347","17:a1:1c:4a:b2:76","N/A DHCP Assigned","Green","Connected",null,null,"Amber","Some Issues"]
["Workstation","Dell","WS004","ABC12348","d2:59:c3:cc:fd:9c","N/A DHCP Assigned","Green","Connected",null,null,"Green","No Issues"]
["Workstation","Dell","WS005","ABC12349","8e:aa:3e:de:ed:0d","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS006","ABC12350","b2:f8:94:5c:8d:30","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS007","ABC12351","0b:5d:17:35:9f:cb","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS008","ABC12352","53:dd:ee:30:16:e6","N/A DHCP Assigned","Amber","Connected"]
["Workstation","Dell","WS009","ABC12353","8d:f8:c6:9f:fd:21","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS010","ABC12354","e5:8c:ab:04:36:c9","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS011","ABC12355","8b:09:02:b9:10:68","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS012","ABC12356","ed:1b:e6:89:79:b9","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS013","ABC12357","2f:20:74:9f:8d:2e","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS014","ABC12358","00:2a:ce:fb:aa:06","N/A DHCP Assigned","Red","Disconnected"]
["Workstation","Dell","WS015","ABC12359","dc:a2:0b:be:23:87","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS016","ABC12360","b8:7f:8a:98:a5:60","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS017","ABC12361","ab:8e:7c:1b:d5:cf","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS018","ABC12362","5e:47:2d:78:05:d5","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS019","ABC12363","07:69:d3:ee:2a:dd","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS020","ABC12364","3d:2a:bc:b1:ea:76","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS021","ABC12365","56:1e:4d:b4:45:93","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS022","ABC12366","c5:51:6d:67:ed:1f","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS023","ABC12367","4a:1f:fb:c6:c8:a3","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS024","ABC12368","4a:04:e6:02:e1:57","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS025","ABC12369","d2:85:2d:e0:f8:26","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS026","ABC12370","0b:3d:e1:c5:ef:5a","N/A DHCP Assigned","Amber","Connected"]
["Workstation","Dell","WS027","ABC12371","53:0a:79:4b:50:7f","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS028","ABC12372","a7:bf:1f:a2:8a:39","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS029","ABC12373","48:dd:b3:f4:43:b5","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS030","ABC12374","7c:17:c1:58:f6:24","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS031","ABC12375","31:19:23:fc:e0:5f","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS032","ABC12376","bc:98:1d:ea:75:56","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS033","ABC12377","50:11:9d:b0:c6:e2","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS034","ABC12378","76:94:60:6b:62:12","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS035","ABC12379","93:1b:42:19:a5:b5","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS036","ABC12380","5b:46:28:6d:bd:ac","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS037","ABC12381","0a:76:15:b7:d0:f7","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS038","ABC12382","4a:58:a9:43:31:68","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS039","ABC12383","0b:d2:0a:e3:ee:89","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS040","ABC12384","41:e5:f0:43:d8:3a","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS041","ABC12385","3e:e4:c9:0e:03:e6","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS042","ABC12386","a4:73:4c:91:61:65","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS043","ABC12387","cc:2b:5d:4a:97:73","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS044","ABC12388","57:12:12:bf:c5:5b","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS045","ABC12389","c8:ef:f4:80:54:3b","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS046","ABC12390","68:04:d5:a7:c1:c3","N/A DHCP Assigned","Red","Disconnected"]
["Workstation","Dell","WS047","ABC12391","05:d4:d5:0b:7b:fc","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS048","ABC12392","6b:a3:51:e4:ba:af","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS049","ABC12393","9a:4e:ed:fd:3f:8b","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS050","ABC12394","21:d3:5b:af:99:3e","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS051","ABC12395","e9:da:08:fe:55:72","N/A DHCP Assigned","Amber","Connected"]
["Workstation","Dell","WS052","ABC12396","1e:15:84:a0:dd:b3","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS053","ABC12397","ca:3c:8a:3d:1e:f6","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS054","ABC12398","2e:3d:5f:02:89:a0","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS055","ABC12399","89:71:e8:17:aa:95","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS056","ABC12400","22:c2:f8:3c:8c:d2","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS057","ABC12401","76:85:ad:53:8c:2b","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS058","ABC12402","15:4d:e0:93:3f:c5","N/A DHCP Assigned","Red","Disconnected"]
["Workstation","Dell","WS059","ABC12403","cb:8c:f0:05:8b:ae","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS060","ABC12404","48:73:58:ee:94:19","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS061","ABC12405","03:f2:20:7d:d3:ac","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS062","ABC12406","03:89:6c:fd:cc:d9","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS063","ABC12407","11:e7:c7:5e:eb:02","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS064","ABC12408","b3:2d:69:7d:10:02","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS065","ABC12409","2d:9e:19:06:c3:d3","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS066","ABC12410","7d:d4:a4:5a:ca:0f","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS067","ABC12411","fd:09:6f:a1:33:e3","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS068","ABC12412","77:ac:c8:9a:82:d7","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS069","ABC12413","e1:dd:26:38:72:41","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS070","ABC12414","12:0f:c5:e3:18:82","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS071","ABC12415","4e:89:fb:0d:35:bf","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS072","ABC12416","0a:43:fa:a2:c9:a6","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS073","ABC12417","4c:2a:cd:ec:62:64","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS074","ABC12418","64:0b:8c:d9:d0:d1","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS075","ABC12419","a5:8c:2c:4d:6e:7c","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS076","ABC12420","0f:bb:f4:22:89:62","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS077","ABC12421","63:6a:a7:b7:a7:ea","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS078","ABC12422","af:08:06:47:e4:e1","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS079","ABC12423","8c:a2:d7:94:25:2f","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS080","ABC12424","e2:03:c7:5d:e3:1e","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS081","ABC12425","64:24:d3:df:22:25","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS082","ABC12426","3b:d0:33:09:45:81","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS083","ABC12427","42:8e:06:07:2f:31","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS084","ABC12428","91:b0:eb:42:29:36","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS085","ABC12429","53:7d:98:94:30:70","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS086","ABC12430","6e:e1:ca:ee:b1:1c","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS087","ABC12431","09:a3:77:bf:a0:87","N/A DHCP Assigned","Amber","Connected"]
["Workstation","Dell","WS088","ABC12432","9d:34:77:2f:f1:44","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS089","ABC12433","8e:cf:6a:a6:c0:c7","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS090","ABC12434","bf:12:65:78:36:90","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS091","ABC12435","f0:46:18:b0:1a:81","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS092","ABC12436","5e:04:47:e5:8e:e7","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS093","ABC12437","80:30:c5:ab:b5:26","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS094","ABC12438","a3:92:c2:31:c6:6d","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS095","ABC12439","29:90:36:d9:f9:40","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS096","ABC12440","cf:ab:c9:83:79:71","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS097","ABC12441","35:a7:4b:5a:6b:62","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS098","ABC12442","69:05:17:d0:f9:64","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS099","ABC12443","e6:a9:64:45:a3:66","N/A DHCP Assigned","Green","Connected"]
["Workstation","Dell","WS100","ABC12444","ba:f6:8c:98:e0:fe","N/A DHCP Assigned","Green","Connected"]
["Server","Dell","SRV09","DEF1234","3d:85:b9:25:1a:46","192.168.220.10","Green","Connected"]
["Server","Dell","App1","DEF1235","ad:cf:68:04:8a:7e","192.168.220.18","Green","Connected"]
["Server","Dell","App2","DEF1236","00:cc:71:0d:54:c0","192.168.220.21","Green","Connected"]
["Server","Dell","DB1","DEF1237","08:d8:e1:90:98:f5","192.168.220.27","Green","Connected"]
["Server","Dell","DB2","DEF1238","22:d1:4d:71:ce:90","192.168.220.29","Green","Connected"]
["Switch","Cisco","SW10","FGH1234","e2:57:0e:b5:7f:89","192.168.220.81","Green","Connected"]
["Switch","Cisco","SW11","FGH1235","e1:98:4c:b5:e4:1b","192.168.220.83","Green","Connected"]
["Switch","Cisco","SW12","FGH1236","7d:f5:94:c4:c6:f4","192.168.220.84","Green","Connected"]
["Switch","Cisco","SW15","FGH3217","18-03-5C-4D-65-B9","192.168.220.85","Green","Connected"]
["Switch","Cisco","SW19","FGH3215","2A-95-54-53-4B-B1","192.168.220.86","Green","Connected"]
["Printer","HP","PRN01","HPP1234","DE-E9-B2-2E-19-CB","192.168.220.230","Green","Connected"]
["Printer","HP","PRN02","HPP2345","32-60-E9-E9-CA-48","192.168.220.231","Green","Connected"]
["Printer","HP","PRN03","HPP3456","7D-71-78-28-50-9A","192.168.220.232","Green","Connected"]
["Printer","HP","PRN04","HPP4567","9F-D0-DD-42-95-EB","192.168.220.233","Green","Connected"]
["Printer","HP","PRN20","HPP5678","12-1A-72-D0-33-C3","192.168.220.234","Green","Connected"]

{"sheet":"Lookup","index":6,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"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","CVVS 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","Management","Lookup8","Lookup9","Lookup10","Lookup11","Lookup12","Lookup13","Lookup14","Lookup15","Lookup16","Lookup17","Lookup18","Lookup19","Lookup20"]
[null,"Amber","Virtual","Disconnected","Close","High","Fail","Networking"]
[null,"Green",null,null,null,"Medium",null,"Server and Storage"]
[null,null,null,null,null,"Low",null,"Security"]
[null,null,null,null,null,"Information",null,"Area 1"]
[null,null,null,null,null,null,null,"Area 2"]
[null,null,null,null,null,null,null,"Area 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]