{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["TVR41 NTSC - Simple","TVR41 PAL - Simple","TVR41 NTSC - Advanced","TVR41 PAL - Advanced"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":3,"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":"TVR41 NTSC - Simple","index":0,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"TruVision DVR 41"]
[null,"Calculator (NTSC)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FPS List",null,"Resolution","quality","参考基值（x）"]
[null,"INPUTS",null,"Storage Requirements:",null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"4CIF","Highest",3072]
["Number of Days of Storage",1,null,"4CIF","2CIF","CIF","QCIF",null,null,null,null,null,null,null,null,null,null,22,null,"4CIF","Higher",2048]
["Numbers of Cameras",1,null,{"$f":"ROUNDUP(((VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"3  GB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"2  GB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"1  GB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"1  GB"},null,null,null,null,null,null,null,null,null,null,20,null,"4CIF","Medium",1792]
["Frames Per Second (per ch)",20,null,{"$f":"ROUNDUP(((VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},null,null,null,null,null,null,null,null,null,null,18,null,"4CIF","Low",1536]
["Quality Setting","Highest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"4CIF","Lower",1280]
["% Motion Detection Rec.",0.1,null,"Bandwidth Usage:",null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,"4CIF","Lowest",1024]
["*Please note the values calculated are +/- 5% accurate.",null,null,"4CIF","2CIF","CIF","QCIF",null,null,null,null,null,null,null,null,null,null,12,null,"2CIF","Highest",1792]
[null,null,null,{"$f":"(VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"2.52  Mbps"},{"$f":"(VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"1.47  Mbps"},{"$f":"(VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"0.84  Mbps"},{"$f":"(VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"0.42  Mbps"},null,null,null,null,null,null,null,null,null,null,10,null,"2CIF","Higher",1280]
[null,null,null,{"$f":"(VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"2580.48  Kbps"},{"$f":"(VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"1505.28  Kbps"},{"$f":"(VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"860.16  Kbps"},{"$f":"(VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"430.08  Kbps"},null,null,null,null,null,null,null,null,null,null,8,null,"2CIF","Medium",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"2CIF","Low",896]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"2CIF","Lower",768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"2CIF","Lowest",512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"CIF","Highest",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,"CIF","Higher",768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,null,"CIF","Medium",512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.125,null,"CIF","Low",448]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.25E-2,null,"CIF","Lower",384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIF","Lowest",256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Highest",512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Higher",384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Medium",256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Low",192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Lower",128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Lowest",96]

{"sheet":"TVR41 PAL - Simple","index":1,"n_rows":30,"n_cols":22,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"TruVision DVR 41"]
[null,"Calculator (PAL)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FPS List",null,"Resolution","quality","参考基值（x）"]
[null,"INPUTS",null,"Storage Requirements:",null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,"4CIF","Highest",3072]
["Number of Days of Storage",1,null,"4CIF","2CIF","CIF","QCIF",null,null,null,null,null,null,null,null,null,null,22,null,"4CIF","Higher",2048]
["Numbers of Cameras",1,null,{"$f":"ROUNDUP(((VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"4  GB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"2  GB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"2  GB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024),0)&\"  GB\"","v":"1  GB"},null,null,null,null,null,null,null,null,null,null,20,null,"4CIF","Medium",1792]
["Frames Per Second (per ch)",20,null,{"$f":"ROUNDUP(((VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},{"$f":"ROUNDUP(((VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9/8*3600*24*B12*B8/1024/1024/1024),2)&\"  TB\"","v":"0.01  TB"},null,null,null,null,null,null,null,null,null,null,18,null,"4CIF","Low",1536]
["Quality Setting","Highest",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"4CIF","Lower",1280]
["% Motion Detection Rec.",0.12,null,"Bandwidth Usage:",null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,"4CIF","Lowest",1024]
["*Please note the values calculated are +/- 5% accurate.",null,null,"4CIF","2CIF","CIF","QCIF",null,null,null,null,null,null,null,null,null,null,12,null,"2CIF","Highest",1792]
[null,null,null,{"$f":"(VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"2.52  Mbps"},{"$f":"(VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"1.47  Mbps"},{"$f":"(VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"0.84  Mbps"},{"$f":"(VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))/1024*B9&\"  Mbps\"","v":"0.42  Mbps"},null,null,null,null,null,null,null,null,null,null,10,null,"2CIF","Higher",1280]
[null,null,null,{"$f":"(VLOOKUP($B$11,U7:V12,2,FALSE)/5+(VLOOKUP($B$11,U7:V12,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"2580.48  Kbps"},{"$f":"(VLOOKUP($B$11,U13:V18,2,FALSE)/5+(VLOOKUP($B$11,U13:V18,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"1505.28  Kbps"},{"$f":"(VLOOKUP($B$11,U19:V24,2,FALSE)/5+(VLOOKUP($B$11,U19:V24,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"860.16  Kbps"},{"$f":"(VLOOKUP($B$11,U25:V30,2,FALSE)/5+(VLOOKUP($B$11,U25:V30,2,FALSE)*4*ROUNDUP(B10,0))/(25*5))*B9&\"  Kbps\"","v":"430.08  Kbps"},null,null,null,null,null,null,null,null,null,null,8,null,"2CIF","Medium",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"2CIF","Low",896]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"2CIF","Lower",768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,"2CIF","Lowest",512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"CIF","Highest",1024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,"CIF","Higher",768]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,null,"CIF","Medium",512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.125,null,"CIF","Low",448]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.25E-2,null,"CIF","Lower",384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIF","Lowest",256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Highest",512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Higher",384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Medium",256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Low",192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Lower",128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QCIF","Lowest",96]

{"sheet":"TVR41 NTSC - Advanced","index":2,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"TVR 41 Advanced (Expert Mode)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FPS List",null,null,"4CIF","2CIF","CIF","QCIF"]
[null,"Calculator (NTSC)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"Highest",3072,1792,1024,512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,"Higher",2048,1280,768,384]
[null,"INPUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,"Medium",1792,1024,512,256]
["Number of Days of Storage",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,"Low",1536,896,448,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"Lower",1280,768,384,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,"Lowest",1024,512,256,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
["Cameras",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,null,null,null,null,null,10]
["Resolution","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF","CIF",null,null,null,null,8]
["Frame Per Second",15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,null,null,null,null,6]
["Quality ","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest","Highest",null,null,null,null,4]
["% Motion Recording",0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,null,null,null,null,2]
["Bandwidth Consumption (Mbps)",{"$f":"(INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))*4*ROUNDUP(B11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))*4*ROUNDUP(C11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(D11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(E11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))*4*ROUNDUP(F11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))*4*ROUNDUP(G11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))*4*ROUNDUP(H11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))*4*ROUNDUP(I11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))*4*ROUNDUP(J11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))*4*ROUNDUP(K11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))*4*ROUNDUP(L11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))*4*ROUNDUP(M11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))*4*ROUNDUP(N11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))*4*ROUNDUP(O11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))*4*ROUNDUP(P11,0))/(25*5))/1024","v":0.67999999999999994},{"$f":"(INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))*4*ROUNDUP(Q11,0))/(25*5))/1024","v":0.67999999999999994},null,null,null,null,null,1]
["Storage per day per ch (GB)",{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))*4*ROUNDUP(B11,0))/(25*5))/8*3600*24*B13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))*4*ROUNDUP(C11,0))/(25*5))/8*3600*24*C13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(E11,0))/(25*5))/8*3600*24*E13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(E11,0))/(25*5))/8*3600*24*E13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))*4*ROUNDUP(F11,0))/(25*5))/8*3600*24*F13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))*4*ROUNDUP(G11,0))/(25*5))/8*3600*24*G13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))*4*ROUNDUP(H11,0))/(25*5))/8*3600*24*H13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))*4*ROUNDUP(I11,0))/(25*5))/8*3600*24*I13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))*4*ROUNDUP(J11,0))/(25*5))/8*3600*24*J13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))*4*ROUNDUP(K11,0))/(25*5))/8*3600*24*K13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))*4*ROUNDUP(L11,0))/(25*5))/8*3600*24*L13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))*4*ROUNDUP(M11,0))/(25*5))/8*3600*24*M13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))*4*ROUNDUP(N11,0))/(25*5))/8*3600*24*N13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))*4*ROUNDUP(O11,0))/(25*5))/8*3600*24*O13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))*4*ROUNDUP(P11,0))/(25*5))/8*3600*24*P13/1024/1024),2)","v":3.88},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))*4*ROUNDUP(Q11,0))/(25*5))/8*3600*24*Q13/1024/1024),2)","v":3.88},null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.25E-2]
[]
["Total Storage Required",{"$f":"SUM(B15:Q15)*B5","v":186.24000000000004}]
[null,{"$f":"SUM(B15:Q15)*B5/1024","v":0.18187500000000004}]
[]
["Total Bandwidth Required",{"$f":"SUM(B14:Q14)","v":10.879999999999997},"Mbps"]
[null,{"$f":"SUM(B14:Q14)*1024","v":11141.119999999997},"kbps"]

{"sheet":"TVR41 PAL - Advanced","index":3,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"TVR 41 Advanced (Expert Mode)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FPS List",null,null,"4CIF","2CIF","CIF","QCIF"]
[null,"Calculator (PAL)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,"Highest",3072,1792,1024,512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,"Higher",2048,1280,768,384]
[null,"INPUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,"Medium",1792,1024,512,256]
["Number of Days of Storage",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,"Low",1536,896,448,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"Lower",1280,768,384,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,"Lowest",1024,512,256,96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
["Cameras",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,null,null,null,null,null,10]
["Resolution","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF","4CIF",null,null,null,null,8]
["Frame Per Second",22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,22,null,null,null,null,6]
["Quality ","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher","Higher",null,null,null,null,4]
["% Motion Recording",0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,0.54,null,null,null,null,2]
["Bandwidth Consumption (Mbps)",{"$f":"(INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))*4*ROUNDUP(B11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))*4*ROUNDUP(C11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(E11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(E11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))*4*ROUNDUP(F11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))*4*ROUNDUP(G11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))*4*ROUNDUP(H11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))*4*ROUNDUP(I11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))*4*ROUNDUP(J11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))*4*ROUNDUP(K11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))*4*ROUNDUP(L11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))*4*ROUNDUP(M11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))*4*ROUNDUP(N11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))*4*ROUNDUP(O11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))*4*ROUNDUP(P11,0))/(25*5))/1024","v":1.8079999999999998},{"$f":"(INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))*4*ROUNDUP(Q11,0))/(25*5))/1024","v":1.8079999999999998},null,null,null,null,null,1]
["Storage per day per ch (GB)",{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(B12,Y2:Y7,0),MATCH(B10,Z1:AC1,0))*4*ROUNDUP(B11,0))/(25*5))/8*3600*24*B13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(C12,Y2:Y7,0),MATCH(C10,Z1:AC1,0))*4*ROUNDUP(C11,0))/(25*5))/8*3600*24*C13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(D12,Y2:Y7,0),MATCH(D10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(D12,Y2:Y7,0),MATCH(D10,Z1:AC1,0))*4*ROUNDUP(D11,0))/(25*5))/8*3600*24*D13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(E12,Y2:Y7,0),MATCH(E10,Z1:AC1,0))*4*ROUNDUP(E11,0))/(25*5))/8*3600*24*E13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(F12,Y2:Y7,0),MATCH(F10,Z1:AC1,0))*4*ROUNDUP(F11,0))/(25*5))/8*3600*24*F13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(G12,Y2:Y7,0),MATCH(G10,Z1:AC1,0))*4*ROUNDUP(G11,0))/(25*5))/8*3600*24*G13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(H12,Y2:Y7,0),MATCH(H10,Z1:AC1,0))*4*ROUNDUP(H11,0))/(25*5))/8*3600*24*H13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(I12,Y2:Y7,0),MATCH(I10,Z1:AC1,0))*4*ROUNDUP(I11,0))/(25*5))/8*3600*24*I13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(J12,Y2:Y7,0),MATCH(J10,Z1:AC1,0))*4*ROUNDUP(J11,0))/(25*5))/8*3600*24*J13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(K12,Y2:Y7,0),MATCH(K10,Z1:AC1,0))*4*ROUNDUP(K11,0))/(25*5))/8*3600*24*K13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(L12,Y2:Y7,0),MATCH(L10,Z1:AC1,0))*4*ROUNDUP(L11,0))/(25*5))/8*3600*24*L13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(M12,Y2:Y7,0),MATCH(M10,Z1:AC1,0))*4*ROUNDUP(M11,0))/(25*5))/8*3600*24*M13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(N12,Y2:Y7,0),MATCH(N10,Z1:AC1,0))*4*ROUNDUP(N11,0))/(25*5))/8*3600*24*N13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(O12,Y2:Y7,0),MATCH(O10,Z1:AC1,0))*4*ROUNDUP(O11,0))/(25*5))/8*3600*24*O13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(P12,Y2:Y7,0),MATCH(P10,Z1:AC1,0))*4*ROUNDUP(P11,0))/(25*5))/8*3600*24*P13/1024/1024),2)","v":10.299999999999999},{"$f":"ROUNDUP(((INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))/5+(INDEX(Z2:AC7,MATCH(Q12,Y2:Y7,0),MATCH(Q10,Z1:AC1,0))*4*ROUNDUP(Q11,0))/(25*5))/8*3600*24*Q13/1024/1024),2)","v":10.299999999999999},null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.25E-2]
[]
["Total Storage Required",{"$f":"SUM(B15:Q15)*B5","v":494.40000000000003}]
[null,{"$f":"SUM(B15:Q15)*B5/1024","v":0.48281250000000003}]
[]
["Total Bandwidth Required",{"$f":"SUM(B14:Q14)","v":28.927999999999997},"Mbps"]
[null,{"$f":"SUM(B14:Q14)*1024","v":29622.271999999997},"kbps"]