{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Series Circuit Parameters","Lamp Load","LED Load","Sign Load","In-pavement RGL","Elevated RGL","Stop Bar","Other Loads","Load Summary","variables","SL Table"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":60,"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":"Series Circuit Parameters","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,3,16,4],[3,1,3,6],[5,1,5,6],[25,5,25,6],[2,3,2,7],[4,3,4,7],[8,3,8,4]]}
[]
[null," SERIES CIRCUIT PARAMETERS"]
[null,"A. ","Airport Name","<Enter Airport Name Here>"]
[]
[null,"B.","Circuit Identification (if applicable)","<Enter Circuit ID as required>"]
[]
[null,"C.","Maximum CCR Output Current",6.6," Amps "]
[]
[null,"D.","Number of CCR Steps","5-Step (2.8A-6.6A)"]
[]
[null,"E.","Input Voltage","480Vac"]
[]
[null,"F.","Frequency","60Hz"]
[]
[null,"G.","Series Circuit Cable Wire Length Units","Feet"]
[]
[null,"H.","CCR Architecture","Ferroresonant"]
[]
[null,"I.","Estimated roundtrip length of L-824 series circuit wire",10000,{"$f":"\" \" & $D$15 & \"\"","v":" Feet"}]
[]
[null,"J.","L-824 Wire Size",8," AWG"]
[]
[null,"K.","L-824 Wire Resistance (see note below)",0.66,{"$f":"\" ohms/1,000 \" & $D$15","v":" ohms/1,000 Feet"}]
[]
[null,null,"Wire Resistance Note: "]
[null,null,"For AWG 6, use 0.42 ohms/1,000 Feet","L-824 LOAD",null,{"$f":"ROUND((D7^2)*(D23*(D19/1000)),1)","v":287.5},null," VA"]
[null,null,"For AWG 8, use 0.66 ohms/1,000 Feet"]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"Lamp Load","index":1,"n_rows":126,"n_cols":15,"rows_kept":126,"cut":false,"hidden":false,"merged":[[2,0,123,0],[37,7,37,11],[41,3,41,4],[7,7,7,11],[5,7,5,8],[35,7,35,8],[65,7,65,8],[27,9,27,14],[31,1,31,15],[61,1,61,15],[79,3,80,5],[79,7,79,8],[104,3,104,10],[97,7,97,11],[11,3,11,4],[117,9,117,14],[121,13,123,15],[2,16,123,17],[3,14,11,14],[13,14,15,14],[33,14,41,14],[43,14,45,14],[57,9,57,14],[63,14,71,14],[73,14,75,14],[87,9,87,14],[93,14,101,14],[103,14,105,14],[109,3,110,5],[109,7,109,8],[13,3,13,6],[19,3,20,5],[19,7,19,8],[14,3,14,10],[43,3,43,6],[44,3,44,10],[101,3,101,4],[91,1,91,15],[49,3,50,5],[103,3,103,6],[74,3,74,10],[67,7,67,11],[71,3,71,4],[73,3,73,6],[95,7,95,8],[49,7,49,8]]}
[]
[null,"  Tungsten Halogen / Incandescent Lamp Fixture Load"]
[]
[null,"1.","Fixture Load Calculator #1",null,null,null,null,null,null,null,null,null,null,"*","Note: If fixture has multiple lamps, enter maximum wattage when maximum number of lamps are on. Example: For a bi-directional L-852D (with two 30W lamps) where both lamps can be on at the same time, enter 60W."]
[]
[null,null,"A.","Fixture Description",null,null,null,"L-850C"]
[]
[null,null,"B.","Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,100]
[]
[null,null,"D.","Fixture Wattage*",null,null,null,45," W"]
[]
[null,null,"E.","Are long secondary wires present?**",null,null,null,"No",null,null,null,null,null,"**","Note: \"No\" is automatically assumed if transformer is located underneath fixture."]
[]
[null,null,null,"1. Estimated roundtrip length of Isol. Tx. secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J18,VLOOKUP(J18,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G20*(J16/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer***",null,null,null,3," VA",null,null,null,null,"***","Note: Any other load not listed in calculator."]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H12+J20+H22","v":48}," VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,45," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H26,VLOOKUP(H26,variables!$L$5:$M$17,2,FALSE),0)","v":"9"}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total CCR Load for Fixture No. 1",null,{"$f":"H10*(H24+H28)","v":5700},"VA"]
[]
[]
[]
[null,"2.","Fixture Load Calculator #2",null,null,null,null,null,null,null,null,null,null,"*","Note: If fixture has multiple lamps, enter maximum wattage when maximum number of lamps are on. Example: For a bi-directional L-852D (with two 30W lamps) where both lamps can be on at the same time, enter 60W."]
[]
[null,null,"A.","Fixture Description",null,null,null,"L-850C"]
[]
[null,null,"B.","Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,1]
[]
[null,null,"D.","Fixture Wattage*",null,null,null,45," W"]
[]
[null,null,"E.","Are long secondary wires present?**",null,null,null,"No",null,null,null,null,null,"**","Note: \"No\" is automatically assumed if transformer is located underneath fixture."]
[]
[null,null,null,"1. Estimated roundtrip length of Isol. Tx. secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J48,VLOOKUP(J48,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G50*(J46/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer***",null,null,null,3," VA",null,null,null,null,"***","Note: Any other load not listed in calculator."]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H42+J50+H52","v":48}," VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,45," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H56,VLOOKUP(H56,variables!$L$5:$M$17,2,FALSE),0)","v":"9"}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total CCR Load for Fixture No. 1",null,{"$f":"H40*(H54+H58)","v":57},"VA"]
[]
[]
[]
[null,"3.","Fixture Load Calculator #3",null,null,null,null,null,null,null,null,null,null,"*","Note: If fixture has multiple lamps, enter maximum wattage when maximum number of lamps are on. Example: For a bi-directional L-852D (with two 30W lamps) where both lamps can be on at the same time, enter 60W."]
[]
[null,null,"A.","Fixture Description"]
[]
[null,null,"B.","Manufacturer"]
[]
[null,null,"C.","Number of Light Fixtures"]
[]
[null,null,"D.","Fixture Wattage*",null,null,null,null," W"]
[]
[null,null,"E.","Are long secondary wires present?**",null,null,null,"No",null,null,null,null,null,"**","Note: \"No\" is automatically assumed if transformer is located underneath fixture."]
[]
[null,null,null,"1. Estimated roundtrip length of Isol. Tx. secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J78,VLOOKUP(J78,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G80*(J76/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer***",null,null,null,null," VA",null,null,null,null,"***","Note: Any other load not listed in calculator."]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H72+J80+H82","v":0}," VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,null," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H86,VLOOKUP(H86,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total CCR Load for Fixture No. 1",null,{"$f":"H70*(H84+H88)","v":0},"VA"]
[]
[]
[]
[null,"4.","Fixture Load Calculator #4",null,null,null,null,null,null,null,null,null,null,"*","Note: If fixture has multiple lamps, enter maximum wattage when maximum number of lamps are on. Example: For a bi-directional L-852D (with two 30W lamps) where both lamps can be on at the same time, enter 60W."]
[]
[null,null,"A.","Fixture Description"]
[]
[null,null,"B.","Manufacturer"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,0]
[]
[null,null,"D.","Fixture Wattage*",null,null,null,null," W"]
[]
[null,null,"E.","Are long secondary wires present?**",null,null,null,"No",null,null,null,null,null,"**","Note: \"No\" is automatically assumed if transformer is located underneath fixture."]
[]
[null,null,null,"1. Estimated roundtrip length of Isol. Tx. secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J108,VLOOKUP(J108,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G110*(J106/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer***",null,null,null,3," VA",null,null,null,null,"***","Note: Any other load not listed in calculator."]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H102+J110+H112","v":3}," VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,45," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H116,VLOOKUP(H116,variables!$L$5:$M$17,2,FALSE),0)","v":"9"}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total CCR Load for Fixture No. 1",null,{"$f":"H100*(H114+H118)","v":0},"VA"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Tungsten-Halogen/Incandescent Lamp Load",null,{"$f":"L30+L60+L90+L120","v":5757},"VA"]
[]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"LED Load","index":2,"n_rows":129,"n_cols":13,"rows_kept":129,"cut":false,"hidden":false,"merged":[[2,0,126,0],[37,7,37,11],[41,3,41,4],[6,7,6,11],[49,3,50,5],[31,1,31,13],[12,3,12,6],[13,3,13,10],[14,3,15,8],[16,3,16,8],[68,7,68,11],[44,3,44,10],[72,3,72,4],[63,1,63,13],[122,1,122,5],[122,12,122,13],[18,3,19,5],[18,7,18,8],[43,3,43,6],[80,3,81,5],[2,15,2,19],[4,15,8,15],[74,3,74,6],[62,1,62,13],[47,3,47,8],[10,3,10,4],[126,1,126,13],[75,3,75,10],[76,3,77,8],[78,3,78,8],[125,2,125,5],[119,1,119,13],[121,1,121,13],[80,7,80,8],[93,1,93,13],[123,1,123,13],[125,7,125,13],[107,3,108,8],[99,7,99,11],[103,3,103,4],[109,3,109,8],[124,1,124,13],[111,7,111,8],[105,3,105,6],[111,3,112,5],[45,3,46,8],[106,3,106,10],[49,7,49,8]]}
[]
[null,"  LED FIXTURE LOAD",null,null,null,null,"Note:  Use the \"Other Loads\" sheet to enter LED PAPI, REIL and Wind Cone data."]
[null,"1.","Fixture Load Calculator #1"]
[]
[null,null,"A.","Fixture Description",null,null,null,"L-850B(L)"]
[]
[null,null,"B.","Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,20]
[]
[null,null,"D.","LED fixture load",null,null,null,12," VA"]
[]
[null,null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,null,"1. Estimated roundtrip length of Isolation Transformer secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J17,VLOOKUP(J17,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G19*(J15/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer *",null,null,null,0," VA"]
[null,null,null,"(Any other load not listed in calculator.)"]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H11+J19+H21","v":12},"VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,20," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H26,VLOOKUP(H26,variables!$L$5:$M$17,2,FALSE),0)","v":6}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total Fixture Load No. 1",null,{"$f":"H9*(H24+H28)","v":360}," VA"]
[]
[]
[]
[null,"2.","Fixture Load Calculator #2"]
[]
[null,null,"A.","Fixture Description",null,null,null,"L-852D(L)"]
[]
[null,null,"B.","Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,0]
[]
[null,null,"D.","LED fixture load",null,null,null,22," VA"]
[]
[null,null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,null,"1. Estimated roundtrip length of Isolation Transformer secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J48,VLOOKUP(J48,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G50*(J46/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer",null,null,null,2," VA"]
[null,null,null,"(Any other load not listed in calculator.)"]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H42+J50+H52","v":24},"VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,15," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H57,VLOOKUP(H57,variables!$L$5:$M$17,2,FALSE),0)","v":4.5}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total Fixture Load No. 2",null,{"$f":"H40*(H55+H59)","v":0}," VA"]
[]
[]
[]
[null,"3.","Fixture Load Calculator #3"]
[]
[null,null,"A.","Fixture Description",null,null,null,"L-862E(L)"]
[]
[null,null,"B.","Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,0]
[]
[null,null,"D.","LED fixture load",null,null,null,33," VA"]
[]
[null,null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,null,"1. Estimated roundtrip length of Isolation Transformer secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J79,VLOOKUP(J79,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G81*(J77/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer",null,null,null,3," VA"]
[null,null,null,"(Any other load not listed in calculator.)"]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H73+J81+H83","v":36},"VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,45," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H88,VLOOKUP(H88,variables!$L$5:$M$17,2,FALSE),0)","v":"9"}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total Fixture Load No. 3",null,{"$f":"H71*(H86+H90)","v":0}," VA"]
[]
[]
[]
[null,"4.","Fixture Load Calculator #4"]
[]
[null,null,"A.","Fixture Description",null,null,null,"L-850B(L)"]
[]
[null,null,"B.","Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,null,"C.","Number of Light Fixtures",null,null,null,0]
[]
[null,null,"D.","LED fixture load",null,null,null,22," VA"]
[]
[null,null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,null,"1. Estimated roundtrip length of Isolation Transformer secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,null,"3. Wire Resistance",null,null,{"$f":"IF(J110,VLOOKUP(J110,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(G112*(J108/1000)),1)","v":0}," VA"]
[]
[null,null,"F.","Other Load on Isolation Transformer",null,null,null,1," VA"]
[null,null,null,"(Any other load not listed in calculator.)"]
[]
[null,null,"G.","Total Isolation Transformer Load",null,null,null,{"$f":"H104+J112+H114","v":23},"VA"]
[]
[null,null,"H.","Isolation Transformer Used",null,null,null,25," W"]
[]
[null,null,"I.","Isolation Transformer Losses",null,null,null,{"$f":"IF(H119,VLOOKUP(H119,variables!$L$5:$M$17,2,FALSE),0)","v":7.5}," VA"]
[]
[null,null,null,null,null,null,null,null,null,"Total Fixture Load No. 4",null,{"$f":"H102*(H117+H121)","v":0}," VA"]
[]
[]
[null,null,"Total LED Fixture Load",null,null,null,{"$f":"L30+L61+L92+L123","v":360}," VA"]
[]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"Sign Load","index":3,"n_rows":125,"n_cols":9,"rows_kept":125,"cut":false,"hidden":false,"merged":[[121,1,121,7],[27,2,27,7],[28,1,28,7],[43,3,44,3],[43,5,43,6],[61,5,61,6],[97,1,97,7],[63,4,63,6],[71,5,71,7],[91,5,91,6],[67,5,67,6],[67,3,68,3],[73,1,73,7],[115,3,116,3],[115,5,115,6],[1,0,1,13],[19,3,20,3],[19,5,19,6],[13,5,13,6],[15,4,15,6],[13,9,13,13],[18,9,18,13],[3,0,122,0],[37,5,37,6],[39,4,39,6],[52,1,52,7],[50,1,50,7],[51,2,51,7],[85,5,85,6],[111,4,111,6],[49,1,49,7],[26,1,26,7],[6,9,6,13],[19,9,19,10],[15,9,15,13],[20,11,20,12],[109,5,109,6],[87,4,87,6],[91,3,92,3],[4,9,4,13],[20,10,23,10],[25,1,25,7],[12,9,12,13],[7,9,7,13],[9,9,9,13],[8,9,8,13],[10,9,10,13],[11,9,11,13],[24,9,24,13],[23,11,23,12],[22,11,22,12],[21,11,21,12]]}
[]
["  FAA L-858 / ICAO / TP312 Sign Load"]
[]
[null,"1.","Sign Load No. 1 Calculator",null,null,null,null,null,"Reference Data: "]
[]
[null,null,"A.","Sign Manufacturer",null,null,"ADB Safegate"]
[]
[null,null,"B.","Sign Size",null,null,"Size 2"]
[]
[null,null,"C.","Sign Modules (FAA) or Sign Length (ICAO/TP312)",null,null,"4 Module"]
[]
[null,null,"D.","Light Source",null,null,"LED"]
[]
[null,null,"E.","Sign Power Architecture",null,"FAA LED"]
[]
[null,null,"F.","Sign Style","Style 2 (4.8A - 6.6A) 3-step"]
[]
[null,null,"G.","Sign Transformer Used",null,null,300," W"]
[]
[null,null,"H.","Sign VA as seen on the primary of the isolation transformer",null,255,null," VA"]
[]
[null,null,"I.","Total Number of Signs in this Configuration",null,null,2]
[]
[null,null,null,"Total Sign Load No. 1",{"$f":"F20*G22","v":510}," VA"]
[]
[]
[]
[null,"2.","Sign Load No. 2 Calculator"]
[]
[null,null,"A.","Sign Manufacturer",null,null,"ADB Safegate"]
[]
[null,null,"B.","Sign Size",null,null,"Size 2"]
[]
[null,null,"C.","Sign Modules (FAA) or Sign Length (ICAO/TP312)",null,null,"4 Module"]
[]
[null,null,"D.","Light Source",null,null,"LED"]
[]
[null,null,"E.","Sign Power Architecture",null,"FAA LED"]
[]
[null,null,"F.","Sign Style","Style 3 (2.8A - 6.6A) 5-step"]
[]
[null,null,"G.","Sign Transformer Used",null,null,300," W"]
[]
[null,null,"H.","Sign VA as seen on the primary of the isolation transformer",null,255,null," VA"]
[]
[null,null,"I.","Total Number of Signs in this Configuration",null,null,0]
[]
[null,null,null,"Total Sign Load No. 2",{"$f":"F44*G46","v":0}," VA"]
[]
[]
[]
[null,"3.","Sign Load No. 3 Calculator"]
[]
[null,null,"A.","Sign Manufacturer",null,null,"ADB Safegate"]
[]
[null,null,"B.","Sign Size",null,null,"Size 2"]
[]
[null,null,"C.","Sign Modules (FAA) or Sign Length (ICAO/TP312)",null,null,"4 Module"]
[]
[null,null,"D.","Light Source",null,null,"LED"]
[]
[null,null,"E.","Sign Power Architecture",null,"FAA LED"]
[]
[null,null,"F.","Sign Style","Style 3 (2.8A - 6.6A) 5-step"]
[]
[null,null,"G.","Sign Transformer Used",null,null,300," W"]
[]
[null,null,"H.","Sign VA as seen on the primary of the isolation transformer",null,255,null," VA"]
[]
[null,null,"I.","Total Number of Signs in this Configuration",null,null,0]
[]
[null,null,null,"Total Sign Load No. 3",{"$f":"F68*G70","v":0}," VA"]
[]
[]
[]
[null,"4.","Sign Load No. 4 Calculator"]
[]
[null,null,"A.","Sign Manufacturer",null,null,"ADB Safegate"]
[]
[null,null,"B.","Sign Size",null,null,"Size 2"]
[]
[null,null,"C.","Sign Modules (FAA) or Sign Length (ICAO/TP312)",null,null,"4 Module"]
[]
[null,null,"D.","Light Source",null,null,"LED"]
[]
[null,null,"E.","Sign Power Architecture",null,"FAA LED"]
[]
[null,null,"F.","Sign Style","Style 3 (2.8A - 6.6A) 5-step"]
[]
[null,null,"G.","Sign Transformer Used",null,null,300," W"]
[]
[null,null,"H.","Sign VA as seen on the primary of the isolation transformer",null,255,null," VA"]
[]
[null,null,"I.","Total Number of Signs in this Configuration",null,null,0]
[]
[null,null,null,"Total Sign Load No. 4",{"$f":"F92*G94","v":0}," VA"]
[]
[]
[]
[null,"5.","Sign Load No. 5 Calculator"]
[]
[null,null,"A.","Sign Manufacturer",null,null,"ADB Safegate"]
[]
[null,null,"B.","Sign Size",null,null,"Size 2"]
[]
[null,null,"C.","Sign Modules (FAA) or Sign Length (ICAO/TP312)",null,null,"4 Module"]
[]
[null,null,"D.","Light Source",null,null,"LED"]
[]
[null,null,"E.","Sign Power Architecture",null,"FAA LED"]
[]
[null,null,"F.","Sign Style","Style 3 (2.8A - 6.6A) 5-step"]
[]
[null,null,"G.","Sign Transformer Used",null,null,300," W"]
[]
[null,null,"H.","Sign VA as seen on the primary of the isolation transformer",null,255,null," VA"]
[]
[null,null,"I.","Total Number of Signs in this Configuration",null,null,0]
[]
[null,null,null,"Total Sign Load No. 5",{"$f":"F116*G118","v":0}," VA"]
[]
[]
[null,null,null,"Total Sign Load",{"$f":"E24+E48+E72+E96+E120","v":510}," VA"]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"In-pavement RGL","index":4,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[38,6,39,8],[40,6,40,8],[41,6,41,8],[21,6,21,7],[32,1,32,8],[29,2,29,7],[25,2,25,9],[23,8,23,10],[27,2,27,9],[33,2,33,5],[17,2,18,7],[34,1,36,1],[24,1,24,5],[19,2,19,7],[21,2,22,4],[31,2,31,5],[35,2,35,12],[34,2,34,12],[36,2,36,12],[9,7,9,8],[5,2,5,5],[15,2,15,5],[6,2,6,7],[11,2,11,5],[10,1,10,7],[12,2,12,8],[14,1,14,7]]}
[]
[]
[]
[]
[null," In-Pavement Runway Guard Light (IRGL) Load"]
[null,"A.","Fixture Description",null,null,null,"L-852G(L)"]
[null,null,"Note: Use the Stop Bar tab if the fixture is a L-852G/S."]
[null,"B.","Fixture Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,"C.","Fixture Load",null,null,null,105," W or VA (LED)"]
[]
[null,"D.","Monitored or Unmonitored?",null,null,null,"Un-Monitored"]
[null,null,"Note: Selecting Unmonitored zeros out any load associated with the Master."]
[null,"E.","Isolation Transformer Wattage",null,null,null,45," W","  Select from dropdown or type-in"]
[]
[null,"F.","Are long secondary wires present?",null,null,null,"No"]
[null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,"1. Estimated roundtrip length of Isolation Transformer secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,"3. Wire Resistance",null,null,null,{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(F22*(I18/1000)),1)","v":0}," VA"]
[]
[null,"G. ","Type of Fixture Pulsing Device Used",null,null,null,null,null,"BRITE II Single Remote"]
[]
[null,null,"1. Other Pulsing Device Load plus isolation transformer loss when ON",null,null,null,null,null,null,null,149," VA"]
[null,null,"Note: Enter isolation transformer load if LED."]
[null,null,"2. Other Pulsing Device Load plus isolation transformer loss when OFF",null,null,null,null,null,null,null,70," VA"]
[null,null,"Note: Used for incandescent only. Enter 0 if LED."]
[null,"H.","Total Number of In-pavement Light Fixtures on Circuit",null,null,null,null,null,1]
[null,null,"Note: The load calculations assumes the fixtures alternately pulse according to FAA requirements. "]
[null,"I.","Any Other Load on CCR",null,null,null,0," VA"]
[]
[null,"J.","Monitoring Device Load (if present).",null,null,null,0," VA"]
[null,null,"Note: This, for example, is the BRITE/AGLAS Master load, if any."]
[null,null,"Note: This calculation assumes that there is no operational need to have all lights ON at the same time. If all the lights are ON, the CCR might be overloaded in at least the high step (B5/B100). The FAA requires that RGLs pulse in all operational modes: Power-on, Normal Operation, and Failsafe mode. Therefore, there is no operational situation in which RGL lights will be steady burning ON."]
[null,null,"There also might be a CCR loading consideration if pulsing RGLs are being phased in with existing steady-burning yellow hold bars and all lights will be steady-burning initially."]
[null,null,null,null,null,null,"Load Calculation"]
[null,null,null,null,null,null,"Max. CCR Load for Fixture + Pulsing Device + Transformer",null,null,null,{"$f":"I22+K26+K28","v":219}," VA"]
[]
[null,null,null,null,null,null,"Monitoring Device Load + Other Load",null,null,null,{"$f":"IF(G12=\"Monitored\",G34,0)+G32","v":0}," VA"]
[null,null,null,null,null,null,"Total In-pavement RGL Fixture load",null,null,null,{"$f":"K41+(I30*K39)","v":219}," VA"]
[]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"Elevated RGL","index":5,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[14,2,15,6],[18,6,18,7],[28,2,28,5]]}
[]
[" Elevated L-804 Runway Guard Light (RGL)"]
[]
[null,"A.","Fixture Description",null,null,null,"L-804"]
[null,null,"Note: Use the Stop Bar tab if the L-804 is on the same circuit as the Stop Bar."]
[null,"B.","Fixture Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,"C.","Fixture Load",null,null,null,100," W or VA (LED)"]
[null,null,"Note: Enter the wattage for only one of the two lamps in the L-804 (since only one is on at a time.)"]
[null,"D. ","Type of Fixture Pulsing Device Used",null,null,null,"BRITE III Dual Remote (AGLAS)"]
[null,null,"Note: Entering PCB version inserts load for PCB only and auto zeros anything associated with BRITE / AGLAS / LINC 360"]
[null,null,"1. Pulsing Device Load.",null,null,null,null,"Note:Enter zero if LED.",25," VA"]
[null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,"1. Estimated roundtrip length of Isolation Transformer secondary wire",null,null,null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,"2. Isolation Transformer Secondary Wire Gauge",null,null,null,null,null,null," AWG"]
[]
[null,null,"3. Wire Resistance",null,null,null,{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(F19*(I15/1000)),1)","v":0}," VA"]
[]
[null,"F.","Total Isolation Transformer Load",null,null,null,{"$f":"G8+I12+I19","v":125},"VA"]
[]
[null,"G.","Isolation Transformer Wattage",null,null,null,null," W"]
[]
[null,null,"Isolation Transformer Losses",null,null,null,{"$f":"IF(G21,VLOOKUP(G23,variables!$L$5:$M$17,2,FALSE),0)","v":{"$error":"#N/A"}},"VA"]
[]
[null,"H.","Total Number of Elevated Light Fixtures on Circuit",null,null,null,null,null,4]
[null,null,"Note: The load calculations assumes the fixtures alternately pulse according to FAA requirements. "]
[null,"I.","Any Other Load on CCR",null,null,null,0," VA"]
[]
[null,"J.","Monitored or Unmonitored?",null,null,null,"Un-Monitored"]
[null,null,"Note: Selecting Unmonitored zeros out any load associated with the Master."]
[null,"K.","Monitoring Device Load (if present).",null,null,null,0," VA"]
[null,null,"Note: This, for example, is the BRITE/AGLAS Master load, if any."]
[]
[null,null,null,null,null,null,"Load Calculation"]
[null,null,null,null,null,null,"Max. CCR Load for Fixture + Pulsing Device + Transformer Losses",null,null,{"$f":"G21+G25","v":{"$error":"#N/A"}}," VA"]
[null,null,null,null,null,null,"Monitoring Device Load + Other Load",null,null,{"$f":"IF(G31=\"Monitored\",G33,0)+G29","v":0}," VA"]
[null,null,null,null,null,null,"Total Elevated RGL Fixture Load ",null,null,{"$f":"J38+(I27*J37)","v":{"$error":"#N/A"}}," VA"]
[]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"Stop Bar","index":6,"n_rows":136,"n_cols":11,"rows_kept":136,"cut":false,"hidden":false,"merged":[[117,4,117,5],[86,2,86,5],[74,2,74,5],[119,2,119,5],[97,1,98,1],[84,4,84,5],[97,2,97,8],[89,1,89,5],[78,8,80,8],[72,2,72,5],[11,2,11,3],[44,2,44,5],[21,4,21,5],[15,2,15,5],[40,2,40,4],[76,2,76,5],[78,2,78,5],[50,4,50,5]]}
[]
[null,"Stop Bar Loads, with or without In-pavement & Elevated RGL Loads"]
[]
["In-pavement Stop Bar"]
[]
[null,"A.","Fixture Description",null,null,null,"L-852S"]
[]
[null,"B.","Fixture Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,"C.","Fixture Load",null,null,null,53," W or VA (LED)"]
[]
[null,"D. ","Type of Control/Monitoring Device Used"]
[]
[null,null,"1. Max. Control/Monitoring Device Load",null,null,null,null," VA"]
[]
[null,"E.","Are long secondary wires present?",null,null,null,"Yes"]
[null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,"1. Estimated roundtrip length of L-830 secondary wire",null,null,null,5,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,"2. L-830 Secondary Wire Gauge",null,null,null,16," AWG"]
[]
[null,null,"3. Wire Resistance and Load",{"$f":"IF(G20,VLOOKUP(G20,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":4.3499999999999996},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(D22*(G18/1000)),1)","v":0.9}," VA"]
[]
[null,"F.","Isolation Transformer Wattage",null,null,null,45," W"]
[]
[null,"G.","Isolation Transformer Losses",null,null,null,{"$f":"IF(G24,VLOOKUP(G24,variables!$L$5:$M$17,2,FALSE),0)","v":"9"}," VA"]
[]
[null,"H.","Total Individual Fixture CCR Load",null,null,null,{"$f":"G10+G14+G22+G26","v":62.9}," VA",null,"SubTotal"]
[]
[null,"I.","Total Number of In-pavement Stop Bar Fixtures on Circuit",null,null,null,10,null,null,{"$f":"G30*G28","v":629}," VA"]
[]
[]
[null,"Elevated Stop Bar"]
[]
[null,"A.","Fixture Description",null,null,null,"L-862S"]
[]
[null,"B.","Fixture Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,"C.","Fixture Load",null,null,null,150," W or VA (LED)"]
[]
[null,"D. ","Type of Control/Monitoring Device Used",null,null,null,"BRITE III (AGLAS) Single Remote"]
[]
[null,null,"1. Max. Control/Monitoring Device Load",null,null,null,25," VA"]
[]
[null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,"1. Estimated roundtrip length of L-830 secondary wire",null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,"2. L-830 Secondary Wire Gauge",null,null,null,null," AWG"]
[]
[null,null,"3. Wire Resistance",{"$f":"IF(G49,VLOOKUP(G49,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(D51*(G47/1000)),1)","v":0}," VA"]
[]
[null,"F.","Isolation Transformer Wattage",null,null,null,150," W"]
[]
[null,"G.","Isolation Transformer Losses",null,null,null,{"$f":"IF(G53,VLOOKUP(G53,variables!$L$5:$M$17,2,FALSE),0)","v":20}," VA"]
[]
[null,"H.","Total Individual Fixture CCR Load",null,null,null,{"$f":"G39+G43+G51+G55","v":195}," VA",null,"SubTotal"]
[]
[null,"I.","Total Number of Elevated Stop Bar Fixtures on Circuit",null,null,null,2,null,null,{"$f":"G59*G57","v":390}," VA"]
[]
[null,"Sensor Load"]
[]
[null,"A.","Type of Sensor Used",null,null,null,"Inductive Loop"]
[]
[null,"B.","Individual Sensor + Isolation Transformer (if present) Load ",null,null,null,564,"VA",null,"SubTotal"]
[]
[null,"C.","Total number of sensors",null,null,null,2,null,null,{"$f":"G65*G67","v":1128}," VA"]
[]
[]
[]
[null,"In-pavement RGL Load Calculator (L-852G Side only in RVR >1200 ft.)"]
[]
[null,"A.","Fixture Description",null,null,null,"L-852G"]
[]
[null,"B.","Fixture Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,"C.","Fixture Load",null,null,null,105," W or VA (LED)"]
[]
[null,"D.","Are long secondary wires present?",null,null,null,"No"]
[null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,"1. Estimated roundtrip length of L-830 secondary wire",null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,"2. L-830 Secondary Wire Gauge",null,null,null,null," AWG"]
[]
[null,null,"3. Wire Resistance",{"$f":"IF(G83,VLOOKUP(G83,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(D85*(G81/1000)),1)","v":0}," VA"]
[]
[null,"E.","Isolation Transformer Wattage",null,null,null,100," W"]
[]
[null,"F.","Type of Fixture Pulsing Device Used",null,null,null,"BRITE II Single Remote"]
[]
[null,null,"1. Other Pulsing Device Load plus isolation transformer loss when ON",null,null,null,149," VA"]
[null,null,"Note: Enter isolation transformer load if LED."]
[null,null,"2. Other Pulsing Device Load plus isolation transformer loss when OFF",null,null,null,70," VA"]
[null,null,"Note: Used for incandescent only. Enter 0 if LED.",null,null,null,null,null,null,"SubTotal"]
[null,"G.","Total Number of In-pavement Light Fixtures on Circuit",null,null,null,33,null,null,{"$f":"(G91+G93)*G95","v":7227}," VA"]
[null,null,"Note: The load calculations assumes the fixtures alternately pulse according to FAA requirements. "]
[]
[null,null,"Note: This calculation assumes that there is no operational need to have all lights ON at the same time. If all the lights are ON, the CCR might be overloaded in at least the high step (B5/B100). The FAA requires that RGLs pulse in all operational modes: Power-on, Normal Operation, and Failsafe mode. Therefore, there is no operational situation in which RGL lights will be steady burning ON."]
[]
[" Elevated L-804 Runway Guard Light (RGL)"]
[]
[null,"A.","Fixture Description",null,null,null,"L-804"]
[null,null,"Note: Use this Stop Bar tab if the L-804 is on the same circuit as the Stop Bar."]
[null,"B.","Fixture Manufacturer",null,null,null,"ADB Safegate"]
[]
[null,"C.","Fixture Load",null,null,null,100," W or VA (LED)"]
[null,null,"Note: Enter the wattage for only one of the two lamps in the L-804 (since only one is on at a time.)"]
[null,"D. ","Type of Fixture Pulsing Device Used",null,null,null,"BRITE II Dual Remote"]
[null,null,"Note: Entering PCB version inserts load for PCB only and auto zeros anything associated with BRITE / AGLAS"]
[null,null,"1. Pulsing Device Load.",null,null,null,20," VA"]
[null,null," Note: Enter zero if LED."]
[null,"E.","Are long secondary wires present?",null,null,null,"No"]
[null,null,"Note: Zero is automatically assumed if transformer is located underneath fixture.  "]
[null,null,"1. Estimated roundtrip length of L-830 secondary wire",null,null,null,null,{"$f":"\" \" & 'Series Circuit Parameters'!$D$15 & \"\"","v":" Feet"}]
[]
[null,null,"2. L-830 Secondary Wire Gauge",null,null,null,null," AWG"]
[]
[null,null,"3. Wire Resistance",{"$f":"IF(G116,VLOOKUP(G116,variables!$I$8:$K$9,variables!$J$1,FALSE),0)","v":0},{"$f":"\" ohms / 1000 \" & 'Series Circuit Parameters'!$D$15","v":" ohms / 1000 Feet"},null,{"$f":"ROUND(('Series Circuit Parameters'!$D$7^2)*(D118*(G114/1000)),1)","v":0}," VA"]
[]
[null,"F.","Isolation Transformer Wattage",null,null,null,100," W"]
[]
[null,"G.","Isolation Transformer Losses",null,null,null,{"$f":"IF(G120,VLOOKUP(G120,variables!$L$5:$M$17,2,FALSE),0)","v":15}," VA"]
[]
[null,"H.","Max CCR Load for Fixture + Pulsing Device + Transformer",null,null,null,{"$f":"G106+G110+G118+G122","v":135}," VA",null,"SubTotal"]
[]
[null,"I.","Total Number of Elevated Light Fixtures on Circuit",null,null,null,4,null,null,{"$f":"G126*G124","v":540}," VA"]
[null,null,"Note: The load calculations assumes the fixtures alternately pulse according to FAA requirements. "]
[]
[null,"Control/Monitoring Interface Device Load"]
[null,"A.","Monitoring Device Load (if present).",null,null,null,32," VA"]
[null,null,"Note: This, for example, is the BRITE/AGLAS Master load, if any.",null,null,null,null,null,null,"SubTotal"]
[null,"B.","Any Other Load",null,null,null,0," VA",null,{"$f":"G130+G132","v":32}," VA"]
[]
[null,null,null,null,null,null,null,null,"Total Stop Bar Load",{"$f":"J30+J59+J67+J95+J126+J132","v":9946}," VA"]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"Other Loads","index":7,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[2,0,86,0],[4,10,4,13],[3,2,3,5],[3,10,3,13],[54,2,54,5],[37,2,37,5],[37,10,37,13],[20,10,20,13],[20,2,20,5],[4,2,4,5],[72,2,72,5],[72,10,72,13],[87,1,87,9],[38,2,38,5],[38,10,38,13],[90,2,90,15],[21,2,21,5],[21,10,21,13],[22,2,22,5],[55,2,55,5],[55,10,55,13],[54,10,54,13],[71,10,71,13],[71,2,71,5]]}
[]
[null,"Other Load(s)",null,null,null,null,null,null,null,null,null,null,null,"* = Select from dropdown or type in value"]
[]
[null,"1.","Other Load Description (Select From Dropdown or Type-in)",null,null,null,null,null,null,"2.","Other Load Description (Select From Dropdown or Type-in)"]
[null,"*","4-Box (L-880) Type B (Current Driven) Single Channel PAPI",null,null,null,null,null,null,"*"]
[]
[null,null,"Device VA ",310," VA",null,null,null,null,null,"Device VA ",null," VA"]
[]
[null,null,"Isolation Transformer Used (if any) ",300," VA",null,null,null,null,null,"Isolation Transformer Used (if any) ",null," VA"]
[]
[null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(D9,VLOOKUP(D9,variables!$L$5:$M$17,2,FALSE),0)","v":30}," VA",null,null,null,null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(L9,VLOOKUP(L9,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA"]
[]
[null,null,"Other Losses (if any) ",null," VA",null,null,null,null,null,"Other Losses (if any) ",null," VA"]
[]
[null,null,"Quantity",1,null,null,null,null,null,null,"Quantity"]
[]
[null,null,"Total Load ",{"$f":"(D7+D11+D13)*D15","v":340}," VA",null,null,null,null,null,"Total Load ",{"$f":"(L7+L11+L13)*L15","v":0}," VA"]
[]
[]
[]
[null,"3.","Other Load Description (Select From Dropdown or Type-in)",null,null,null,null,null,null,"4.","Other Load Description (Select From Dropdown or Type-in)"]
[null,"*",null,null,null,null,null,null,null,"*"]
[]
[null,null,"Device VA ",null," VA",null,null,null,null,null,"Device VA ",null," VA"]
[]
[null,null,"Isolation Transformer Used (if any) ",null," VA",null,null,null,null,null,"Isolation Transformer Used (if any) ",null," VA"]
[]
[null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(D26,VLOOKUP(D26,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA",null,null,null,null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(L26,VLOOKUP(L26,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA"]
[]
[null,null,"Other Losses (if any) ",null," VA",null,null,null,null,null,"Other Losses (if any) ",null," VA"]
[]
[null,null,"Quantity",null,null,null,null,null,null,null,"Quantity"]
[]
[null,null,"Total Load ",{"$f":"(D24+D28+D30)*D32","v":0}," VA",null,null,null,null,null,"Total Load ",{"$f":"(L24+L28+L30)*L32","v":0}," VA"]
[]
[]
[]
[null,"5.","Other Load Description (Select From Dropdown or Type-in)",null,null,null,null,null,null,"6.","Other Load Description (Select From Dropdown or Type-in)"]
[null,"*",null,null,null,null,null,null,null,"*"]
[]
[null,null,"Device VA ",null," VA",null,null,null,null,null,"Device VA ",null," VA"]
[]
[null,null,"Isolation Transformer Used (if any) ",null," VA",null,null,null,null,null,"Isolation Transformer Used (if any) ",null," VA"]
[]
[null,null,"Isolation Transformer Losses (if any) ",null," VA",null,null,null,null,null,"Isolation Transformer Losses (if any) ",null," VA"]
[]
[null,null,"Other Losses (if any) ",null," VA",null,null,null,null,null,"Other Losses (if any) ",null," VA"]
[]
[null,null,"Quantity",null,null,null,null,null,null,null,"Quantity"]
[]
[null,null,"Total Load ",{"$f":"(D41+D45+D47)*D49","v":0}," VA",null,null,null,null,null,"Total Load ",{"$f":"(L41+L45+L47)*L49","v":0}," VA"]
[]
[]
[]
[null,"7.","Other Load Description (Select From Dropdown or Type-in)",null,null,null,null,null,null,"8.","Other Load Description (Select From Dropdown or Type-in)"]
[null,"*",null,null,null,null,null,null,null,"*"]
[]
[null,null,"Device VA ",null," VA",null,null,null,null,null,"Device VA ",null," VA"]
[]
[null,null,"Isolation Transformer Used (if any) ",null," VA",null,null,null,null,null,"Isolation Transformer Used (if any) ",null," VA"]
[]
[null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(D60,VLOOKUP(D60,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA",null,null,null,null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(L60,VLOOKUP(L60,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA"]
[]
[null,null,"Other Losses (if any) ",null," VA",null,null,null,null,null,"Other Losses (if any) ",null," VA"]
[]
[null,null,"Quantity",null,null,null,null,null,null,null,"Quantity"]
[]
[null,null,"Total Load ",{"$f":"(D58+D62+D64)*D66","v":0}," VA",null,null,null,null,null,"Total Load ",{"$f":"(L58+L62+L64)*L66","v":0}," VA"]
[]
[]
[]
[null,"9.","Other Load Description (Select From Dropdown or Type-in)",null,null,null,null,null,null,"10.","Other Load Description (Select From Dropdown or Type-in)"]
[null,"*",null,null,null,null,null,null,null,"*"]
[]
[null,null,"Device VA ",null," VA",null,null,null,null,null,"Device VA ",null," VA"]
[]
[null,null,"Isolation Transformer Used (if any) ",null," VA",null,null,null,null,null,"Isolation Transformer Used (if any) ",null," VA"]
[]
[null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(D77,VLOOKUP(D77,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA",null,null,null,null,null,"Isolation Transformer Losses (if any) ",{"$f":"IF(L77,VLOOKUP(L77,variables!$L$5:$M$17,2,FALSE),0)","v":0}," VA"]
[]
[null,null,"Other Losses (if any) ",null," VA",null,null,null,null,null,"Other Losses (if any) ",null," VA"]
[]
[null,null,"Quantity",null,null,null,null,null,null,null,"Quantity"]
[]
[null,null,"Total Load ",{"$f":"(D75+D79+D81)*D83","v":0}," VA",null,null,null,null,null,"Total Load ",{"$f":"(L75+L79+L81)*L83","v":0}," VA"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Other Load",{"$f":"$D17+$L17+$D34+$L34+$D51+$L51+$D68+$L68+$D85+$L85","v":340}," VA"]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"Load Summary","index":8,"n_rows":76,"n_cols":14,"rows_kept":76,"cut":false,"hidden":false,"merged":[[18,1,18,6],[73,0,73,1]]}
[]
[]
["CCR Load Summary"]
[]
["Airport Name",{"$f":"'Series Circuit Parameters'!D3 & \"\"","v":"<Enter Airport Name Here>"}]
[]
["Circuit Identification",{"$f":"'Series Circuit Parameters'!D5 & \"\"","v":"<Enter Circuit ID as required>"}]
[]
["Maximum CCR Output Current",{"$f":"'Series Circuit Parameters'!D7 & \"\"","v":"6.6"}]
[]
["Number of CCR Steps",{"$f":"'Series Circuit Parameters'!D9 & \"\"","v":"5-Step (2.8A-6.6A)"}]
[]
["Input Voltage",{"$f":"'Series Circuit Parameters'!D11 & \"\"","v":"480Vac"}]
[]
["Frequency",{"$f":"'Series Circuit Parameters'!D13 & \"\"","v":"60Hz"}]
[]
["CCR Architecture",{"$f":"'Series Circuit Parameters'!D17 & \"\"","v":"Ferroresonant"}]
[]
["Load Description","Device Description",null,null,null,null,null,"Manuf.","Isolation Transformer Used","Qty.","Individual Device CCR Load VA","Subtotal Load VA","Subtotal Load Type VA"]
["Lamp Load 1",{"$f":"'Lamp Load'!H6 & \"\"","v":"L-850C"},null,null,null,null,null,{"$f":"'Lamp Load'!H8 & \"\"","v":"ADB Safegate"},{"$f":"'Lamp Load'!H26 & \"W\"","v":"45W"},{"$f":"'Lamp Load'!H10","v":100},{"$f":"'Lamp Load'!H12","v":45},{"$f":"'Lamp Load'!L30","v":5700}]
["Lamp Load 2",{"$f":"'Lamp Load'!H36 & \"\"","v":"L-850C"},null,null,null,null,null,{"$f":"'Lamp Load'!H38 & \"\"","v":"ADB Safegate"},{"$f":"'Lamp Load'!H56 & \"W\"","v":"45W"},{"$f":"'Lamp Load'!H40","v":1},{"$f":"'Lamp Load'!H42","v":45},{"$f":"'Lamp Load'!L60","v":57}]
["Lamp Load 3",{"$f":"'Lamp Load'!H66 & \"\"","v":""},null,null,null,null,null,{"$f":"'Lamp Load'!H68 & \"\"","v":""},{"$f":"'Lamp Load'!H86 & \"W\"","v":"W"},{"$f":"'Lamp Load'!H70","v":0},{"$f":"'Lamp Load'!H72","v":0},{"$f":"'Lamp Load'!L90","v":0}]
["Lamp Load 4",{"$f":"'Lamp Load'!H96 & \"\"","v":""},null,null,null,null,null,{"$f":"'Lamp Load'!H98 & \"\"","v":""},{"$f":"'Lamp Load'!H116 & \"W\"","v":"45W"},{"$f":"'Lamp Load'!H100","v":0},{"$f":"'Lamp Load'!H102","v":0},{"$f":"'Lamp Load'!L120","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Lamp Load",{"$f":"ROUND(lampVAtotal,0)","v":5757},"VA"]
["LED Load 1",{"$f":"'LED Load'!H5 & \"\"","v":"L-850B(L)"},null,null,null,null,null,{"$f":"'LED Load'!H7 & \"\"","v":"ADB Safegate"},{"$f":"'LED Load'!H26 & \"W\"","v":"20W"},{"$f":"'LED Load'!H9","v":20},{"$f":"'LED Load'!H11","v":12},{"$f":"'LED Load'!L30","v":360}]
["LED Load 2",{"$f":"'LED Load'!H36 & \"\"","v":"L-852D(L)"},null,null,null,null,null,{"$f":"'LED Load'!H38 & \"\"","v":"ADB Safegate"},{"$f":"'LED Load'!H57 & \"W\"","v":"15W"},{"$f":"'LED Load'!H40","v":0},{"$f":"'LED Load'!H42","v":22},{"$f":"'LED Load'!L61","v":0}]
["LED Load 3",{"$f":"'LED Load'!H67 & \"\"","v":"L-862E(L)"},null,null,null,null,null,{"$f":"'LED Load'!H69 & \"\"","v":"ADB Safegate"},{"$f":"'LED Load'!H88 & \"W\"","v":"45W"},{"$f":"'LED Load'!H71","v":0},{"$f":"'LED Load'!H73","v":33},{"$f":"'LED Load'!L92","v":0}]
["LED Load 4",{"$f":"'LED Load'!H98 & \"\"","v":"L-850B(L)"},null,null,null,null,null,{"$f":"'LED Load'!H100 & \"\"","v":"ADB Safegate"},{"$f":"'LED Load'!H119 & \"W\"","v":"25W"},{"$f":"'LED Load'!H102","v":0},{"$f":"'LED Load'!H104","v":22},{"$f":"'LED Load'!L123","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total LED Load",{"$f":"ROUND(LEDVAtotal,0)","v":360},"VA"]
["Sign Load 1","Sign",{"$f":"'Sign Load'!G8 & \"\"","v":"Size 2"},{"$f":"'Sign Load'!G10 & \"\"","v":"4 Module"},{"$f":"'Sign Load'!G12 & \"\"","v":"LED"},{"$f":"'Sign Load'!F14 & \"\"","v":"FAA LED"},{"$f":"'Sign Load'!E16 & \"\"","v":"Style 2 (4.8A - 6.6A) 3-step"},{"$f":"'Sign Load'!G6 & \"\"","v":"ADB Safegate"},{"$f":"signTX1 & \"W\"","v":"300W"},{"$f":"'Sign Load'!G22 & \"\"","v":"2"},{"$f":"'Sign Load'!F20 & \"\"","v":"255"},{"$f":"'Sign Load'!E24","v":510}]
["Sign Load 2","Sign",{"$f":"'Sign Load'!G32 & \"\"","v":"Size 2"},{"$f":"'Sign Load'!G34 & \"\"","v":"4 Module"},{"$f":"'Sign Load'!G36 & \"\"","v":"LED"},{"$f":"'Sign Load'!F38 & \"\"","v":"FAA LED"},{"$f":"'Sign Load'!E40 & \"\"","v":"Style 3 (2.8A - 6.6A) 5-step"},{"$f":"'Sign Load'!G30 & \"\"","v":"ADB Safegate"},{"$f":"signTX2 & \"W\"","v":"300W"},{"$f":"'Sign Load'!G46 & \"\"","v":"0"},{"$f":"'Sign Load'!F44 & \"\"","v":"255"},{"$f":"'Sign Load'!E48","v":0}]
["Sign Load 3","Sign",{"$f":"'Sign Load'!G56 & \"\"","v":"Size 2"},{"$f":"'Sign Load'!G58 & \"\"","v":"4 Module"},{"$f":"'Sign Load'!G60 & \"\"","v":"LED"},{"$f":"'Sign Load'!F62 & \"\"","v":"FAA LED"},{"$f":"'Sign Load'!E64 & \"\"","v":"Style 3 (2.8A - 6.6A) 5-step"},{"$f":"'Sign Load'!G54 & \"\"","v":"ADB Safegate"},{"$f":"signTX3 & \"W\"","v":"300W"},{"$f":"'Sign Load'!G70 & \"\"","v":"0"},{"$f":"'Sign Load'!F68 & \"\"","v":"255"},{"$f":"'Sign Load'!E72","v":0}]
["Sign Load 4","Sign",{"$f":"'Sign Load'!G80 & \"\"","v":"Size 2"},{"$f":"'Sign Load'!G82 & \"\"","v":"4 Module"},{"$f":"'Sign Load'!G84 & \"\"","v":"LED"},{"$f":"'Sign Load'!F86 & \"\"","v":"FAA LED"},{"$f":"'Sign Load'!E88 & \"\"","v":"Style 3 (2.8A - 6.6A) 5-step"},{"$f":"'Sign Load'!G78 & \"\"","v":"ADB Safegate"},{"$f":"signTX4 & \"W\"","v":"300W"},{"$f":"'Sign Load'!G94 & \"\"","v":"0"},{"$f":"'Sign Load'!F92 & \"\"","v":"255"},{"$f":"'Sign Load'!E96","v":0}]
["Sign Load 5","Sign",{"$f":"'Sign Load'!G104 & \"\"","v":"Size 2"},{"$f":"'Sign Load'!G106 & \"\"","v":"4 Module"},{"$f":"'Sign Load'!G108 & \"\"","v":"LED"},{"$f":"'Sign Load'!F110 & \"\"","v":"FAA LED"},{"$f":"'Sign Load'!E112 & \"\"","v":"Style 3 (2.8A - 6.6A) 5-step"},{"$f":"'Sign Load'!G102 & \"\"","v":"ADB Safegate"},{"$f":"signTX5 & \"W\"","v":"300W"},{"$f":"'Sign Load'!G118 & \"\"","v":"0"},{"$f":"'Sign Load'!F116 & \"\"","v":"255"},{"$f":"'Sign Load'!E120","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Sign Load",{"$f":"ROUND(signVAtotal,0)","v":510},"VA"]
["In-pavement RGL Fixture Load",{"$f":"'In-pavement RGL'!G6","v":"L-852G(L)"},{"$f":"'In-pavement RGL'!G12 & \"\"","v":"Un-Monitored"},null,null,null,null,{"$f":"'In-pavement RGL'!G8 & \"\"","v":"ADB Safegate"},{"$f":"'In-pavement RGL'!G14 & \"W\"","v":"45W"},{"$f":"'In-pavement RGL'!I30","v":1},{"$f":"'In-pavement RGL'!G10","v":105},{"$f":"'In-pavement RGL'!K39","v":219}]
["In-pavement RGL Monitoring Device Load",null,null,null,null,null,null,{"$f":"'In-pavement RGL'!G8 & \"\"","v":"ADB Safegate"},null,{"$f":"IF('In-pavement RGL'!G34,1,0)","v":0},{"$f":"'In-pavement RGL'!G34","v":0},{"$f":"'In-pavement RGL'!K41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total In-pavement RGL Load",{"$f":"ROUND(irglVAtotal,0)","v":219},"VA"]
["Elevated RGL Fixture Load",{"$f":"'Elevated RGL'!G4","v":"L-804"},{"$f":"'Elevated RGL'!G31 & \"\"","v":"Un-Monitored"},null,null,null,null,{"$f":"'Elevated RGL'!G6 & \"\"","v":"ADB Safegate"},{"$f":"'Elevated RGL'!G23 & \"W\"","v":"W"},{"$f":"'Elevated RGL'!I27","v":4},{"$f":"'Elevated RGL'!G8","v":100},{"$f":"'Elevated RGL'!J37","v":{"$error":"#N/A"}}]
["Elevated RGL Monitoring Device Load",null,null,null,null,null,null,null,null,null,null,{"$f":"'Elevated RGL'!J38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Elevated RGL Load",{"$f":"ROUND(L804VAtotal,0)","v":{"$error":"#N/A"}},"VA"]
["Stop Bar In-pavement Load",{"$f":"'Stop Bar'!G6 & \"\"","v":"L-852S"},null,null,null,null,null,{"$f":"'Stop Bar'!G8 & \"\"","v":"ADB Safegate"},{"$f":"'Stop Bar'!G24 & \"W\"","v":"45W"},{"$f":"'Stop Bar'!G30","v":10},{"$f":"'Stop Bar'!G28","v":62.9},{"$f":"'Stop Bar'!J30","v":629}]
["Stop Bar Elevated Fixture Load",{"$f":"'Stop Bar'!G35 & \"\"","v":"L-862S"},null,null,null,null,null,{"$f":"'Stop Bar'!G37 & \"\"","v":"ADB Safegate"},{"$f":"'Stop Bar'!G53 & \"W\"","v":"150W"},{"$f":"'Stop Bar'!G59","v":2},{"$f":"'Stop Bar'!G57","v":195},{"$f":"'Stop Bar'!J59","v":390}]
["Stop Bar Sensor Load",{"$f":"'Stop Bar'!G63 & \"\"","v":"Inductive Loop"},null,null,null,null,null,null,null,{"$f":"'Stop Bar'!G67","v":2},{"$f":"'Stop Bar'!G65 & \"W\"","v":"564W"},{"$f":"'Stop Bar'!J67","v":1128}]
["Stop Bar Elevated RGL Load",{"$f":"'Stop Bar'!G73 & \"\"","v":"L-852G"},null,null,null,null,null,{"$f":"'Stop Bar'!G104 & \"\"","v":"ADB Safegate"},{"$f":"'Stop Bar'!G120 & \"W\"","v":"100W"},{"$f":"'Stop Bar'!G126","v":4},{"$f":"'Stop Bar'!G106","v":100},{"$f":"'Stop Bar'!J126","v":540}]
["Stop Bar Monitoring Device Load",null,null,null,null,null,null,null,null,null,null,{"$f":"'Stop Bar'!J132","v":32}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Stop Bar Load",{"$f":"ROUND(stopbarVAtotal,0)","v":9946},"VA"]
["Other Load 1",{"$f":"'Other Loads'!C5 & \"\"","v":"4-Box (L-880) Type B (Current Driven) Single Channel PAPI"},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$D15","v":1},{"$f":"'Other Loads'!$D7","v":310},{"$f":"'Other Loads'!$D17","v":340}]
["Other Load 2",{"$f":"'Other Loads'!K5 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$L15","v":0},{"$f":"'Other Loads'!$L7","v":0},{"$f":"'Other Loads'!$L17","v":0}]
["Other Load 3",{"$f":"'Other Loads'!C22 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$D32","v":0},{"$f":"'Other Loads'!$D24","v":0},{"$f":"'Other Loads'!$D34","v":0}]
["Other Load 4",{"$f":"'Other Loads'!K22 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$L32","v":0},{"$f":"'Other Loads'!$L24","v":0},{"$f":"'Other Loads'!$L34","v":0}]
["Other Load 5",{"$f":"'Other Loads'!C39 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$D49","v":0},{"$f":"'Other Loads'!$D41","v":0},{"$f":"'Other Loads'!$D51","v":0}]
["Other Load 6",{"$f":"'Other Loads'!K39 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$L49","v":0},{"$f":"'Other Loads'!$L41","v":0},{"$f":"'Other Loads'!$L51","v":0}]
["Other Load 7",{"$f":"'Other Loads'!C56 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$D66","v":0},{"$f":"'Other Loads'!$D58","v":0},{"$f":"'Other Loads'!$D68","v":0}]
["Other Load 8",{"$f":"'Other Loads'!K56 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$L66","v":0},{"$f":"'Other Loads'!$L58","v":0},{"$f":"'Other Loads'!$L68","v":0}]
["Other Load 9",{"$f":"'Other Loads'!C73 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$D83","v":0},{"$f":"'Other Loads'!$D75","v":0},{"$f":"'Other Loads'!$D85","v":0}]
["Other Load 10",{"$f":"'Other Loads'!K73 & \"\"","v":""},null,null,null,null,null,null,null,{"$f":"'Other Loads'!$L83","v":0},{"$f":"'Other Loads'!$L75","v":0},{"$f":"'Other Loads'!$L85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Other Load",{"$f":"ROUND(otherVAtotal,0)","v":340},"VA"]
[]
["L-824 Wire Load","L-824",{"$f":"'Series Circuit Parameters'!D19 & \" \" & 'Series Circuit Parameters'!D15","v":"10000 Feet"},{"$f":"'Series Circuit Parameters'!D21 & \" \" & 'Series Circuit Parameters'!E21","v":"8  AWG"},null,null,null,null,null,1,{"$f":"'Series Circuit Parameters'!F26","v":287.5},{"$f":"'Series Circuit Parameters'!F26","v":287.5}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Wire Load",{"$f":"ROUND(l824VAtotal,0)","v":288},"VA"]
["Total Calculated CCR Load",{"$f":"M62","v":{"$error":"#N/A"}},"VA",null,null,null,null,null,null,null,null,"Total Calculated CCR Load",{"$f":"M24+M29+M35+M38+M41+M47+M58+M61","v":{"$error":"#N/A"}},"VA"]
[]
["Desired Safety Factor",15,"%   Type in the percentage you want the CCR load to stay below the CCR rating."]
[]
["CCR Load with Safety Factor",{"$f":"ROUND(((M62*(B64/100))+M62),0)","v":{"$error":"#N/A"}},"VA"]
[]
["Recommended CCR size",0,"KW"]
[]
["Actual CCR Safety Factor",{"$f":"IF(B68>0,ROUND(((1-M62/(B68*1000))* 100),0),0)","v":0},"%  Below maximum CCR rating."]
[]
["Recommended Tap Setting",90,"% Tap  (Thyristor or SCR CCR only)"]
[]
["Do you want to export summary data to an overall CCR summary spreadsheet?",null,"EXPORT","  Clicking on EXPORT will export this sheet to a new spreadsheet you can save on your computer."]
[]
["CCR LOAD CALCULATOR | © 2009-2024 ADB SAFEGATE | All Rights Reserved."]

{"sheet":"variables","index":9,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,0,0,8],[0,10,0,14]]}
[null,null,null,null,null,null,null,null,null,{"$f":"IF('Series Circuit Parameters'!$D$15=\"Feet\",2,3)","v":2}]
[]
[]
["output",null,"frequency",null,"architecture",null,"units",null,"awg","f","m","watts","xfmrloss",null,"fixture","fixture2",null,"signtype"]
[6.6,null,"60Hz",null,"Ferroresonant",null,"Feet","AWG",6,0.42,5.61,10,3,null,"L-850A","L-850A(L)",null,"L-858Y - Direction/Destination/Boundary",null,"L-830-16","10/15","6.6A/6.6A",70,"3 / 4.5"]
[20,null,"50Hz",null,"Thyristor",null,"Meters","mm2",8,0.66,3.54,15,4.5,null,"L-850B","L-850B(L)",null,"L-858R - Mandatory",null,"L-830-17","20/25","6.6A/6.6A",70,"6 / 7.5"]
[null,null,null,null,"Other Manufacturer SCR",null,null,null,null,null,null,20,6,null,"L-850C","L-850C(L)",null,"L-858L - Runway/Taxiway Location",null,"L-830-1","30/45","6.6A/6.6A",80,"6/9"]
["signman",null,"signsize",null,null,null,"lamptype",null,12,1.71,2.16,25,7.5,null,"L-850D","L-850D(L)",null,"L-858B - Runway Distance Remaining",null,"L-830-2","30/45","20A/6.6A",80,"6/9"]
["ADB Safegate",null,"Size 1",null,"gendesc",null,"Halogen",null,16,4.3499999999999996,1.37,30,"6",null,"L-850E","L-850T(L)",null,null,null,"L-830-3",65,"6.6A/6.6A",80,13]
[null,null,"Size 2",null,"1 Module",null,"Fluorescent",null,null,null,null,45,"9",null,"L-850F","L-852A(L)",null,"signstyle",null,"L-830-4",100,"6.6A/6.6A",85,15]
["lampwatt",null,"Size 3",null,"2 Module",null,"LED",null,"lamparch",null,null,65,13,null,"L-852A","L-852B(L)",null,"Style 2 (4.8A - 6.6A) 3-step",null,"L-830-5",100,"20A/6.6A",85,15]
[105,null,"Size 4",null,"3 Module",null,null,null,"Low VA",null,null,100,15,null,"L-852B","L-852C(L)",null,"Style 3 (2.8A - 6.6A) 5-step",null,"L-830-18",150,"6.6A/6.6A",85,22.5]
[null,null,"Size 5",null,"4 Module",null,"watts2",null,"Standard VA",null,null,150,20,null,"L-852C","L-852D(L)",null,"Style 5 (5.5A only)",null,"L-830-19",150,"20A/20A",85,22.5]
["monitor",null,null,null,"700 mm",null,100,null,"5.5A (Single-step)",null,null,200,22.5,null,"L-852D","L-852J(L)",null,null,null,"L-830-6",200,"6.6A/6.6A",90,20]
["Monitored",null,"pulsing",null,"900 mm",null,null,null,"Fluorescent",null,null,300,30,null,"L-852E","L-852K(L)",null,"otherdesc",null,"L-830-7",200,"20A/6.6A",90,20]
["Un-Monitored",null,"BRITE II Single Remote",null,"1100 mm",null,"fixdesc",null,"FAA LED",null,null,500,"50",null,"L-852F","L-852S(L)",null,"L-849A/C/E REIL with PA-4",null,"L-830-8",300,"6.6A/20A",90,30]
[null,null,"BRITE III (AGLAS) Single Remote",null,"1300 mm",null,"L-852S",null,"ICAO LED (Single Sided) (600 mm)",null,null,1500,75,null,"L-852T","L-852T(L)",null,"L-849A/E LED REIL",null,"L-830-9",300,"20A/20A",90,30]
[null,null,"LINC 360 Single Remote",null,"1500 mm",null,"L-852G/S",null,"ICAO LED (Dual Sided) (600 mm)",null,null,null,null,null,"L-860","L-861(L)",null,"L-849C LED REIL",null,"L-830-10",300,"6.6A/6.6A",90,30]
[null,null,null,null,"1700 mm",null,null,null,"ICAO LED (Single Sided) (800 mm)",null,null,null,null,null,"L-860E","L-861E(L)",null,"4-Box (L-880) Type B (Current Driven) 2-Lamp Optical Box",null,"L-830-11",300,"20A/6.6A",90,30]
[null,null,"Thyristor",null,"1900 mm",null,"irgldesc",null,"ICAO LED (Dual Sided) (800 mm)",null,2.5,null,5.61,null,"L-861","L-861T(L)",null,"4-Box (L-880) Type B (Current Driven) 3-Lamp Optical Box",null,"L-830-12",500,"6.6A/20A",90,50]
[null,null,10,null,"2100 mm",null,"L-852G",null,null,null,4,null,3.54,null,"L-861E","L-862(L)",null,"2-Box (L-881) Type B (Current Driven) 2-Lamp Optical Box",null,"L-830-13",500,"20A/20A",90,50]
[null,null,20,null,"2300 mm",null,null,null,"sensor",null,6,0.42,2.16,null,"L-861T","L-862E(L)",null,"2-Box (L-881) Type B (Current Driven) 3-Lamp Optical Box",null,"L-830-15",500,"20A/6.6A",90,50]
[null,null,30,null,"2500 mm",null,"ergldesc",null,"Microwave",null,8,0.66,null,null,"L-861SE",null,null,"4-Box (L-880) Type B (Current Driven) Single Channel PAPI"]
[null,null,40,null,"2700 mm",null,"L-804",null,"Inductive Loop",null,10,null,1.37,null,"L-862",null,null,"2-Box (L-881) Type B (Current Driven) Single Channel PAPI"]
[null,null,50,null,"2900 mm",null,null,null,null,null,12,1.71,null,null,"L-862E",null,null,"4-Box LED PAPI (L-880) (Current Driven)",15]
[null,null,60,null,"3300 mm",null,null,null,"transform",null,16,4.3499999999999996,null,null,"L-862S",null,null,"2-Box LED PAPI (L-881) (Current Driven)",20]
[null,null,70,null,"3700 mm",null,null,null,65,65,"awg",null,"mm2",null,"Approach (UEL)",null,null,"L-806 Wind Cone with PA-4",25]
[null,null,80,null,null,null,null,null,100,100,6,0.42,2.5,5.61,"Approach (PAR-56)",null,null,"L-807 Wind Cone with PA-4"]
[null,null,90,null,"inputvoltage",null,null,null,150,150,8,0.66,4,3.54,"Approach (In-pavement)",null,null,"L-806 LED Wind Cone Internally Lit (Current Driven)"]
[null,null,100,null,"208Vac",null,null,null,200,200,12,1.71,6,2.16,null,null,null,"L-806 LED Wind Cone Externally Lit (Current Driven)"]
[null,null,null,null,"220Vac",null,null,null,300,300,16,4.3499999999999996,10,1.37,null,null,null,"L-807 LED Wind Cone Internally Lit (Current Driven)"]
[null,null,"yesno",null,"230Vac",null,null,null,500,500,null,null,null,null,null,null,null,"L-807 LED Wind Cone Externally Lit (Current Driven)"]
[null,null,"Yes",null,"240Vac",null,null,null,"300 (2)",600,null,null,null,null,null,null,null,"fpulsing"]
[null,null,"No",null,"347Vac",null,null,null,"500 & 300",800,null,null,null,null,null,null,null,"Internal PCB (unmonitored only)"]
[null,null,null,null,"380Vac",null,null,null,"500 (2)",1000,null,null,null,null,null,null,null,"BRITE II Dual Remote"]
[null,null,"ccrsteps",null,"400Vac",null,null,null,null,null,null,null,null,null,null,null,null,"BRITE III Dual Remote (AGLAS)"]
[null,null,"3-Step (4.8A-6.6A)",null,"480Vac",null,null,null,null,null,null,null,null,null,null,null,null,"LINC 360 Dual Remote"]
[null,null,"5-Step (2.8A-6.6A)",null,"600Vac",null,null,null,null,null,null,null,null,null,null,null,null,"npulsing"]
[null,null,"5-Step (8.5A-20A)",null,"2400Vac",null,null,null,null,null,null,null,null,null,null,null,null,"BRITE II Dual Remote"]
[null,null,"1-Step (5.5A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BRITE III Dual Remote (AGLAS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LINC 360 Dual Remote"]

{"sheet":"SL Table","index":10,"n_rows":197,"n_cols":10,"rows_kept":197,"cut":false,"hidden":true,"merged":[]}
["type","architecture","style","Sign Size","watts","Modules","Transformer","Lamps","Power factor","load"]
["Halogen","Low Va",2,1,48,1,100,1,0.98,106]
["Halogen","Low Va",2,1,48,2,200,2,0.99,155]
["Halogen","Low Va",2,1,48,3,300,3,0.98,202]
["Halogen","Low Va",2,1,48,4,300,4,0.99,250]
["Halogen","Low Va",2,2,48,1,200,2,0.99,155]
["Halogen","Low Va",2,2,48,2,300,4,0.99,250]
["Halogen","Low Va",2,2,48,3,500,6,0.98,340]
["Halogen","Low Va",2,2,48,4,"300 (2)",8,0.97,450]
["Halogen","Low Va",2,3,48,1,200,2,0.99,155]
["Halogen","Low Va",2,3,48,2,300,4,0.99,250]
["Halogen","Low Va",2,3,48,3,500,6,0.98,340]
["Halogen","Low Va",2,3,48,4,"300 (2)",8,0.97,450]
["Halogen","Low Va",2,4,48,1,300,4,0.99,250]
["Halogen","Low Va",2,5,48,1,200,2,0.99,155]
["Halogen","Low Va",3,1,48,1,200,1,0.97,105]
["Halogen","Low Va",3,1,48,2,300,2,0.98,145]
["Halogen","Low Va",3,1,48,3,500,3,0.98,190]
["Halogen","Low Va",3,1,48,4,500,4,0.98,233]
["Halogen","Low Va",3,2,48,1,300,2,0.98,145]
["Halogen","Low Va",3,2,48,2,500,4,0.98,233]
["Halogen","Low Va",3,2,48,3,"500 & 300",6,0.98,350]
["Halogen","Low Va",3,2,48,4,"500 (2)",8,0.97,440]
["Halogen","Low Va",3,3,48,1,300,2,0.98,145]
["Halogen","Low Va",3,3,48,2,500,4,0.98,233]
["Halogen","Low Va",3,3,48,3,"500 & 300",6,0.98,350]
["Halogen","Low Va",3,3,48,4,"500 (2)",8,0.97,440]
["Halogen","Low Va",3,4,48,1,500,4,0.98,233]
["Halogen","Low Va",3,5,48,1,300,2,0.98,145]
["Halogen","Low Va",5,1,48,1,65,1,0.99,48]
["Halogen","Low Va",5,1,48,2,100,2,0.99,96]
["Halogen","Low Va",5,1,48,3,200,3,0.99,144]
["Halogen","Low Va",5,1,48,4,200,4,0.99,192]
["Halogen","Low Va",5,2,48,1,100,2,0.99,96]
["Halogen","Low Va",5,2,48,2,200,4,0.99,192]
["Halogen","Low Va",5,2,48,3,300,6,1,288]
["Halogen","Low Va",5,2,48,4,500,8,0.98,384]
["Halogen","Low Va",5,3,48,1,100,2,0.99,96]
["Halogen","Low Va",5,3,48,2,200,4,0.99,192]
["Halogen","Low Va",5,3,48,3,300,6,1,288]
["Halogen","Low Va",5,3,48,4,500,8,0.98,384]
["Halogen","Low Va",5,4,48,1,200,4,0.99,192]
["Halogen","Low Va",5,5,48,1,100,2,0.99,96]
["Halogen","Standard Va",2,1,48,1,"30/45",1,0.59,104]
["Halogen","Standard Va",2,1,48,2,100,2,0.46,222]
["Halogen","Standard Va",2,1,48,3,100,3,0.52,302]
["Halogen","Standard Va",2,1,48,4,200,4,0.52,319]
["Halogen","Standard Va",2,2,48,1,100,2,0.46,222]
["Halogen","Standard Va",2,2,48,2,200,4,0.52,319]
["Halogen","Standard Va",2,2,48,3,300,6,0.48,460]
["Halogen","Standard Va",2,2,48,4,300,8,0.53,570]
["Halogen","Standard Va",2,3,48,1,100,2,0.46,222]
["Halogen","Standard Va",2,3,48,2,200,4,0.52,319]
["Halogen","Standard Va",2,3,48,3,300,6,0.48,460]
["Halogen","Standard Va",2,3,48,4,300,8,0.53,570]
["Halogen","Standard Va",2,4,48,1,200,4,0.52,319]
["Halogen","Standard Va",2,5,48,1,100,2,0.46,222]
["Halogen","Standard Va",3,1,48,1,100,1,0.21,231]
["Halogen","Standard Va",3,1,48,2,200,2,0.32,316]
["Halogen","Standard Va",3,1,48,3,300,3,0.24,641]
["Halogen","Standard Va",3,1,48,4,500,4,0.31,652]
["Halogen","Standard Va",3,2,48,1,200,2,0.32,316]
["Halogen","Standard Va",3,2,48,2,300,4,0.21,652]
["Halogen","Standard Va",3,2,48,3,500,6,0.23,910]
["Halogen","Standard Va",3,2,48,4,"300 (2)",8,0.31,1304]
["Halogen","Standard Va",3,3,48,1,200,2,0.32,316]
["Halogen","Standard Va",3,3,48,2,300,4,0.21,652]
["Halogen","Standard Va",3,3,48,3,500,6,0.23,910]
["Halogen","Standard Va",3,3,48,4,"300 (2)",8,0.31,1304]
["Halogen","Standard Va",3,4,48,1,500,4,0.31,652]
["Halogen","Standard Va",3,5,48,1,300,2,0.32,316]
["Fluorescent","Fluorescent",2,1,18,1,100,1,0.74,57]
["Fluorescent","Fluorescent",2,1,18,2,200,2,0.57999999999999996,119]
["Fluorescent","Fluorescent",2,1,18,3,200,3,0.61,147]
["Fluorescent","Fluorescent",2,1,18,4,300,4,0.62,178]
["Fluorescent","Fluorescent",2,2,18,1,200,2,0.57999999999999996,119]
["Fluorescent","Fluorescent",2,2,18,2,300,4,0.62,178]
["Fluorescent","Fluorescent",2,2,18,3,300,6,0.64,229]
["Fluorescent","Fluorescent",2,2,18,4,"300 (2) ",8,0.55000000000000004,380]
["Fluorescent","Fluorescent",2,3,18,1,200,2,0.57999999999999996,119]
["Fluorescent","Fluorescent",2,3,18,2,300,4,0.62,178]
["Fluorescent","Fluorescent",2,3,18,3,300,6,0.64,229]
["Fluorescent","Fluorescent",2,3,18,4,"300 (2) ",8,0.55000000000000004,380]
["Fluorescent","Fluorescent",2,4,18,1,300,4,0.62,178]
["Fluorescent","Fluorescent",2,5,18,1,200,2,0.57999999999999996,119]
["Fluorescent","Fluorescent",3,1,18,1,100,1,0.6,79]
["Fluorescent","Fluorescent",3,1,18,2,200,2,0.5,157]
["Fluorescent","Fluorescent",3,1,18,3,300,3,0.49,195]
["Fluorescent","Fluorescent",3,1,18,4,300,4,0.51,231]
["Fluorescent","Fluorescent",3,2,18,1,200,2,0.5,157]
["Fluorescent","Fluorescent",3,2,18,2,300,4,0.51,231]
["Fluorescent","Fluorescent",3,2,18,3,500,6,0.46,350]
["Fluorescent","Fluorescent",3,2,18,4,"300 (2)",8,0.44,480]
["Fluorescent","Fluorescent",3,3,18,1,200,2,0.5,157]
["Fluorescent","Fluorescent",3,3,18,2,300,4,0.51,231]
["Fluorescent","Fluorescent",3,3,18,3,500,6,0.46,350]
["Fluorescent","Fluorescent",3,3,18,4,"300 (2)",8,0.44,480]
["Fluorescent","Fluorescent",3,4,18,1,300,4,0.51,231]
["Fluorescent","Fluorescent",3,5,18,1,200,2,0.5,157]
["Fluorescent","Fluorescent",5,1,18,1,100,1,0.8,48]
["Fluorescent","Fluorescent",5,1,18,2,200,2,0.69,99]
["Fluorescent","Fluorescent",5,1,18,3,200,3,0.72,122]
["Fluorescent","Fluorescent",5,1,18,4,300,4,0.73,148]
["Fluorescent","Fluorescent",5,2,18,1,200,2,0.69,99]
["Fluorescent","Fluorescent",5,2,18,2,300,4,0.73,148]
["Fluorescent","Fluorescent",5,2,18,3,300,6,0.75,190]
["Fluorescent","Fluorescent",5,2,18,4,"300 (2)",8,0.66,317]
["Fluorescent","Fluorescent",5,3,18,1,200,2,0.69,99]
["Fluorescent","Fluorescent",5,3,18,2,300,4,0.73,148]
["Fluorescent","Fluorescent",5,3,18,3,300,6,0.75,190]
["Fluorescent","Fluorescent",5,3,18,4,"300 (2)",8,0.66,317]
["Fluorescent","Fluorescent",5,4,18,1,300,4,0.73,148]
["Fluorescent","Fluorescent",5,5,18,1,200,2,0.69,99]
["LED","FAA LED",2,1,null,1,65,null,0.83,85]
["LED","FAA LED",2,1,null,2,100,null,0.83,95]
["LED","FAA LED",2,1,null,3,100,null,0.88,95]
["LED","FAA LED",2,1,null,4,100,null,0.91,95]
["LED","FAA LED",2,2,null,1,65,null,0.88,90]
["LED","FAA LED",2,2,null,2,100,null,0.88,95]
["LED","FAA LED",2,2,null,3,100,null,0.91,100]
["LED","FAA LED",2,2,null,4,100,null,0.91,100]
["LED","FAA LED",2,3,null,1,100,null,0.83,95]
["LED","FAA LED",2,3,null,2,100,null,0.91,95]
["LED","FAA LED",2,3,null,3,100,null,0.91,100]
["LED","FAA LED",2,3,null,4,150,null,0.88,115]
["LED","FAA LED",2,4,null,1,100,null,0.84,95]
["LED","FAA LED",2,5,null,1,100,null,0.83,95]
["LED","FAA LED",3,1,null,1,100,null,0.88,75]
["LED","FAA LED",3,1,null,2,150,null,0.88,95]
["LED","FAA LED",3,1,null,3,150,null,0.88,95]
["LED","FAA LED",3,1,null,4,150,null,0.9,100]
["LED","FAA LED",3,2,null,1,150,null,0.88,90]
["LED","FAA LED",3,2,null,2,150,null,0.9,95]
["LED","FAA LED",3,2,null,3,150,null,0.83,100]
["LED","FAA LED",3,2,null,4,150,null,0.83,100]
["LED","FAA LED",3,3,null,1,150,null,0.88,95]
["LED","FAA LED",3,3,null,2,150,null,0.9,100]
["LED","FAA LED",3,3,null,3,150,null,0.83,100]
["LED","FAA LED",3,3,null,4,200,null,0.85,115]
["LED","FAA LED",3,4,null,1,150,null,0.88,95]
["LED","FAA LED",3,5,null,1,150,null,0.83,95]
["LED","FAA LED",5,1,null,1,65,null,0.84,75]
["LED","FAA LED",5,1,null,2,65,null,0.84,85]
["LED","FAA LED",5,1,null,3,100,null,0.88,85]
["LED","FAA LED",5,1,null,4,100,null,0.88,95]
["LED","FAA LED",5,2,null,1,65,null,0.92,75]
["LED","FAA LED",5,2,null,2,100,null,0.89,85]
["LED","FAA LED",5,2,null,3,100,null,0.9,100]
["LED","FAA LED",5,2,null,4,100,null,0.9,100]
["LED","FAA LED",5,3,null,1,65,null,0.84,85]
["LED","FAA LED",5,3,null,2,100,null,0.88,95]
["LED","FAA LED",5,3,null,3,100,null,0.92,100]
["LED","FAA LED",5,3,null,4,100,null,0.92,110]
["LED","FAA LED",5,4,null,1,65,null,0.83,85]
["LED","FAA LED",5,5,null,1,65,null,0.92,85]
["LED","ICAO LED (Single Sided) (600mm)",2,1,null,1,65,null,0.83,85]
["LED","ICAO LED (Single Sided) (600mm)",2,1,null,2,100,null,0.83,95]
["LED","ICAO LED (Single Sided) (600mm)",2,1,null,3,100,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",2,1,null,4,100,null,0.91,95]
["LED","ICAO LED (Single Sided) (600mm)",2,2,null,1,65,null,0.88,90]
["LED","ICAO LED (Single Sided) (600mm)",2,2,null,2,100,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",2,2,null,3,100,null,0.91,100]
["LED","ICAO LED (Single Sided) (600mm)",2,2,null,4,100,null,0.91,100]
["LED","ICAO LED (Single Sided) (600mm)",2,3,null,1,100,null,0.83,95]
["LED","ICAO LED (Single Sided) (600mm)",2,3,null,2,100,null,0.91,95]
["LED","ICAO LED (Single Sided) (600mm)",2,3,null,3,100,null,0.91,100]
["LED","ICAO LED (Single Sided) (600mm)",2,3,null,4,150,null,0.88,115]
["LED","ICAO LED (Single Sided) (600mm)",2,4,null,1,100,null,0.84,95]
["LED","ICAO LED (Single Sided) (600mm)",2,5,null,1,100,null,0.83,95]
["LED","ICAO LED (Single Sided) (600mm)",3,1,null,1,100,null,0.88,75]
["LED","ICAO LED (Single Sided) (600mm)",3,1,null,2,150,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",3,1,null,3,150,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",3,1,null,4,150,null,0.9,100]
["LED","ICAO LED (Single Sided) (600mm)",3,2,null,1,150,null,0.88,90]
["LED","ICAO LED (Single Sided) (600mm)",3,2,null,2,150,null,0.9,95]
["LED","ICAO LED (Single Sided) (600mm)",3,2,null,3,150,null,0.83,100]
["LED","ICAO LED (Single Sided) (600mm)",3,2,null,4,150,null,0.83,100]
["LED","ICAO LED (Single Sided) (600mm)",3,3,null,1,150,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",3,3,null,2,150,null,0.9,100]
["LED","ICAO LED (Single Sided) (600mm)",3,3,null,3,150,null,0.83,100]
["LED","ICAO LED (Single Sided) (600mm)",3,3,null,4,200,null,0.85,115]
["LED","ICAO LED (Single Sided) (600mm)",3,4,null,1,150,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",3,5,null,1,150,null,0.83,95]
["LED","ICAO LED (Single Sided) (600mm)",5,1,null,1,65,null,0.84,75]
["LED","ICAO LED (Single Sided) (600mm)",5,1,null,2,65,null,0.84,85]
["LED","ICAO LED (Single Sided) (600mm)",5,1,null,3,100,null,0.88,85]
["LED","ICAO LED (Single Sided) (600mm)",5,1,null,4,100,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",5,2,null,1,65,null,0.92,75]
["LED","ICAO LED (Single Sided) (600mm)",5,2,null,2,100,null,0.89,85]
["LED","ICAO LED (Single Sided) (600mm)",5,2,null,3,100,null,0.9,100]
["LED","ICAO LED (Single Sided) (600mm)",5,2,null,4,100,null,0.9,100]
["LED","ICAO LED (Single Sided) (600mm)",5,3,null,1,65,null,0.84,85]
["LED","ICAO LED (Single Sided) (600mm)",5,3,null,2,100,null,0.88,95]
["LED","ICAO LED (Single Sided) (600mm)",5,3,null,3,100,null,0.92,100]
["LED","ICAO LED (Single Sided) (600mm)",5,3,null,4,100,null,0.92,110]
["LED","ICAO LED (Single Sided) (600mm)",5,4,null,1,65,null,0.83,85]
["LED","ICAO LED (Single Sided) (600mm)",5,5,null,1,65,null,0.92,85]