{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["ディスク容量計算","リスト"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":false,"merged":[[23,3,23,4],[9,8,14,8]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"作成","2023年8月  MESW"]
[]
[null,"本ファイルは、映像データの保存に必要なディスク容量（目安）を計算するためのファイルです。"]
[null,"入力セルに映像保存の条件を入力することで、必要なディスク容量、およびネカ録の推奨機種を表示します。"]
[]
[null,null,"【映像保存の条件】",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↓マクロ書込","↓検算用"]
[null,null,null,"解像度","画像圧縮方式","フレームレート\n（コマ/秒）","ビットレート\n（Kbps）","カメラ台数","保存日数\n（日）","録画容量\n（TB）","使用する\nﾈｯﾄﾜｰｸ帯域\n（Mbps）",null,null,null,null,null,"画像容量\n（KB）","１週間分の録画容量\n（MB）","１台分の録画容量\n（MB）","録画容量\n（MB）","録画容量\n（GB）"]
[null,null,null,"HD","H.264",30,1536,10,30,{"$f":"U10/1024","v":4.634857177734375},{"$f":"IF(H10>0,IF(E10=\"H.264\",G10*H10*1.1/1024,Q10*F10*H10*8*1.1/1024),0)","v":16.5},null,"入力セル",null,null,null,60,{"$f":"IF(E10=\"H.264\",G10/8*3600*24*7/1024,Q10*F10*3600*(24*7)/1024)","v":113400},{"$f":"R10/7*$I$10","v":486000},{"$f":"S10*H10","v":4860000},{"$f":"S10*H10/1024","v":4746.09375}]
[null,null,null,"VGA","H.264",10,1024,0,null,{"$f":"U11/1024","v":0},0,null,null,null,null,null,28,75600,{"$f":"R11/7*$I$10","v":324000},0,{"$f":"S11*H11/1024","v":0}]
[null,null,null,"VGA","JPEG",5,null,0,null,0,0,null,null,null,null,null,40,118125,506250,0,0]
[null,null,null,"VGA","JPEG",5,null,0,null,0,0,null,null,null,null,null,40,118125,506250,0,0]
[null,null,null,"VGA","JPEG",5,null,0,null,0,0,null,null,null,null,null,40,118125,506250,0,0]
[null,null,null,"VGA","JPEG",5,null,0,null,0,0,null,null,null,null,null,40,118125,506250,0,0]
[null,null,null,"※解像度でフルHDを指定する場合、画像圧縮方式はH.264を選択してください。",null,null,null,null,"合計",{"$f":"SUM(J10:J15)","v":4.634857177734375},{"$f":"SUM(K10:K15)","v":16.5},null,null,null,null,null,null,null,null,{"$f":"SUM(T10:T15)","v":4860000},{"$f":"SUM(U10:U15)","v":4746.09375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※画像容量（KB/コマ）"]
[null,null,"【ネカ録に必要なディスク容量】",null,null,null,null,null,null,null,null,null,null,null,null,null,"　・JPEGの場合　　・・・　　　VGA ：40、SXVGA ：120、HD：85、フルHD：190"]
[null,null,null,"項目",null,"値",null,null,null,null,null,null,null,null,null,null,"　・H.264の場合　　・・・　　　VGA ：28、SXVGA ：  84、HD：60、フルHD：133"]
[null,null,null,"必要なディスク容量 （TB）",null,{"$f":"SUM(J10:J15)","v":4.634857177734375}]
[]
[null,null,"【使用するネットワーク帯域】"]
[null,null,null,"項目",null,"値"]
[null,null,null,"カメラとネカ録間の帯域（Mbps）",null,{"$f":"SUM(K10:K15)","v":16.5}]
[null,null,null,"※通信速度1000Mbpsで接続しているネットワークで、使用する帯域が150Mbpsを超過した場合、"]
[null,null,null,"　 映像保存時にコマ落ちが発生する可能性があります。"]
[]
[null,null,"【ネカ録推奨機種】"]
[null,null,null,null,"デスクトップ",null,"（録画可能日数）","ラックマウント",null,"（録画可能日数）"]
[null,null,null,"RAIDなし",{"$f":"LOOKUP($T$16/1024,リスト!B32:C35)","v":"該当機種なし"},null,{"$f":"IF($T$16 <> 0,VLOOKUP($T$16/1024,リスト!$B$32:$D$35,3)/$T$16*$I$10*1024,\"\")","v":0},"-",null,"-"]
[null,null,null,"RAID1",{"$f":"LOOKUP($T$16/1024,リスト!B42:C46)","v":"NS-1860 (12TB) RAID1"},null,{"$f":"IF($T$16 <> 0,VLOOKUP($T$16/1024,リスト!$B$42:$D$46,3)/$T$16*$I$10*1024,\"\")","v":33.754074074074076},"-",null,"-"]
[null,null,null,"RAID5",{"$f":"LOOKUP($T$16/1024,リスト!B48:C50)","v":"NS-3850 (8TB) RAID5"},null,{"$f":"IF($T$16 <> 0,VLOOKUP($T$16/1024,リスト!$B$48:$D$50,3)/$T$16*$I$10*1024,\"\")","v":33.754074074074076},"-",null,"-"]
[null,null,null,"RAID6",{"$f":"LOOKUP($T$16/1024,リスト!B52:C56)","v":"NS-3850 (16TB) RAID6"},null,{"$f":"IF($T$16 <> 0,VLOOKUP($T$16/1024,リスト!$B$52:$D$56,3)/$T$16*$I$10*1024,\"\")","v":67.508148148148152},{"$f":"LOOKUP($T$16/1024,リスト!B58:C62)","v":"NS-5850 (24TB) RAID6"},null,{"$f":"IF($T$16 <> 0,VLOOKUP($T$16/1024,リスト!$B$58:$D$62,3)/$T$16*$I$10*1024,\"\")","v":112.51358024691358}]
[]
[null,null,"【参考：カメラ情報】"]
[null,null,"　●主要カメラの最大フレームレート"]
[null,null,null,null,"カメラ型名","解像度","画像圧縮方式","最大フレームレート","備考"]
[null,null,null,null,"NC-6100","SXVGA","H.264",15,"ストリーム1の場合"]
[null,null,null,null,null,"SXVGA","JPEG",30,"ストリーム1の場合"]
[null,null,null,null,null,"VGA","H.264",30,"ストリーム1の場合"]
[null,null,null,null,null,"VGA","JPEG",30,"ストリーム1の場合"]
[null,null,null,null,"NC-6700","SXVGA","H.264",15,"ストリーム1の場合"]
[null,null,null,null,null,"SXVGA","JPEG",30,"ストリーム1の場合"]
[null,null,null,null,null,"VGA","H.264",30,"ストリーム1の場合"]
[null,null,null,null,null,"VGA","JPEG",30,"ストリーム1の場合"]
[null,null,null,null,"BB-165A","SXVGA","H.264",30]
[null,null,null,null,"<BBシリーズ>","SXVGA","JPEG",30]
[null,null,null,null,null,"VGA","H.264",30]
[null,null,null,null,null,"VGA","JPEG",30]
[null,null,null,null,"BB-SC384A","SXVGA","H.264",30,"天井吊り下げ専用"]
[null,null,null,null,"<BBシリーズ>","SXVGA","JPEG",30]
[null,null,null,null,null,"VGA","H.264",30]
[null,null,null,null,null,"VGA","JPEG",30]
[null,null,null,null,"WV-SC385","SXVGA","H.264",30]
[null,null,null,null,"<i-Proシリーズ>","SXVGA","JPEG",30]
[null,null,null,null,null,"VGA","H.264",30]
[null,null,null,null,null,"VGA","JPEG",30]

{"sheet":"リスト","index":1,"n_rows":101,"n_cols":16,"rows_kept":101,"cut":false,"hidden":true,"merged":[[50,0,50,3],[20,0,20,3],[8,0,8,3],[14,0,14,3],[40,0,40,3],[46,0,46,3],[35,0,35,3]]}
["画像圧縮方式","画像サイズ","動き検知",null,null,"画像圧縮方式","画像サイズ","画像容量\n(Iﾌﾚｰﾑ)","ﾋﾞｯﾄﾚｰﾄ",null,"フレームレート",null,"解像度","JPEG\n帯域（kbps）","H.264\n帯域（kbps）"]
["JPEG","QVGA","有り",null,null,"JPEG","QVGA",13,null,null,1,null,"VGA",352,563,"※VGA(40KB/ｺﾏ), 1fps, 1台"]
["H.264","VGA","なし",null,null,"JPEG","VGA",40,null,null,2,null,"SXVGA",1056,1690,"※SXVGA(120KB/ｺﾏ), 1fps, 1台"]
[null,"SXVGA",null,null,null,"JPEG","SXVGA",120,null,null,3,null,"HD",748,1126,"※HD(85KB/ｺﾏ), 1fps, 1台"]
[null,"HD",null,null,null,"JPEG","HD",85,null,null,4,null,"フルHD",1672,2253,"※FHD(190KB/ｺﾏ), 1fps, 1台"]
[null,"フルHD",null,null,null,"JPEG","フルHD",190,null,null,5]
[null,null,null,null,null,"H.264（動き多）","QVGA",10,256,null,6,null,"リアルタイムトレンド枚数(枚)"]
["HDD実効容量","LOOKUP用録画容量","機種","録画容量",null,"H.264（動き多）","VGA",28,512,null,7,null,0,"※帯域計算用"]
["デスクトップ JPEG/H.264 RAID1",null,null,null,null,"H.264（動き多）","SXVGA",84,1536,null,8]
[0,0,"NS-1800 (2TB) RAID1",{"$f":"B11","v":900},null,"H.264（動き多）","HD",60,1024,null,9,null,"基準フレームレート(fps)"]
[1000,900,"NS-1800 (4TB) RAID1",{"$f":"B12","v":1800},null,"H.264（動き多）","フルHD",133,2048,null,10]
[2000,1800,"NS-1800 (6TB) RAID1",{"$f":"B13","v":2700},null,null,null,null,null,null,11,null,5,"※帯域計算用"]
[3000,2700,"NS-1800 (8TB) RAID1",3600,null,null,null,null,"ﾋﾞｯﾄﾚｰﾄ",null,12]
[4000,3600,"該当機種なし",0,null,null,null,null,256,null,13,null,"画像容量比（JPEG基準）"]
["デスクトップ JPEG/H.264 RAID5",null,null,null,null,null,null,null,384,null,14,null,"JPEG",1]
[0,0,"NS-3800 (8TB) RAID5",5400,null,null,null,"VGA(1fps)→",512,null,15,null,"H.264",{"$f":"H8/H3","v":0.7}]
[6000,5400,"NS-3800 (16TB) RAID5",12600,null,null,null,"VGA(5fps以下)、SXVGA(1ｆｐｓ)、ＨＤ(1fps)→",768,null,16]
[14000,12600,"NS-3800 (24TB) RAID5",18900,null,null,null,"VGA(30fps以下)、SXVGA(5fps以下)、HD(5fps以下)→",1024,null,17]
[21000,18900,"NS-3800 (32TB) RAID5",25200,null,null,null,"SXVGA(10fps以下)、HD(30fps以下)、フルHD(1fps)→",1536,null,18]
[28000,25200,"該当機種なし",0,null,null,null,"SXVGA(15fps以下)、フルHD(5fps以下)→",2048,null,19]
["デスクトップ JPEG/H.264 RAID6",null,null,null,null,null,null,"SXVGA(30fps以下)、フルHD(10fps以下)→",3072,null,20]
[0,0,"NS-3800 (16TB) RAID6",10800,null,null,null,null,4096,null,21]
[12000,10800,"NS-3800 (24TB) RAID6",16200,null,null,null,"フルHD(15fps以下)→",5120,null,22]
[18000,16200,"NS-3800 (32TB) RAID6",21600,null,null,null,"フルHD(30fps以下)→",6144,null,23]
[24000,21600,"該当機種なし",0,null,null,null,null,null,null,24]
["ラックマウント JPEG/H.264 RAID6",null,null,null,null,null,null,null,null,null,25]
[0,0,"NS-5800 (24TB) RAID6",18000,null,null,null,null,null,null,26]
[20000,18000,"NS-5800 (36TB) RAID6",27000,null,null,null,null,null,null,27]
[30000,27000,"NS-5800 (48TB) RAID6",36000,null,null,null,null,null,null,28]
[40000,36000,"該当機種なし",0,null,null,null,null,null,null,29]
["デスクトッフ゜ JPEG/H.264 RAIDなし",null,null,null,null,null,null,null,null,null,30]
[0,0,"NS-850 (240GB) RAIDなし",198]
[240,198,"NS-850 (480GB) RAIDなし",426]
[480,426,"NS-850 (960GB) RAIDなし",882]
[960,882,"該当機種なし",0]
["デスクトップ JPEG/H.264 RAID1"]
[0,0,"NS-1850 (4TB) RAID1",{"$f":"B38","v":1780}]
[2000,1780,"NS-1850 (8TB) RAID1",{"$f":"B39","v":3560}]
[4000,3560,"NS-1850 (12TB) RAID1",{"$f":"B40","v":5340}]
[6000,5340,"該当機種なし",0]
["デスクトップ JPEG/H.264 RAID1"]
[0,0,"NS-1860 (4TB) RAID1",{"$f":"B43","v":1780}]
[2000,1780,"NS-1860 (8TB) RAID1",{"$f":"B44","v":3560}]
[4000,3560,"NS-1860 (12TB) RAID1",{"$f":"B45","v":5340}]
[6000,5340,"NS-1860 (16TB) RAID1",{"$f":"B46","v":7120}]
[8000,7120,"該当機種なし",0]
["デスクトップ JPEG/H.264 RAID5"]
[0,0,"NS-3850 (8TB) RAID5",{"$f":"B49","v":5340}]
[6000,5340,"NS-3850 (24TB) RAID5",{"$f":"B50","v":16020}]
[18000,16020,"該当機種なし",0]
["デスクトップ JPEG/H.264 RAID6"]
[0,0,"NS-3850 (16TB) RAID6",{"$f":"B53","v":10680}]
[12000,10680,"NS-3850 (32TB) RAID6",{"$f":"B54","v":21360}]
[24000,21360,"NS-3850 (48TB) RAID6",{"$f":"B55","v":32040}]
[36000,32040,"NS-3850 (64TB) RAID6",{"$f":"B56","v":42720}]
[48000,42720,"該当機種なし",0]
["ラックマウント JPEG/H.264 RAID6"]
[0,0,"NS-5850 (24TB) RAID6",{"$f":"B59","v":17800}]
[20000,17800,"NS-5850 (48TB) RAID6",{"$f":"B60","v":35600}]
[40000,35600,"NS-5850 (72TB) RAID6",{"$f":"B61","v":53400}]
[60000,53400,"NS-5850 (96TB) RAID6",{"$f":"B62","v":71200}]
[80000,71200,"該当機種なし",0]
[]
[]
["■録画容量[MB]",null,null,null,null,null,null,null,"■解像度／フレームレート／ビットレート、および品質の関係（品質は50を基準とする）"]
["H.264"]
["Iフレーム録画なし、音声あり",null,"(ビットレート[Kbps]/8+20)*3600*24*保存日数[日]/1000"]
["Iフレーム録画なし、音声なし",null,"ビットレート[Kbps]/8*3600*24*保存日数[日]/1000"]
["Iフレーム録画あり、音声あり",null,"(画像容量[KB]*フレームレート[コマ/秒]+20)*3600*24*保存日数[日]/1000"]
["Iフレーム録画あり、音声なし",null,"画像容量[KB]*フレームレート[コマ/秒]*3600*24*保存日数[日]/1000"]
["JPEG"]
["音声あり",null,"(画像容量[KB]*フレームレート[コマ/秒]+20)*3600*24*保存日数[日]/1000"]
["音声なし",null,"画像容量[KB]*フレームレート[コマ/秒]*3600*24*保存日数[日]/1000"]
[]
["2015-01-07"]
["※音声、Iフレーム録画、動き検知は「なし」で固定とする。"]
[]
["■ネットワーク帯域[Mbps]"]
["H.264"]
["音声あり","(ビットレート[Kbps]+160)*カメラ台数*1.1/1024"]
["音声なし","ビットレート[Kbps]*カメラ台数*1.1/1024"]
["JPEG"]
["音声あり","(画像容量[KB]*フレームレート[コマ/秒]+20)*カメラ台数*8*1.1/1024"]
["音声なし","画像容量[KB]*フレームレート[コマ/秒]*カメラ台数*8*1.1/1024"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"2023-08-03"]
[null,null,null,null,null,null,null,null,"　　ビットレートはネカ録5_システム設計ガイドを参考に計算する"]