{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Configuration","Unit Specific","Imported Log","Input"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[96,0,98,0]]}
[]
[]
[]
[]
["        StartUp Stick™ – v1.05"]

{"sheet":"Configuration","index":1,"n_rows":140,"n_cols":5,"rows_kept":140,"cut":false,"hidden":false,"merged":[],"read":"row_number_cap"}
[]
[null,null,null,null,"Types in 'Unit Specific' Sheet"]
[null,null,null,null,"None"]
[null,null,null,null,"NIC SN or Row # in 'Unit Specific' Sheet"]
[]
[null,null,"",null,"Set to CDU specified by NIC SN or Row #"]
[null,"System Settings",""]
[null,"Parameter","Value"]
[null,"Current admn User Password","admn"]
[null,"New admn User Password","Apply No Change"]
[null,"System Location","Apply No Change"]
[null,"Temperature Scale"]
[null,"Outlet Sequence Order"]
[null,"Outlet sequence Delay"]
[]
[null,"Network Settings"]
[null,"Parameter","Value"]
[null,"Network Mode",""]
[null,"DHCP Enabled",""]
[null,"DHCP Boot Delay Enabled",""]
[null,"DHCP Static Address Fallback Enabled",""]
[null,"DHCP FQDN Enabled",""]
[null,"FQDN Name","Apply No Change"]
[null,"Static IPv6 Address","Apply No Change"]
[null,"Static IPv6 Prefix","Apply No Change"]
[null,"Static IPv6 Gateway","Apply No Change"]
[null,"Static IPv4 Address","Apply No Change"]
[null,"Static IPv4 Subnet Mask","Apply No Change"]
[null,"Static IPv4 Gateway","Apply No Change"]
[null,"Static Primary DNS Server","Apply No Change"]
[null,"Static Secondary DNS Server","Apply No Change"]
[]
[null,"TELNET/SSH Settings"]
[null,"Parameter","Value"]
[null,"Telnet Enabled",""]
[null,"Telnet Port","Apply No Change"]
[null,"SSH Enabled",""]
[null,"SSH Port","Apply No Change"]
[null,"SSH Authentication Method"]
[]
[null,"HTTP/SSL Settings"]
[null,"Parameter","Value"]
[null,"HTTP Enabled"]
[null,"HTTP Port","Apply No Change"]
[null,"HTTPS (SSL) Enabled"]
[null,"HTTPS (SSL) Port","Apply No Change"]
[]
[null,"FTP Settings"]
[null,"Parameter","Value"]
[null,"FTP Server Enabled",""]
[null,"FTP Client Auto Update Enabled"]
[null,"FTP Client Update Host","Apply No Change"]
[null,"FTP Client Update User Name","Apply No Change"]
[null,"FTP Client Update Password","Apply No Change"]
[null,"FTP Client Update Directory","Apply No Change"]
[null,"FTP Client Update File Name","Apply No Change"]
[null,"FTP Client Update Day",""]
[null,"FTP Client Update Hour",""]
[]
[null,"SMTP Settings"]
[null,"Parameter","Value"]
[null,"SMTP Notifications Enabled"]
[null,"SMTP Host","Apply No Change"]
[null,"SMTP Host Port","Apply No Change"]
[null,"SMTP From Address","Apply No Change"]
[null,"SMTP Primary To Address","Apply No Change"]
[null,"SMTP Secondary To Address","Apply No Change"]
[null,"SMTP Event Messages Enabled",""]
[null,"SMTP Authorization Messages Enabled",""]
[null,"SMTP Configuration Messages Enabled",""]
[null,"SMTP Power Messages Enabled",""]
[null,"SMTP Authentication Type",""]
[null,"SMTP Authenticate With",""]
[null,"SMTP Host Authentication User Name","Apply No Change"]
[null,"SMTP Host Authentication Password","Apply No Change"]
[null,"SMTP Subject Used"]
[]
[null,"SNMP Settings"]
[null,"Parameter","Value"]
[null,"SNMP V1/V2 Enabled"]
[null,"SNMP V2 Get Community","Apply No Change"]
[null,"SNMP V2 Set Community","Apply No Change"]
[null,"SNMP V2 Trap Community","Apply No Change"]
[null,"SNMP V3 Enabled",""]
[null,"SNMP V3 RW User Authentication Method"]
[null,"SNMP V3 RW User Name","Apply No Change"]
[null,"SNMP V3 RW User Authentication Password","Apply No Change"]
[null,"SNMP V3 RW User Privacy Password","Apply No Change"]
[null,"SNMP V3 RO User Authentication Method",""]
[null,"SNMP V3 RO User Name","Apply No Change"]
[null,"SNMP V3 RO User Authentication Password","Apply No Change"]
[null,"SNMP V3 RO User Privacy Password","Apply No Change"]
[null,"SNMP V3 Trap User Name","Apply No Change"]
[null,"SNMP Trap Format"]
[null,"SNMP Trap Destination Primary Host","Apply No Change"]
[null,"SNMP Trap Destination Secondary Host","Apply No Change"]
[null,"SNMP Trap IP Restrictions",""]
[null,"SNMP Trap Error Repeat Time(seconds)","Apply No Change"]
[null,"SNMP System Name","Apply No Change"]
[null,"SNMP System Contact","Apply No Change"]
[]
[null,"SNTP/DST Settings"]
[null,"Parameter","Value"]
[null,"SNTP Primary Host","Apply No Change"]
[null,"SNTP Secondary Host","Apply No Change"]
[null,"Local GMT Offset","Apply No Change"]
[null,"DST Enabled",""]
[null,"DST Start TZ","Apply No Change"]
[null,"DST End TZ","Apply No Change"]
[]
[null,"SysLog Settings"]
[null,"Parameter","Value"]
[null,"SysLog Primary Host","Apply No Change"]
[null,"SysLog Secondary Host","Apply No Change"]
[null,"SysLog Port","Apply No Change"]
[]
[null,"WLAN Settings"]
[null,"Parameter","Value"]
[null,"WLAN Enabled"]
[null,"bssid","Apply No Change"]
[null,"Key","Apply No Change"]
[null,"Key Secure","Apply No Change"]
[null,"Security"]
[null,"ssid","Apply No Change"]
[]
[null,"LDAP Settings"]
[null,"Parameter","Value"]
[null,"bind type"]
[null,"group membership attribute","Apply No Change"]
[null,"group search"]
[null,"group search base distinguished name","Apply No Change"]
[null,"port","Apply No Change"]
[null,"primary host","Apply No Change"]
[null,"search bind distinguished name","Apply No Change"]
[null,"search bind password","Apply No Change"]
[null,"search bind password secure","Apply No Change"]
[null,"secondary host","Apply No Change"]
[null,"user membership attribute","Apply No Change"]
[null,"user search base distinguished name","Apply No Change"]
[null,"user search filter","Apply No Change"]

{"sheet":"Unit Specific","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Network Interface Card         Serial Number (NIC SN)"]

{"sheet":"Imported Log","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Log Entries"]

{"sheet":"Input","index":4,"n_rows":209,"n_cols":11,"rows_kept":209,"cut":false,"hidden":true,"merged":[]}
[null,"Apply No Change"]
[]
["Field","Network Mode"]
[null,"text"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"Disabled"]
[null,"IPv4 Only"]
[null,"Dual IPv6/IPv4"]
[]
["Field","Unit Specific"]
[null,"text"]
[null,"Global"]
[null,"Per Unit"]
[null,"Formula"]
[]
["Field","SMTP Authentication Type"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"None"]
[null,"Digest-MD5"]
[null,"CRAM-MD5"]
[null,"LOGIN"]
[null,"PLAIN"]
[null,"Any"]
[]
["Field","Ftp Client Update Day"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"Sunday"]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Everyday"]
[]
["Field","Snmp V3 Authendication Type"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"None"]
[null,"MD5"]
[]
["Field ","ftp client update hour"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"12 am"]
[null,"1 am"]
[null,"2 am"]
[null,"3 am"]
[null,"4 am"]
[null,"5 am"]
[null,"6 am"]
[null,"7 am"]
[null,"8 am"]
[null,"9 am"]
[null,"10 am"]
[null,"11 am"]
[null,"12 pm"]
[null,"1 pm"]
[null,"2 pm"]
[null,"3 pm"]
[null,"4 pm"]
[null,"5 pm"]
[null,"6 pm"]
[null,"7 pm"]
[null,"8 pm"]
[null,"9 pm"]
[null,"10 pm"]
[null,"11 pm"]
[]
["Field","Smtp Authenticate With"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"SMTP From Address"]
[null,"SMTP Authentication User Name"]
[]
["Field","SMTP Subject Used"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"Location"]
[null,"System ID"]
[]
["Field","Web Server Protocol(s)"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"None"]
[null,"Http"]
[null,"Http + Https"]
[null,"Https"]
[]
["Field","SNMP Auth Type"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"None"]
[null,"MD5"]
[null,"MD5 With DES"]
[]
[]
["Field","SNMP Trap Format"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"V1"]
[null,"V2c"]
[null,"V3"]
[]
["Field","Ssh Authentication Mode"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"Password Only"]
[null,"Keyboard Only"]
[null,"Keyboard and Password"]
[]
["Field","Snmp Trap Ip Restrictions"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"None"]
[null,"Trap Destinations Only",null,null,null,"not net addr","not broad addr","is point to point (CDU does not support /31, point to point, which is reasonable as not a router! second row validates /31)"]
[null,null,null,"not equal","same subnet",{"$f":"IF(J110<>K110,TRUE,FALSE)","v":true},{"$f":"IF(J110<>K111,TRUE,FALSE)","v":true},false]
["Is Gateway in subnet",null,{"$f":"IF(D109*E109*F108*F109*G108*G109=1,TRUE,H108)","v":true},{"$f":"IF(J110<>J112,TRUE,FALSE)","v":true},{"$f":"IF(K110=K112,TRUE,FALSE)","v":true},{"$f":"IF(J112<>K112,TRUE,FALSE)","v":true},{"$f":"IF(J112<>K111,TRUE,FALSE)","v":true},{"$f":"IF(J111=4294967294,IF((ABS(J110-J112)=1),E109,FALSE),FALSE)","v":false}]
["Ipv4 Address",null,10,1,2,1,null,null,null,{"$f":"C110*2^24+D110*2^16+E110*2^8+F110","v":167838209},{"$f":"SUMPRODUCT(F116:F147,G116:G147)","v":167837696}]
["Ipv4 Subnet",null,255,255,0,0,0,{"$f":"SUM(C116:C147)","v":0},{"$f":"C111*2^24+D111*2^16+E111*2^8+F111","v":4294901760},{"$f":"IF(IpV4SubnetBits<>0,H111,I111)","v":4294901760},{"$f":"K110+(2^32-J111)-1","v":167903231}]
["IpV4 Gateway",null,10,1,1,1,null,null,null,{"$f":"C112*2^24+D112*2^16+E112*2^8+F112","v":167837953},{"$f":"SUMPRODUCT(F116:F147,H116:H147)","v":167837696}]
["IpV4 Subnet Broadcast"]
[]
["Used to calcultate subnet when bits are specified.",null,null,null,null,null,"IP Bits","Gateway Bits"]
[1,{"$f":"IF($G$111>=A116,1,0)","v":0},{"$f":"((2^(A$147-A116))*B116)","v":0},null,"128.0.0.0",{"$f":"2^(A$147-A116)","v":2147483648},{"$f":"IF(ISEVEN(INT($J$110/(2^(32-A116)))),0,1)*IF(ISEVEN(INT($J$111/(2^(32-A116)))),0,1)","v":0},{"$f":"IF(ISEVEN(INT($J$112/(2^(32-A116)))),0,1)*IF(ISEVEN(INT($J$111/(2^(32-A116)))),0,1)","v":0},"MSB"]
[{"$f":"A116+1","v":2},{"$f":"IF($G$111>=A117,1,0)","v":0},0,null,"192.0.0.0",{"$f":"2^(A$147-A117)","v":1073741824},{"$f":"IF(ISEVEN(INT($J$110/(2^(32-A117)))),0,1)*IF(ISEVEN(INT($J$111/(2^(32-A117)))),0,1)","v":0},{"$f":"IF(ISEVEN(INT($J$112/(2^(32-A117)))),0,1)*IF(ISEVEN(INT($J$111/(2^(32-A117)))),0,1)","v":0}]
[{"$f":"A117+1","v":3},0,0,null,"224.0.0.0",536870912,0,0]
[4,0,0,null,"240.0.0.0",268435456,0,0]
[5,{"$f":"IF($G$111>=A120,1,0)","v":0},0,null,"248.0.0.0",134217728,1,1]
[6,{"$f":"IF($G$111>=A121,1,0)","v":0},0,null,"252.0.0.0",67108864,0,0]
[7,0,0,null,"254.0.0.0",33554432,1,1]
[8,0,0,null,"255.0.0.0",16777216,0,0]
[9,0,0,null,"255.128.0.0",8388608,0,0]
[10,0,0,null,"255.192.0.0",4194304,0,0]
[11,0,0,null,"255.224.0.0",2097152,0,0]
[12,0,0,null,"255.240.0.0",1048576,0,0]
[13,0,0,null,"255.248.0.0",524288,0,0]
[14,0,0,null,"255.252.0.0",262144,0,0]
[15,0,0,null,"255.254.0.0",131072,0,0]
[{"$f":"A130+1","v":16},0,0,null,"255.255.0.0",65536,1,1]
[17,0,0,null,"255.255.128.0",32768,0,0]
[18,0,0,null,"255.255.192.0",16384,0,0]
[19,0,0,null,"255.255.224.0",8192,0,0]
[20,0,0,null,"255.255.240.0",4096,0,0]
[21,0,0,null,"255.255.248.0",2048,0,0]
[22,0,0,null,"255.255.252.0",1024,0,0]
[23,0,0,null,"255.255.254.0",512,0,0]
[24,0,0,null,"255.255.255.0",256,0,0]
[25,0,0,null,"255.255.255.128",128,0,0]
[26,0,0,null,"255.255.255.192",64,0,0]
[27,0,0,null,"255.255.255.224",32,0,0]
[28,0,0,null,"255.255.255.240",16,0,0]
[29,0,0,null,"255.255.255.248",8,0,0]
[30,0,0,null,"255.255.255.252",4,0,0]
[31,0,0,null,"255.255.255.254",2,0,0]
[32,0,0,null,"255.255.255.255",1,0,0,"LSB"]
[]
["Reference Information"]
[]
["Set Bits In Quad",null,null,"Quad Value"]
[0,null,null,0]
[{"$f":"8-B153","v":1},7,{"$f":"2^B153","v":128},{"$f":"C153","v":128}]
[{"$f":"8-B154","v":2},6,{"$f":"2^B154","v":64},{"$f":"SUM(C153:C154)","v":192}]
[3,5,32,{"$f":"SUM(C153:C155)","v":224}]
[4,4,16,{"$f":"SUM(C153:C156)","v":240}]
[5,3,8,{"$f":"SUM(C153:C157)","v":248}]
[6,2,4,{"$f":"SUM(C153:C158)","v":252}]
[7,1,2,{"$f":"SUM(C153:C159)","v":254}]
[8,0,1,{"$f":"SUM(C153:C160)","v":255},{"$f":"VALUE(TRIM(RIGHT(SUBSTITUTE(A162,\".\",REPT(\" \",50)),25)))","v":56}]
["split out quads wihtout vba, use excel calculation formula instead"]
["192.168.50.56",{"$f":"VALUE(LEFT(A162,FIND(\".\",A162)-1))","v":192},{"$f":"VALUE(LEFT(MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))),FIND(\".\",MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))))-1))","v":168},{"$f":"INT(LEFT(MID(MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))),FIND(\".\",MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))))+1,LEN(MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))))-LEN(FIND(\".\",MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162)))))),FIND(\".\",MID(MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))),FIND(\".\",MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))))+1,LEN(MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162))))-LEN(FIND(\".\",MID(A162,FIND(\".\",A162)+1,LEN(A162)-LEN(FIND(\".\",A162)))))))-1))","v":50}]
[]
["Field","Wlan Secutiry"]
[null,{"$f":"B1","v":"Apply No Change"}]
[null,"open"]
[null,"wep open key"]
[null,"wep shared key"]
[null,"wpa-psk aes"]
[null,"wpa-psk tkip"]
[null,"wpa-psk tkip+aes"]
[null,"wpa2-psk aes"]
[null,"wpa2-psk tkip"]
[null,"wpa2-psk tkip+aes"]
[]
["Field","Ldap bind type"]
[null,"Apply No Change"]
[null,"md5"]
[null,"simple"]
[null,"tls"]
[]
["Field","Temperature Scale"]
[null,"Apply No Change"]
[null,"Fahrenheit"]
[null,"Celsius"]
[]
["Field","Outlet Sequence Order"]
[null,"Apply No Change"]
[null,"Normal"]
[null,"Reversed"]
[]
["Field","Outlet Sequence Delay"]
[null,"Apply No Change"]
[null,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]