{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Subnetting","VLSM Calculator","VLSM Table","Net"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"whole","date_system":"1900"}

{"sheet":"Subnetting","index":0,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,11,1,17]]}
[null,"SUBNETTING CALCULATOR v.1.3 © Marek Telecki, 2010"]
[null,null,null,null,null,null,null,null,null,null,null,"HEX"]
[]
[null,"Host IP Address",null,10,".",168,".",114,".",250,null,{"$f":"DEC2HEX(D4)","v":"A"},".",{"$f":"DEC2HEX(F4)","v":"A8"},".",{"$f":"DEC2HEX(H4)","v":"72"},".",{"$f":"DEC2HEX(J4)","v":"FA"}]
[null,"Binary",null,{"$f":"DEC2BIN(D4)+0","v":1010},null,{"$f":"DEC2BIN(F4)+0","v":10101000},null,{"$f":"DEC2BIN(H4)+0","v":1110010},null,{"$f":"DEC2BIN(J4)+0","v":11111010}]
[null,"Host IP Address Type",null,{"$f":"IF(OR(AND(D4=192,F4=168),AND(D4=172,F4>15,F4<32),D4=10),\"private\",IF(D4=0,\"default\",IF(D4=127,\"loopback\",IF(AND(D4=169,F4=254),\"link-local\",IF(AND(D4=192,F4=0,H4=2),\"test\",IF(AND(D4>223,D4<240),\"group\",IF(AND(D4>239,J4<255),\"experimental\",\"public\")))))))","v":"private"}]
[null,"Host IP Address Class",null,{"$f":"IF(D4<128,\"A\",IF(D4<192,\"B\",IF(D4<224,\"C\",\"other\")))","v":"A"}]
[]
[null,"Subnet Mask",null,255,".",255,".",255,".",128,null,{"$f":"DEC2HEX(D9)","v":"FF"},".",{"$f":"DEC2HEX(F9)","v":"FF"},".",{"$f":"DEC2HEX(H9)","v":"FF"},".",{"$f":"DEC2HEX(J9)","v":"80"}]
[null,"Binary",null,{"$f":"DEC2BIN(D9)+0","v":11111111},null,{"$f":"DEC2BIN(F9)+0","v":11111111},null,{"$f":"DEC2BIN(H9)+0","v":11111111},null,{"$f":"DEC2BIN(J9)+0","v":10000000}]
[null,"Prefix",null,{"$f":"IF(D7=\"C\",VLOOKUP(J9,B42:C50,2)+24,IF(D7=\"B\",VLOOKUP(H9,B42:C50,2)+VLOOKUP(J9,B42:C50,2)+16,IF(D7=\"A\",VLOOKUP(F9,B42:C50,2)+VLOOKUP(H9,B42:C50,2)+VLOOKUP(J9,B42:C50,2)+8,\"-\")))","v":25}]
[null,"Subnet Mask Validation",null,{"$f":"IF(AND(F9=LOOKUP(F9,B42:B50),H9=LOOKUP(H9,B42:B50),J9=LOOKUP(J9,B42:B50),OR(AND(F9<255,H9=0,J9=0),AND(F9=255,H9<F9,J9=0),AND(F9=255,H9=255,OR(J9=0,J9>0),J9<255))),\"Correct mask\",\"Wrong mask\")","v":"Correct mask"}]
[]
[null,"Major (default) Network Mask",null,255,".",{"$f":"IF(OR(D7=\"B\",D7=\"C\"),255,0)","v":0},".",{"$f":"IF(D7=\"C\",255,0)","v":0},".",0,null,"FF",".","0",".","0",".","0"]
[null,"Binary",null,{"$f":"DEC2BIN(D14)+0","v":11111111},null,{"$f":"DEC2BIN(F14)+0","v":0},null,{"$f":"DEC2BIN(H14)+0","v":0},null,{"$f":"DEC2BIN(J14)+0","v":0}]
[]
[]
[null,"Number of Subnet Bits",null,{"$f":"IF(D7=\"A\",VLOOKUP(F9,B42:C50,2)+VLOOKUP(H9,B42:C50,2)+VLOOKUP(J9,B42:C50,2),IF(D7=\"B\",VLOOKUP(H9,B42:C50,2)+VLOOKUP(J9,B42:C50,2),IF(D7=\"C\",VLOOKUP(J9,B42:C50,2),\"other\")))","v":17}]
[null,"Number of Subnets",null,{"$f":"2^D18","v":131072}]
[null,"Number of Host Bits per Subnet",null,{"$f":"IF(D7=\"A\",24-D18,IF(D7=\"B\",16-D18,IF(D7=\"C\",8-D18,\"other\")))","v":7}]
[null,"Number of Usable Host per Subnet",null,{"$f":"2^D20-2","v":126}]
[]
[null,"Subnet Address for this IP Address",null,{"$f":"BIN2DEC(D24)","v":10},".",{"$f":"BIN2DEC(F24)","v":168},".",{"$f":"BIN2DEC(H24)","v":114},".",{"$f":"BIN2DEC(J24)","v":128},null,"A",".","A8",".","72",".","80"]
[null,"Binary",null,{"$f":"DEC2BIN(SUMPRODUCT(MOD(INT(D4/bits),2)*MOD(INT(D9/bits),2),bits))+0","v":1010},null,{"$f":"DEC2BIN(SUMPRODUCT(MOD(INT(F4/bits),2)*MOD(INT(F9/bits),2),bits))+0","v":10101000},null,{"$f":"DEC2BIN(SUMPRODUCT(MOD(INT(H4/bits),2)*MOD(INT(H9/bits),2),bits))+0","v":1110010},null,{"$f":"DEC2BIN(SUMPRODUCT(MOD(INT(J4/bits),2)*MOD(INT(J9/bits),2),bits))+0","v":10000000}]
[]
[null,"IP Address of First Host on this Subnet",null,{"$f":"D4","v":10},".",{"$f":"BIN2DEC(F27)","v":168},".",{"$f":"BIN2DEC(H27)","v":114},".",{"$f":"BIN2DEC(J27)","v":129},null,"A",".","A8",".","72",".","81"]
[null,"Binary",null,{"$f":"D5+0","v":1010},null,{"$f":"F24+0","v":10101000},null,{"$f":"H24+0","v":1110010},null,{"$f":"J24+1","v":10000001}]
[]
[null,"IP Address of Last Host on this Subnet",null,{"$f":"D4","v":10},".",{"$f":"BIN2DEC(F30)","v":168},".",{"$f":"BIN2DEC(H30)","v":114},".",{"$f":"J32-1","v":254},null,"A",".","A8",".","72",".","FE"]
[null,"Binary",null,{"$f":"D5+0","v":1010},null,{"$f":"F33","v":10101000},null,{"$f":"H33","v":1110010},null,{"$f":"DEC2BIN(J29)+0","v":11111110}]
[]
[null,"Broadcast Address for this Subnet",null,{"$f":"BIN2DEC(D33)","v":10},".",{"$f":"IF(D20>16,F23+(2^(D20-16))-1,F23)","v":168},".",{"$f":"IF(AND(D20>8,D20<16),H23+(2^(D20-8))-1,IF(D20>16,255,H23))","v":114},".",{"$f":"IF(D20<8,J23+(2^D20)-1,255)","v":255},null,"A",".","A8",".","72",".","FF"]
[null,"Binary",null,{"$f":"D24","v":1010},null,{"$f":"DEC2BIN(F32)+0","v":10101000},null,{"$f":"DEC2BIN(H32)+0","v":1110010},null,{"$f":"DEC2BIN(J32)+0","v":11111111}]
[]
[]
[]
[]
[]
[]
[]
[null,"Wartość maski","Ilość bitow"]
[null,0,0]
[null,128,1]
[null,192,2]
[null,224,3]
[null,240,4]
[null,248,5]
[null,252,6]
[null,254,7]
[null,255,8]

{"sheet":"VLSM Calculator","index":1,"n_rows":46,"n_cols":63,"rows_kept":46,"cut":false,"hidden":false,"merged":[[4,1,4,3],[5,1,5,3],[6,1,6,3],[8,1,8,3],[0,58,1,59],[3,1,3,3],[0,52,1,52],[0,53,1,53],[0,54,1,54],[0,55,1,55],[0,50,1,50],[0,47,1,47],[0,48,1,48],[0,49,1,49],[0,61,1,61],[0,62,1,62],[0,60,1,60],[0,51,1,51],[0,56,1,56],[0,57,1,57],[11,5,11,11],[11,13,11,19],[11,21,11,27],[11,29,11,35],[11,37,11,43]]}
[null,"VARIABLE LENGTH SUBNET MASK CALCULATOR v.1.3 © Marek Telecki, 2010",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subnet","No. Of Hosts","+10%","No. Of Host's Bits",null,"BIT",null,null,null,"DEC",null,"BIN",null,null,"Ilość bitow","Wartość maski"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"D14","v":100},{"$f":"ROUNDUP(AW3+(AW3*0.1),0)","v":110},{"$f":"ROUNDUP(LOG(AW3+2,2),0)","v":7},null,0,null,"20","=",{"$f":"2^BA3","v":1},null,{"$f":"DEC2BIN($BA$3)+0","v":0},{"$f":"DEC2BIN(BE3,8)","v":"00000001"},null,0,0]
[null,"Major Network  IP Address",null,null,null,222,".",37,".",34,".",0,null,null,null,null,null,null,null,"user input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"D16","v":60},66,{"$f":"ROUNDUP(LOG(AW4+2,2),0)","v":6},null,1,null,"21","=",2,null,0,"00000010",null,1,128]
[null,"Host IP Address Type",null,null,null,{"$f":"IF(OR(AND(F4=192,H4=168),AND(F4=172,H4>15,H4<32),F4=10),\"private\",IF(F4=0,\"default\",IF(F4=127,\"loopback\",IF(AND(F4=169,H4=254),\"link-local\",IF(AND(F4=192,H4=0,J4=2),\"test\",IF(AND(F4>223,F4<240),\"group\",IF(AND(F4>239,L4<255),\"experimental\",\"public\")))))))","v":"public"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"D18","v":29},32,5,null,2,null,"22","=",4,null,0,"00000100",null,2,192]
[null,"Host IP Address Class",null,null,null,{"$f":"IF(F4<128,\"A\",IF(F4<192,\"B\",IF(F4<224,\"C\",\"other\")))","v":"C"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"D20","v":12},14,4,null,3,null,"23","=",8,null,0,"00001000",null,3,224]
[null,"Major (default) Network Mask",null,null,null,255,".",{"$f":"IF(OR(F6=\"B\",F6=\"C\"),255,0)","v":255},".",{"$f":"IF(F6=\"C\",255,0)","v":255},".",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"D22","v":3},4,3,null,4,null,"24","=",16,null,0,"00010000",null,4,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"D24","v":0},0,1,null,5,null,"25","=",32,null,0,"00100000",null,5,248]
[null,"No. of Subnets",null,null,null,{"$f":"COUNTIF(AW3:AW18,\">0\")","v":5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"D26","v":0},0,1,null,6,null,"26","=",64,null,0,"01000000",null,6,252]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,{"$f":"D28","v":0},0,1,null,7,null,"27","=",128,null,0,"10000000",null,7,254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,{"$f":"D30","v":0},0,1,null,8,null,"28","=",256,null,{"$f":"DEC2BIN(BE3,8)","v":"00000001"},{"$f":"DEC2BIN($BA$3)+0","v":0},null,8,255]
[null,null,null,"Number of Hosts",null,"Subnet Address for this IP Address",null,null,null,null,null,null,null,"IP Address of First Host on this Subnet",null,null,null,null,null,null,null,"IP Address of Last Host on this Subnet",null,null,null,null,null,null,null,"Broadcast Address for this Subnet",null,null,null,null,null,null,null,"Subnet Mask",null,null,null,null,null,null,null,"Prefix",null,10,{"$f":"D32","v":0},0,1,null,9,null,"29","=",512,null,{"$f":"DEC2BIN(BE4,8)","v":"00000010"},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,{"$f":"D34","v":0},0,1,null,10,null,"210","=",1024,null,"00000100",0]
[null,"Subnet #1",null,100,null,{"$f":"F4","v":222},".",{"$f":"H4","v":37},".",{"$f":"J4","v":34},".",{"$f":"L4","v":0},null,{"$f":"F14","v":222},".",{"$f":"H14","v":37},".",{"$f":"J14","v":34},".",{"$f":"L14+1","v":1},null,{"$f":"AD14","v":222},".",{"$f":"AF14","v":37},".",{"$f":"AH14","v":34},".",{"$f":"AJ14-1","v":126},null,{"$f":"F14","v":222},".",{"$f":"IF(AY3>16,H14+(2^(AY3-16))-1,H14)","v":37},".",{"$f":"IF(AND(AY3>8,AY3<16),J14+(2^(AY3-8))-1,IF(AY3>16,255,J14))","v":34},".",{"$f":"IF(AY3<8,L14+(2^AY3)-1,255)","v":127},null,{"$f":"F7","v":255},".",{"$f":"H7","v":255},".",{"$f":"IF(OR(16-AY3<0,16-AY3=0),0,VLOOKUP(16-AY3,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY3<0,8-AY3=0),0,VLOOKUP(8-AY3,BJ3:BK11,2))","v":128},null,{"$f":"32-AY3","v":25},null,12,{"$f":"D36","v":0},0,1,null,11,null,"211","=",2048,null,"00001000",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"D38","v":0},0,1,null,12,null,"212","=",4096,null,"00010000",0]
[null,"Subnet #2",null,60,null,{"$f":"AD14","v":222},".",{"$f":"AF14","v":37},".",{"$f":"IF(L16>0,AH14,AH14+1)","v":34},".",{"$f":"IF(AJ14<250,AJ14+1,0)","v":128},null,{"$f":"F16","v":222},".",{"$f":"H16","v":37},".",{"$f":"J16","v":34},".",{"$f":"L16+1","v":129},null,{"$f":"AD16","v":222},".",{"$f":"AF16","v":37},".",{"$f":"AH16","v":34},".",{"$f":"AJ16-1","v":190},null,{"$f":"F16","v":222},".",{"$f":"IF(AY4>16,H16+(2^(AY4-16))-1,H16)","v":37},".",{"$f":"IF(AND(AY4>8,AY4<16),J16+(2^(AY4-8))-1,IF(AY4>16,255,J16))","v":34},".",{"$f":"IF(AY4<8,L16+(2^AY4)-1,255)","v":191},null,{"$f":"AL14","v":255},".",{"$f":"AN14","v":255},".",{"$f":"IF(OR(16-AY4<0,16-AY4=0),0,VLOOKUP(16-AY4,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY4<0,8-AY4=0),0,VLOOKUP(8-AY4,BJ3:BK11,2))","v":192},null,{"$f":"32-AY4","v":26},null,14,{"$f":"D40","v":0},0,1,null,13,null,"213","=",8192,null,"00100000",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,{"$f":"D42","v":0},0,1,null,14,null,"214","=",16384,null,"01000000",0]
[null,"Subnet #3",null,29,null,{"$f":"AD16","v":222},".",{"$f":"AF16","v":37},".",{"$f":"IF(L18>0,AH16,AH16+1)","v":34},".",{"$f":"IF(AJ16<250,AJ16+1,0)","v":192},null,{"$f":"F18","v":222},".",{"$f":"H18","v":37},".",{"$f":"J18","v":34},".",{"$f":"L18+1","v":193},null,{"$f":"AD18","v":222},".",{"$f":"AF18","v":37},".",{"$f":"AH18","v":34},".",{"$f":"AJ18-1","v":222},null,{"$f":"F18","v":222},".",{"$f":"IF(AY6>16,H18+(2^(AY6-16))-1,H18)","v":37},".",{"$f":"IF(AND(AY6>8,AY6<16),J18+(2^(AY6-8))-1,IF(AY6>16,255,J18))","v":34},".",{"$f":"IF(AY5<8,L18+(2^AY5)-1,255)","v":223},null,{"$f":"AL16","v":255},".",{"$f":"AN16","v":255},".",{"$f":"IF(OR(16-AY5<0,16-AY5=0),0,VLOOKUP(16-AY5,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY5<0,8-AY5=0),0,VLOOKUP(8-AY5,BJ3:BK11,2))","v":224},null,{"$f":"32-AY5","v":27},null,16,{"$f":"D44","v":0},0,1,null,15,null,"215","=",32768,null,"10000000",0]
[]
[null,"Subnet #4",null,12,null,{"$f":"AD18","v":222},".",{"$f":"AF18","v":37},".",{"$f":"IF(L20>0,AH18,AH18+1)","v":34},".",{"$f":"IF(AJ18<250,AJ18+1,0)","v":224},null,{"$f":"F20","v":222},".",{"$f":"H20","v":37},".",{"$f":"J20","v":34},".",{"$f":"L20+1","v":225},null,{"$f":"AD20","v":222},".",{"$f":"AF20","v":37},".",{"$f":"AH20","v":34},".",{"$f":"AJ20-1","v":238},null,{"$f":"F20","v":222},".",{"$f":"IF(AY6>16,H20+(2^(AY6-16))-1,H20)","v":37},".",{"$f":"IF(AND(AY6>8,AY6<16),J20+(2^(AY6-8))-1,IF(AY6>16,255,J20))","v":34},".",{"$f":"IF(AY6<8,L20+(2^AY6)-1,255)","v":239},null,{"$f":"AL18","v":255},".",{"$f":"AN18","v":255},".",{"$f":"IF(OR(16-AY6<0,16-AY6=0),0,VLOOKUP(16-AY6,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY6<0,8-AY6=0),0,VLOOKUP(8-AY6,BJ3:BK11,2))","v":240},null,{"$f":"32-AY6","v":28}]
[]
[null,"Subnet #5",null,3,null,{"$f":"AD20","v":222},".",{"$f":"AF20","v":37},".",{"$f":"IF(L22>0,AH20,AH20+1)","v":34},".",{"$f":"IF(AJ20<250,AJ20+1,0)","v":240},null,{"$f":"F22","v":222},".",{"$f":"H22","v":37},".",{"$f":"J22","v":34},".",{"$f":"L22+1","v":241},null,{"$f":"AD22","v":222},".",{"$f":"AF22","v":37},".",{"$f":"AH22","v":34},".",{"$f":"AJ22-1","v":246},null,{"$f":"F22","v":222},".",{"$f":"IF(AY7>16,H22+(2^(AY7-16))-1,H22)","v":37},".",{"$f":"IF(AND(AY7>8,AY7<16),J22+(2^(AY7-8))-1,IF(AY7>16,255,J22))","v":34},".",{"$f":"IF(AY7<8,L22+(2^AY7)-1,255)","v":247},null,{"$f":"AL20","v":255},".",{"$f":"AN20","v":255},".",{"$f":"IF(OR(16-AY7<0,16-AY7=0),0,VLOOKUP(16-AY7,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY7<0,8-AY7=0),0,VLOOKUP(8-AY7,BJ3:BK11,2))","v":248},null,{"$f":"32-AY7","v":29}]
[]
[null,"Subnet #6",null,0,null,{"$f":"AD22","v":222},".",{"$f":"AF22","v":37},".",{"$f":"IF(L24>0,AH22,AH22+1)","v":34},".",{"$f":"IF(AJ22<250,AJ22+1,0)","v":248},null,{"$f":"F24","v":222},".",{"$f":"H24","v":37},".",{"$f":"J24","v":34},".",{"$f":"L24+1","v":249},null,{"$f":"AD24","v":222},".",{"$f":"AF24","v":37},".",{"$f":"AH24","v":34},".",{"$f":"AJ24-1","v":248},null,{"$f":"F24","v":222},".",{"$f":"IF(AY8>16,H24+(2^(AY8-16))-1,H24)","v":37},".",{"$f":"IF(AND(AY8>8,AY8<16),J24+(2^(AY8-8))-1,IF(AY8>16,255,J24))","v":34},".",{"$f":"IF(AY8<8,L24+(2^AY8)-1,255)","v":249},null,{"$f":"AL22","v":255},".",{"$f":"AN22","v":255},".",{"$f":"IF(OR(16-AY8<0,16-AY8=0),0,VLOOKUP(16-AY8,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY8<0,8-AY8=0),0,VLOOKUP(8-AY8,BJ3:BK11,2))","v":254},null,{"$f":"32-AY8","v":31}]
[]
[null,"Subnet #7",null,0,null,{"$f":"AD24","v":222},".",{"$f":"AF24","v":37},".",{"$f":"IF(L26>0,AH24,AH24+1)","v":34},".",{"$f":"IF(AJ24<250,AJ24+1,0)","v":250},null,{"$f":"F26","v":222},".",{"$f":"H26","v":37},".",{"$f":"J26","v":34},".",{"$f":"L26+1","v":251},null,{"$f":"AD26","v":222},".",{"$f":"AF26","v":37},".",{"$f":"AH26","v":34},".",{"$f":"AJ26-1","v":250},null,{"$f":"F26","v":222},".",{"$f":"IF(AY9>16,H26+(2^(AY9-16))-1,H26)","v":37},".",{"$f":"IF(AND(AY9>8,AY9<16),J26+(2^(AY9-8))-1,IF(AY9>16,255,J26))","v":34},".",{"$f":"IF(AY9<8,L26+(2^AY9)-1,255)","v":251},null,{"$f":"AL24","v":255},".",{"$f":"AN24","v":255},".",{"$f":"IF(OR(16-AY9<0,16-AY9=0),0,VLOOKUP(16-AY9,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY9<0,8-AY9=0),0,VLOOKUP(8-AY9,BJ3:BK11,2))","v":254},null,{"$f":"32-AY9","v":31}]
[]
[null,"Subnet #8",null,0,null,{"$f":"AD26","v":222},".",{"$f":"AF26","v":37},".",{"$f":"IF(L28>0,AH26,AH26+1)","v":35},".",{"$f":"IF(AJ26<250,AJ26+1,0)","v":0},null,{"$f":"F28","v":222},".",{"$f":"H28","v":37},".",{"$f":"J28","v":35},".",{"$f":"L28+1","v":1},null,{"$f":"AD28","v":222},".",{"$f":"AF28","v":37},".",{"$f":"AH28","v":35},".",{"$f":"AJ28-1","v":0},null,{"$f":"F28","v":222},".",{"$f":"IF(AY10>16,H28+(2^(AY10-16))-1,H28)","v":37},".",{"$f":"IF(AND(AY10>8,AY10<16),J28+(2^(AY10-8))-1,IF(AY10>16,255,J28))","v":35},".",{"$f":"IF(AY10<8,L28+(2^AY10)-1,255)","v":1},null,{"$f":"AL26","v":255},".",{"$f":"AN26","v":255},".",{"$f":"IF(OR(16-AY10<0,16-AY10=0),0,VLOOKUP(16-AY10,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY10<0,8-AY10=0),0,VLOOKUP(8-AY10,BJ3:BK11,2))","v":254},null,{"$f":"32-AY10","v":31}]
[]
[null,"Subnet #9",null,0,null,{"$f":"AD28","v":222},".",{"$f":"AF28","v":37},".",{"$f":"IF(L30>0,AH28,AH28+1)","v":35},".",{"$f":"IF(AJ28<250,AJ28+1,0)","v":2},null,{"$f":"F30","v":222},".",{"$f":"H30","v":37},".",{"$f":"J30","v":35},".",{"$f":"L30+1","v":3},null,{"$f":"AD30","v":222},".",{"$f":"AF30","v":37},".",{"$f":"AH30","v":35},".",{"$f":"AJ30-1","v":2},null,{"$f":"F30","v":222},".",{"$f":"IF(AY11>16,H30+(2^(AY11-16))-1,H30)","v":37},".",{"$f":"IF(AND(AY11>8,AY11<16),J30+(2^(AY11-8))-1,IF(AY11>16,255,J30))","v":35},".",{"$f":"IF(AY11<8,L30+(2^AY11)-1,255)","v":3},null,{"$f":"AL28","v":255},".",{"$f":"AN28","v":255},".",{"$f":"IF(OR(16-AY11<0,16-AY11=0),0,VLOOKUP(16-AY11,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY11<0,8-AY11=0),0,VLOOKUP(8-AY11,BJ3:BK11,2))","v":254},null,{"$f":"32-AY11","v":31}]
[]
[null,"Subnet #10",null,0,null,{"$f":"AD30","v":222},".",{"$f":"AF30","v":37},".",{"$f":"IF(L32>0,AH30,AH30+1)","v":35},".",{"$f":"IF(AJ30<250,AJ30+1,0)","v":4},null,{"$f":"F32","v":222},".",{"$f":"H32","v":37},".",{"$f":"J32","v":35},".",{"$f":"L32+1","v":5},null,{"$f":"AD32","v":222},".",{"$f":"AF32","v":37},".",{"$f":"AH32","v":35},".",{"$f":"AJ32-1","v":4},null,{"$f":"F32","v":222},".",{"$f":"IF(AY12>16,H32+(2^(AY12-16))-1,H32)","v":37},".",{"$f":"IF(AND(AY12>8,AY12<16),J32+(2^(AY12-8))-1,IF(AY12>16,255,J32))","v":35},".",{"$f":"IF(AY12<8,L32+(2^AY12)-1,255)","v":5},null,{"$f":"AL30","v":255},".",{"$f":"AN30","v":255},".",{"$f":"IF(OR(16-AY12<0,16-AY12=0),0,VLOOKUP(16-AY12,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY12<0,8-AY12=0),0,VLOOKUP(8-AY12,BJ3:BK11,2))","v":254},null,{"$f":"32-AY12","v":31}]
[]
[null,"Subnet #11",null,0,null,{"$f":"AD32","v":222},".",{"$f":"AF32","v":37},".",{"$f":"IF(L34>0,AH32,AH32+1)","v":35},".",{"$f":"IF(AJ32<250,AJ32+1,0)","v":6},null,{"$f":"F34","v":222},".",{"$f":"H34","v":37},".",{"$f":"J34","v":35},".",{"$f":"L34+1","v":7},null,{"$f":"AD34","v":222},".",{"$f":"AF34","v":37},".",{"$f":"AH34","v":35},".",{"$f":"AJ34-1","v":6},null,{"$f":"F34","v":222},".",{"$f":"IF(AY13>16,H34+(2^(AY13-16))-1,H34)","v":37},".",{"$f":"IF(AND(AY13>8,AY13<16),J34+(2^(AY13-8))-1,IF(AY13>16,255,J34))","v":35},".",{"$f":"IF(AY13<8,L34+(2^AY13)-1,255)","v":7},null,{"$f":"AL32","v":255},".",{"$f":"AN32","v":255},".",{"$f":"IF(OR(16-AY13<0,16-AY13=0),0,VLOOKUP(16-AY13,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY13<0,8-AY13=0),0,VLOOKUP(8-AY13,BJ3:BK11,2))","v":254},null,{"$f":"32-AY13","v":31}]
[]
[null,"Subnet #12",null,0,null,{"$f":"AD34","v":222},".",{"$f":"AF34","v":37},".",{"$f":"IF(L36>0,AH34,AH34+1)","v":35},".",{"$f":"IF(AJ34<250,AJ34+1,0)","v":8},null,{"$f":"F36","v":222},".",{"$f":"H36","v":37},".",{"$f":"J36","v":35},".",{"$f":"L36+1","v":9},null,{"$f":"AD36","v":222},".",{"$f":"AF36","v":37},".",{"$f":"AH36","v":35},".",{"$f":"AJ36-1","v":8},null,{"$f":"F36","v":222},".",{"$f":"IF(AY14>16,H36+(2^(AY14-16))-1,H36)","v":37},".",{"$f":"IF(AND(AY14>8,AY14<16),J36+(2^(AY14-8))-1,IF(AY14>16,255,J36))","v":35},".",{"$f":"IF(AY14<8,L36+(2^AY14)-1,255)","v":9},null,{"$f":"AL34","v":255},".",{"$f":"AN34","v":255},".",{"$f":"IF(OR(16-AY14<0,16-AY14=0),0,VLOOKUP(16-AY14,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY14<0,8-AY14=0),0,VLOOKUP(8-AY14,BJ3:BK11,2))","v":254},null,{"$f":"32-AY14","v":31}]
[]
[null,"Subnet #13",null,0,null,{"$f":"AD36","v":222},".",{"$f":"AF36","v":37},".",{"$f":"IF(L38>0,AH36,AH36+1)","v":35},".",{"$f":"IF(AJ36<250,AJ36+1,0)","v":10},null,{"$f":"F38","v":222},".",{"$f":"H38","v":37},".",{"$f":"J38","v":35},".",{"$f":"L38+1","v":11},null,{"$f":"AD38","v":222},".",{"$f":"AF38","v":37},".",{"$f":"AH38","v":35},".",{"$f":"AJ38-1","v":10},null,{"$f":"F38","v":222},".",{"$f":"IF(AY15>16,H38+(2^(AY15-16))-1,H38)","v":37},".",{"$f":"IF(AND(AY15>8,AY15<16),J38+(2^(AY15-8))-1,IF(AY15>16,255,J38))","v":35},".",{"$f":"IF(AY15<8,L38+(2^AY15)-1,255)","v":11},null,{"$f":"AL36","v":255},".",{"$f":"AN36","v":255},".",{"$f":"IF(OR(16-AY15<0,16-AY15=0),0,VLOOKUP(16-AY15,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY15<0,8-AY15=0),0,VLOOKUP(8-AY15,BJ3:BK11,2))","v":254},null,{"$f":"32-AY15","v":31}]
[]
[null,"Subnet #14",null,0,null,{"$f":"AD38","v":222},".",{"$f":"AF38","v":37},".",{"$f":"IF(L40>0,AH38,AH38+1)","v":35},".",{"$f":"IF(AJ38<250,AJ38+1,0)","v":12},null,{"$f":"F40","v":222},".",{"$f":"H40","v":37},".",{"$f":"J40","v":35},".",{"$f":"L40+1","v":13},null,{"$f":"AD40","v":222},".",{"$f":"AF40","v":37},".",{"$f":"AH40","v":35},".",{"$f":"AJ40-1","v":12},null,{"$f":"F40","v":222},".",{"$f":"IF(AY16>16,H40+(2^(AY16-16))-1,H40)","v":37},".",{"$f":"IF(AND(AY16>8,AY16<16),J40+(2^(AY16-8))-1,IF(AY16>16,255,J40))","v":35},".",{"$f":"IF(AY16<8,L40+(2^AY16)-1,255)","v":13},null,{"$f":"AL38","v":255},".",{"$f":"AN38","v":255},".",{"$f":"IF(OR(16-AY16<0,16-AY16=0),0,VLOOKUP(16-AY16,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY16<0,8-AY16=0),0,VLOOKUP(8-AY16,BJ3:BK11,2))","v":254},null,{"$f":"32-AY16","v":31}]
[]
[null,"Subnet #15",null,0,null,{"$f":"AD40","v":222},".",{"$f":"AF40","v":37},".",{"$f":"IF(L42>0,AH40,AH40+1)","v":35},".",{"$f":"IF(AJ40<250,AJ40+1,0)","v":14},null,{"$f":"F42","v":222},".",{"$f":"H42","v":37},".",{"$f":"J42","v":35},".",{"$f":"L42+1","v":15},null,{"$f":"AD42","v":222},".",{"$f":"AF42","v":37},".",{"$f":"AH42","v":35},".",{"$f":"AJ42-1","v":14},null,{"$f":"F42","v":222},".",{"$f":"IF(AY17>16,H42+(2^(AY17-16))-1,H42)","v":37},".",{"$f":"IF(AND(AY17>8,AY17<16),J42+(2^(AY17-8))-1,IF(AY17>16,255,J42))","v":35},".",{"$f":"IF(AY17<8,L42+(2^AY17)-1,255)","v":15},null,{"$f":"AL40","v":255},".",{"$f":"AN40","v":255},".",{"$f":"IF(OR(16-AY17<0,16-AY17=0),0,VLOOKUP(16-AY17,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY17<0,8-AY17=0),0,VLOOKUP(8-AY17,BJ3:BK11,2))","v":254},null,{"$f":"32-AY17","v":31}]
[]
[null,"Subnet #16",null,0,null,{"$f":"AD42","v":222},".",{"$f":"AF42","v":37},".",{"$f":"IF(L44>0,AH42,AH42+1)","v":35},".",{"$f":"IF(AJ42<250,AJ42+1,0)","v":16},null,{"$f":"F44","v":222},".",{"$f":"H44","v":37},".",{"$f":"J44","v":35},".",{"$f":"L44+1","v":17},null,{"$f":"AD44","v":222},".",{"$f":"AF44","v":37},".",{"$f":"AH44","v":35},".",{"$f":"AJ44-1","v":16},null,{"$f":"F44","v":222},".",{"$f":"IF(AY18>16,H44+(2^(AY18-16))-1,H44)","v":37},".",{"$f":"IF(AND(AY18>8,AY18<16),J44+(2^(AY18-8))-1,IF(AY18>16,255,J44))","v":35},".",{"$f":"IF(AY18<8,L44+(2^AY18)-1,255)","v":17},null,{"$f":"AL42","v":255},".",{"$f":"AN42","v":255},".",{"$f":"IF(OR(16-AY18<0,16-AY18=0),0,VLOOKUP(16-AY18,BJ3:BK11,2))","v":255},".",{"$f":"IF(OR(8-AY18<0,8-AY18=0),0,VLOOKUP(8-AY18,BJ3:BK11,2))","v":254},null,{"$f":"32-AY18","v":31}]
[]
[null,"Total hosts:",null,{"$f":"SUM(D14:D44)","v":204}]

{"sheet":"VLSM Table","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,5]]}
[]
[null,"Company name:",null,null,null,null,"Date:",{"$f":"TODAY()","v":"2011-01-30"}]
[]
[null,"VLSM Addressing - Subnets printout",null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,{"$f":"'VLSM Calculator'!F9","v":5}]
[]
[null,"Subnet","Subnet Address","Subnet Mask (/X)","First Usable Host","Last Usable Host","Broadcast Address","Division name"]
[null,1,{"$f":"CONCATENATE('VLSM Calculator'!F14,\".\",'VLSM Calculator'!H14,\".\",'VLSM Calculator'!J14,\".\",'VLSM Calculator'!L14)","v":"222.37.34.0"},{"$f":"'VLSM Calculator'!AT14","v":25},{"$f":"CONCATENATE('VLSM Calculator'!N14,\".\",'VLSM Calculator'!P14,\".\",'VLSM Calculator'!R14,\".\",'VLSM Calculator'!T14)","v":"222.37.34.1"},{"$f":"CONCATENATE('VLSM Calculator'!V14,\".\",'VLSM Calculator'!X14,\".\",'VLSM Calculator'!Z14,\".\",'VLSM Calculator'!AB14)","v":"222.37.34.126"},{"$f":"CONCATENATE('VLSM Calculator'!AD14,\".\",'VLSM Calculator'!AF14,\".\",'VLSM Calculator'!AH14,\".\",'VLSM Calculator'!AJ14)","v":"222.37.34.127"}]
[null,2,{"$f":"CONCATENATE('VLSM Calculator'!F16,\".\",'VLSM Calculator'!H16,\".\",'VLSM Calculator'!J16,\".\",'VLSM Calculator'!L16)","v":"222.37.34.128"},{"$f":"'VLSM Calculator'!AT16","v":26},{"$f":"CONCATENATE('VLSM Calculator'!N16,\".\",'VLSM Calculator'!P16,\".\",'VLSM Calculator'!R16,\".\",'VLSM Calculator'!T16)","v":"222.37.34.129"},{"$f":"CONCATENATE('VLSM Calculator'!V16,\".\",'VLSM Calculator'!X16,\".\",'VLSM Calculator'!Z16,\".\",'VLSM Calculator'!AB16)","v":"222.37.34.190"},{"$f":"CONCATENATE('VLSM Calculator'!AD16,\".\",'VLSM Calculator'!AF16,\".\",'VLSM Calculator'!AH16,\".\",'VLSM Calculator'!AJ16)","v":"222.37.34.191"}]
[null,3,{"$f":"CONCATENATE('VLSM Calculator'!F18,\".\",'VLSM Calculator'!H18,\".\",'VLSM Calculator'!J18,\".\",'VLSM Calculator'!L18)","v":"222.37.34.192"},{"$f":"'VLSM Calculator'!AT18","v":27},{"$f":"CONCATENATE('VLSM Calculator'!N18,\".\",'VLSM Calculator'!P18,\".\",'VLSM Calculator'!R18,\".\",'VLSM Calculator'!T18)","v":"222.37.34.193"},{"$f":"CONCATENATE('VLSM Calculator'!V18,\".\",'VLSM Calculator'!X18,\".\",'VLSM Calculator'!Z18,\".\",'VLSM Calculator'!AB18)","v":"222.37.34.222"},{"$f":"CONCATENATE('VLSM Calculator'!AD18,\".\",'VLSM Calculator'!AF18,\".\",'VLSM Calculator'!AH18,\".\",'VLSM Calculator'!AJ18)","v":"222.37.34.223"}]
[null,4,{"$f":"CONCATENATE('VLSM Calculator'!F20,\".\",'VLSM Calculator'!H20,\".\",'VLSM Calculator'!J20,\".\",'VLSM Calculator'!L20)","v":"222.37.34.224"},{"$f":"'VLSM Calculator'!AT20","v":28},{"$f":"CONCATENATE('VLSM Calculator'!N20,\".\",'VLSM Calculator'!P20,\".\",'VLSM Calculator'!R20,\".\",'VLSM Calculator'!T20)","v":"222.37.34.225"},{"$f":"CONCATENATE('VLSM Calculator'!V20,\".\",'VLSM Calculator'!X20,\".\",'VLSM Calculator'!Z20,\".\",'VLSM Calculator'!AB20)","v":"222.37.34.238"},{"$f":"CONCATENATE('VLSM Calculator'!AD20,\".\",'VLSM Calculator'!AF20,\".\",'VLSM Calculator'!AH20,\".\",'VLSM Calculator'!AJ20)","v":"222.37.34.239"}]
[null,5,{"$f":"CONCATENATE('VLSM Calculator'!F22,\".\",'VLSM Calculator'!H22,\".\",'VLSM Calculator'!J22,\".\",'VLSM Calculator'!L22)","v":"222.37.34.240"},{"$f":"'VLSM Calculator'!AT22","v":29},{"$f":"CONCATENATE('VLSM Calculator'!N22,\".\",'VLSM Calculator'!P22,\".\",'VLSM Calculator'!R22,\".\",'VLSM Calculator'!T22)","v":"222.37.34.241"},{"$f":"CONCATENATE('VLSM Calculator'!V22,\".\",'VLSM Calculator'!X22,\".\",'VLSM Calculator'!Z22,\".\",'VLSM Calculator'!AB22)","v":"222.37.34.246"},{"$f":"CONCATENATE('VLSM Calculator'!AD22,\".\",'VLSM Calculator'!AF22,\".\",'VLSM Calculator'!AH22,\".\",'VLSM Calculator'!AJ22)","v":"222.37.34.247"}]
[null,6,{"$f":"CONCATENATE('VLSM Calculator'!F24,\".\",'VLSM Calculator'!H24,\".\",'VLSM Calculator'!J24,\".\",'VLSM Calculator'!L24)","v":"222.37.34.248"},{"$f":"'VLSM Calculator'!AT24","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N24,\".\",'VLSM Calculator'!P24,\".\",'VLSM Calculator'!R24,\".\",'VLSM Calculator'!T24)","v":"222.37.34.249"},{"$f":"CONCATENATE('VLSM Calculator'!V24,\".\",'VLSM Calculator'!X24,\".\",'VLSM Calculator'!Z24,\".\",'VLSM Calculator'!AB24)","v":"222.37.34.248"},{"$f":"CONCATENATE('VLSM Calculator'!AD24,\".\",'VLSM Calculator'!AF24,\".\",'VLSM Calculator'!AH24,\".\",'VLSM Calculator'!AJ24)","v":"222.37.34.249"}]
[null,7,{"$f":"CONCATENATE('VLSM Calculator'!F26,\".\",'VLSM Calculator'!H26,\".\",'VLSM Calculator'!J26,\".\",'VLSM Calculator'!L26)","v":"222.37.34.250"},{"$f":"'VLSM Calculator'!AT26","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N26,\".\",'VLSM Calculator'!P26,\".\",'VLSM Calculator'!R26,\".\",'VLSM Calculator'!T26)","v":"222.37.34.251"},{"$f":"CONCATENATE('VLSM Calculator'!V26,\".\",'VLSM Calculator'!X26,\".\",'VLSM Calculator'!Z26,\".\",'VLSM Calculator'!AB26)","v":"222.37.34.250"},{"$f":"CONCATENATE('VLSM Calculator'!AD26,\".\",'VLSM Calculator'!AF26,\".\",'VLSM Calculator'!AH26,\".\",'VLSM Calculator'!AJ26)","v":"222.37.34.251"}]
[null,8,{"$f":"CONCATENATE('VLSM Calculator'!F28,\".\",'VLSM Calculator'!H28,\".\",'VLSM Calculator'!J28,\".\",'VLSM Calculator'!L28)","v":"222.37.35.0"},{"$f":"'VLSM Calculator'!AT28","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N28,\".\",'VLSM Calculator'!P28,\".\",'VLSM Calculator'!R28,\".\",'VLSM Calculator'!T28)","v":"222.37.35.1"},{"$f":"CONCATENATE('VLSM Calculator'!V28,\".\",'VLSM Calculator'!X28,\".\",'VLSM Calculator'!Z28,\".\",'VLSM Calculator'!AB28)","v":"222.37.35.0"},{"$f":"CONCATENATE('VLSM Calculator'!AD28,\".\",'VLSM Calculator'!AF28,\".\",'VLSM Calculator'!AH28,\".\",'VLSM Calculator'!AJ28)","v":"222.37.35.1"}]
[null,9,{"$f":"CONCATENATE('VLSM Calculator'!F30,\".\",'VLSM Calculator'!H30,\".\",'VLSM Calculator'!J30,\".\",'VLSM Calculator'!L30)","v":"222.37.35.2"},{"$f":"'VLSM Calculator'!AT30","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N30,\".\",'VLSM Calculator'!P30,\".\",'VLSM Calculator'!R30,\".\",'VLSM Calculator'!T30)","v":"222.37.35.3"},{"$f":"CONCATENATE('VLSM Calculator'!V30,\".\",'VLSM Calculator'!X30,\".\",'VLSM Calculator'!Z30,\".\",'VLSM Calculator'!AB30)","v":"222.37.35.2"},{"$f":"CONCATENATE('VLSM Calculator'!AD30,\".\",'VLSM Calculator'!AF30,\".\",'VLSM Calculator'!AH30,\".\",'VLSM Calculator'!AJ30)","v":"222.37.35.3"}]
[null,10,{"$f":"CONCATENATE('VLSM Calculator'!F32,\".\",'VLSM Calculator'!H32,\".\",'VLSM Calculator'!J32,\".\",'VLSM Calculator'!L32)","v":"222.37.35.4"},{"$f":"'VLSM Calculator'!AT32","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N32,\".\",'VLSM Calculator'!P32,\".\",'VLSM Calculator'!R32,\".\",'VLSM Calculator'!T32)","v":"222.37.35.5"},{"$f":"CONCATENATE('VLSM Calculator'!V32,\".\",'VLSM Calculator'!X32,\".\",'VLSM Calculator'!Z32,\".\",'VLSM Calculator'!AB32)","v":"222.37.35.4"},{"$f":"CONCATENATE('VLSM Calculator'!AD32,\".\",'VLSM Calculator'!AF32,\".\",'VLSM Calculator'!AH32,\".\",'VLSM Calculator'!AJ32)","v":"222.37.35.5"}]
[null,11,{"$f":"CONCATENATE('VLSM Calculator'!F34,\".\",'VLSM Calculator'!H34,\".\",'VLSM Calculator'!J34,\".\",'VLSM Calculator'!L34)","v":"222.37.35.6"},{"$f":"'VLSM Calculator'!AT34","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N34,\".\",'VLSM Calculator'!P34,\".\",'VLSM Calculator'!R34,\".\",'VLSM Calculator'!T34)","v":"222.37.35.7"},{"$f":"CONCATENATE('VLSM Calculator'!V34,\".\",'VLSM Calculator'!X34,\".\",'VLSM Calculator'!Z34,\".\",'VLSM Calculator'!AB34)","v":"222.37.35.6"},{"$f":"CONCATENATE('VLSM Calculator'!AD34,\".\",'VLSM Calculator'!AF34,\".\",'VLSM Calculator'!AH34,\".\",'VLSM Calculator'!AJ34)","v":"222.37.35.7"}]
[null,12,{"$f":"CONCATENATE('VLSM Calculator'!F36,\".\",'VLSM Calculator'!H36,\".\",'VLSM Calculator'!J36,\".\",'VLSM Calculator'!L36)","v":"222.37.35.8"},{"$f":"'VLSM Calculator'!AT36","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N36,\".\",'VLSM Calculator'!P36,\".\",'VLSM Calculator'!R36,\".\",'VLSM Calculator'!T36)","v":"222.37.35.9"},{"$f":"CONCATENATE('VLSM Calculator'!V36,\".\",'VLSM Calculator'!X36,\".\",'VLSM Calculator'!Z36,\".\",'VLSM Calculator'!AB36)","v":"222.37.35.8"},{"$f":"CONCATENATE('VLSM Calculator'!AD36,\".\",'VLSM Calculator'!AF36,\".\",'VLSM Calculator'!AH36,\".\",'VLSM Calculator'!AJ36)","v":"222.37.35.9"}]
[null,13,{"$f":"CONCATENATE('VLSM Calculator'!F38,\".\",'VLSM Calculator'!H38,\".\",'VLSM Calculator'!J38,\".\",'VLSM Calculator'!L38)","v":"222.37.35.10"},{"$f":"'VLSM Calculator'!AT38","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N38,\".\",'VLSM Calculator'!P38,\".\",'VLSM Calculator'!R38,\".\",'VLSM Calculator'!T38)","v":"222.37.35.11"},{"$f":"CONCATENATE('VLSM Calculator'!V38,\".\",'VLSM Calculator'!X38,\".\",'VLSM Calculator'!Z38,\".\",'VLSM Calculator'!AB38)","v":"222.37.35.10"},{"$f":"CONCATENATE('VLSM Calculator'!AD38,\".\",'VLSM Calculator'!AF38,\".\",'VLSM Calculator'!AH38,\".\",'VLSM Calculator'!AJ38)","v":"222.37.35.11"}]
[null,14,{"$f":"CONCATENATE('VLSM Calculator'!F40,\".\",'VLSM Calculator'!H40,\".\",'VLSM Calculator'!J40,\".\",'VLSM Calculator'!L40)","v":"222.37.35.12"},{"$f":"'VLSM Calculator'!AT40","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N40,\".\",'VLSM Calculator'!P40,\".\",'VLSM Calculator'!R40,\".\",'VLSM Calculator'!T40)","v":"222.37.35.13"},{"$f":"CONCATENATE('VLSM Calculator'!V40,\".\",'VLSM Calculator'!X40,\".\",'VLSM Calculator'!Z40,\".\",'VLSM Calculator'!AB40)","v":"222.37.35.12"},{"$f":"CONCATENATE('VLSM Calculator'!AD40,\".\",'VLSM Calculator'!AF40,\".\",'VLSM Calculator'!AH40,\".\",'VLSM Calculator'!AJ40)","v":"222.37.35.13"}]
[null,15,{"$f":"CONCATENATE('VLSM Calculator'!F42,\".\",'VLSM Calculator'!H42,\".\",'VLSM Calculator'!J42,\".\",'VLSM Calculator'!L42)","v":"222.37.35.14"},{"$f":"'VLSM Calculator'!AT42","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N42,\".\",'VLSM Calculator'!P42,\".\",'VLSM Calculator'!R42,\".\",'VLSM Calculator'!T42)","v":"222.37.35.15"},{"$f":"CONCATENATE('VLSM Calculator'!V42,\".\",'VLSM Calculator'!X42,\".\",'VLSM Calculator'!Z42,\".\",'VLSM Calculator'!AB42)","v":"222.37.35.14"},{"$f":"CONCATENATE('VLSM Calculator'!AD42,\".\",'VLSM Calculator'!AF42,\".\",'VLSM Calculator'!AH42,\".\",'VLSM Calculator'!AJ42)","v":"222.37.35.15"}]
[null,16,{"$f":"CONCATENATE('VLSM Calculator'!F44,\".\",'VLSM Calculator'!H44,\".\",'VLSM Calculator'!J44,\".\",'VLSM Calculator'!L44)","v":"222.37.35.16"},{"$f":"'VLSM Calculator'!AT44","v":31},{"$f":"CONCATENATE('VLSM Calculator'!N44,\".\",'VLSM Calculator'!P44,\".\",'VLSM Calculator'!R44,\".\",'VLSM Calculator'!N44)","v":"222.37.35.222"},{"$f":"CONCATENATE('VLSM Calculator'!V44,\".\",'VLSM Calculator'!X44,\".\",'VLSM Calculator'!Z44,\".\",'VLSM Calculator'!AB44)","v":"222.37.35.16"},{"$f":"CONCATENATE('VLSM Calculator'!AD44,\".\",'VLSM Calculator'!AF44,\".\",'VLSM Calculator'!AH44,\".\",'VLSM Calculator'!AJ44)","v":"222.37.35.17"}]

{"sheet":"Net","index":3,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,0,null,8,null,32,null,40,null,128,null,136,null,160,null,168]
[null,null,3,null,11,null,35,null,43,null,131,null,139,null,163,null,171]
[null,4,null,12,null,36,null,44,null,132,null,140,null,164,null,172]
[null,null,7,null,15,null,39,null,47,null,135,null,143,null,167,null,175]
[null,16,null,24,null,48,null,56,null,144,null,152,null,176,null,184]
[null,null,19,null,27,null,51,null,59,null,147,null,155,null,179,null,187]
[null,20,null,28,null,52,null,60,null,148,null,156,null,180,null,188]
[null,null,23,null,31,null,55,null,63,null,151,null,159,null,183,null,191]
[null,64,null,72,null,96,null,112,null,192,null,200,null,224,null,232]
[null,null,67,null,75,null,99,null,115,null,195,null,203,null,227,null,235]
[null,68,null,76,null,100,null,116,null,196,null,204,null,228,null,236]
[null,null,71,null,79,null,103,null,119,null,199,null,207,null,231,null,239]
[null,80,null,88,null,104,null,120,null,208,null,216,null,240,null,248]
[null,null,83,null,91,null,107,null,123,null,211,null,219,null,243,null,251]
[null,84,null,92,null,108,null,124,null,212,null,220,null,244,null,252]
[null,null,87,null,95,null,111,null,127,null,215,null,223,null,247,null,255]
[]
[null,256]
[null,128]
[null,64]
[null,32]
[null,16]
[null,8]
[null,4]