{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Delta Quad Duo LOOP 1","Delta Quad Duo LOOP 2","Device specifications"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":3,"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":"Delta Quad Duo LOOP 1","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,7,6,8],[12,1,12,2],[2,3,2,6],[3,3,3,6],[6,0,6,2],[6,3,6,4],[6,5,6,6],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[25,0,25,1],[25,7,25,8],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[23,0,23,2],[23,7,23,8],[24,0,24,1],[24,7,24,8],[26,0,26,1],[26,7,26,8],[27,0,27,1],[28,0,28,1],[29,0,29,3]]}
["Delta Quad Duo Loop 1 load calculation form",null,null,"Ver:09.09.2013 ØS"]
[]
["Project",null,"Date"]
["System number",null,"Responsible"]
[]
[]
["Loop configuration",null,null,"Device current",null,"Total current",null,"Loop load factor"]
["Count","Device type",null,"Nominal","Alarm","Nominal","Alarm","Device","Total"]
[null,null,null,{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,'Device specifications'!$A$2:$C22,2,FALSE))","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,'Device specifications'!$A$2:$C22,3,FALSE))","v":""},{"$f":"IF(AND($A9>0,$B9<>\"\"),$A9*D9,\"\")","v":""},{"$f":"IF(AND($A9>0,$B9<>\"\"),$A9*E9,\"\")","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},{"$f":"IF(AND($A9>0,$B9<>\"\"),$A9*H9,\"\")","v":""}]
[null,null,null,{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,'Device specifications'!$A$2:$C23,2,FALSE))","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,'Device specifications'!$A$2:$C23,3,FALSE))","v":""},{"$f":"IF(AND($A10>0,$B10<>\"\"),$A10*D10,\"\")","v":""},"",{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},{"$f":"IF(AND($A10>0,$B10<>\"\"),$A10*H10,\"\")","v":""}]
[null,null,null,{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,'Device specifications'!$A$2:$C24,2,FALSE))","v":""},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,'Device specifications'!$A$2:$C24,3,FALSE))","v":""},"","",{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,'Device specifications'!$A$2:$C25,2,FALSE))","v":""},{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,'Device specifications'!$A$2:$C25,3,FALSE))","v":""},"","",{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,'Device specifications'!$A$2:$C26,2,FALSE))","v":""},{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,'Device specifications'!$A$2:$C26,3,FALSE))","v":""},"","",{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,'Device specifications'!$A$2:$C27,2,FALSE))","v":""},{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,'Device specifications'!$A$2:$C27,3,FALSE))","v":""},"","",{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,'Device specifications'!$A$2:$C28,2,FALSE))","v":""},{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,'Device specifications'!$A$2:$C28,3,FALSE))","v":""},"","",{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'Device specifications'!$A$2:$C29,2,FALSE))","v":""},{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'Device specifications'!$A$2:$C29,3,FALSE))","v":""},"","",{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'Device specifications'!$A$2:$C30,2,FALSE))","v":""},{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'Device specifications'!$A$2:$C30,3,FALSE))","v":""},"","",{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,null,null,"","",null,""]
[null,null,null,null,null,"","",null,""]
[null,null,null,null,null,"","",null,""]
[{"$f":"SUM(A9:A20)","v":0},{"$f":"IF(A21>126,\"ERROR! No of devices are above the maximum of 126\",\"\")","v":""},null,null,null,{"$f":"SUM(F9:F20)","v":0},{"$f":"SUM(G9:G20)","v":0},null,{"$f":"SUM(I9:I20)","v":0}]
[{"$f":"IF(I21>120,\"ERROR! Loop load is above the maximum of 120 for a DA Quad\",\"\")","v":""}]
[{"$f":"IF(F21>450,\"ERROR! Loop current is above the maximum of 450mA for a DA Quad\",\"\")","v":""}]
["Loop lenght calculation results",null,null,null,null,null,"Resist. Ω/m","Device insertion resistance"]
["Maximum loop length using 0.8mm2 cable",null,{"$f":"IF(D25>E25,E25,D25)","v":920},{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G25)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G25)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,920,IF(I21<101,610,IF(I21<121,340,\"Error\")))","v":920},null,2.1364999999999999E-2,0.1]
["Maximum loop length using 1.0mm2 cable",null,{"$f":"IF(D26>E26,E26,D26)","v":1200},{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G26)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G26)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,1200,IF(I21<101,900,IF(I21<121,500,\"Error\")))","v":1200},null,1.7031999999999999E-2,"Calculation tolerance margin"]
["Maximum loop length using 1.5mm2 cable",null,1200,{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G27)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G27)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,1200,IF(I21<101,1200,IF(I21<121,900,\"Error\")))","v":1200},null,1.1186700000000001E-2,0.2]
["Maximum loop length using 2.5mm2 cable",null,1200,{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G28)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G28)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,1200,IF(I21<101,1200,IF(I21<121,1200,\"Error\")))","v":1200},null,6.7120000000000001E-3]
[]
["Notes:\n1. Assuming a maximum total loop current of 450mA for the DAQ\n2. Assuming 1500m total maximum cable length regardless\n3. Assuming 28V minimum voltage at the end of the loop\n4. Assuming 36V nominal loop voltage at the DA Quad\n5. Max loop load is 120"]

{"sheet":"Delta Quad Duo LOOP 2","index":1,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,5,6,6],[11,1,11,2],[12,1,12,2],[2,3,2,6],[3,3,3,6],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[13,1,13,2],[14,1,14,2],[29,0,29,3],[6,0,6,2],[6,3,6,4],[25,0,25,1],[27,0,27,1],[28,0,28,1],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[23,0,23,2],[26,0,26,1],[24,0,24,1],[6,7,6,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8]]}
["Delta Quad Duo Loop 2 load calculation form",null,null,"Ver:09.09.2013 ØS"]
[]
["Project",null,"Date"]
["System number",null,"Responsible"]
[]
[]
["Loop configuration",null,null,"Device current",null,"Total current",null,"Loop load factor"]
["Count","Device type",null,"Nominal","Alarm","Nominal","Alarm","Device","Total"]
[null,null,null,{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,'Device specifications'!$A$2:$C22,2,FALSE))","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,'Device specifications'!$A$2:$C22,3,FALSE))","v":""},{"$f":"IF(AND($A9>0,$B9<>\"\"),$A9*D9,\"\")","v":""},{"$f":"IF(AND($A9>0,$B9<>\"\"),$A9*E9,\"\")","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},{"$f":"IF(AND($A9>0,$B9<>\"\"),$A9*H9,\"\")","v":""}]
[null,null,null,{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,'Device specifications'!$A$2:$C23,2,FALSE))","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,'Device specifications'!$A$2:$C23,3,FALSE))","v":""},{"$f":"IF(AND($A10>0,$B10<>\"\"),$A10*D10,\"\")","v":""},{"$f":"IF(AND($A10>0,$B10<>\"\"),$A10*E10,\"\")","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},{"$f":"IF(AND($A10>0,$B10<>\"\"),$A10*H10,\"\")","v":""}]
[null,null,null,{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,'Device specifications'!$A$2:$C24,2,FALSE))","v":""},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,'Device specifications'!$A$2:$C24,3,FALSE))","v":""},"","",{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,'Device specifications'!$A$2:$C25,2,FALSE))","v":""},{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,'Device specifications'!$A$2:$C25,3,FALSE))","v":""},"","",{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,'Device specifications'!$A$2:$C26,2,FALSE))","v":""},{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,'Device specifications'!$A$2:$C26,3,FALSE))","v":""},"","",{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,'Device specifications'!$A$2:$C27,2,FALSE))","v":""},{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,'Device specifications'!$A$2:$C27,3,FALSE))","v":""},"","",{"$f":"IF($B14=\"\",\"\",VLOOKUP($B14,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,'Device specifications'!$A$2:$C28,2,FALSE))","v":""},{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,'Device specifications'!$A$2:$C28,3,FALSE))","v":""},"","",{"$f":"IF($B15=\"\",\"\",VLOOKUP($B15,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'Device specifications'!$A$2:$C29,2,FALSE))","v":""},{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'Device specifications'!$A$2:$C29,3,FALSE))","v":""},"","",{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'Device specifications'!$A$2:$C30,2,FALSE))","v":""},{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'Device specifications'!$A$2:$C30,3,FALSE))","v":""},"","",{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'Device specifications'!$A$2:$D$22,4,FALSE))","v":""},""]
[null,null,null,null,null,"","",null,""]
[null,null,null,null,null,"","",null,""]
[null,null,null,null,null,"","",null,""]
[null,null,null,null,null,{"$f":"SUM(F9:F20)","v":0},{"$f":"SUM(G9:G20)","v":0},null,{"$f":"SUM(I9:I20)","v":0}]
[{"$f":"IF(I21>120,\"ERROR! Loop load is above the maximum of 120 for a DA Quad\",\"\")","v":""}]
[{"$f":"IF(F21>450,\"ERROR! Loop current is above the maximum of 450mA for a DA Quad\",\"\")","v":""}]
["Loop lenght calculation results",null,null,null,null,null,"Resist. Ω/m","Device insertion resistance"]
["Maximum loop length using 0.8mm2 cable",null,{"$f":"IF(D25>E25,E25,D25)","v":920},{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G25)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G25)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,920,IF(I21<101,610,IF(I21<121,340,\"Error\")))","v":920},null,2.1364999999999999E-2,0.1]
["Maximum loop length using 1.0mm2 cable",null,{"$f":"IF(D26>E26,E26,D26)","v":1200},{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G26)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G26)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,1200,IF(I21<101,900,IF(I21<121,500,\"Error\")))","v":1200},null,1.7031999999999999E-2,"Calculation tolerance margin"]
["Maximum loop length using 1.5mm2 cable",null,1200,{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G27)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G27)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,1200,IF(I21<101,1200,IF(I21<121,900,\"Error\")))","v":1200},null,1.1186700000000001E-2,0.2]
["Maximum loop length using 2.5mm2 cable",null,1200,{"$f":"IF($F$21>0,IF(((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G28)/2*(1-$H$27)<1500,((((36-28)/$F$21*1000)-SUM($A$9:$A$20)*$H$25)/G28)/2*(1-$H$27),1500),\"\")","v":""},{"$f":"IF(I21<61,1200,IF(I21<101,1200,IF(I21<121,1200,\"Error\")))","v":1200},null,6.7120000000000001E-3]
[]
["Notes:\n1. Assuming a maximum total loop current of 450mA for the DAQ\n2. Assuming 1500m total maximum cable length regardless\n3. Assuming 28V minimum voltage at the end of the loop\n4. Assuming 36V nominal loop voltage at the DA Quad\n5. Max loop load is 120"]

{"sheet":"Device specifications","index":2,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Name","Nominal current (mA)","Alarm current (mA)","Loop load"]
["OvaLED",13,1]
["OvaLED recessed",13,1]
["OmniLED",13,1]
["OmniLED recessed",13,1]
["ExiLED (Default: 25% light output in normal mode)",13,1]
["ExiLED (High output: 50% light in normal mode)",22,1]
["Mains Monitor",0.48,0.48]
["IQ8Quad Heat detector",0.37,0.45]
["IQ8Quad optical and multidetector",0.39,0.47]
["IQ8Quad multidetector sounder or flash",0.15,2.8,2]
["IQ8Quad multidetector sounder/flash/speach",0.15,4.2,3]
["IQ8Quad Manual call point",0.38,0.44]
["IQ8Quad TAL",0.13,0.27]
["IQ8Quad TAM",0.43,0.49]
["Esser Third party transponder",1.25,1.25]
["Esser twelve relay transponder",0.1,0.1]
["IQ8Quad transponder 4-2",6,6]
["IQ8Quad Ex iso-barriere",2.5,2.5,3]
["Remote indicator lamp for detector",0.1,1]
["IQ8Alarm sounder",0.5,2.2000000000000002,3]
["IQ8Alarm flash/sounder/speach",0.5,4.0999999999999996,3]