{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculations","UserInterface","Start"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Calculations","index":0,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,1,1,2],[10,5,15,5],[2,10,2,11],[2,12,2,14],[1,10,1,14],[10,4,16,4],[9,0,18,0],[41,11,41,14],[40,11,40,13],[29,12,31,12],[32,12,36,12],[10,6,10,7],[20,6,20,7],[28,13,28,15],[25,6,25,7],[40,1,40,5],[40,7,40,8],[39,11,39,14]]}
[]
[null,"Bandwidth ",null,null,null,null,null,null,null,null,"Sensor Specs and calculation"]
[null,"Protocol","Bandwidth (Gbps)",null,"Bitness","Bitness","Sensor","Max Height (V)","Max Width (H)",null,"2020BSI",null,"2020e"]
[null,"CXP3",2.4,null,8,11,"Iron 2020BSI",2048,2048,null,"Tclkseq (LVDS_clk/12)= ",50,"Tclkseq (LVDS_clk) = ",45]
[null,"CXP6",4.9000000000000004,null,10,12,"Iron 2020e",2048,2048,null,"Tline 12bit = ",{"$f":"560*(1/(L4*1000000))","v":1.1199999999999999E-5},"Tline RHDR = ",{"$f":"534*(1/(N4*1000000))","v":1.1866666666666668E-5}]
[null,"CXP12",9.8000000000000007,null,12,null,"Iron 2011e",1152,2048,null,"Tline 11bit = ",{"$f":"330*(1/(L4*1000000))","v":6.6000000000000003E-6},"Tline GHDR = ",{"$f":"130*(1/(N4*1000000))","v":2.888888888888889E-6}]
[null,"CLHS",9.8000000000000007,null,null,null,null,null,null,null,"K * Tline (12bit) = ",{"$f":"UserInterface!D27*L5","v":2.2937599999999999E-2},"K * Tline RHDR = ",{"$f":"UserInterface!D27*N5","v":2.4302933333333335E-2}]
[null,"10GIGE Vision",9.8000000000000007,null,null,null,"Max Height of Selected Sensor (V):",{"$f":"VLOOKUP(UserInterface!B23,Calculations!G4:I6,2,FALSE)","v":2048},null,null,"K * Tline (11bit) = ",{"$f":"UserInterface!D27*L6","v":1.3516800000000001E-2},"(2K +14)* Tline GHDR = ",{"$f":"(2*UserInterface!D27+14)*N6","v":1.1873333333333333E-2}]
[null,null,null,null,null,null,"Max Width of Selected Sensor (H):",{"$f":"VLOOKUP(UserInterface!B23,Calculations!G4:I6,3,FALSE)","v":2048},null,null,"(N + 1) * Tline (12bit) = ",{"$f":"(H24+1)*L5","v":1.2319999999999999E-4},"(N + 1) * Tline RHDR = ",{"$f":"(H24+1)*N5","v":1.3053333333333335E-4}]
["Partial protocol availability as a function of the bitness mode. Only used for the selection in the user interface!","2020BSI 11bit",null,null,null,null,null,null,null,null,"(N + 1) * Tline (11bit) = ",{"$f":"(H24+1)*L6","v":7.2600000000000003E-5},"(2K+14 + Mblank) * Tline GHDR = ",{"$f":"(2*UserInterface!D27+H23+14)*N6","v":1.1873333333333333E-2}]
[null,"CXP6",null,null,"Lower of the two","Interface FPS","Calculation",null,null,null,"N > (K-1)",{"$f":"IF(H24>UserInterface!D27,TRUE,FALSE)","v":false},"N > (K-1)",{"$f":"IF(H24>(UserInterface!D27-1),TRUE,FALSE)","v":false},null,"K",2048]
[null,"CLHS",null,null,null,null,"Protocol Bandwidth (Gbps)",{"$f":"VLOOKUP((UserInterface!D29),B4:C8,2,FALSE)","v":4.9000000000000004},null,null,null,null,"GHDR_A",null,null,"N",1024]
[null,"10GIGE Vision",null,null,null,null,"Bits per line",{"$f":"UserInterface!D26*UserInterface!D28","v":22528},null,null,"Tline HS (11bit) =",{"$f":"360*(1/(L4*1000000))","v":7.2000000000000005E-6},"GHDR_B"]
[null,null,null,null,null,null,"Line duration (Limited by bandwidth) (us) ",{"$f":"H13/(H12*1000)","v":4.5975510204081633},null,null,"(K/2) * Tline (HS, 11bit) = ",{"$f":"(UserInterface!D27/2)*L13","v":7.3728000000000005E-3},"GHDR_C",null,null,"K x Tline =",{"$f":"Q11*N26","v":2.3392711111111113E-2},{"$f":"1/Q14","v":42.748358463035018}]
[null,"2020BSI 12bit",null,null,null,null,"Total frame time (us)",{"$f":"H14*(UserInterface!D27)","v":9415.7844897959185},null,null,"(N + 1) * Tline (HS, 11bit) = ",{"$f":"(H24+1)*L13","v":7.9200000000000001E-5},"GHDR_D",null,null,"(N+1) x Tline =",{"$f":"N26*(Q12+1)","v":1.1707777777777779E-2},{"$f":"1/Q15","v":85.413305494922653}]
[null,"CXP6",null,null,null,null,"Interface Frame rate (fps)",{"$f":"IF(UserInterface!B23=\"Iron 2020BSI\", 1000000/H15, interface_fps_calc(1000000/H15))","v":106.20463978160511},null,null,"N > (K/2-1)",{"$f":"IF(H24>(UserInterface!D27/2-1),TRUE,FALSE)","v":false}]
[null,"CXP12",null,null,null,"Sensor","Sensor Max fps (mode dependant)",{"$f":"IF(NOT(UserInterface!D25=\"Normal Mode\"),ROUNDDOWN(VLOOKUP(UserInterface!D25,Calculations!N32:P37,3,FALSE),0),VLOOKUP(UserInterface!D28,Calculations!O30:P31,2,FALSE))","v":73.982007575757578},null,null,null,null,"Tline RHDRB = ",{"$f":"574*(1/(N4*1000000))","v":1.2755555555555556E-5}]
[null,"CLHS",null,null,null,null,"Actual Max FPS",{"$f":"IF(UserInterface!B23=\"Iron 2020BSI\", MIN(H16,H17), fps_result(MIN(H16,H17)))","v":73.982007575757578},null,null,null,null,"K * Tline RHDRB = ",{"$f":"UserInterface!D27*N17","v":2.6123377777777779E-2}]
[null,"10GIGE Vision",null,null,null,null,null,null,null,null,null,null,"N * Tline RHDRB = ",{"$f":"(H24)*N17","v":1.2755555555555556E-4}]
[]
[null,null,null,null,null,null,"Exposure Time & Mblank Parameters",null,null,null,null,null,"Tline DDS =",{"$f":"130*(1/(N4*1000000))","v":2.888888888888889E-6}]
[null,null,null,null,null,null,"Exposure Time (µs) - DDS Mode Only",4.9000000000000004,null,null,null,null,"DDS_A",{"$f":"IF(AND((H22/1000000)>O22,(H22/1000000)<O23),TRUE,FALSE)","v":false},{"$f":"110*(1/(N4*1000000))+N21","v":5.3333333333333337E-6}]
[null,null,null,null,null,null,"MBLANK Lines - DDS & GHDR Modes Only",0,null,null,null,null,"DDS_B",{"$f":"IF(AND((H22/1000000)>O23,(H22/1000000)<O24),TRUE,FALSE)","v":false},{"$f":"110*(1/(N4*1000000))+5*N21","v":1.6888888888888891E-5}]
[null,null,null,null,null,null,"Exposure Time (line times)",10,null,null,null,null,"DDS_C",{"$f":"IF(AND((H22/1000000)>O24),TRUE,FALSE)","v":false},{"$f":"110*(1/(N4*1000000))+(UserInterface!D27/2+5)*N21","v":2.9751111111111111E-3}]
[]
[null,null,null,null,null,null,"Exposure Time (line times)",null,null,null,null,null,"Tline LPM =",{"$f":"514*(1/(N4*1000000))","v":1.1422222222222223E-5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sensor","Modes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020BSI","Normal Mode",12,{"$f":"1/L7","v":43.596540178571431}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Mode",11,{"$f":"1/L8","v":73.982007575757578}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High Speed Mode","-",{"$f":"IF(L16,1/L15,1/L14)","v":135.63368055555554}]
[null,null,null,null,null,null,null,null,null,null,null,null,"2020e/2011e","Rolling HDR","-",{"$f":"IF(N11,1/N9,1/N7)","v":41.147296348314605}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Global HDR","-",{"$f":"IF(N11,1/N10,1/N8)","v":84.222346996069632}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rolling HDR Binning","-",{"$f":"IF(N11,1/N19,1/N18)","v":38.27988893728223}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Delta Data Sampling","-",{"$f":"1/(((UserInterface!D27/2)+13)*N21)","v":333.80313033157779}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Low Power Mode","-",{"$f":"IF(N11,1/((H24+1)*N26),1/((UserInterface!D27)*N26))","v":42.748358463035018}]
[]
[]
[null,"2020BSI Calculations",null,null,null,null,null,null,null,null,null,"2020e/2011e Calculations"]
[null,"High speed (HS) mode",null,null,null,null,null,"Normal + HDR modes"]
[null,null,null,null,null,null,null,null,null,null,null,"DDS mode"]

{"sheet":"UserInterface","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[[27,3,27,4],[28,3,28,4],[29,3,29,4],[29,1,29,2],[24,1,24,2],[24,3,24,4],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[25,3,25,4],[26,3,26,4],[22,0,23,0],[3,1,5,2],[6,1,6,2],[14,1,17,4],[22,1,23,1],[19,1,20,2],[21,1,21,4],[23,2,23,3]]}
[]
[]
[]
[null,"IRON 2020"]
[]
[]
[null,"Frame-Rate Calculator"]
[]
[]
[]
[]
[]
[]
[]
[null,"This document is provided as a simple and convinent tool for our customers to use. Please feel free to contact our support team with any questions - we will be happy to  provide assitance and support! For more information, products and the latest updates visit our website,  www.KayaInstruments.com"]
[]
[]
[]
[]
[null,"Camera Selector"]
[]
[null," Select a camera model from the drop-down menu below:"]
["Selector u","Iron 2020BSI"]
[null,null,{"$f":"VLOOKUP(B23,Calculations!G4:I6,2,FALSE)&\" (V) x \"&VLOOKUP(B23,Calculations!G4:I6,3,FALSE)&\" (H)\"","v":"2048 (V) x 2048 (H)"}]
[null,"Mode Selection",null,"Normal Mode"]
[null,"Desired Number of Horizontal Pixels (H)",null,2048]
[null,"Number of Desired lines (V)",null,2048]
[null,"Bitness Selection:",null,11]
[null,"Interface Selection:",null,"CXP6"]
[null,"MAX Frame Rate: ",null,{"$f":"Calculations!H18","v":73.982007575757578}]

{"sheet":"Start","index":2,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"You must enable macros in order to use this calculator!"]