{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["referenacja","Parametry","Formularz"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"referenacja","index":0,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[12,3,19,3],[20,3,27,3],[28,3,30,3],[2,0,3,0],[12,0,19,0],[20,0,27,0],[28,0,30,0],[4,0,7,0],[8,0,11,0],[4,3,7,3],[8,3,11,3]]}
[]
[null,"lp","Polecenia: ","komentarz"]
["Interface",1,"set network interface tunnel units [tunnel]","Tworzymy interfejs tunnel który będzie wykorzystwany w VPN'nie"]
[null,2,"set zone [zone] network layer3  [tunnel]","Tworzymy zone typu L3 z dodaniem interfejsu tunnel który wcześniej skonfigurowaliśmy"]
["IKE Profil",3,"set network ike crypto-profiles ike-crypto-profiles [Name_IKE] hash [hash_ike]","Profil IKE z parametrami "]
[null,4,"set network ike crypto-profiles ike-crypto-profiles [Name_IKE] dh-group [dh-group_ike]"]
[null,5,"set network ike crypto-profiles ike-crypto-profiles [Name_IKE] encryption [encryption_ike]"]
[null,6,"set network ike crypto-profiles ike-crypto-profiles [Name_IKE] lifetime [lifetime_ike_jednostka] [lifetime_ike]"]
["IPSec Profil",7,"set network ike crypto-profiles ipsec-crypto-profiles [name_crypto] [tryb_crypto] authentication [authentication_crypto]","Profil IPSec z parametrami "]
[null,8,"set network ike crypto-profiles ipsec-crypto-profiles [name_crypto] [tryb_crypto] encryption [encryption_crypto]"]
[null,9,"set network ike crypto-profiles ipsec-crypto-profiles [name_crypto] lifetime [lifetime_crypto_jednostka] [lifetime_crypto]"]
[null,10,"set network ike crypto-profiles ipsec-crypto-profiles [name_crypto] dh-group [dh-group_crypto]"]
["Gateway",11,"set network ike gateway [name_gw] authentication pre-shared-key key [psk_gw]","Tworzymy profil peera "]
[null,12,"set network ike gateway [name_gw] protocol ikev1 dpd enable [dpd_gw]"]
[null,13,"set network ike gateway [name_gw] protocol ikev1 ike-crypto-profile [Name_IKE]"]
[null,14,"set network ike gateway [name_gw] protocol ikev1 exchange-mode [mode_gw]"]
[null,15,"set network ike gateway [name_gw] protocol-common nat-traversal enable [nat-t_gw]"]
[null,16,"set network ike gateway [name_gw] protocol-common fragmentation enable [fragmention_gw]"]
[null,17,"set network ike gateway [name_gw] local-address interface [Local_Int_gw]"]
[null,18,"set network ike gateway [name_gw] peer-address ip [peer_ip_gw]"]
["IPSec",19,"set network tunnel ipsec [Name_ipsec] auto-key ike-gateway [name_gw] ","tworzymy połączenie IPSec"]
[null,20,"set network tunnel ipsec [Name_ipsec] auto-key proxy-id [name_proxy] protocol [protocol_proxy]"]
[null,21,"set network tunnel ipsec [Name_ipsec] auto-key proxy-id [name_proxy] local [local_proxy]"]
[null,22,"set network tunnel ipsec [Name_ipsec] auto-key proxy-id [name_proxy] remote [remote_proxy]"]
[null,23,"set network tunnel ipsec [Name_ipsec] auto-key ipsec-crypto-profile [name_crypto]"]
[null,24,"set network tunnel ipsec [Name_ipsec] tunnel-monitor enable [monitor_ipsec]"]
[null,25,"set network tunnel ipsec [Name_ipsec] tunnel-interface [tun.int_ipsec]"]
[null,26,"set network tunnel ipsec [Name_ipsec] anti-replay [anti-replay_ipsce]"]
["routing",27,"set network virtual-router default routing-table ip static-route Route-toASA interface [tunnel]","dodajemy routing do urządzenia "]
[null,28,"set network virtual-router default routing-table ip static-route Route-toASA metric [metric]"]
[null,29,"set network virtual-router default routing-table ip static-route Route-toASA destination [dest_net]"]

{"sheet":"Parametry","index":1,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,2],[14,0,14,2]]}
["IKE",null,null,"int_tunel",null,null,null,null,"Local_Int_gw",null,"metric",null,"zonna"]
["hash_1","PFS_1","encryption_1","tunnel.1","lifetime","mode","no","main","ethernet1/1",null,10]
["md5","group1","3des","tunnel.2","days","ah","yes","aggressive","ethernet1/2",null,20]
["sha1","group14","aes-128-cbc","tunnel.3","hours","esp",null,"auto","ethernet1/3",null,30]
["sha256","group19","aes-192-cbc","tunnel.4","minutes",null,null,null,"ethernet1/4",null,40]
["sha384","group2","aes-256-cbc","tunnel.5","seconds ",null,null,null,"ethernet1/5",null,50]
["sha512","group20",null,"tunnel.6",null,null,null,null,"ethernet1/6",null,60]
[null,"group5",null,"tunnel.7",null,null,null,null,null,null,70]
[null,null,null,"tunnel.8",null,null,null,null,null,null,80]
[null,null,null,"tunnel.9",null,null,null,null,null,null,90]
[null,null,null,"tunnel.10",null,null,null,null,null,null,100]
[null,null,null,"tunnel.11",null,null,null,null,null,null,110]
[null,null,null,"tunnel.12",null,null,null,null,null,null,120]
[null,null,null,"tunnel.13",null,null,null,null,null,null,130]
["IPSEC",null,null,"tunnel.14"]
["md5","group1","3des","tunnel.15"]
["none","group14","aes-128-cbc","tunnel.16"]
["sha1","group19","aes-128-gcm","tunnel.17"]
["sha256","group2","aes-192-cbc","tunnel.18"]
["sha384","group20","aes-256-cbc","tunnel.19"]
["sha512","group5","aes-256-gcm","tunnel.20"]
[null,"no-pfs","null","tunnel.21"]
[null,null,null,"tunnel.22"]
[null,null,null,"tunnel.23"]
[null,null,null,"tunnel.24"]
[null,null,null,"tunnel.25"]
[null,null,null,"tunnel.26"]

{"sheet":"Formularz","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Parametr","Wpisujemy/Wybieramy","Opis Pola"]
["[zone]","VPN","Nazwa zonny którą wykorzystamy dla Interfejsu tunnel "]
["[tunnel]","tunnel.5","Interfejs tunnel przypisany do zony VPN"]
["[Name_IKE]","IKE_Profil","Nazwa profilu IKE"]
["[hash_ike]","sha1","parametr hash"]
["[dh-group_ike]","group19","wybieramy grupe DH dla IKE",null,null,"Nazwa Arkusza w której będzie gotwoy config:","VPN_conf"]
["[encryption_ike]","3des","wybieramy parametr encryption IKE"]
["[lifetime_ike]",3600,"wpisujemy czas dla Lifetime IKE",null,null,"wpisujemy"]
["[lifetime_ike_jednostka]","seconds ","wybieramy jednostkę czasu ",null,null,"nie obługuje generator innej opcji"]
["[name_crypto]","crypot_Profil","Wpisujemy nazwę dla Profile Crypto",null,null,"wybieramy z listy "]
["[tryb_crypto]","esp","Wybieramy tryb cryto w tej chwili jest tylko ESP",null,null,"pobiera dane w wcześniejszego pola "]
["[authentication_crypto]","sha1","Wybieramy authentication dla Crypto"]
["[encryption_crypto]","aes-128-cbc","Wybieramy encrypition dla cypto"]
["[lifetime_crypto]",3600,"wpisujemy czas dla Lifetime Crypto"]
["[lifetime_crypto_jednostka]","seconds ","wybieramy jednostkę czasu "]
["[dh-group_crypto]","group14","Wybieramy pfs dla Crypto"]
["[name_gw]","gw_name","Wpisujemy nazwę profilu Gataway "]
["[psk_gw]","Nasz_klucz_psk","wpisujemy klucz psk"]
["[dpd_gw]","no","w tej wersji NO"]
["[mode_gw]","main","exchange-mode main lub agresive - w tej chwili generator jest przygotowany pod main"]
["[nat-t_gw]","no","nat-traversal on/off"]
["[fragmention_gw]","no","fragmentation on/yes dla IKE w tej wersji NO"]
["[Local_Int_gw]","ethernet1/2","Wybieramy interfej Localny który będzie używany do połączenia "]
["[peer_ip_gw]","8.8.8.8","wpisujemy adres peera "]
["[Name_ipsec]","nazwa_ipsec_profilu","wpisujemy nazwę profilu IPSec"]
["[monitor_ipsec]","no","monitor on/off w tej chwili generator no"]
["[tun.int_ipsec]",{"$f":"B3","v":"tunnel.5"},"Interfejs Tunnel wcześniej wybrany"]
["[anti-replay_ipsce]","no","anti-replay on"]
["[name_proxy]","Nazwa_proxy-ID's","Nazwa profilu proxy-id's"]
["[local_proxy]","sieć lokalna","Wpisujemy lokalne proxy w formacie ip address/netmask - sieć lokalna która będzie podlegała szyfrowaniu "]
["[remote_proxy]","sieć zdalna","Wpisujemy zdalne proxy w formacie ip address/netmask - sieć zdlana która będzie podlegała szyfrowaniu"]
["[protocol_proxy]","any","wybieramy portokół - domyślna wrtość any "]
["[name_router]","default","nazwa Routera Palo - domyślna wartość default - możemy wpisać swóją nazwę "]
["[name_static_route]","nazwa_routingu","nazwa statycznego routingu"]
["[int_tunnel]",{"$f":"B3","v":"tunnel.5"},"Interfejs przez który ma być routowany "]
["[dest_net]",{"$f":"B31","v":"sieć zdalna"},"wpisujemy sieć zdalną - przyjołem że jest takie samo jak dla remote_proxy "]
["[metric]",10,"Metryka dla routingu domyślnie 10"]