Spreadsheet: 160551d1339104245-cross-referancing-rec-server-capacity-calculator-v3
Sheet: Rec Server Capacity

 |  | CCTV Recording Server Capacity Calculator |  |  |  |  |  |  |  |  |  |  |  | Frame Size KBytes @ 25 FPS |  |  |  |  | Qty |  | Frames Per Second |  | Stream |  |  |  | Frame Size KBytes @ 30 FPS
 |  | Project Number: |  |  |  |  |  |  |  |  |  |  | Resolution | H.264 | MPEG-4 | RAW | MJPG |  |  |  |  |  | H.264 |  |  |  | H.264 | MPEG-4 | RAW | MJPG
 |  | Project Title: |  |  |  |  |  |  |  |  |  |  | QVGA (320 X 240) | 1 | 2 | 225 | 12 |  | 1 |  | 25 |  | MPEG-4 |  |  |  | 1 | 2 | 225 | 12
 |  | Site Identification |  |  |  |  |  |  |  |  |  |  | SIF "NTSC" (352 x 240) | 1 | 3 | 247 | 13 |  | 2 |  | 30 |  | RAW |  |  |  | 1 | 3 | 247 | 13
 |  | Department: |  |  |  |  |  |  |  |  |  |  | SIF "PAL" (352 x 288) | 1 | 3 | 297 | 15 |  | 3 |  |  |  | MJPG |  |  |  | 1 | 3 | 297 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | CIF (352 x 288) | 1 | 3 | 297 | 15 |  | 4 |  | Days |  |  |  |  |  | 1 | 3 | 297 | 15
 |  |  |  |  |  |  | Recording Period Required |  |  |  |  |  | VGA (640 x 480) | 4 | 10 | 900 | 46 |  | 5 |  |  |  |  |  |  |  | 3 | 9 | 900 | 46
Camera |  |  | Compression Method | Recording Resolution | Frames Per Second | Frame Size (KBytes) |  |  | Bandwidth (Mbits) | Storage (GB) |  |  | DCIF / 2CIF - "NTSC" (704 x 240) | 2 | 5 | 495 | 26 |  | 6 |  |  |  |  |  |  |  | 2 | 5 | 495 | 26
Make | Model | Qty |  |  |  |  | Qty | Period |  |  |  |  | DCIF / 2CIF "PAL" (704 x 288) | 3 | 7 | 594 | 31 |  | 7 |  |  |  |  |  |  |  | 2 | 6 | 594 | 31
 |  | 1 | MPEG-4 | QVGA (320 X 240) | 30 |  |  |  |  |  |  |  | 4CIF "NTSC" (704 x 480) | 4 | 11 | 990 | 51 |  | 8 |  |  |  |  |  |  |  | 4 | 10 | 990 | 51
 |  |  |  |  |  |  |  |  |  |  |  |  | 4CIF "PAL" (704 x 576) | 5 | 13 | 1188 | 61 |  | 9 |  |  |  |  |  |  |  | 4 | 12 | 1188 | 61
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (800 x 600) | 6 | 16 | 1406 | 73 |  | 10 |  |  |  |  |  |  |  | 5 | 15 | 1406 | 73
 |  |  |  |  |  |  |  |  |  |  |  |  | HD (1280 x 720) | 11 | 30 | 2699 | 139 |  | 11 |  |  |  |  |  |  |  | 10 | 28 | 2699 | 139
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.22 MP (1280 x 960) | 14 | 40 | 3599 | 186 |  | 12 |  |  |  |  |  |  |  | 13 | 37 | 3599 | 186
 |  |  |  |  |  |  |  |  |  |  |  |  | 1.3 MP (1280 x 1024) | 15 | 42 | 3839 | 198 |  | 13 |  |  |  |  |  |  |  | 14 | 40 | 3839 | 198
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 MP (1600 x x1200) | 22 | 62 | 5624 | 290 |  | 14 |  |  |  |  |  |  |  | 21 | 58 | 5624 | 290
 |  |  |  |  |  |  |  |  |  |  |  |  | FULL HD (1920 x 1080) | 24 | 67 | 6074 | 314 |  | 15 |  | Bandwidth (Mbits) = FrameSize (Kb) * 1024 * 8 * FPS * Cameras / 1000000 |  |  |  |  |  | 23 | 63 | 6074 | 314
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 MP (2048 x 1536) | 37 | 102 | 9214 | 476 |  | 16 |  | Storage Space (GB) = FrameSize (Kb) * 1024 *FPS * Cameras * Days * 24 * 60 * 60* Activity * / 1000 000 000 |  |  |  |  |  | 35 | 96 | 9214 | 476
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 MP (2288 x 1712) | 46 | 127 | 11473 | 592 |  | 17 |  |  |  |  |  |  |  | 43 | 119 | 11473 | 592
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 MP (2560 x 1920) | 59 | 164 | 14850 | 767 |  | 18 |  | Bandwidth (Mbits) | "=SUM(F10*1024*8*G10*C10/1000000)" |  |  |  |  | 55 | 154 | 14850 | 767
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | Storage Space (GB) | "=SUM(F10*1024*G10*C10*H10*24*60*60*100/[PHONE])"
 |  |  |  |  |  |  |  |  |  |  |  |  | Legend |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Use Dropdown List |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter Information |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Auto Populates |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Use Table for Cross Reference |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  | Total Bandwidth |  |  |  |  | Mbits |  |  |  |  |  |  |  |  | 30
 |  |  |  |  | Total Storage Capacity |  |  |  |  | GB (Gigabytes) |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100