{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["splash","LengthHeight","Overview","notes","chart"],"not_rendered":{"charts":1,"images":23,"macros":1,"external_links":0,"defined_names":2,"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":"splash","index":0,"n_rows":185,"n_cols":14,"rows_kept":185,"cut":false,"hidden":false,"merged":[[7,4,8,11],[12,4,12,11],[14,4,14,11],[5,4,6,11],[10,4,10,11],[40,4,42,11],[56,4,56,11],[92,4,93,11],[87,4,88,11],[58,4,58,11],[84,4,85,11],[53,4,55,11],[90,4,90,11],[184,4,185,11],[119,4,119,11],[121,4,122,11],[124,4,124,11],[128,4,129,11],[157,4,158,11],[160,4,161,11],[126,4,126,11],[155,4,155,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Document no: ",null,"I-200178-1"]
[null,null,null,null,null,null,null,null,null,null,null,"Version:",null,{"$f":"notes!$B$1","v":1}]
[null,null,null,null,"Seismic Calculation Tool",null,null,null,null,null,null,"Date:",null,{"$f":"notes!$B$2","v":"2016-08-02"}]
[]
[null,null,null,null,"Planning the detection layout of a protected surface requires the consideration of many factors in order to provide the highest security level.\n"]
[]
[null,null,null,null,"Vanderbilt`s Seismic Calculation Tool assists in the design process. Enter the operating radius of the chosen detector as well as the dimensions of the wall, ceiling or floor and Vanderbilt`s Seismic Calculation Tool will automatically calculate:"]
[]
[null,null,null,null,"• The number of detectors required."]
[null,null,null,null,"• The optimum spacing of the detectors to maximize the detection coverage."]
[]
[null,null,null,null," Please press START to enter the application. "]
[]
[null,null,null,null,"For more information on how to use Vanderbilt`s Calculation Tool, please refer to the user instructions below. "]
[]
[null,null,null,null,"1. Input"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Figure 1:   Input screen"]
[]
[null,null,null,null,"• Select the operating radius of the chosen Vanderbilt seismic detector based on the surface material of the wall. Depending on the type of detector and it`s detection capabilities only a limited selection may apply. Please refer to Table 1 for more information."]
[]
[]
[]
[null,null,null,null,"Operating Radius","Surface Material","GM710","GM730","GM760","GM775","GM775LSNi","GM780LSN"]
[null,null,null,null,"1.0m","Steel",2,2,2,2,2,2]
[null,null,null,null,"1.5m","Steel",2,2,2,2,2,2]
[null,null,null,null,"2.0m","Steel",2,2,2,2,2,2]
[null,null,null,null,"2.5m","Concrete",0,2,2,2,2,2]
[null,null,null,null,"4.0m","Concrete",0,2,2,2,2,2]
[null,null,null,null,"5.0m","Concrete",0,0,2,2,2,2]
[null,null,null,null,"Table 1:   Operating radius per detector"]
[]
[null,null,null,null,"• Enter the length and the height of the wall in metres (m). The height of the wall will also assist in identifying the operating radius. If the height of the wall exceeds the operating radius of the detector, an additional row (or rows) of detectors is required. However, this will also be automatically calculated. "]
[]
[]
[null,null,null,null,"• Please note, that both values need to be entered for the calculation tool to work. "]
[]
[null,null,null,null,"Please press CALCULATE to receive the proposed detection layout."]
[]
[null,null,null,null,"2. Results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Figure 2:   Result screen"]
[]
[null,null,null,null,"• Total detectors: The calculated number of detectors required for a wall to ensure comprehensive protection. Vanderbilt`s Seismic Calculation Tool already considers overlapping coverage areas for the detectors to provide 100% detection coverage."]
[]
[]
[null,null,null,null,"• Distance to first: The calculated distance (length) between the corner of the protected wall and the first detector."]
[]
[]
[null,null,null,null,"• Distance from last: The calculated distance (length) between the last detector and the far corner of the wall."]
[]
[null,null,null,null,"• Height from Bottom: The calculated mounting height of the first row of detectors. It represents the calculated distance (height) between the bottom of the protected wall and the first row of detectors."]
[]
[]
[null,null,null,null,"3. Tabulated results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Figure 3:   Tabulated results screen"]
[]
[null,null,null,null,"• Detector: List of each required detector and its location alongside the wall.  "]
[]
[null,null,null,null,"• Distance (Length): Calculated distance (length) between either the corner of the protected wall and the first detector or the previous detector and the next detector.  "]
[]
[]
[null,null,null,null,"• Accumulated Distance (Length): Calculated distance (length) between the corner of the protected wall and the detector."]
[]
[null,null,null,null,"• Mounting Height: Calculated distance (height) between the bottom of the protected wall and the detector."]
[]
[null,null,null,null,"• Row: The row the specific detector is positioned on. If the height of the wall exceeds the operating radius of the detector, an additional row (or rows) of detectors is required."]
[]
[]
[null,null,null,null,"4. Detector Location"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Figure 4:   Detector locations screen"]
[]
[null,null,null,null,"• Detector location: Schematical overview of the wall with the calculated position of each required detector."]
[]
[null,null,null,null,"• Include coordinates: Checkbox to include the coordinates of each detector in the schematic overview (Figure 4). They are displayed above each detector point with the length (L) and height (H) in metres. By default, this checkbox is activated. "]
[]
[]
[null,null,null,null,"• To Scale: Checkbox to display the detector locations according to the ratio of the wall dimensions. By default, this checkbox is not activated. "]
[]
[]
[null,null,null,null,"5. Print"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Figure 5:   Print screen"]
[]
[null,null,null,null,"• Print: Easy way of printing the results of the detection layout, which can be used for quotation, installation and commissioning. "]

{"sheet":"LengthHeight","index":1,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":true,"merged":[[3,11,3,18]]}
[null,"Radius:",2,"Length:",0,"Height:",0]
[]
[null,"Distances","Calculated distance","Accumulated distance","Total detectors",null,"Distances","Recommended distance","Accumulated distance","Total detectors"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1+$G$1<=0),\"-\",\"dmax\"),\"-\")","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B4=\"-\"),\"-\",ROUND(IF(B4=\"sdmax\",$C$1*1.5,IF(B4=\"-\",0,$C$1*0.8)),2))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B4=\"-\"),\"-\",IF(_xlfn.XOR(B4=\"dmax\",B4=\"drem\"),SUM($C$4:C4),IF(SUM($C$4:C4)<$E$1,SUM($C$4:C4),0)))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B4=\"-\"),\"-\",IF($E$1-D4=$E$1,0,IF(_xlfn.XOR(B4=\"dmax\",B4=\"sdmax\"),1,0)))","v":"-"},null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",B4)","v":"-"},{"$f":"IF($E$19=1,IF(G4=\"-\",\"-\",$E$1/2), IF(G4=\"-\",\"-\",IF((($E$1-(1.6*$C$1))/($E$19-1))<($C$1*0.8), ROUND($E$1/($E$19+1),2),IF(G4=\"sdbal\",ROUND(($E$1-(1.6*$C$1))/($E$19-1),2),IF(G4=\"-\",\"-\",$C$1*0.8)))))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G4=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G4=\"dmax\",G4=\"drem\"),SUM($H$4:H4),IF(G4=\"-\",0,IF(SUM($H$4:H4),IF(G4=\"-\",0,SUM($H$4:H4))))),1))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G4=\"-\"),\"-\",IF($E$1-I4=$E$1,0,IF(_xlfn.XOR(G4=\"dmax\",G4=\"sdbal\"),1,0)))","v":"-"},null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(AND($E$1<=0,$G$1<=0),\"Please enter valid length and height.\",IF($G$1<=0,\"Please enter valid height\",IF($E$1<=0,\"Please enter correct length\",\"\"))),\"Incorrect operating radius. Please choose a valid radius from the table below.\")","v":"Please enter valid length and height."}]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(D4+$C$4>=$E$1,\"drem\",\"sdmax\")),\"-\")","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B5=\"-\"),\"-\",ROUND(IF(B5=\"sdmax\",$C$1*1.5,IF(B5=\"-\",0,$C$1*0.8)),2))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B5=\"-\"),\"-\",IF(_xlfn.XOR(B5=\"dmax\",B5=\"drem\"),SUM($C$4:C5),IF(SUM($C$4:C4)<$E$1,SUM($C$4:C5),0)))","v":"-"},"-",null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(B5=\"sdmax\",\"sdBal\",B5))","v":"-"},{"$f":"IF($E$19=1,IF(G5=\"-\",\"-\",$E$1/2), IF(G5=\"-\",\"-\",IF((($E$1-(1.6*$C$1))/($E$19-1))<($C$1*0.8), ROUND($E$1/($E$19+1),2),IF(G5=\"sdbal\",ROUND(($E$1-(1.6*$C$1))/($E$19-1),2),IF(G5=\"-\",\"-\",$C$1*0.8)))))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G5=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G5=\"dmax\",G5=\"drem\"),SUM($H$4:H5),IF(G5=\"-\",0,IF(SUM($H$4:H5),IF(G5=\"-\",0,SUM($H$4:H5))))),1))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B5=\"drem\",B5=\"-\"),\"-\", IF(AND(B5=\"sdmax\",(SUM($C$4:C5)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B6=\"-\"),\"-\",IF(_xlfn.XOR(B6=\"dmax\",B6=\"drem\"),SUM($C$4:C6),IF(SUM($C$4:C5)<$E$1,SUM($C$4:C6),0)))","v":"-"},"-",null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(B6=\"sdmax\",\"sdBal\",B6))","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G6=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G6=\"dmax\",G6=\"drem\"),SUM($H$4:H6),IF(G6=\"-\",0,IF(SUM($H$4:H6),IF(G6=\"-\",0,SUM($H$4:H6))))),1))","v":"-"},"-",null," Radius"," Material"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B6=\"drem\",B6=\"-\"),\"-\", IF(AND(B6=\"sdmax\",(SUM($C$4:C6)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B7=\"-\"),\"-\",IF(_xlfn.XOR(B7=\"dmax\",B7=\"drem\"),SUM($C$4:C7),IF(SUM($C$4:C6)<$E$1,SUM($C$4:C7),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G7=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G7=\"dmax\",G7=\"drem\"),SUM($H$4:H7),IF(G7=\"-\",0,IF(SUM($H$4:H7),IF(G7=\"-\",0,SUM($H$4:H7))))),1))","v":"-"},"-",null,1,"Steel"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B7=\"drem\",B7=\"-\"),\"-\", IF(AND(B7=\"sdmax\",(SUM($C$4:C7)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B8=\"-\"),\"-\",IF(_xlfn.XOR(B8=\"dmax\",B8=\"drem\"),SUM($C$4:C8),IF(SUM($C$4:C7)<$E$1,SUM($C$4:C8),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G8=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G8=\"dmax\",G8=\"drem\"),SUM($H$4:H8),IF(G8=\"-\",0,IF(SUM($H$4:H8),IF(G8=\"-\",0,SUM($H$4:H8))))),1))","v":"-"},"-",null,1.5,"Steel"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B8=\"drem\",B8=\"-\"),\"-\", IF(AND(B8=\"sdmax\",(SUM($C$4:C8)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B9=\"-\"),\"-\",IF(_xlfn.XOR(B9=\"dmax\",B9=\"drem\"),SUM($C$4:C9),IF(SUM($C$4:C8)<$E$1,SUM($C$4:C9),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G9=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G9=\"dmax\",G9=\"drem\"),SUM($H$4:H9),IF(G9=\"-\",0,IF(SUM($H$4:H9),IF(G9=\"-\",0,SUM($H$4:H9))))),1))","v":"-"},"-",null,2,"Steel"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B9=\"drem\",B9=\"-\"),\"-\", IF(AND(B9=\"sdmax\",(SUM($C$4:C9)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B10=\"-\"),\"-\",IF(_xlfn.XOR(B10=\"dmax\",B10=\"drem\"),SUM($C$4:C10),IF(SUM($C$4:C9)<$E$1,SUM($C$4:C10),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G10=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G10=\"dmax\",G10=\"drem\"),SUM($H$4:H10),IF(G10=\"-\",0,IF(SUM($H$4:H10),IF(G10=\"-\",0,SUM($H$4:H10))))),1))","v":"-"},"-",null,2.5,"Concrete"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B10=\"drem\",B10=\"-\"),\"-\", IF(AND(B10=\"sdmax\",(SUM($C$4:C10)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B11=\"-\"),\"-\",IF(_xlfn.XOR(B11=\"dmax\",B11=\"drem\"),SUM($C$4:C11),IF(SUM($C$4:C10)<$E$1,SUM($C$4:C11),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G11=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G11=\"dmax\",G11=\"drem\"),SUM($H$4:H11),IF(G11=\"-\",0,IF(SUM($H$4:H11),IF(G11=\"-\",0,SUM($H$4:H11))))),1))","v":"-"},"-",null,4,"Concrete"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B11=\"drem\",B11=\"-\"),\"-\", IF(AND(B11=\"sdmax\",(SUM($C$4:C11)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B12=\"-\"),\"-\",IF(_xlfn.XOR(B12=\"dmax\",B12=\"drem\"),SUM($C$4:C12),IF(SUM($C$4:C11)<$E$1,SUM($C$4:C12),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G12=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G12=\"dmax\",G12=\"drem\"),SUM($H$4:H12),IF(G12=\"-\",0,IF(SUM($H$4:H12),IF(G12=\"-\",0,SUM($H$4:H12))))),1))","v":"-"},"-",null,5,"Concrete"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B12=\"drem\",B12=\"-\"),\"-\", IF(AND(B12=\"sdmax\",(SUM($C$4:C12)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B13=\"-\"),\"-\",IF(_xlfn.XOR(B13=\"dmax\",B13=\"drem\"),SUM($C$4:C13),IF(SUM($C$4:C12)<$E$1,SUM($C$4:C13),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G13=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G13=\"dmax\",G13=\"drem\"),SUM($H$4:H13),IF(G13=\"-\",0,IF(SUM($H$4:H13),IF(G13=\"-\",0,SUM($H$4:H13))))),1))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B13=\"drem\",B13=\"-\"),\"-\", IF(AND(B13=\"sdmax\",(SUM($C$4:C13)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B14=\"-\"),\"-\",IF(_xlfn.XOR(B14=\"dmax\",B14=\"drem\"),SUM($C$4:C14),IF(SUM($C$4:C13)<$E$1,SUM($C$4:C14),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G14=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G14=\"dmax\",G14=\"drem\"),SUM($H$4:H14),IF(G14=\"-\",0,IF(SUM($H$4:H14),IF(G14=\"-\",0,SUM($H$4:H14))))),1))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B14=\"drem\",B14=\"-\"),\"-\", IF(AND(B14=\"sdmax\",(SUM($C$4:C14)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B15=\"-\"),\"-\",IF(_xlfn.XOR(B15=\"dmax\",B15=\"drem\"),SUM($C$4:C15),IF(SUM($C$4:C14)<$E$1,SUM($C$4:C15),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G15=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G15=\"dmax\",G15=\"drem\"),SUM($H$4:H15),IF(G15=\"-\",0,IF(SUM($H$4:H15),IF(G15=\"-\",0,SUM($H$4:H15))))),1))","v":"-"},"-",null,"Detector","Distance               (Length)","Accumulated distance (Length)","Mounting Height","Row"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B15=\"drem\",B15=\"-\"),\"-\", IF(AND(B15=\"sdmax\",(SUM($C$4:C15)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B16=\"-\"),\"-\",IF(_xlfn.XOR(B16=\"dmax\",B16=\"drem\"),SUM($C$4:C16),IF(SUM($C$4:C15)<$E$1,SUM($C$4:C16),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G16=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G16=\"dmax\",G16=\"drem\"),SUM($H$4:H16),IF(G16=\"-\",0,IF(SUM($H$4:H16),IF(G16=\"-\",0,SUM($H$4:H16))))),1))","v":"-"},"-",null,1,3.2,3.2,3.2,1]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B16=\"drem\",B16=\"-\"),\"-\", IF(AND(B16=\"sdmax\",(SUM($C$4:C16)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B17=\"-\"),\"-\",IF(_xlfn.XOR(B17=\"dmax\",B17=\"drem\"),SUM($C$4:C17),IF(SUM($C$4:C16)<$E$1,SUM($C$4:C17),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G17=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G17=\"dmax\",G17=\"drem\"),SUM($H$4:H17),IF(G17=\"-\",0,IF(SUM($H$4:H17),IF(G17=\"-\",0,SUM($H$4:H17))))),1))","v":"-"},"-",null,2,4.8,8,3.2,1]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B17=\"drem\",B17=\"-\"),\"-\", IF(AND(B17=\"sdmax\",(SUM($C$4:C17)+$C$4)<=$E$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B18=\"-\"),\"-\",IF(_xlfn.XOR(B18=\"dmax\",B18=\"drem\"),SUM($C$4:C18),IF(SUM($C$4:C17)<$E$1,SUM($C$4:C18),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G18=\"-\"),\"-\",ROUND(IF(_xlfn.XOR(G18=\"dmax\",G18=\"drem\"),SUM($H$4:H18),IF(G18=\"-\",0,IF(SUM($H$4:H18),IF(G18=\"-\",0,SUM($H$4:H18))))),1))","v":"-"},"-",null,3,4.8,12.8,3.2,1]
[null,null,null,{"$f":"MAX(D4:D18)","v":0},{"$f":"ROUND(SUM(E4:E18),0)","v":0},null,null,null,{"$f":"ROUND(MAX(I4:I18),1)","v":0},{"$f":"ROUND(SUM(J4:J18),0)","v":0},null,4,3.2,3.2,8,2]
[null,null,null,null,null,null,null,null,null,null,null,5,4.8,8,8,2]
[null,null,null,null,null,null,null,null,null,null,null,6,4.8,12.8,8,2]
[null,"Distances","Calculated distance","Accumulated distance","Total detectors",null,"Distances","Recommended distance","Accumulated distance","Total detectors"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",\"dmax\"),\"-\")","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B23=\"-\"),\"-\",ROUND(IF(B23=\"sdmax\",$C$1*1.5,IF(B23=\"-\",0,$C$1*0.8)),2))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B23=\"-\"),\"-\",IF(_xlfn.XOR(B23=\"dmax\",B23=\"drem\"),SUM($C$23:C23),IF(SUM($C$23:C23)<$G$1,SUM($C$23:C23),0)))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B23=\"-\"),\"-\",IF($G$1-D23=$G$1,0,IF(_xlfn.XOR(B23=\"dmax\",B23=\"sdmax\"),1,0)))","v":"-"},null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(B23=\"sdmax\",\"sdbal\",B23))","v":"-"},{"$f":"IF($E$38=1,IF(G23=\"-\",\"-\",$G$1/2), IF(G23=\"-\",\"-\",IF((($G$1-(1.6*$C$1))/($E$38-1))<($C$1*0.8), ROUND($G$1/($E$38+1),2),IF(G23=\"sdbal\",ROUND(($G$1-(1.6*$C$1))/($E$38-1),2),IF(G23=\"-\",\"-\",$C$1*0.8)))))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G23=\"-\"),\"-\",IF(_xlfn.XOR(G23=\"dmax\",G23=\"drem\"),SUM($H$23:H23),IF(G23=\"-\",0,IF(SUM($H$23:H23),IF(G23=\"-\",0,SUM($H$23:H23))))))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G23=\"-\"),\"-\",IF($G$1-I23=$G$1,0,IF(_xlfn.XOR(G23=\"dmax\",G23=\"sdbal\"),1,0)))","v":"-"}]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(D23+$C$23>=$G$1,\"drem\",\"sdmax\")),\"-\")","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B24=\"-\"),\"-\",ROUND(IF(B24=\"sdmax\",$C$1*1.5,IF(B24=\"-\",0,$C$1*0.8)),2))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B24=\"-\"),\"-\",IF(_xlfn.XOR(B24=\"dmax\",B24=\"drem\"),SUM($C$23:C24),IF(SUM($C$23:C23)<$G$1,SUM($C$23:C24),0)))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B24=\"-\"),\"-\",IF($G$1-D24=$G$1,0,IF(_xlfn.XOR(B24=\"dmax\",B24=\"sdmax\"),1,0)))","v":"-"},null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(B24=\"sdmax\",\"sdbal\",B24))","v":"-"},{"$f":"IF($E$38=1,IF(G24=\"-\",\"-\",$G$1/2), IF(G24=\"-\",\"-\",IF((($G$1-(1.6*$C$1))/($E$38-1))<($C$1*0.8), ROUND($G$1/($E$38+1),2),IF(G24=\"sdbal\",ROUND(($G$1-(1.6*$C$1))/($E$38-1),2),IF(G24=\"-\",\"-\",$C$1*0.8)))))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G24=\"-\"),\"-\",IF(_xlfn.XOR(G24=\"dmax\",G24=\"drem\"),SUM($H$23:H24),IF(G24=\"-\",0,IF(SUM($H$23:H24),IF(G24=\"-\",0,SUM($H$23:H24))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B24=\"drem\",B24=\"-\"),\"-\", IF(AND(B24=\"sdmax\",(SUM($C$23:C24)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B25=\"-\"),\"-\",ROUND(IF(B25=\"sdmax\",$C$1*1.5,IF(B25=\"-\",0,$C$1*0.8)),2))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B25=\"-\"),\"-\",IF(_xlfn.XOR(B25=\"dmax\",B25=\"drem\"),SUM($C$23:C25),IF(SUM($C$23:C24)<$G$1,SUM($C$23:C25),0)))","v":"-"},"-",null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(B25=\"sdmax\",\"sdbal\",B25))","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G25=\"-\"),\"-\",IF(_xlfn.XOR(G25=\"dmax\",G25=\"drem\"),SUM($H$23:H25),IF(G25=\"-\",0,IF(SUM($H$23:H25),IF(G25=\"-\",0,SUM($H$23:H25))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B25=\"drem\",B25=\"-\"),\"-\", IF(AND(B25=\"sdmax\",(SUM($C$23:C25)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B26=\"-\"),\"-\",ROUND(IF(B26=\"sdmax\",$C$1*1.5,IF(B26=\"-\",0,$C$1*0.8)),2))","v":"-"},{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B26=\"-\"),\"-\",IF(_xlfn.XOR(B26=\"dmax\",B26=\"drem\"),SUM($C$23:C26),IF(SUM($C$23:C25)<$G$1,SUM($C$23:C26),0)))","v":"-"},"-",null,{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\",IF(B26=\"sdmax\",\"sdbal\",B26))","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G26=\"-\"),\"-\",IF(_xlfn.XOR(G26=\"dmax\",G26=\"drem\"),SUM($H$23:H26),IF(G26=\"-\",0,IF(SUM($H$23:H26),IF(G26=\"-\",0,SUM($H$23:H26))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B26=\"drem\",B26=\"-\"),\"-\", IF(AND(B26=\"sdmax\",(SUM($C$23:C26)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B27=\"-\"),\"-\",IF(_xlfn.XOR(B27=\"dmax\",B27=\"drem\"),SUM($C$23:C27),IF(SUM($C$23:C26)<$G$1,SUM($C$23:C27),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G27=\"-\"),\"-\",IF(_xlfn.XOR(G27=\"dmax\",G27=\"drem\"),SUM($H$23:H27),IF(G27=\"-\",0,IF(SUM($H$23:H27),IF(G27=\"-\",0,SUM($H$23:H27))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B27=\"drem\",B27=\"-\"),\"-\", IF(AND(B27=\"sdmax\",(SUM($C$23:C27)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B28=\"-\"),\"-\",IF(_xlfn.XOR(B28=\"dmax\",B28=\"drem\"),SUM($C$23:C28),IF(SUM($C$23:C27)<$G$1,SUM($C$23:C28),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G28=\"-\"),\"-\",IF(_xlfn.XOR(G28=\"dmax\",G28=\"drem\"),SUM($H$23:H28),IF(G28=\"-\",0,IF(SUM($H$23:H28),IF(G28=\"-\",0,SUM($H$23:H28))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B28=\"drem\",B28=\"-\"),\"-\", IF(AND(B28=\"sdmax\",(SUM($C$23:C28)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B29=\"-\"),\"-\",IF(_xlfn.XOR(B29=\"dmax\",B29=\"drem\"),SUM($C$23:C29),IF(SUM($C$23:C28)<$G$1,SUM($C$23:C29),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G29=\"-\"),\"-\",IF(_xlfn.XOR(G29=\"dmax\",G29=\"drem\"),SUM($H$23:H29),IF(G29=\"-\",0,IF(SUM($H$23:H29),IF(G29=\"-\",0,SUM($H$23:H29))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B29=\"drem\",B29=\"-\"),\"-\", IF(AND(B29=\"sdmax\",(SUM($C$23:C29)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B30=\"-\"),\"-\",IF(_xlfn.XOR(B30=\"dmax\",B30=\"drem\"),SUM($C$23:C30),IF(SUM($C$23:C29)<$G$1,SUM($C$23:C30),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G30=\"-\"),\"-\",IF(_xlfn.XOR(G30=\"dmax\",G30=\"drem\"),SUM($H$23:H30),IF(G30=\"-\",0,IF(SUM($H$23:H30),IF(G30=\"-\",0,SUM($H$23:H30))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B30=\"drem\",B30=\"-\"),\"-\", IF(AND(B30=\"sdmax\",(SUM($C$23:C30)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B31=\"-\"),\"-\",IF(_xlfn.XOR(B31=\"dmax\",B31=\"drem\"),SUM($C$23:C31),IF(SUM($C$23:C30)<$G$1,SUM($C$23:C31),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G31=\"-\"),\"-\",IF(_xlfn.XOR(G31=\"dmax\",G31=\"drem\"),SUM($H$23:H31),IF(G31=\"-\",0,IF(SUM($H$23:H31),IF(G31=\"-\",0,SUM($H$23:H31))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B31=\"drem\",B31=\"-\"),\"-\", IF(AND(B31=\"sdmax\",(SUM($C$23:C31)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B32=\"-\"),\"-\",IF(_xlfn.XOR(B32=\"dmax\",B32=\"drem\"),SUM($C$23:C32),IF(SUM($C$23:C31)<$G$1,SUM($C$23:C32),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G32=\"-\"),\"-\",IF(_xlfn.XOR(G32=\"dmax\",G32=\"drem\"),SUM($H$23:H32),IF(G32=\"-\",0,IF(SUM($H$23:H32),IF(G32=\"-\",0,SUM($H$23:H32))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B32=\"drem\",B32=\"-\"),\"-\", IF(AND(B32=\"sdmax\",(SUM($C$23:C32)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B33=\"-\"),\"-\",IF(_xlfn.XOR(B33=\"dmax\",B33=\"drem\"),SUM($C$23:C33),IF(SUM($C$23:C32)<$G$1,SUM($C$23:C33),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G33=\"-\"),\"-\",IF(_xlfn.XOR(G33=\"dmax\",G33=\"drem\"),SUM($H$23:H33),IF(G33=\"-\",0,IF(SUM($H$23:H33),IF(G33=\"-\",0,SUM($H$23:H33))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B33=\"drem\",B33=\"-\"),\"-\", IF(AND(B33=\"sdmax\",(SUM($C$23:C33)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B34=\"-\"),\"-\",IF(_xlfn.XOR(B34=\"dmax\",B34=\"drem\"),SUM($C$23:C34),IF(SUM($C$23:C33)<$G$1,SUM($C$23:C34),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G34=\"-\"),\"-\",IF(_xlfn.XOR(G34=\"dmax\",G34=\"drem\"),SUM($H$23:H34),IF(G34=\"-\",0,IF(SUM($H$23:H34),IF(G34=\"-\",0,SUM($H$23:H34))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B34=\"drem\",B34=\"-\"),\"-\", IF(AND(B34=\"sdmax\",(SUM($C$23:C34)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B35=\"-\"),\"-\",IF(_xlfn.XOR(B35=\"dmax\",B35=\"drem\"),SUM($C$23:C35),IF(SUM($C$23:C34)<$G$1,SUM($C$23:C35),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G35=\"-\"),\"-\",IF(_xlfn.XOR(G35=\"dmax\",G35=\"drem\"),SUM($H$23:H35),IF(G35=\"-\",0,IF(SUM($H$23:H35),IF(G35=\"-\",0,SUM($H$23:H35))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B35=\"drem\",B35=\"-\"),\"-\", IF(AND(B35=\"sdmax\",(SUM($C$23:C35)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B36=\"-\"),\"-\",IF(_xlfn.XOR(B36=\"dmax\",B36=\"drem\"),SUM($C$23:C36),IF(SUM($C$23:C35)<$G$1,SUM($C$23:C36),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G36=\"-\"),\"-\",IF(_xlfn.XOR(G36=\"dmax\",G36=\"drem\"),SUM($H$23:H36),IF(G36=\"-\",0,IF(SUM($H$23:H36),IF(G36=\"-\",0,SUM($H$23:H36))))))","v":"-"},"-"]
[null,{"$f":"IF(OR($C$1=1,$C$1=1.5,$C$1=2,$C$1=2.5,$C$1=4,$C$1=5),IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0),\"-\", IF(OR(B36=\"drem\",B36=\"-\"),\"-\", IF(AND(B36=\"sdmax\",(SUM($C$23:C36)+$C$23)<=$G$1),\"sdmax\",\"drem\"))),\"-\")","v":"-"},"-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,B37=\"-\"),\"-\",IF(_xlfn.XOR(B37=\"dmax\",B37=\"drem\"),SUM($C$23:C37),IF(SUM($C$23:C36)<$G$1,SUM($C$23:C37),0)))","v":"-"},"-",null,"-","-",{"$f":"IF(OR($E$1<=0,$G$1<=0,$E$1*$G$1<=0,G37=\"-\"),\"-\",IF(_xlfn.XOR(G37=\"dmax\",G37=\"drem\"),SUM($H$23:H37),IF(G37=\"-\",0,IF(SUM($H$23:H37),IF(G37=\"-\",0,SUM($H$23:H37))))))","v":"-"},"-"]
[null,null,null,{"$f":"MAX(D23:D37)","v":0},{"$f":"ROUND(SUM(E23:E37),0)","v":0},null,null,null,{"$f":"ROUND(MAX(I23:I37),1)","v":0},{"$f":"ROUND(SUM(J23:J37),0)","v":0}]

{"sheet":"Overview","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Detector","Distance (Length)","Accumulated distance (Length)","Mounting Height","Row"]

{"sheet":"notes","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Version ",1]
["Date","2016-08-02"]
[]
[]
["Version ",1]
["Initial file created"]

{"sheet":"chart","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}