{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["お客様情報","インターフェース設定","パラメータ設定","設定情報","必須入力","隠し_申込情報"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"お客様情報","index":0,"n_rows":90,"n_cols":21,"rows_kept":90,"cut":false,"hidden":false,"merged":[[12,13,12,16],[68,1,74,1],[68,2,68,7],[68,8,68,20],[69,2,69,7],[69,8,69,20],[70,2,70,7],[70,8,70,20],[71,2,71,7],[71,8,71,20],[72,2,72,7],[72,8,72,20],[73,2,73,7],[73,8,73,20],[74,2,74,7],[74,8,74,20],[63,1,64,1],[63,2,63,7],[63,8,63,20],[64,2,64,7],[64,8,64,20],[58,2,58,7],[58,8,58,20],[59,2,59,7],[50,1,61,1],[50,2,50,7],[50,8,50,20],[51,2,51,7],[51,8,51,20],[52,2,52,7],[52,8,52,20],[53,2,53,7],[53,8,53,20],[54,2,54,7],[61,2,61,7],[61,8,61,20],[59,8,59,20],[60,2,60,7],[60,8,60,20],[54,8,54,20],[55,2,55,7],[55,8,55,20],[56,2,56,7],[56,8,56,20],[57,2,57,7],[57,8,57,20],[43,2,43,7],[43,8,43,20],[44,2,44,7],[44,8,44,20],[45,2,45,7],[45,8,45,20],[40,2,40,7],[40,8,40,20],[41,2,41,7],[41,8,41,20],[42,2,42,7],[42,8,42,20],[37,2,37,7],[37,8,37,20],[38,2,38,7],[38,8,38,20],[39,2,39,7],[39,8,39,20],[30,2,30,7],[30,8,30,20],[31,2,31,7],[31,8,31,20],[34,2,34,7],[34,8,34,20],[35,2,35,7],[35,8,35,20],[36,2,36,7],[2,1,2,10],[4,1,4,7],[5,1,5,7],[7,1,7,4],[7,5,7,8],[7,10,7,12],[10,10,10,12],[12,10,12,12],[4,10,4,12],[34,1,45,1],[27,2,27,7],[27,8,27,20],[28,2,28,7],[7,13,7,16],[8,1,8,4],[8,5,8,8],[8,10,8,12],[8,13,8,16],[9,1,9,4],[9,5,9,8],[9,10,9,12],[9,13,9,16],[10,1,10,4],[10,5,10,8],[12,1,12,4],[12,5,12,8],[28,8,28,20],[29,2,29,7],[29,8,29,20],[36,8,36,20],[13,1,13,4],[13,5,13,8],[16,1,16,4],[14,1,14,4],[14,5,14,8],[23,8,23,20],[24,2,24,7],[24,8,24,20],[25,2,25,7],[25,8,25,20],[26,2,26,7],[26,8,26,20],[18,1,18,4],[18,5,18,8],[20,1,31,1],[20,2,20,7],[20,8,20,20],[21,2,21,7],[21,8,21,20],[22,2,22,7],[22,8,22,20],[23,2,23,7],[16,5,16,8],[17,1,17,4],[17,5,17,8],[4,13,4,16],[89,1,89,2],[80,3,80,20],[79,3,79,20],[81,3,81,20],[82,3,82,20],[83,3,83,20],[84,3,84,20],[85,3,85,20],[86,3,86,20],[87,3,87,20],[88,3,88,20],[89,3,89,20],[79,1,79,2],[80,1,80,2],[81,1,81,2],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[10,13,10,16],[86,1,86,2],[87,1,87,2],[88,1,88,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM_2.0"]
[null,"MIND クラウドサービス"]
[null,{"$f":"I22","v":0},null,null,null,null,null,null,null,null,null,"様　申込情報シート"]
[]
[null,"代理店様・協力会社様入力項目",null,null,null,null,null,null,null,null,"設定機種",null,null,"CE-S2"]
[null,"ＭＩＮＤ入力項目"]
[null,null,null,null,null,null,null,null,null,null,"※赤文字は必須記入欄です。"]
[null,"ＭＩＮＤ営業記入欄",null,null,null,"MIND営業記入欄の値",null,null,null,null,"申込日"]
[null,"MIND営業（所属）",null,null,null,"ＪＮ一",null,null,null,null,"申込内容",null,null,"新規"]
[null,"MIND営業（氏名）",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,"お客様/代理店様ID"]
[null,"事業所ID"]
[]
[null,"企業ID",null,null,null,"JAPNT13"]
[null,"ユーザID（CN）"]
[null,"グループID（OU）",null,null,null,"GRP-36200"]
[]
[null,"ご契約者情報","フリガナ"]
[null,null,"会社名"]
[null,null,"フリガナ"]
[null,null,"所属"]
[null,null,"フリガナ"]
[null,null,"氏名（空白不要）"]
[null,null,"郵便番号（ハイフン含む）"]
[null,null,"フリガナ"]
[null,null,"住所"]
[null,null,"電話番号（ハイフン含む）"]
[null,null,"FAX番号（ハイフン含む）"]
[null,null,"E-Mailアドレス"]
[]
[null,null,"物品送付先がご契約者と同じ場合はこちらへチェックをお願いします。"]
[null,"物品送付先","フリガナ"]
[null,null,"会社名"]
[null,null,"フリガナ"]
[null,null,"所属"]
[null,null,"フリガナ"]
[null,null,"氏名（空白不要）"]
[null,null,"郵便番号（ハイフン含む）"]
[null,null,"フリガナ"]
[null,null,"住所"]
[null,null,"電話番号（ハイフン含む）"]
[null,null,"FAX番号（ハイフン含む）"]
[null,null,"E-Mailアドレス"]
[]
[]
[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,"FAX番号（ハイフン含む）"]
[null,null,"E-Mailアドレス"]
[]
[null,"回線環境","インターネットサービスプラン名"]
[null,null,"プロバイダ名"]
[]
[]
[null,"※本サービスに関するエンドユーザ様の問い合わせ先情報"]
[null,"エンドユーザ様\n問い合わせ先情報","フリガナ"]
[null,null,"会社名"]
[null,null,"フリガナ"]
[null,null,"所属"]
[null,null,"フリガナ"]
[null,null,"氏名（空白不要）"]
[null,null,"電話番号（ハイフン含む）"]
[]
[]
[]
[null,"代理店記入欄"]
[null,"顧客ID",null,"ORCAKJN0003"]
[null,"請求パタン",null,"標準請求"]
[null,"備考１"]
[null,"備考２"]
[null,"受付番号"]
[null,"備考３"]
[null,"備考４"]
[null,"備考５"]
[null,"備考６"]
[null,"備考７"]
[null,"備考８"]

{"sheet":"インターフェース設定","index":1,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,1,14,21],[16,1,22,2],[16,3,16,12],[16,13,16,19],[17,3,17,12],[17,13,17,21],[18,3,18,12],[18,13,18,21],[19,3,19,12],[19,13,19,21],[21,3,21,12],[21,13,21,21],[22,3,22,12],[22,13,22,21],[20,13,20,21],[0,1,0,17],[3,1,3,6],[3,7,3,12],[6,3,7,6],[6,7,6,12],[6,13,6,21],[7,7,7,12],[7,13,7,21],[11,3,11,12],[11,13,11,21],[12,3,12,12],[12,13,12,21],[6,1,12,2],[10,13,10,21],[8,3,8,6],[8,7,8,21],[9,3,10,6],[9,7,9,12],[9,13,9,19],[10,7,10,12]]}
[null,"インタフェース設定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM_2.0"]
[]
[null,"お客様ネットワークへの接続種別選択（WAN側セグメント）"]
[null,"種別",null,null,null,null,null,"DHCP"]
[]
[null,"お客様ネットワークの接続情報（WAN側セグメント）",null,null,null,null,null,null,null,null,null,null,null,"※①にて選択した種別の項目のみ記入してください。"]
[null,"WAN",null,"PPPoE",null,null,null,"プロバイダ　ユーザID"]
[null,null,null,null,null,null,null,"プロバイダ　パスワード"]
[null,null,null,"DHCP",null,null,null,"※記入の必要はありません"]
[null,null,null,"固定IPアドレス",null,null,null,"機器 WAN側IPアドレス",null,null,null,null,null,null,null,null,null,null,null,null,"/"]
[null,null,null,null,null,null,null,"WAN側デフォルトゲートウェイアドレス"]
[null,null,null,"インターネット用優先DNSサーバ　※任意"]
[null,null,null,"インターネット用代替DNSサーバ　※任意"]
[]
[null,"ルータ型クライアントのネットワーク情報（LAN側セグメント）"]
[null,"VPN接続用ポートLAN"]
[null,"VPN用\nLAN",null,"機器 LAN側IPアドレス",null,null,null,null,null,null,null,null,null,"192.168.199.1",null,null,null,null,null,null,"/",24]
[null,null,null,"DHCP利用の有無",null,null,null,null,null,null,null,null,null,"有"]
[null,null,null,"DHCP配信開始IPアドレス",null,null,null,null,null,null,null,null,null,"192.168.199.2"]
[null,null,null,"DHCP配信終了IPアドレス  (指定可能IPアドレス数は128まで)",null,null,null,null,null,null,null,null,null,"192.168.199.30"]
[null,null,null,"DNS配信IPアドレス",null,null,null,null,null,null,null,null,null,"LAN側IPアドレスを使用する"]
[null,null,null,"DNS配信IPアドレス（優先DNSサーバ）　※任意"]
[null,null,null,"DNS配信IPアドレス（代替DNSサーバ）　※任意"]

{"sheet":"パラメータ設定","index":2,"n_rows":65,"n_cols":42,"rows_kept":65,"cut":false,"hidden":true,"merged":[[17,1,64,3],[4,1,7,3],[27,5,27,10],[28,5,28,10],[16,1,16,3],[10,1,10,6],[10,7,10,15],[13,1,13,6],[13,7,13,15],[7,4,7,6],[7,7,7,12],[7,13,7,15],[20,5,20,10],[21,5,21,10],[31,13,31,18],[32,13,32,18],[33,13,33,18],[34,13,34,18],[44,5,44,10],[45,5,45,10],[46,5,46,10],[35,5,35,10],[64,13,64,18],[47,13,47,18],[3,1,3,3],[3,4,3,6],[3,7,3,12],[3,13,3,15],[3,16,3,18],[6,4,6,6],[6,7,6,12],[6,13,6,15],[6,16,6,18],[7,16,7,18],[4,16,4,18],[5,4,5,6],[5,7,5,12],[5,13,5,15],[5,16,5,18],[4,4,4,6],[4,7,4,12],[4,13,4,15],[16,13,16,18],[17,13,17,18],[18,13,18,18],[19,13,19,18],[29,13,29,18],[20,13,20,18],[21,13,21,18],[22,13,22,18],[23,13,23,18],[24,13,24,18],[35,13,35,18],[36,13,36,18],[37,13,37,18],[38,13,38,18],[39,13,39,18],[30,13,30,18],[16,5,16,12],[17,5,17,10],[18,5,18,10],[19,5,19,10],[25,13,25,18],[26,13,26,18],[27,13,27,18],[28,13,28,18],[29,5,29,10],[22,5,22,10],[23,5,23,10],[24,5,24,10],[25,5,25,10],[26,5,26,10],[30,5,30,10],[31,5,31,10],[32,5,32,10],[33,5,33,10],[42,13,42,18],[43,13,43,18],[44,13,44,18],[45,13,45,18],[46,13,46,18],[42,5,42,10],[40,13,40,18],[41,13,41,18],[41,5,41,10],[43,5,43,10],[34,5,34,10],[63,13,63,18],[58,13,58,18],[59,13,59,18],[60,13,60,18],[61,13,61,18],[62,13,62,18],[53,13,53,18],[54,13,54,18],[55,13,55,18],[56,13,56,18],[57,13,57,18],[48,13,48,18],[49,13,49,18],[50,13,50,18],[51,13,51,18],[52,13,52,18],[47,5,47,10],[48,5,48,10],[49,5,49,10],[50,5,50,10],[51,5,51,10],[36,5,36,10],[37,5,37,10],[38,5,38,10],[39,5,39,10],[40,5,40,10],[64,5,64,10],[62,5,62,10],[63,5,63,10],[57,5,57,10],[58,5,58,10],[59,5,59,10],[60,5,60,10],[61,5,61,10],[52,5,52,10],[53,5,53,10],[54,5,54,10],[55,5,55,10],[56,5,56,10]]}
[null,"パラメータ設定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SM_2.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,"SPEED/Duplex",null,null,null,null,null,"ポートタイプ",null,null,"ポートの開閉"]
[null,null,null,null,"0/1",null,null,"auto",null,null,null,null,null,"vpn",null,null,"enable"]
[null,null,null,null,"0/2",null,null,"auto",null,null,null,null,null,"vpn",null,null,"enable"]
[null,null,null,null,"0/3",null,null,"auto",null,null,null,null,null,"vpn",null,null,"enable"]
[null,null,null,null,"0/4",null,null,"auto",null,null,null,null,null,"internet",null,null,"enable"]
[]
[null,"②NTPサーバ機能"]
[null,"NTPサーバ機能"]
[]
[null,"③NATコントロール"]
[null,"NAT化アドレスのみの通信の有無",null,null,null,null,null,"無"]
[]
[null,"④ルーティング",null,null,"※ルーティングは最大48個まで設定可能"]
[null,null,null,null,"番号","宛先ネットワークアドレス",null,null,null,null,null,null,null,"宛先ルータ"]
[null,"ルーティング",null,null,1,null,null,null,null,null,null,"/"]
[null,null,null,null,2,null,null,null,null,null,null,"/"]
[null,null,null,null,3,null,null,null,null,null,null,"/"]
[null,null,null,null,4,null,null,null,null,null,null,"/"]
[null,null,null,null,5,null,null,null,null,null,null,"/"]
[null,null,null,null,6,null,null,null,null,null,null,"/"]
[null,null,null,null,7,null,null,null,null,null,null,"/"]
[null,null,null,null,8,null,null,null,null,null,null,"/"]
[null,null,null,null,9,null,null,null,null,null,null,"/"]
[null,null,null,null,10,null,null,null,null,null,null,"/"]
[null,null,null,null,11,null,null,null,null,null,null,"/"]
[null,null,null,null,12,null,null,null,null,null,null,"/"]
[null,null,null,null,13,null,null,null,null,null,null,"/"]
[null,null,null,null,14,null,null,null,null,null,null,"/"]
[null,null,null,null,15,null,null,null,null,null,null,"/"]
[null,null,null,null,16,null,null,null,null,null,null,"/"]
[null,null,null,null,17,null,null,null,null,null,null,"/"]
[null,null,null,null,18,null,null,null,null,null,null,"/"]
[null,null,null,null,19,null,null,null,null,null,null,"/"]
[null,null,null,null,20,null,null,null,null,null,null,"/"]
[null,null,null,null,21,null,null,null,null,null,null,"/"]
[null,null,null,null,22,null,null,null,null,null,null,"/"]
[null,null,null,null,23,null,null,null,null,null,null,"/"]
[null,null,null,null,24,null,null,null,null,null,null,"/"]
[null,null,null,null,25,null,null,null,null,null,null,"/"]
[null,null,null,null,26,null,null,null,null,null,null,"/"]
[null,null,null,null,27,null,null,null,null,null,null,"/"]
[null,null,null,null,28,null,null,null,null,null,null,"/"]
[null,null,null,null,29,null,null,null,null,null,null,"/"]
[null,null,null,null,30,null,null,null,null,null,null,"/"]
[null,null,null,null,31,null,null,null,null,null,null,"/"]
[null,null,null,null,32,null,null,null,null,null,null,"/"]
[null,null,null,null,33,null,null,null,null,null,null,"/"]
[null,null,null,null,34,null,null,null,null,null,null,"/"]
[null,null,null,null,35,null,null,null,null,null,null,"/"]
[null,null,null,null,36,null,null,null,null,null,null,"/"]
[null,null,null,null,37,null,null,null,null,null,null,"/"]
[null,null,null,null,38,null,null,null,null,null,null,"/"]
[null,null,null,null,39,null,null,null,null,null,null,"/"]
[null,null,null,null,40,null,null,null,null,null,null,"/"]
[null,null,null,null,41,null,null,null,null,null,null,"/"]
[null,null,null,null,42,null,null,null,null,null,null,"/"]
[null,null,null,null,43,null,null,null,null,null,null,"/"]
[null,null,null,null,44,null,null,null,null,null,null,"/"]
[null,null,null,null,45,null,null,null,null,null,null,"/"]
[null,null,null,null,46,null,null,null,null,null,null,"/"]
[null,null,null,null,47,null,null,null,null,null,null,"/"]
[null,null,null,null,48,null,null,null,null,null,null,"/"]

{"sheet":"設定情報","index":3,"n_rows":68,"n_cols":3,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["【設定情報】"]
[]
[null,"本シートは返信専用です。本シートを修正し、お申し込みを行っても設定は反映されません。"]
[]
[null,"項目名","項目内容"]
[null,"所属する事業所名"]
[null,"設置場所（VPNルータの設置場所の会社名）"]
[null,"クライアントのホスト名"]
[null,{"$f":"IF(C9=\"\",\"\",\"接続先名称１\")","v":""}]
[null,{"$f":"IF(B9=\"\",\"\",\"NAT種別１\")","v":""}]
[null,{"$f":"IF(B9=\"\",\"\",\"接続元ネットワークアドレス１\")","v":""}]
[null,{"$f":"IF(B9=\"\",\"\",\"備考１\")","v":""}]
[null,{"$f":"IF(C13=\"\",\"\",\"接続先名称２\")","v":""}]
[null,{"$f":"IF(B13=\"\",\"\",\"NAT種別２\")","v":""}]
[null,{"$f":"IF(B13=\"\",\"\",\"接続元ネットワークアドレス２\")","v":""}]
[null,{"$f":"IF(B13=\"\",\"\",\"備考２\")","v":""}]
[null,{"$f":"IF(C17=\"\",\"\",\"接続先名称３\")","v":""}]
[null,{"$f":"IF(B17=\"\",\"\",\"NAT種別３\")","v":""}]
[null,{"$f":"IF(B18=\"\",\"\",\"接続元ネットワークアドレス３\")","v":""}]
[null,{"$f":"IF(B19=\"\",\"\",\"備考３\")","v":""}]
[null,{"$f":"IF(C21=\"\",\"\",\"接続先名称４\")","v":""}]
[null,{"$f":"IF(B21=\"\",\"\",\"NAT種別４\")","v":""}]
[null,{"$f":"IF(B21=\"\",\"\",\"接続元ネットワークアドレス４\")","v":""}]
[null,{"$f":"IF(B21=\"\",\"\",\"備考４\")","v":""}]
[null,{"$f":"IF(C25=\"\",\"\",\"接続先名称５\")","v":""}]
[null,{"$f":"IF(B25=\"\",\"\",\"NAT種別５\")","v":""}]
[null,{"$f":"IF(B25=\"\",\"\",\"接続元ネットワークアドレス５\")","v":""}]
[null,{"$f":"IF(B25=\"\",\"\",\"備考５\")","v":""}]
[null,{"$f":"IF(C29=\"\",\"\",\"接続先名称６\")","v":""}]
[null,{"$f":"IF(B29=\"\",\"\",\"NAT種別６\")","v":""}]
[null,{"$f":"IF(B29=\"\",\"\",\"接続元ネットワークアドレス６\")","v":""}]
[null,{"$f":"IF(B29=\"\",\"\",\"備考６\")","v":""}]
[null,{"$f":"IF(C33=\"\",\"\",\"接続先名称７\")","v":""}]
[null,{"$f":"IF(B33=\"\",\"\",\"NAT種別７\")","v":""}]
[null,{"$f":"IF(B33=\"\",\"\",\"接続元ネットワークアドレス７\")","v":""}]
[null,{"$f":"IF(B33=\"\",\"\",\"備考７\")","v":""}]
[null,{"$f":"IF(C37=\"\",\"\",\"接続先名称８\")","v":""}]
[null,{"$f":"IF(B37=\"\",\"\",\"NAT種別８\")","v":""}]
[null,{"$f":"IF(B37=\"\",\"\",\"接続元ネットワークアドレス８\")","v":""}]
[null,{"$f":"IF(B37=\"\",\"\",\"備考８\")","v":""}]
[null,{"$f":"IF(C41=\"\",\"\",\"接続先名称９\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",\"NAT種別９\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",\"接続元ネットワークアドレス９\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",\"備考９\")","v":""}]
[null,{"$f":"IF(C45=\"\",\"\",\"接続先名称１０\")","v":""}]
[null,{"$f":"IF(B45=\"\",\"\",\"NAT種別１０\")","v":""}]
[null,{"$f":"IF(B45=\"\",\"\",\"接続元ネットワークアドレス１０\")","v":""}]
[null,{"$f":"IF(B45=\"\",\"\",\"備考１０\")","v":""}]
[null,{"$f":"IF(C49=\"\",\"\",\"接続先名称１１\")","v":""}]
[null,{"$f":"IF(B49=\"\",\"\",\"NAT種別１１\")","v":""}]
[null,{"$f":"IF(B49=\"\",\"\",\"接続元ネットワークアドレス１１\")","v":""}]
[null,{"$f":"IF(B49=\"\",\"\",\"備考１１\")","v":""}]
[null,{"$f":"IF(C53=\"\",\"\",\"接続先名称１２\")","v":""}]
[null,{"$f":"IF(B53=\"\",\"\",\"NAT種別１２\")","v":""}]
[null,{"$f":"IF(B53=\"\",\"\",\"接続元ネットワークアドレス１２\")","v":""}]
[null,{"$f":"IF(B53=\"\",\"\",\"備考１２\")","v":""}]
[null,{"$f":"IF(C57=\"\",\"\",\"接続先名称１３\")","v":""}]
[null,{"$f":"IF(B57=\"\",\"\",\"NAT種別１３\")","v":""}]
[null,{"$f":"IF(B57=\"\",\"\",\"接続元ネットワークアドレス１３\")","v":""}]
[null,{"$f":"IF(B57=\"\",\"\",\"備考１３\")","v":""}]
[null,{"$f":"IF(C61=\"\",\"\",\"接続先名称１４\")","v":""}]
[null,{"$f":"IF(B61=\"\",\"\",\"NAT種別１４\")","v":""}]
[null,{"$f":"IF(B61=\"\",\"\",\"接続元ネットワークアドレス１４\")","v":""}]
[null,{"$f":"IF(B61=\"\",\"\",\"備考１４\")","v":""}]
[null,{"$f":"IF(C65=\"\",\"\",\"接続先名称１５\")","v":""}]
[null,{"$f":"IF(B65=\"\",\"\",\"NAT種別１５\")","v":""}]
[null,{"$f":"IF(B65=\"\",\"\",\"接続元ネットワークアドレス１５\")","v":""}]
[null,{"$f":"IF(B65=\"\",\"\",\"備考１５\")","v":""}]

{"sheet":"必須入力","index":4,"n_rows":120,"n_cols":15,"rows_kept":120,"cut":false,"hidden":true,"merged":[[1,1,1,2],[2,1,2,2]]}
[]
[null,"全必須入力チェック結果",null,{"$f":"IF(COUNTIF(B7:B120,\"NG\")=0,IF(D3=\"OK\",\"OK\",\"NG\"),\"NG\")","v":"NG"},null,"必須入力ボタンを押した結果","B列のNG","C列のNG","合計エラー件数"]
[null,"必須入力ボタン",null,{"$f":"IF(F3=\"OK\", IF(COUNTIF(B7:B120,\"NG\")=0,\"OK\",\"NG\"),\"NG\")","v":"NG"},null,"NG",{"$f":"COUNTIF(B7:B120,\"NG\")","v":20},{"$f":"COUNTIF(C7:C120,\"NG\")","v":0},{"$f":"G3+H3","v":20}]
[]
[]
[null,"結果","項目名","値"]
[null,{"$f":"IF(D7=\"\",\"NG\",\"OK\")","v":"OK"},"MIND営業（所属）",{"$f":"IF(お客様情報!F9= \"\",\"\",お客様情報!F9)","v":"ＪＮ一"}]
[null,"NG","MIND営業（氏名）",{"$f":"IF(お客様情報!F10= \"\",\"\",お客様情報!F10)","v":""}]
[null,{"$f":"IF(D9=\"\",\"NG\",\"OK\")","v":"NG"},"MINOS番号",{"$f":"IF(お客様情報!F11= \"\",\"\",お客様情報!F11)","v":""},null,"物品送付先がご契約者と同じ場合はこちらへチェック",false]
[null,{"$f":"IF(D10=\"\",\"NG\",\"OK\")","v":"NG"},"申込日",{"$f":"IF(お客様情報!N8= \"\",\"\",お客様情報!N8)","v":""},null,"設置場所",{"$f":"IF(G11=TRUE,2,IF(G12=TRUE,3,1))","v":1}]
[null,"OK","申込内容",{"$f":"IF(お客様情報!N9= \"\",\"\",お客様情報!N9)","v":"新規"},null,"設置場所同ご契約者",false]
[null,"NG","利用開始日",{"$f":"IF(お客様情報!N11= \"\",\"\",お客様情報!N11)","v":""},null,"設置場所同送付先",false]
[null,{"$f":"IF(D13=\"\",\"NG\",\"OK\")","v":"OK"},"企業ID",{"$f":"IF(お客様情報!F17= \"\",\"\",お客様情報!F17)","v":"JAPNT13"}]
[null,{"$f":"IF(D14=\"\",\"OK\",\"OK\")","v":"OK"},"ユーザID",{"$f":"IF(お客様情報!F18= \"\",\"\",お客様情報!F18)","v":""}]
[null,{"$f":"IF(D15=\"\",\"NG\",\"OK\")","v":"OK"},"グループID",{"$f":"IF(お客様情報!F19= \"\",\"\",お客様情報!F19)","v":"GRP-36200"}]
[null,{"$f":"IF(D16=\"\",IF(D11=\"コンフィグ設定変更\",\"NG\",\"OK\"),\"OK\")","v":"OK"},"ルータ設定",{"$f":"IF(お客様情報!N13= \"\",\"\",お客様情報!N13)","v":"無"}]
[null,{"$f":"IF(D17=\"\",\"OK\",\"OK\")","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I21= \"\",\"\",お客様情報!I21)","v":""}]
[null,"NG","会社名",{"$f":"IF(お客様情報!I22= \"\",\"\",お客様情報!I22)","v":""}]
[null,{"$f":"IF(D19=\"\",\"OK\",\"OK\")","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I23= \"\",\"\",お客様情報!I23)","v":""}]
[null,{"$f":"IF(D20=\"\",\"OK\",\"OK\")","v":"OK"},"所属",{"$f":"IF(お客様情報!I24= \"\",\"\",お客様情報!I24)","v":""}]
[null,{"$f":"IF(D21=\"\",\"OK\",\"OK\")","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I25= \"\",\"\",お客様情報!I25)","v":""}]
[null,"NG","氏名（空白不要）",{"$f":"IF(お客様情報!I26= \"\",\"\",お客様情報!I26)","v":""}]
[null,"NG","郵便番号（ハイフン含む）",{"$f":"IF(お客様情報!I27= \"\",\"\",お客様情報!I27)","v":""}]
[null,{"$f":"IF(D24=\"\",\"OK\",\"OK\")","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I28= \"\",\"\",お客様情報!I28)","v":""}]
[null,"NG","住所",{"$f":"IF(お客様情報!I29= \"\",\"\",お客様情報!I29)","v":""}]
[null,{"$f":"IF(D26=\"\",\"NG\",\"OK\")","v":"NG"},"電話番号（ハイフン含む）",{"$f":"IF(お客様情報!I30= \"\",\"\",お客様情報!I30)","v":""}]
[null,{"$f":"IF(D27=\"\",IF(G9=TRUE,\"OK\",\"OK\"),IF(G9=FALSE,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I35= \"\",\"\",お客様情報!I35)","v":""},null,"※物品送付先がご契約者と同じ場合はこちらへチェックが有る場合は、入力不可"]
[null,{"$f":"IF(D28=\"\",IF(G9=TRUE,\"OK\",\"NG\"),IF(G9=FALSE,\"OK\",\"NG\"))","v":"NG"},"会社名",{"$f":"IF(お客様情報!I36= \"\",\"\",お客様情報!I36)","v":""},null,"同上"]
[null,{"$f":"IF(D29=\"\",IF(G9=TRUE,\"OK\",\"OK\"),IF(G9=FALSE,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I37= \"\",\"\",お客様情報!I37)","v":""},null,"同上"]
[null,{"$f":"IF(D30=\"\",IF(G9=TRUE,\"OK\",\"OK\"),IF(G9=FALSE,\"OK\",\"NG\"))","v":"OK"},"所属",{"$f":"IF(お客様情報!I38= \"\",\"\",お客様情報!I38)","v":""},null,"同上"]
[null,{"$f":"IF(D31=\"\",IF(G9=TRUE,\"OK\",\"OK\"),IF(G9=FALSE,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I39= \"\",\"\",お客様情報!I39)","v":""},null,"同上"]
[null,{"$f":"IF(D32=\"\",IF(G9=TRUE,\"OK\",\"NG\"),IF(G9=FALSE,\"OK\",\"NG\"))","v":"NG"},"氏名（空白不要）",{"$f":"IF(お客様情報!I40= \"\",\"\",お客様情報!I40)","v":""},null,"同上"]
[null,{"$f":"IF(D33=\"\",IF(G9=TRUE,\"OK\",\"NG\"),IF(G9=FALSE,\"OK\",\"NG\"))","v":"NG"},"郵便番号（ハイフン含む）",{"$f":"IF(お客様情報!I41= \"\",\"\",お客様情報!I41)","v":""},null,"同上"]
[null,{"$f":"IF(D34=\"\",IF(G9=TRUE,\"OK\",\"OK\"),IF(G9=FALSE,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I42= \"\",\"\",お客様情報!I42)","v":""},null,"同上"]
[null,{"$f":"IF(D35=\"\",IF(G9=TRUE,\"OK\",\"NG\"),IF(G9=FALSE,\"OK\",\"NG\"))","v":"NG"},"住所",{"$f":"IF(お客様情報!I43= \"\",\"\",お客様情報!I43)","v":""},null,"同上"]
[null,{"$f":"IF(D36=\"\",IF(G9=TRUE,\"OK\",\"NG\"),IF(G9=FALSE,\"OK\",\"NG\"))","v":"NG"},"電話番号（ハイフン含む）",{"$f":"IF(お客様情報!I44= \"\",\"\",お客様情報!I44)","v":""},null,"同上"]
[null,{"$f":"IF(D37=\"\",\"OK\",IF(G9=FALSE,\"OK\",\"NG\"))","v":"OK"},"FAX番号（ハイフン含む）",{"$f":"IF(お客様情報!I45= \"\",\"\",お客様情報!I45)","v":""},null,"※物品送付先がご契約者と同じ場合はこちらへチェックが有る場合は、入力不可"]
[null,{"$f":"IF(D38=\"\",\"OK\",IF(G9=FALSE,\"OK\",\"NG\"))","v":"OK"},"E-Mailアドレス",{"$f":"IF(お客様情報!I46= \"\",\"\",お客様情報!I46)","v":""},null,"同上"]
[null,{"$f":"IF(D39=\"\",IF(G10<>1,\"OK\",\"OK\"),IF(G10=1,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I51= \"\",\"\",お客様情報!I51)","v":""},null,"※設置場所がご契約者、送付先と同じ場合は場合は、入力不可"]
[null,{"$f":"IF(D40=\"\",IF(G10<>1,\"OK\",\"NG\"),IF(G10=1,\"OK\",\"NG\"))","v":"NG"},"会社名",{"$f":"IF(お客様情報!I52= \"\",\"\",お客様情報!I52)","v":""},null,"同上"]
[null,{"$f":"IF(D41=\"\",IF(G10<>1,\"OK\",\"OK\"),IF(G10=1,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I53= \"\",\"\",お客様情報!I53)","v":""},null,"同上"]
[null,{"$f":"IF(D42=\"\",IF(G10<>1,\"OK\",\"OK\"),IF(G10=1,\"OK\",\"NG\"))","v":"OK"},"所属",{"$f":"IF(お客様情報!I54= \"\",\"\",お客様情報!I54)","v":""},null,"同上"]
[null,{"$f":"IF(D43=\"\",IF(G10<>1,\"OK\",\"OK\"),IF(G10=1,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I55= \"\",\"\",お客様情報!I55)","v":""},null,"同上"]
[null,{"$f":"IF(D44=\"\",IF(G10<>1,\"OK\",\"NG\"),IF(G10=1,\"OK\",\"NG\"))","v":"NG"},"氏名（空白不要）",{"$f":"IF(お客様情報!I56= \"\",\"\",お客様情報!I56)","v":""},null,"同上"]
[null,{"$f":"IF(D45=\"\",IF(G10<>1,\"OK\",\"NG\"),IF(G10=1,\"OK\",\"NG\"))","v":"NG"},"郵便番号（ハイフン含む）",{"$f":"IF(お客様情報!I57= \"\",\"\",お客様情報!I57)","v":""},null,"同上"]
[null,{"$f":"IF(D46=\"\",IF(G10<>1,\"OK\",\"OK\"),IF(G10=1,\"OK\",\"OK\"))","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I58= \"\",\"\",お客様情報!I58)","v":""},null,"同上"]
[null,{"$f":"IF(D47=\"\",IF(G10<>1,\"OK\",\"NG\"),IF(G10=1,\"OK\",\"NG\"))","v":"NG"},"住所",{"$f":"IF(お客様情報!I59= \"\",\"\",お客様情報!I59)","v":""},null,"同上"]
[null,{"$f":"IF(D48=\"\",IF(G10<>1,\"OK\",\"NG\"),IF(G10=1,\"OK\",\"NG\"))","v":"NG"},"電話番号（ハイフン含む）",{"$f":"IF(お客様情報!I60= \"\",\"\",お客様情報!I60)","v":""},null,"同上"]
[null,{"$f":"IF(D49=\"\",\"OK\",IF(G10=1,\"OK\",\"NG\"))","v":"OK"},"FAX番号（ハイフン含む）",{"$f":"IF(お客様情報!I61= \"\",\"\",お客様情報!I61)","v":""},null,"※設置場所がご契約者、送付先と同じ場合は場合は、入力不可（必須対象外）"]
[null,{"$f":"IF(D50=\"\",\"OK\",IF(G10=1,\"OK\",\"NG\"))","v":"OK"},"E-Mailアドレス",{"$f":"IF(お客様情報!I62= \"\",\"\",お客様情報!I62)","v":""},null,"同上"]
[null,{"$f":"IF(D51=\"\",\"OK\",\"OK\")","v":"OK"},"フリガナ",{"$f":"IF(お客様情報!I69= \"\",\"\",お客様情報!I69)","v":""},null,"※本サービスに関するエンドユーザ様の問い合わせ先情報"]
[null,{"$f":"IF(D52=\"\",\"OK\",\"OK\")","v":"OK"},"会社名",{"$f":"IF(お客様情報!I70= \"\",\"\",お客様情報!I70)","v":""},null,"同上"]
[null,"OK","フリガナ",{"$f":"IF(お客様情報!I71= \"\",\"\",お客様情報!I71)","v":""},null,"同上"]
[null,"OK","所属",{"$f":"IF(お客様情報!I72= \"\",\"\",お客様情報!I72)","v":""},null,"同上"]
[null,"OK","フリガナ",{"$f":"IF(お客様情報!I73= \"\",\"\",お客様情報!I73)","v":""},null,"同上"]
[null,"OK","氏名（空白不要）",{"$f":"IF(お客様情報!I74= \"\",\"\",お客様情報!I74)","v":""},null,"同上"]
[null,"OK","電話番号（ハイフン含む）",{"$f":"IF(お客様情報!I75= \"\",\"\",お客様情報!I75)","v":""},null,"同上"]
[]
[null,{"$f":"IF(D59=\"\",\"NG\",\"OK\")","v":"OK"},"種別",{"$f":"IF(インターフェース設定!H4= \"\",\"\",インターフェース設定!H4)","v":"DHCP"}]
[null,{"$f":"IF(OR(D60=\"\"),IF(OR(D59=\"固定IPアドレス\",D59=\"DHCP\"),\"OK\",\"NG\"),\"OK\")","v":"OK"},"プロバイダ　ユーザID",{"$f":"IF(インターフェース設定!N7= \"\",\"\",インターフェース設定!N7)","v":""}]
[null,{"$f":"IF(OR(D61=\"\"),IF(OR(D59=\"固定IPアドレス\",D59=\"DHCP\"),\"OK\",\"NG\"),\"OK\")","v":"OK"},"プロバイダ　パスワード",{"$f":"IF(インターフェース設定!N8= \"\",\"\",インターフェース設定!N8)","v":""}]
[null,{"$f":"IF(OR(D62=\"\",F62=\"\"),IF(OR(D59=\"PPPoE\",D59=\"DHCP\"),\"OK\",\"NG\"),\"OK\")","v":"OK"},"固定IPアドレス　S-NETR WAN側IPアドレス",{"$f":"IF(インターフェース設定!N10= \"\",\"\",インターフェース設定!N10)","v":""},"マスク",{"$f":"IF(インターフェース設定!V10= \"\",\"\",インターフェース設定!V10)","v":""}]
[null,{"$f":"IF(OR(D63=\"\"),IF(OR(D59=\"PPPoE\",D59=\"DHCP\"),\"OK\",\"NG\"),\"OK\")","v":"OK"},"固定IPアドレス　WAN側デフォルトゲートウェイアドレス",{"$f":"IF(インターフェース設定!N11= \"\",\"\",インターフェース設定!N11)","v":""},"マスク",{"$f":"IF(インターフェース設定!V11= \"\",\"\",インターフェース設定!V11)","v":""}]
[null,{"$f":"IF(AND(D64<>\"\",F64<>\"\"),\"OK\",\"NG\")","v":"OK"},"VPN用LAN　CE-S1 LAN側IPアドレス",{"$f":"IF(インターフェース設定!N17= \"\",\"\",インターフェース設定!N17)","v":"192.168.199.1"},"マスク",{"$f":"IF(インターフェース設定!V17= \"\",\"\",インターフェース設定!V17)","v":24}]
[null,{"$f":"IF(AND(D65<>\"\",F65<>\"\"),\"OK\",\"OK\")","v":"OK"},"管理用LAN　CE-S1 LAN側IPアドレス",null,"マスク"]
[null,{"$f":"IF(AND(D66=\"有\"),IF(AND(D66=\"有\",F66<>\"\",H66<>\"\"),\"OK\",\"NG\"),\"OK\")","v":"OK"},"DHCP利用の有無",{"$f":"IF(インターフェース設定!N18= \"\",\"\",インターフェース設定!N18)","v":"有"},"配信開始",{"$f":"IF(インターフェース設定!N19= \"\",\"\",インターフェース設定!N19)","v":"192.168.199.2"},"配信終了",{"$f":"IF(インターフェース設定!N20= \"\",\"\",インターフェース設定!N20)","v":"192.168.199.30"}]
[null,null,"入力途中","1レコード"]
[null,{"$f":"IF(AND(D68=\"NG\",D69=\"NG\",D70=\"NG\",D71=\"NG\",D72=\"NG\"),\"NG\",IF(AND(C68=\"OK\",C69=\"OK\",C70=\"OK\",C71=\"OK\",C72=\"OK\"),\"OK\",\"NG\"))","v":"OK"},{"$f":"IF(AND(F68=\"\",H68=\"\",J68=\"\",L68=\"\",N68=\"\"),\"OK\",IF(AND(F68<>\"\",H68<>\"\",J68<>\"\",L68<>\"\",N68<>\"\"),\"OK\",\"NG\"))","v":"OK"},"OK","S-NETR LAN側IPアドレス","","マスク","","インタフェース名（nameif）","","Security Level","","MTU値",""]
[null,null,{"$f":"IF(AND(F69=\"\",H69=\"\",J69=\"\",L69=\"\",N69=\"\"),\"OK\",IF(AND(F69<>\"\",H69<>\"\",J69<>\"\",L69<>\"\",N69<>\"\"),\"OK\",\"NG\"))","v":"OK"},"OK","S-NETR LAN側IPアドレス","","マスク","","インタフェース名（nameif）","","Security Level","","MTU値",""]
[null,null,{"$f":"IF(AND(F70=\"\",H70=\"\",J70=\"\",L70=\"\",N70=\"\"),\"OK\",IF(AND(F70<>\"\",H70<>\"\",J70<>\"\",L70<>\"\",N70<>\"\"),\"OK\",\"NG\"))","v":"OK"},"OK","S-NETR LAN側IPアドレス","","マスク","","インタフェース名（nameif）","","Security Level","","MTU値",""]
[null,null,{"$f":"IF(AND(F71=\"\",H71=\"\",J71=\"\",L71=\"\",N71=\"\"),\"OK\",IF(AND(F71<>\"\",H71<>\"\",J71<>\"\",L71<>\"\",N71<>\"\"),\"OK\",\"NG\"))","v":"OK"},"OK","S-NETR LAN側IPアドレス","","マスク","","インタフェース名（nameif）","","Security Level","","MTU値",""]
[null,null,{"$f":"IF(AND(F72=\"\",H72=\"\",J72=\"\",L72=\"\",N72=\"\"),\"OK\",IF(AND(F72<>\"\",H72<>\"\",J72<>\"\",L72<>\"\",N72<>\"\"),\"OK\",\"NG\"))","v":"OK"},"OK","S-NETR LAN側IPアドレス","","マスク","","インタフェース名（nameif）","","Security Level","","MTU値",""]
[]
[null,{"$f":"IF(J74<>\"disable\",IF(OR(D74=\"\",F74=\"\",H74=\"\",J74=\"\"),\"NG\",\"OK\"),\"OK\")","v":"OK"},"物理ポート　0/1","dummy","SPEED/Duplex",{"$f":"IF(パラメータ設定!H5= \"\",\"\",パラメータ設定!H5)","v":"auto"},"ポートタイプ",{"$f":"IF(パラメータ設定!N5= \"\",\"\",パラメータ設定!N5)","v":"vpn"},"ポートの開閉",{"$f":"IF(パラメータ設定!Q5= \"\",\"\",パラメータ設定!Q5)","v":"enable"}]
[null,{"$f":"IF(J75<>\"disable\",IF(OR(D75=\"\",F75=\"\",H75=\"\",J75=\"\"),\"NG\",\"OK\"),\"OK\")","v":"OK"},"物理ポート　0/2","dummy","SPEED/Duplex",{"$f":"IF(パラメータ設定!H6= \"\",\"\",パラメータ設定!H6)","v":"auto"},"ポートタイプ",{"$f":"IF(パラメータ設定!N6= \"\",\"\",パラメータ設定!N6)","v":"vpn"},"ポートの開閉",{"$f":"IF(パラメータ設定!Q6= \"\",\"\",パラメータ設定!Q6)","v":"enable"}]
[null,{"$f":"IF(J76<>\"disable\",IF(OR(D76=\"\",F76=\"\",H76=\"\",J76=\"\"),\"NG\",\"OK\"),\"OK\")","v":"OK"},"物理ポート　0/3","dummy","SPEED/Duplex",{"$f":"IF(パラメータ設定!H7= \"\",\"\",パラメータ設定!H7)","v":"auto"},"ポートタイプ",{"$f":"IF(パラメータ設定!N7= \"\",\"\",パラメータ設定!N7)","v":"vpn"},"ポートの開閉",{"$f":"IF(パラメータ設定!Q7= \"\",\"\",パラメータ設定!Q7)","v":"enable"}]
[null,{"$f":"IF(J77<>\"disable\",IF(OR(D77=\"\",F77=\"\",H77=\"\",J77=\"\"),\"NG\",\"OK\"),\"OK\")","v":"OK"},"物理ポート　0/4","dummy","SPEED/Duplex",{"$f":"IF(パラメータ設定!H8= \"\",\"\",パラメータ設定!H8)","v":"auto"},"ポートタイプ",{"$f":"IF(パラメータ設定!N8= \"\",\"\",パラメータ設定!N8)","v":"internet"},"ポートの開閉",{"$f":"IF(パラメータ設定!Q8= \"\",\"\",パラメータ設定!Q8)","v":"enable"}]
[null,{"$f":"IF(D78=\"\",\"OK\",\"OK\")","v":"OK"},"NTPサーバ機能",{"$f":"IF(パラメータ設定!H11= \"\",\"\",パラメータ設定!H11)","v":""}]
[null,{"$f":"IF(D79=\"\",\"NG\",\"OK\")","v":"OK"},"NAT化アドレスのみの通信の有無",{"$f":"IF(パラメータ設定!H14= \"\",\"\",パラメータ設定!H14)","v":"無"}]
[]
[null,{"$f":"IF(D81=\"\",\"OK\",\"OK\")","v":"OK"},"adminパスワード"]
[null,{"$f":"IF(D82=\"\",\"OK\",\"OK\")","v":"OK"},"rootパスワード"]
[]
[]
[null,"OK",{"$f":"IF(AND(F85=\"\",H85=\"\",J85=\"\",L85=\"\",N85=\"\",P85=\"\"),\"OK\",IF(AND(F85<>\"\",H85<>\"\",J85<>\"\",L85<>\"\",N85<>\"\",P85<>\"\"),\"OK\",\"NG\"))","v":"OK"},{"$f":"IF(AND(F85<>\"\",H85<>\"\",J85<>\"\",L85<>\"\",N85<>\"\",P85<>\"\"),\"OK\",\"NG\")","v":"NG"},"接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,{"$f":"IF(AND(F96=\"\",H96=\"\",J96=\"\",L96=\"\",N96=\"\",P96=\"\"),\"OK\",IF(AND(F96<>\"\",H96<>\"\",J96<>\"\",L96<>\"\",N96<>\"\",P96<>\"\"),\"OK\",\"NG\"))","v":"OK"},{"$f":"IF(AND(F96<>\"\",H96<>\"\",J96<>\"\",L96<>\"\",N96<>\"\",P96<>\"\"),\"OK\",\"NG\")","v":"NG"},"接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[null,null,"OK","NG","接続先略称",null,"接続先センタ装置GIPアドレス",null,"接続元(CE-S1)LAN側ネットワークアドレス",null,"接続先ネットワークアドレス",null,"接続先証明書認証情報(OU)",null,"接続先証明書認証情報(CN)"]
[]
[null,{"$f":"IF(D102=\"\",\"OK\",\"OK\")","v":"OK"},"Firmware-Version"]
[null,{"$f":"IF(D103=\"\",\"OK\",\"OK\")","v":"OK"},"設置日"]
[null,{"$f":"IF(D104=\"\",\"OK\",\"OK\")","v":"OK"},"保守業者名"]
[null,{"$f":"IF(D105=\"\",\"OK\",\"OK\")","v":"OK"},"保守対応時間"]
[null,{"$f":"IF(D106=\"\",\"OK\",\"OK\")","v":"OK"},"保守業者連絡先"]
[]
[null,null,null,null,null,"NAT","Policy NAT","Exempt NAT","NAT合計","NAPT","Policy NAPT","NAPT合計"]
[null,{"$f":"IF(I109>63,\"NG\",\"OK\")","v":"OK"},"NAT"]
[null,{"$f":"IF(L109>49,\"NG\",\"OK\")","v":"OK"},"NAPT"]
[]
[]
[null,{"$f":"IF(D113=\"\",\"OK\",\"OK\")","v":"OK"},"接続元(CE-S1)LAN側ネットワークアドレス（CIDR形式）"]
[null,{"$f":"IF(D114=\"\",\"OK\",\"OK\")","v":"OK"},"接続元(CE-S1)LAN側NAPT後アドレス（CIDR形式）"]
[null,{"$f":"IF(お客様情報!N9=\"リプレイス\",(IF(D115=\"\",\"OK\",\"OK\")),\"OK\")","v":"OK"},"接続元(CE-S1)LAN側ネットワークアドレス（CIDR形式）"]
[]
[]
[null,{"$f":"IF(D118=\"\",\"NG\",\"OK\")","v":"OK"},"区分",{"$f":"IF(お客様情報!N10= \"\",\"\",お客様情報!N10)","v":"一般"}]
[null,{"$f":"IF(D119=\"\",\"NG\",\"OK\")","v":"NG"},"三次代理店様ID",{"$f":"IF(お客様情報!F15= \"\",\"\",お客様情報!F15)","v":""}]
[null,{"$f":"IF(D120=\"\",\"NG\",\"OK\")","v":"OK"},"設定機種",{"$f":"IF(お客様情報!N5= \"\",\"\",お客様情報!N5)","v":"CE-S2"}]

{"sheet":"隠し_申込情報","index":5,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["申込情報"]
[null,"タイトル","MIND分散型セキュアネットワークサービス(ルータ型クライアント：CE-S2用)　申込情報"]
[null,"バージョン",{"$f":"お客様情報!U1","v":"SM_2.0"}]
[null,"MINOS番号",{"$f":"IF(お客様情報!F11=\"\",\"\",お客様情報!F11)","v":""}]
["ご契約者情報","フリガナ",{"$f":"IF(お客様情報!I21=\"\",\"\",お客様情報!I21)","v":""}]
[null,"会社名",{"$f":"IF(お客様情報!I22=\"\",\"\",お客様情報!I22)","v":""}]
[null,"フリガナ",{"$f":"IF(お客様情報!I23=\"\",\"\",お客様情報!I23)","v":""}]
[null,"所属",{"$f":"IF(お客様情報!I24=\"\",\"\",お客様情報!I24)","v":""}]
[null,"フリガナ",{"$f":"IF(お客様情報!I25=\"\",\"\",お客様情報!I25)","v":""}]
[null,"氏名（空白不要）",{"$f":"IF(お客様情報!I26=\"\",\"\",お客様情報!I26)","v":""}]
[null,"郵便番号（ハイフン含む）",{"$f":"IF(お客様情報!I27=\"\",\"\",お客様情報!I27)","v":""}]
[null,"フリガナ",{"$f":"IF(お客様情報!I28=\"\",\"\",お客様情報!I28)","v":""}]
[null,"住所",{"$f":"IF(お客様情報!I29=\"\",\"\",お客様情報!I29)","v":""}]
[null,"電話番号（ハイフン含む）",{"$f":"IF(お客様情報!I30=\"\",\"\",お客様情報!I30)","v":""}]
[null,"FAX番号（ハイフン含む）",{"$f":"IF(お客様情報!I31=\"\",\"\",お客様情報!I31)","v":""}]
[null,"E-Mailアドレス",{"$f":"IF(お客様情報!I32=\"\",\"\",お客様情報!I32)","v":""}]
["物品送付先","フリガナ",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C5,IF(お客様情報!I35=\"\",\"\",お客様情報!I35))","v":""}]
[null,"会社名",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C6,IF(お客様情報!I36=\"\",\"\",お客様情報!I36))","v":""}]
[null,"フリガナ",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C7,IF(お客様情報!I37=\"\",\"\",お客様情報!I37))","v":""}]
[null,"所属",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C8,IF(お客様情報!I38=\"\",\"\",お客様情報!I38))","v":""}]
[null,"フリガナ",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C9,IF(お客様情報!I39=\"\",\"\",お客様情報!I39))","v":""}]
[null,"氏名（空白不要）",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C10,IF(お客様情報!I40=\"\",\"\",お客様情報!I40))","v":""}]
[null,"郵便番号（ハイフン含む）",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C11,IF(お客様情報!I41=\"\",\"\",お客様情報!I41))","v":""}]
[null,"フリガナ",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C12,IF(お客様情報!I42=\"\",\"\",お客様情報!I42))","v":""}]
[null,"住所",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C13,IF(お客様情報!I43=\"\",\"\",お客様情報!I43))","v":""}]
[null,"電話番号（ハイフン含む）",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C14,IF(お客様情報!I44=\"\",\"\",お客様情報!I44))","v":""}]
[null,"FAX番号（ハイフン含む）",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C15,IF(お客様情報!I45=\"\",\"\",お客様情報!I45))","v":""}]
[null,"E-Mailアドレス",{"$f":"IF(必須入力!G$9=TRUE,隠し_申込情報!C16,IF(お客様情報!I46=\"\",\"\",お客様情報!I46))","v":""}]
["設置場所","フリガナ",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I51=\"\",\"\",お客様情報!I51),IF(必須入力!G$10=2,C5,C17))","v":""}]
[null,"会社名",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I52=\"\",\"\",お客様情報!I52),IF(必須入力!G$10=2,C6,C18))","v":""}]
[null,"フリガナ",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I53=\"\",\"\",お客様情報!I53),IF(必須入力!G$10=2,C7,C19))","v":""}]
[null,"所属",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I54=\"\",\"\",お客様情報!I54),IF(必須入力!G$10=2,C8,C20))","v":""}]
[null,"フリガナ",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I55=\"\",\"\",お客様情報!I55),IF(必須入力!G$10=2,C9,C21))","v":""}]
[null,"氏名（空白不要）",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I56=\"\",\"\",お客様情報!I56),IF(必須入力!G$10=2,C10,C22))","v":""}]
[null,"郵便番号（ハイフン含む）",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I57=\"\",\"\",お客様情報!I57),IF(必須入力!G$10=2,C11,C23))","v":""}]
[null,"フリガナ",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I58=\"\",\"\",お客様情報!I58),IF(必須入力!G$10=2,C12,C24))","v":""}]
[null,"住所",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I59=\"\",\"\",お客様情報!I59),IF(必須入力!G$10=2,C13,C25))","v":""}]
[null,"電話番号（ハイフン含む）",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I60=\"\",\"\",お客様情報!I60),IF(必須入力!G$10=2,C14,C26))","v":""}]
[null,"FAX番号（ハイフン含む）",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I61=\"\",\"\",お客様情報!I61),IF(必須入力!G$10=2,C15,C27))","v":""}]
[null,"E-Mailアドレス",{"$f":"IF(必須入力!G$10=1,IF(お客様情報!I62=\"\",\"\",お客様情報!I62),IF(必須入力!G$10=2,C16,C28))","v":""}]