Spreadsheet: 160363d1339066794-cross-referancing-after
Sheet: Sheet1

 |  | CCTV Recording Server Capacity Calculator |  |  |  |  |  |  |  |  |  |  | Resolution |  | Frame Size KB |  |  |  |  | Qty |  | Frames Per Second |  | Stream
 |  |  |  |  |  |  |  |  | Legend |  |  |  | Name | Verticle X Horizontal | H.264 | MPEG-4 | RAW | MJPEG |  |  |  |  |  | H.264
 |  | Project Number: |  |  |  |  |  |  |  | Manually Entered |  |  | QVGA | 320 X 240 | 2 | 5 | 225 | 12 |  | 1 |  | 5 |  | MPEG-4
 |  | Project Title: |  |  |  |  |  |  |  |  |  |  | SIF (NTSC) | 352 X 240 | 2 | 5 | 247 | 13 |  | 2 |  | 10 |  | RAW
 |  | Department: |  |  |  |  |  |  |  |  |  |  | SIF (PAL) | 352 X 288 | 2 | 6 | 297 | 15 |  | 3 |  | 15 |  | MJPEG
 |  |  |  |  |  |  |  |  |  |  |  |  | CIF | 352 X 288 | 2 | 6 | 297 | 15 |  | 4 |  | 20
 |  |  |  |  |  |  | Recording Period Required |  |  |  |  |  | VGA | 640 X 480 | 7 | 19 | 900 | 46 |  | 5 |  | 25
Camera |  |  | Compression Method | Recording Resolution | [NAME] ([NAME]) | Frames Per Second |  |  | Bandwidth (Mbits) | Storage (GB) |  |  | DCIF / 2CIF - NTSC | 704 X 240 | 4 | 10 | 495 | 26 |  | 6 |  | 30
Make | Model | Qty |  |  |  |  | Qty | Period |  |  |  |  | DCIF / 2CIF PAL | 704 X 288 | 4 | 12 | 594 | 31 |  | 7 |  | 35
 |  |  | H.264 | QVGA (320 X 240) | 2 |  |  | Days |  |  |  |  | 4CIF NTSC | 704 X 480 | 8 | 21 | 990 | 51 |  | 8 |  | 40
 |  |  | H.264 | 5 MP | 112 |  |  | Days |  |  |  |  | 4CIF PAL | 704 X 576 | 9 | 25 | 1188 | 61 |  | 9 |  | 45
 |  |  | MPEG-4 | SIF (NTSC) | 5 |  |  | Days |  |  |  |  | [NAME] | 800 X 600 | 11 | 30 | 1406 | 73 |  | 10 |  | 50
 |  |  | MPEG-4 | 4 MP | 241 |  |  | Days |  |  |  |  | HD | 1280 X 720 | 21 | 57 | 2699 | 139 |  | 11 |  | 55
 |  |  | RAW | SIF (PAL) | 297 |  |  | Days |  |  |  |  | 1.22 MP | 1280 X 960 | 27 | 76 | 3599 | 186 |  | 12 |  | 60
 |  |  | RAW | 3 MP | 9214 |  |  | Days |  |  |  |  | 1.3 MP | 1280 X 1024 | 29 | 81 | 3839 | 198 |  | 13
 |  |  | MJPEG | VGA | 46 |  |  | Days |  |  |  |  | 2 MP | 1600 X 1200 | 42 | 118 | 5624 | 290 |  | 14
 |  |  | MJPEG | FULL HD | 314 |  |  | Days |  |  |  |  | FULL HD | 1920 X 1080 | 46 | 128 | 6074 | 314 |  | 15 |  | Bandwidth (Mbits) = FrameSize (Kb) * 1024 * 8 * FPS * Cameras / 1000000
 |  |  |  |  |  |  |  | Days |  |  |  |  | 3 MP | 2048 X 1536 | 70 | 194 | 9214 | 476 |  | 16 |  | Storage Space (GB) = FrameSize (Kb) * 1024 *FPS * Cameras * Days * 24 * 60 * 60* Activity * / 1000 000 000
 |  |  |  |  |  |  |  | Days |  |  |  |  | 4 MP | 2288 X 1712 | 87 | 241 | 11473 | 592 |  | 17
 |  |  |  |  |  |  |  | Days |  |  |  |  | 5 MP | 2560 X 1920 | 112 | 312 | 14850 | 767 |  | 18 |  | Bandwidth (Mbits) | "=SUM(F10*1024*8*G10*C10/1000000)"
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 19 |  | Storage Space (GB) | "=SUM(F10*1024*G10*C10*H10*24*60*60*100/[PHONE])"
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 22 |  | QVGA (320 X 240)
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 23 |  | SIF "NTSC" (352 x 240)
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 24 |  | SIF (PAL) | 352 X 288
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 25 |  | CIF | 352 X 288
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 26 |  | VGA | 640 X 480
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 27 |  | DCIF / 2CIF - NTSC | 704 X 240
 |  |  |  |  |  |  |  | Days |  |  |  |  |  |  |  |  |  |  |  | 28 |  | DCIF / 2CIF PAL | 704 X 288
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 4CIF NTSC | 704 X 480
 |  |  |  |  | Total Bandwidth |  |  |  |  | Mbits |  |  |  |  |  |  |  |  |  | 30 |  | 4CIF PAL | 704 X 576
 |  |  |  |  | Total Storage Capacity |  |  |  |  | GB |  |  |  |  |  |  |  |  |  | 31 |  | [NAME] | 800 X 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | HD | 1280 X 720
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  | 1.22 MP | 1280 X 960
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 1.3 MP | 1280 X 1024
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 2 MP | 1600 X 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  | FULL HD | 1920 X 1080
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  | 3 MP | 2048 X 1536
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  | 4 MP | 2288 X 1712
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  | 5 MP | 2560 X 1920
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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