{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cover Sheet","GC-OTDOA","(3) SECTOR","(3) SECTOR Split or Add","Sweep-PIM","RET Screen Shot","Fiber OTDR Results","Feeder Misc","TMA-DIPLEXER","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":3,"defined_names":22,"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":"Cover Sheet","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"RF Closeout to be filled out with all Closeout Packages on New Build, Co-Lo, TI, Antenna Mod, Service Improvement or Troubleshooting. "]
[]
[null,"Raw PIM & Sweep data submittals are still required and must be accompanied by this form –both .pdf and .dat format."]
[]
[null,"This template includes some of the following feature tabs to be used in its entirety:"]
[null,"·         Pre and Post PIM/Sweep Tab for 3 sector site"]
[null,"·         Pre & Post PIM/Sweep Report Tab for Sector Split/Sector Adds"]
[null,"·         Sweep-PIM Report Summary Tab"]
[null,"·         RET Screen Shot Tab"]
[null,"o   This screen shot tab is required to be populated when installing sites with RET Antennas"]
[null,"·         Fiber OTDR Results Tab"]
[null,"·         GC-OTDOA Tab (OTDOA -Observed Time Difference Of Arrival)"]
[null,"o   This Tab that must be filled out entirely on every LTE/AWS project –even if it is for troubleshooting a line."]
[null,"o   This requires filling in cable type and cable length distances on Mainline Coax, Bottom and Top Jumpers."]
[null,"o   GPS Cable lengths must be populated as well –"]
[null,"§  For Live sites –measure by using markings on cable or soft tape to get distance"]
[null,"§  For New Builds –you may run DTF to Short to get actual length before installing GPS antenna –*Do not sweep thru GPS antenna."]
[]
[null,"*Some Tabs are intentionally hidden"]
[null,"**If certain Tabs do not apply, you can leave blank or N/A but you must fill out all that apply to each project type."]
[]
[null,"Spreadsheet Version v 4.0 released 10/28/2014"]

{"sheet":"GC-OTDOA","index":1,"n_rows":101,"n_cols":28,"rows_kept":101,"cut":false,"hidden":false,"merged":[[66,1,66,2],[62,1,62,2],[63,1,63,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[64,1,64,2],[0,0,0,1],[0,2,0,4],[56,1,56,2],[57,1,57,2],[65,1,65,2]]}
[null,null,null,null,null,"SURVEY DATA"]
["Band","Sector","EUtranCellFDD","Site Name","Ant. Height _AGL (Ft)","Mainline Feeder Type (Note if Hybrid Cable select \"Fiber\")","Mainline Length Estimate\n(feet)","Feeder Attenuation (dB)","Feeder delay (nsec)","Bottom Jumper Type","Bottm Jumper Length Estimate\n(feet)","Total Bottom Jumper Attenuation (dB)","Total Bottom Jumper Delay (nsec)","Top Jumper Type","Top Jumper Length Estimate (feet)","Total Top Jumper Attenuation (dB)","Total Jumper Delay (nsec)","TMA Type","TMA Delay DL (ENB CNTRLD not added to line calc)","TMA Delay UL (ENB CNTRLD not added to line calc)","Diplexer Type","Diplexer Delay","GPS Cable Type","GPS cable length Estimate (feet)","GPS Feeder Delay nsec","UL/DL Attenuation dB","RFBranch: dlTrafficDelay nsec","RFBranch: ulTrafficDelay nsec"]
[700,"WO",null,null,null,null,null,{"$f":"IF(OR(F3=\"Fiber\",F3=\"\"),0,VLOOKUP(F3,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G3)","v":0},{"$f":"IF(OR(F3=\"Fiber\",F3=\"\"),0,(G3/VLOOKUP(F3,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J3=\"Fiber\",J3=\"\"),0,VLOOKUP(J3,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K3)","v":0},{"$f":"IF(OR(J3=\"Fiber\",J3=\"\"),0,(K3/VLOOKUP(J3,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N3=\"Fiber\",N3=\"\"),0,VLOOKUP(N3,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O3)","v":0},{"$f":"IF(OR(N3=\"Fiber\",N3=\"\"),0,(O3/VLOOKUP(N3,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R3=\"\",0,VLOOKUP(R3,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R3=\"\",0,VLOOKUP(R3,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U3=\"\",0,VLOOKUP(U3,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X3/VLOOKUP(W3,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(H3+L3+P3,1)","v":0},{"$f":"ROUND(I3+M3+Q3+V3,0)","v":0},{"$f":"ROUND(I3+M3+Q3+V3,0)","v":0}]
[700,"WOO",null,null,null,null,null,{"$f":"IF(OR(F4=\"Fiber\",F4=\"\"),0,VLOOKUP(F4,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G4)","v":0},{"$f":"IF(OR(F4=\"Fiber\",F4=\"\"),0,(G4/VLOOKUP(F4,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J4=\"Fiber\",J4=\"\"),0,VLOOKUP(J4,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K4)","v":0},{"$f":"IF(OR(J4=\"Fiber\",J4=\"\"),0,(K4/VLOOKUP(J4,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N4=\"Fiber\",N4=\"\"),0,VLOOKUP(N4,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O4)","v":0},{"$f":"IF(OR(N4=\"Fiber\",N4=\"\"),0,(O4/VLOOKUP(N4,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R4=\"\",0,VLOOKUP(R4,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R4=\"\",0,VLOOKUP(R4,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U4=\"\",0,VLOOKUP(U4,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,{"$f":"ROUND(H4+L4+P4,1)","v":0},0,{"$f":"ROUND(I4+M4+Q4+V4,0)","v":0}]
[700,"BO",null,null,null,null,null,{"$f":"IF(OR(F5=\"Fiber\",F5=\"\"),0,VLOOKUP(F5,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G5)","v":0},{"$f":"IF(OR(F5=\"Fiber\",F5=\"\"),0,(G5/VLOOKUP(F5,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J5=\"Fiber\",J5=\"\"),0,VLOOKUP(J5,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K5)","v":0},{"$f":"IF(OR(J5=\"Fiber\",J5=\"\"),0,(K5/VLOOKUP(J5,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N5=\"Fiber\",N5=\"\"),0,VLOOKUP(N5,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O5)","v":0},{"$f":"IF(OR(N5=\"Fiber\",N5=\"\"),0,(O5/VLOOKUP(N5,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R5=\"\",0,VLOOKUP(R5,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R5=\"\",0,VLOOKUP(R5,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U5=\"\",0,VLOOKUP(U5,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[700,"BOO",null,null,null,null,null,{"$f":"IF(OR(F6=\"Fiber\",F6=\"\"),0,VLOOKUP(F6,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G6)","v":0},{"$f":"IF(OR(F6=\"Fiber\",F6=\"\"),0,(G6/VLOOKUP(F6,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J6=\"Fiber\",J6=\"\"),0,VLOOKUP(J6,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K6)","v":0},{"$f":"IF(OR(J6=\"Fiber\",J6=\"\"),0,(K6/VLOOKUP(J6,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N6=\"Fiber\",N6=\"\"),0,VLOOKUP(N6,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O6)","v":0},{"$f":"IF(OR(N6=\"Fiber\",N6=\"\"),0,(O6/VLOOKUP(N6,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R6=\"\",0,VLOOKUP(R6,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R6=\"\",0,VLOOKUP(R6,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U6=\"\",0,VLOOKUP(U6,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[700,"GO",null,null,null,null,null,{"$f":"IF(OR(F7=\"Fiber\",F7=\"\"),0,VLOOKUP(F7,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G7)","v":0},{"$f":"IF(OR(F7=\"Fiber\",F7=\"\"),0,(G7/VLOOKUP(F7,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J7=\"Fiber\",J7=\"\"),0,VLOOKUP(J7,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K7)","v":0},{"$f":"IF(OR(J7=\"Fiber\",J7=\"\"),0,(K7/VLOOKUP(J7,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N7=\"Fiber\",N7=\"\"),0,VLOOKUP(N7,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O7)","v":0},{"$f":"IF(OR(N7=\"Fiber\",N7=\"\"),0,(O7/VLOOKUP(N7,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R7=\"\",0,VLOOKUP(R7,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R7=\"\",0,VLOOKUP(R7,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U7=\"\",0,VLOOKUP(U7,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[700,"GOO",null,null,null,null,null,{"$f":"IF(OR(F8=\"Fiber\",F8=\"\"),0,VLOOKUP(F8,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G8)","v":0},{"$f":"IF(OR(F8=\"Fiber\",F8=\"\"),0,(G8/VLOOKUP(F8,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J8=\"Fiber\",J8=\"\"),0,VLOOKUP(J8,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K8)","v":0},{"$f":"IF(OR(J8=\"Fiber\",J8=\"\"),0,(K8/VLOOKUP(J8,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N8=\"Fiber\",N8=\"\"),0,VLOOKUP(N8,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O8)","v":0},{"$f":"IF(OR(N8=\"Fiber\",N8=\"\"),0,(O8/VLOOKUP(N8,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R8=\"\",0,VLOOKUP(R8,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R8=\"\",0,VLOOKUP(R8,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U8=\"\",0,VLOOKUP(U8,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[]
["AWS","WR",null,null,null,null,null,{"$f":"IF(OR(F10=\"Fiber\",F10=\"\"),0,VLOOKUP(F10,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G10)","v":0},{"$f":"IF(OR(F10=\"Fiber\",F10=\"\"),0,(G10/VLOOKUP(F10,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J10=\"Fiber\",J10=\"\"),0,VLOOKUP(J10,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K10)","v":0},{"$f":"IF(OR(J10=\"Fiber\",J10=\"\"),0,(K10/VLOOKUP(J10,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N10=\"Fiber\",N10=\"\"),0,VLOOKUP(N10,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O10)","v":0},{"$f":"IF(OR(N10=\"Fiber\",N10=\"\"),0,(O10/VLOOKUP(N10,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R10=\"\",0,VLOOKUP(R10,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R10=\"\",0,VLOOKUP(R10,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U10=\"\",0,VLOOKUP(U10,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X10/VLOOKUP(W10,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},0,{"$f":"ROUND(I10+M10+Q10+V10,0)","v":0},0]
["AWS","WRR",null,null,null,null,null,{"$f":"IF(OR(F11=\"Fiber\",F11=\"\"),0,VLOOKUP(F11,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G11)","v":0},{"$f":"IF(OR(F11=\"Fiber\",F11=\"\"),0,(G11/VLOOKUP(F11,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J11=\"Fiber\",J11=\"\"),0,VLOOKUP(J11,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K11)","v":0},{"$f":"IF(OR(J11=\"Fiber\",J11=\"\"),0,(K11/VLOOKUP(J11,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N11=\"Fiber\",N11=\"\"),0,VLOOKUP(N11,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O11)","v":0},{"$f":"IF(OR(N11=\"Fiber\",N11=\"\"),0,(O11/VLOOKUP(N11,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R11=\"\",0,VLOOKUP(R11,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R11=\"\",0,VLOOKUP(R11,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U11=\"\",0,VLOOKUP(U11,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS","BR",null,null,null,null,null,{"$f":"IF(OR(F12=\"Fiber\",F12=\"\"),0,VLOOKUP(F12,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G12)","v":0},{"$f":"IF(OR(F12=\"Fiber\",F12=\"\"),0,(G12/VLOOKUP(F12,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J12=\"Fiber\",J12=\"\"),0,VLOOKUP(J12,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K12)","v":0},{"$f":"IF(OR(J12=\"Fiber\",J12=\"\"),0,(K12/VLOOKUP(J12,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N12=\"Fiber\",N12=\"\"),0,VLOOKUP(N12,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O12)","v":0},{"$f":"IF(OR(N12=\"Fiber\",N12=\"\"),0,(O12/VLOOKUP(N12,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R12=\"\",0,VLOOKUP(R12,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R12=\"\",0,VLOOKUP(R12,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U12=\"\",0,VLOOKUP(U12,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS","BRR",null,null,null,null,null,{"$f":"IF(OR(F13=\"Fiber\",F13=\"\"),0,VLOOKUP(F13,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G13)","v":0},{"$f":"IF(OR(F13=\"Fiber\",F13=\"\"),0,(G13/VLOOKUP(F13,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J13=\"Fiber\",J13=\"\"),0,VLOOKUP(J13,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K13)","v":0},{"$f":"IF(OR(J13=\"Fiber\",J13=\"\"),0,(K13/VLOOKUP(J13,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N13=\"Fiber\",N13=\"\"),0,VLOOKUP(N13,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O13)","v":0},{"$f":"IF(OR(N13=\"Fiber\",N13=\"\"),0,(O13/VLOOKUP(N13,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R13=\"\",0,VLOOKUP(R13,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R13=\"\",0,VLOOKUP(R13,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U13=\"\",0,VLOOKUP(U13,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS","GR",null,null,null,null,null,{"$f":"IF(OR(F14=\"Fiber\",F14=\"\"),0,VLOOKUP(F14,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G14)","v":0},{"$f":"IF(OR(F14=\"Fiber\",F14=\"\"),0,(G14/VLOOKUP(F14,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J14=\"Fiber\",J14=\"\"),0,VLOOKUP(J14,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K14)","v":0},{"$f":"IF(OR(J14=\"Fiber\",J14=\"\"),0,(K14/VLOOKUP(J14,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N14=\"Fiber\",N14=\"\"),0,VLOOKUP(N14,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O14)","v":0},{"$f":"IF(OR(N14=\"Fiber\",N14=\"\"),0,(O14/VLOOKUP(N14,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R14=\"\",0,VLOOKUP(R14,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R14=\"\",0,VLOOKUP(R14,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U14=\"\",0,VLOOKUP(U14,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS","GRR",null,null,null,null,null,{"$f":"IF(OR(F15=\"Fiber\",F15=\"\"),0,VLOOKUP(F15,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G15)","v":0},{"$f":"IF(OR(F15=\"Fiber\",F15=\"\"),0,(G15/VLOOKUP(F15,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J15=\"Fiber\",J15=\"\"),0,VLOOKUP(J15,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K15)","v":0},{"$f":"IF(OR(J15=\"Fiber\",J15=\"\"),0,(K15/VLOOKUP(J15,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N15=\"Fiber\",N15=\"\"),0,VLOOKUP(N15,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O15)","v":0},{"$f":"IF(OR(N15=\"Fiber\",N15=\"\"),0,(O15/VLOOKUP(N15,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R15=\"\",0,VLOOKUP(R15,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R15=\"\",0,VLOOKUP(R15,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U15=\"\",0,VLOOKUP(U15,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[]
["700 (Sector Split)","WOOO",null,null,null,null,null,{"$f":"IF(OR(F17=\"Fiber\",F17=\"\"),0,VLOOKUP(F17,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G17)","v":0},{"$f":"IF(OR(F17=\"Fiber\",F17=\"\"),0,(G17/VLOOKUP(F17,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J17=\"Fiber\",J17=\"\"),0,VLOOKUP(J17,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K17)","v":0},{"$f":"IF(OR(J17=\"Fiber\",J17=\"\"),0,(K17/VLOOKUP(J17,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N17=\"Fiber\",N17=\"\"),0,VLOOKUP(N17,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O17)","v":0},{"$f":"IF(OR(N17=\"Fiber\",N17=\"\"),0,(O17/VLOOKUP(N17,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R17=\"\",0,VLOOKUP(R17,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R17=\"\",0,VLOOKUP(R17,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U17=\"\",0,VLOOKUP(U17,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X17/VLOOKUP(W17,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},0,{"$f":"ROUND(I17+M17+Q17+V17,0)","v":0},0]
["700 (Sector Split)","WOOOO",null,null,null,null,null,{"$f":"IF(OR(F18=\"Fiber\",F18=\"\"),0,VLOOKUP(F18,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G18)","v":0},{"$f":"IF(OR(F18=\"Fiber\",F18=\"\"),0,(G18/VLOOKUP(F18,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J18=\"Fiber\",J18=\"\"),0,VLOOKUP(J18,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K18)","v":0},{"$f":"IF(OR(J18=\"Fiber\",J18=\"\"),0,(K18/VLOOKUP(J18,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N18=\"Fiber\",N18=\"\"),0,VLOOKUP(N18,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O18)","v":0},{"$f":"IF(OR(N18=\"Fiber\",N18=\"\"),0,(O18/VLOOKUP(N18,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R18=\"\",0,VLOOKUP(R18,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R18=\"\",0,VLOOKUP(R18,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U18=\"\",0,VLOOKUP(U18,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["700 (Sector Split)","BO",null,null,null,null,null,{"$f":"IF(OR(F19=\"Fiber\",F19=\"\"),0,VLOOKUP(F19,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G19)","v":0},{"$f":"IF(OR(F19=\"Fiber\",F19=\"\"),0,(G19/VLOOKUP(F19,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J19=\"Fiber\",J19=\"\"),0,VLOOKUP(J19,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K19)","v":0},{"$f":"IF(OR(J19=\"Fiber\",J19=\"\"),0,(K19/VLOOKUP(J19,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N19=\"Fiber\",N19=\"\"),0,VLOOKUP(N19,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O19)","v":0},{"$f":"IF(OR(N19=\"Fiber\",N19=\"\"),0,(O19/VLOOKUP(N19,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R19=\"\",0,VLOOKUP(R19,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R19=\"\",0,VLOOKUP(R19,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U19=\"\",0,VLOOKUP(U19,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["700 (Sector Split)","BOOO",null,null,null,null,null,{"$f":"IF(OR(F20=\"Fiber\",F20=\"\"),0,VLOOKUP(F20,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G20)","v":0},{"$f":"IF(OR(F20=\"Fiber\",F20=\"\"),0,(G20/VLOOKUP(F20,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J20=\"Fiber\",J20=\"\"),0,VLOOKUP(J20,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K20)","v":0},{"$f":"IF(OR(J20=\"Fiber\",J20=\"\"),0,(K20/VLOOKUP(J20,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N20=\"Fiber\",N20=\"\"),0,VLOOKUP(N20,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O20)","v":0},{"$f":"IF(OR(N20=\"Fiber\",N20=\"\"),0,(O20/VLOOKUP(N20,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R20=\"\",0,VLOOKUP(R20,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R20=\"\",0,VLOOKUP(R20,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U20=\"\",0,VLOOKUP(U20,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["700 (Sector Split)","GO",null,null,null,null,null,{"$f":"IF(OR(F21=\"Fiber\",F21=\"\"),0,VLOOKUP(F21,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G21)","v":0},{"$f":"IF(OR(F21=\"Fiber\",F21=\"\"),0,(G21/VLOOKUP(F21,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J21=\"Fiber\",J21=\"\"),0,VLOOKUP(J21,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K21)","v":0},{"$f":"IF(OR(J21=\"Fiber\",J21=\"\"),0,(K21/VLOOKUP(J21,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N21=\"Fiber\",N21=\"\"),0,VLOOKUP(N21,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O21)","v":0},{"$f":"IF(OR(N21=\"Fiber\",N21=\"\"),0,(O21/VLOOKUP(N21,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R21=\"\",0,VLOOKUP(R21,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R21=\"\",0,VLOOKUP(R21,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U21=\"\",0,VLOOKUP(U21,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["700 (Sector Split)","GOOO",null,null,null,null,null,{"$f":"IF(OR(F22=\"Fiber\",F22=\"\"),0,VLOOKUP(F22,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!G22)","v":0},{"$f":"IF(OR(F22=\"Fiber\",F22=\"\"),0,(G22/VLOOKUP(F22,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J22=\"Fiber\",J22=\"\"),0,VLOOKUP(J22,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!K22)","v":0},{"$f":"IF(OR(J22=\"Fiber\",J22=\"\"),0,(K22/VLOOKUP(J22,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N22=\"Fiber\",N22=\"\"),0,VLOOKUP(N22,'Feeder Misc'!$B$4:$M$34,3,0)*'GC-OTDOA'!O22)","v":0},{"$f":"IF(OR(N22=\"Fiber\",N22=\"\"),0,(O22/VLOOKUP(N22,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R22=\"\",0,VLOOKUP(R22,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R22=\"\",0,VLOOKUP(R22,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U22=\"\",0,VLOOKUP(U22,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[]
["AWS (Sector Split)","WRRR",null,null,null,null,null,{"$f":"IF(OR(F24=\"Fiber\",F24=\"\"),0,VLOOKUP(F24,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G24)","v":0},{"$f":"IF(OR(F24=\"Fiber\",F24=\"\"),0,(G24/VLOOKUP(F24,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J24=\"Fiber\",J24=\"\"),0,VLOOKUP(J24,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K24)","v":0},{"$f":"IF(OR(J24=\"Fiber\",J24=\"\"),0,(K24/VLOOKUP(J24,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N24=\"Fiber\",N24=\"\"),0,VLOOKUP(N24,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O24)","v":0},{"$f":"IF(OR(N24=\"Fiber\",N24=\"\"),0,(O24/VLOOKUP(N24,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R24=\"\",0,VLOOKUP(R24,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R24=\"\",0,VLOOKUP(R24,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U24=\"\",0,VLOOKUP(U24,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X24/VLOOKUP(W24,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},0,{"$f":"ROUND(I24+M24+Q24+V24,0)","v":0},0]
["AWS (Sector Split)","WRRRR",null,null,null,null,null,{"$f":"IF(OR(F25=\"Fiber\",F25=\"\"),0,VLOOKUP(F25,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G25)","v":0},{"$f":"IF(OR(F25=\"Fiber\",F25=\"\"),0,(G25/VLOOKUP(F25,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J25=\"Fiber\",J25=\"\"),0,VLOOKUP(J25,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K25)","v":0},{"$f":"IF(OR(J25=\"Fiber\",J25=\"\"),0,(K25/VLOOKUP(J25,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N25=\"Fiber\",N25=\"\"),0,VLOOKUP(N25,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O25)","v":0},{"$f":"IF(OR(N25=\"Fiber\",N25=\"\"),0,(O25/VLOOKUP(N25,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R25=\"\",0,VLOOKUP(R25,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R25=\"\",0,VLOOKUP(R25,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U25=\"\",0,VLOOKUP(U25,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS (Sector Split)","BRRR",null,null,null,null,null,{"$f":"IF(OR(F26=\"Fiber\",F26=\"\"),0,VLOOKUP(F26,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G26)","v":0},{"$f":"IF(OR(F26=\"Fiber\",F26=\"\"),0,(G26/VLOOKUP(F26,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J26=\"Fiber\",J26=\"\"),0,VLOOKUP(J26,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K26)","v":0},{"$f":"IF(OR(J26=\"Fiber\",J26=\"\"),0,(K26/VLOOKUP(J26,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N26=\"Fiber\",N26=\"\"),0,VLOOKUP(N26,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O26)","v":0},{"$f":"IF(OR(N26=\"Fiber\",N26=\"\"),0,(O26/VLOOKUP(N26,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R26=\"\",0,VLOOKUP(R26,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R26=\"\",0,VLOOKUP(R26,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U26=\"\",0,VLOOKUP(U26,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS (Sector Split)","BRRRR",null,null,null,null,null,{"$f":"IF(OR(F27=\"Fiber\",F27=\"\"),0,VLOOKUP(F27,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G27)","v":0},{"$f":"IF(OR(F27=\"Fiber\",F27=\"\"),0,(G27/VLOOKUP(F27,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J27=\"Fiber\",J27=\"\"),0,VLOOKUP(J27,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K27)","v":0},{"$f":"IF(OR(J27=\"Fiber\",J27=\"\"),0,(K27/VLOOKUP(J27,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N27=\"Fiber\",N27=\"\"),0,VLOOKUP(N27,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O27)","v":0},{"$f":"IF(OR(N27=\"Fiber\",N27=\"\"),0,(O27/VLOOKUP(N27,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R27=\"\",0,VLOOKUP(R27,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R27=\"\",0,VLOOKUP(R27,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U27=\"\",0,VLOOKUP(U27,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS (Sector Split)","GRRR",null,null,null,null,null,{"$f":"IF(OR(F28=\"Fiber\",F28=\"\"),0,VLOOKUP(F28,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G28)","v":0},{"$f":"IF(OR(F28=\"Fiber\",F28=\"\"),0,(G28/VLOOKUP(F28,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J28=\"Fiber\",J28=\"\"),0,VLOOKUP(J28,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K28)","v":0},{"$f":"IF(OR(J28=\"Fiber\",J28=\"\"),0,(K28/VLOOKUP(J28,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N28=\"Fiber\",N28=\"\"),0,VLOOKUP(N28,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O28)","v":0},{"$f":"IF(OR(N28=\"Fiber\",N28=\"\"),0,(O28/VLOOKUP(N28,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R28=\"\",0,VLOOKUP(R28,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R28=\"\",0,VLOOKUP(R28,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U28=\"\",0,VLOOKUP(U28,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["AWS (Sector Split)","GRRRR",null,null,null,null,null,{"$f":"IF(OR(F29=\"Fiber\",F29=\"\"),0,VLOOKUP(F29,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!G29)","v":0},{"$f":"IF(OR(F29=\"Fiber\",F29=\"\"),0,(G29/VLOOKUP(F29,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J29=\"Fiber\",J29=\"\"),0,VLOOKUP(J29,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!K29)","v":0},{"$f":"IF(OR(J29=\"Fiber\",J29=\"\"),0,(K29/VLOOKUP(J29,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N29=\"Fiber\",N29=\"\"),0,VLOOKUP(N29,'Feeder Misc'!$B$4:$M$34,11,0)*'GC-OTDOA'!O29)","v":0},{"$f":"IF(OR(N29=\"Fiber\",N29=\"\"),0,(O29/VLOOKUP(N29,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R29=\"\",0,VLOOKUP(R29,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R29=\"\",0,VLOOKUP(R29,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U29=\"\",0,VLOOKUP(U29,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[]
["PCS-A","WP",null,null,null,null,null,{"$f":"IF(OR(F31=\"Fiber\",F31=\"\"),0,VLOOKUP(F31,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G31)","v":0},{"$f":"IF(OR(F31=\"Fiber\",F31=\"\"),0,(G31/VLOOKUP(F31,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J31=\"Fiber\",J31=\"\"),0,VLOOKUP(J31,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K31)","v":0},{"$f":"IF(OR(J31=\"Fiber\",J31=\"\"),0,(K31/VLOOKUP(J31,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N31=\"Fiber\",N31=\"\"),0,VLOOKUP(N31,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O31)","v":0},{"$f":"IF(OR(N31=\"Fiber\",N31=\"\"),0,(O31/VLOOKUP(N31,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R31=\"\",0,VLOOKUP(R31,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R31=\"\",0,VLOOKUP(R31,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U31=\"\",0,VLOOKUP(U31,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X31/VLOOKUP(W31,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},0,{"$f":"ROUND(I31+M31+Q31+V31,0)","v":0},0]
["PCS-A","WPP",null,null,null,null,null,{"$f":"IF(OR(F32=\"Fiber\",F32=\"\"),0,VLOOKUP(F32,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G32)","v":0},{"$f":"IF(OR(F32=\"Fiber\",F32=\"\"),0,(G32/VLOOKUP(F32,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J32=\"Fiber\",J32=\"\"),0,VLOOKUP(J32,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K32)","v":0},{"$f":"IF(OR(J32=\"Fiber\",J32=\"\"),0,(K32/VLOOKUP(J32,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N32=\"Fiber\",N32=\"\"),0,VLOOKUP(N32,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O32)","v":0},{"$f":"IF(OR(N32=\"Fiber\",N32=\"\"),0,(O32/VLOOKUP(N32,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R32=\"\",0,VLOOKUP(R32,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R32=\"\",0,VLOOKUP(R32,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U32=\"\",0,VLOOKUP(U32,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-A","BP",null,null,null,null,null,{"$f":"IF(OR(F33=\"Fiber\",F33=\"\"),0,VLOOKUP(F33,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G33)","v":0},{"$f":"IF(OR(F33=\"Fiber\",F33=\"\"),0,(G33/VLOOKUP(F33,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J33=\"Fiber\",J33=\"\"),0,VLOOKUP(J33,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K33)","v":0},{"$f":"IF(OR(J33=\"Fiber\",J33=\"\"),0,(K33/VLOOKUP(J33,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N33=\"Fiber\",N33=\"\"),0,VLOOKUP(N33,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O33)","v":0},{"$f":"IF(OR(N33=\"Fiber\",N33=\"\"),0,(O33/VLOOKUP(N33,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R33=\"\",0,VLOOKUP(R33,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R33=\"\",0,VLOOKUP(R33,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U33=\"\",0,VLOOKUP(U33,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-A","BPP",null,null,null,null,null,{"$f":"IF(OR(F34=\"Fiber\",F34=\"\"),0,VLOOKUP(F34,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G34)","v":0},{"$f":"IF(OR(F34=\"Fiber\",F34=\"\"),0,(G34/VLOOKUP(F34,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J34=\"Fiber\",J34=\"\"),0,VLOOKUP(J34,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K34)","v":0},{"$f":"IF(OR(J34=\"Fiber\",J34=\"\"),0,(K34/VLOOKUP(J34,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N34=\"Fiber\",N34=\"\"),0,VLOOKUP(N34,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O34)","v":0},{"$f":"IF(OR(N34=\"Fiber\",N34=\"\"),0,(O34/VLOOKUP(N34,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R34=\"\",0,VLOOKUP(R34,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R34=\"\",0,VLOOKUP(R34,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U34=\"\",0,VLOOKUP(U34,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-A","GP",null,null,null,null,null,{"$f":"IF(OR(F35=\"Fiber\",F35=\"\"),0,VLOOKUP(F35,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G35)","v":0},{"$f":"IF(OR(F35=\"Fiber\",F35=\"\"),0,(G35/VLOOKUP(F35,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J35=\"Fiber\",J35=\"\"),0,VLOOKUP(J35,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K35)","v":0},{"$f":"IF(OR(J35=\"Fiber\",J35=\"\"),0,(K35/VLOOKUP(J35,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N35=\"Fiber\",N35=\"\"),0,VLOOKUP(N35,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O35)","v":0},{"$f":"IF(OR(N35=\"Fiber\",N35=\"\"),0,(O35/VLOOKUP(N35,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R35=\"\",0,VLOOKUP(R35,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R35=\"\",0,VLOOKUP(R35,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U35=\"\",0,VLOOKUP(U35,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-A","GPP",null,null,null,null,null,{"$f":"IF(OR(F36=\"Fiber\",F36=\"\"),0,VLOOKUP(F36,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G36)","v":0},{"$f":"IF(OR(F36=\"Fiber\",F36=\"\"),0,(G36/VLOOKUP(F36,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J36=\"Fiber\",J36=\"\"),0,VLOOKUP(J36,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K36)","v":0},{"$f":"IF(OR(J36=\"Fiber\",J36=\"\"),0,(K36/VLOOKUP(J36,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N36=\"Fiber\",N36=\"\"),0,VLOOKUP(N36,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O36)","v":0},{"$f":"IF(OR(N36=\"Fiber\",N36=\"\"),0,(O36/VLOOKUP(N36,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R36=\"\",0,VLOOKUP(R36,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R36=\"\",0,VLOOKUP(R36,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U36=\"\",0,VLOOKUP(U36,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[]
["PCS-E","WWP",null,null,null,null,null,{"$f":"IF(OR(F38=\"Fiber\",F38=\"\"),0,VLOOKUP(F38,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G38)","v":0},{"$f":"IF(OR(F38=\"Fiber\",F38=\"\"),0,(G38/VLOOKUP(F38,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J38=\"Fiber\",J38=\"\"),0,VLOOKUP(J38,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K38)","v":0},{"$f":"IF(OR(J38=\"Fiber\",J38=\"\"),0,(K38/VLOOKUP(J38,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N38=\"Fiber\",N38=\"\"),0,VLOOKUP(N38,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O38)","v":0},{"$f":"IF(OR(N38=\"Fiber\",N38=\"\"),0,(O38/VLOOKUP(N38,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R38=\"\",0,VLOOKUP(R38,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R38=\"\",0,VLOOKUP(R38,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U38=\"\",0,VLOOKUP(U38,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X38/VLOOKUP(W38,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(H38+L38+P38,1)","v":0},{"$f":"ROUND(I38+M38+Q38+V38,0)","v":0},{"$f":"ROUND(I38+M38+Q38+V38,0)","v":0}]
["PCS-E","WWPP",null,null,null,null,null,{"$f":"IF(OR(F39=\"Fiber\",F39=\"\"),0,VLOOKUP(F39,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G39)","v":0},{"$f":"IF(OR(F39=\"Fiber\",F39=\"\"),0,(G39/VLOOKUP(F39,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J39=\"Fiber\",J39=\"\"),0,VLOOKUP(J39,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K39)","v":0},{"$f":"IF(OR(J39=\"Fiber\",J39=\"\"),0,(K39/VLOOKUP(J39,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N39=\"Fiber\",N39=\"\"),0,VLOOKUP(N39,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O39)","v":0},{"$f":"IF(OR(N39=\"Fiber\",N39=\"\"),0,(O39/VLOOKUP(N39,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R39=\"\",0,VLOOKUP(R39,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R39=\"\",0,VLOOKUP(R39,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U39=\"\",0,VLOOKUP(U39,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-E","BBP",null,null,null,null,null,{"$f":"IF(OR(F40=\"Fiber\",F40=\"\"),0,VLOOKUP(F40,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G40)","v":0},{"$f":"IF(OR(F40=\"Fiber\",F40=\"\"),0,(G40/VLOOKUP(F40,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J40=\"Fiber\",J40=\"\"),0,VLOOKUP(J40,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K40)","v":0},{"$f":"IF(OR(J40=\"Fiber\",J40=\"\"),0,(K40/VLOOKUP(J40,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N40=\"Fiber\",N40=\"\"),0,VLOOKUP(N40,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O40)","v":0},{"$f":"IF(OR(N40=\"Fiber\",N40=\"\"),0,(O40/VLOOKUP(N40,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R40=\"\",0,VLOOKUP(R40,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R40=\"\",0,VLOOKUP(R40,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U40=\"\",0,VLOOKUP(U40,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-E","BBPP",null,null,null,null,null,{"$f":"IF(OR(F41=\"Fiber\",F41=\"\"),0,VLOOKUP(F41,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G41)","v":0},{"$f":"IF(OR(F41=\"Fiber\",F41=\"\"),0,(G41/VLOOKUP(F41,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J41=\"Fiber\",J41=\"\"),0,VLOOKUP(J41,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K41)","v":0},{"$f":"IF(OR(J41=\"Fiber\",J41=\"\"),0,(K41/VLOOKUP(J41,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N41=\"Fiber\",N41=\"\"),0,VLOOKUP(N41,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O41)","v":0},{"$f":"IF(OR(N41=\"Fiber\",N41=\"\"),0,(O41/VLOOKUP(N41,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R41=\"\",0,VLOOKUP(R41,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R41=\"\",0,VLOOKUP(R41,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U41=\"\",0,VLOOKUP(U41,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-E","GGP",null,null,null,null,null,{"$f":"IF(OR(F42=\"Fiber\",F42=\"\"),0,VLOOKUP(F42,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G42)","v":0},{"$f":"IF(OR(F42=\"Fiber\",F42=\"\"),0,(G42/VLOOKUP(F42,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J42=\"Fiber\",J42=\"\"),0,VLOOKUP(J42,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K42)","v":0},{"$f":"IF(OR(J42=\"Fiber\",J42=\"\"),0,(K42/VLOOKUP(J42,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N42=\"Fiber\",N42=\"\"),0,VLOOKUP(N42,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O42)","v":0},{"$f":"IF(OR(N42=\"Fiber\",N42=\"\"),0,(O42/VLOOKUP(N42,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R42=\"\",0,VLOOKUP(R42,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R42=\"\",0,VLOOKUP(R42,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U42=\"\",0,VLOOKUP(U42,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["PCS-E","GGPP",null,null,null,null,null,{"$f":"IF(OR(F43=\"Fiber\",F43=\"\"),0,VLOOKUP(F43,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!G43)","v":0},{"$f":"IF(OR(F43=\"Fiber\",F43=\"\"),0,(G43/VLOOKUP(F43,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J43=\"Fiber\",J43=\"\"),0,VLOOKUP(J43,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!K43)","v":0},{"$f":"IF(OR(J43=\"Fiber\",J43=\"\"),0,(K43/VLOOKUP(J43,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N43=\"Fiber\",N43=\"\"),0,VLOOKUP(N43,'Feeder Misc'!$B$4:$M$34,9,0)*'GC-OTDOA'!O43)","v":0},{"$f":"IF(OR(N43=\"Fiber\",N43=\"\"),0,(O43/VLOOKUP(N43,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R43=\"\",0,VLOOKUP(R43,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R43=\"\",0,VLOOKUP(R43,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U43=\"\",0,VLOOKUP(U43,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
[]
["CDMA","WY",null,null,null,null,null,{"$f":"IF(OR(F45=\"Fiber\",F45=\"\"),0,VLOOKUP(F45,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!G45)","v":0},{"$f":"IF(OR(F45=\"Fiber\",F45=\"\"),0,(G45/VLOOKUP(F45,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J45=\"Fiber\",J45=\"\"),0,VLOOKUP(J45,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!K45)","v":0},{"$f":"IF(OR(J45=\"Fiber\",J45=\"\"),0,(K45/VLOOKUP(J45,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N45=\"Fiber\",N45=\"\"),0,VLOOKUP(N45,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!O45)","v":0},{"$f":"IF(OR(N45=\"Fiber\",N45=\"\"),0,(O45/VLOOKUP(N45,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R45=\"\",0,VLOOKUP(R45,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R45=\"\",0,VLOOKUP(R45,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U45=\"\",0,VLOOKUP(U45,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,{"$f":"ROUND(X45/VLOOKUP(W45,'Feeder Misc'!$B$3:$P$34,15,0)+9,0)","v":{"$error":"#N/A"}},0,{"$f":"ROUND(I45+M45+Q45+V45,0)","v":0},0]
["CDMA","WYY",null,null,null,null,null,{"$f":"IF(OR(F46=\"Fiber\",F46=\"\"),0,VLOOKUP(F46,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!G46)","v":0},{"$f":"IF(OR(F46=\"Fiber\",F46=\"\"),0,(G46/VLOOKUP(F46,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J46=\"Fiber\",J46=\"\"),0,VLOOKUP(J46,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!K46)","v":0},{"$f":"IF(OR(J46=\"Fiber\",J46=\"\"),0,(K46/VLOOKUP(J46,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N46=\"Fiber\",N46=\"\"),0,VLOOKUP(N46,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!O46)","v":0},{"$f":"IF(OR(N46=\"Fiber\",N46=\"\"),0,(O46/VLOOKUP(N46,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R46=\"\",0,VLOOKUP(R46,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R46=\"\",0,VLOOKUP(R46,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U46=\"\",0,VLOOKUP(U46,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,{"$f":"ROUND(I46+M46+Q46+V46,0)","v":0},0]
["CDMA","BY",null,null,null,null,null,{"$f":"IF(OR(F47=\"Fiber\",F47=\"\"),0,VLOOKUP(F47,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!G47)","v":0},{"$f":"IF(OR(F47=\"Fiber\",F47=\"\"),0,(G47/VLOOKUP(F47,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J47=\"Fiber\",J47=\"\"),0,VLOOKUP(J47,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!K47)","v":0},{"$f":"IF(OR(J47=\"Fiber\",J47=\"\"),0,(K47/VLOOKUP(J47,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N47=\"Fiber\",N47=\"\"),0,VLOOKUP(N47,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!O47)","v":0},{"$f":"IF(OR(N47=\"Fiber\",N47=\"\"),0,(O47/VLOOKUP(N47,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R47=\"\",0,VLOOKUP(R47,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R47=\"\",0,VLOOKUP(R47,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U47=\"\",0,VLOOKUP(U47,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["CDMA","BYY",null,null,null,null,null,{"$f":"IF(OR(F48=\"Fiber\",F48=\"\"),0,VLOOKUP(F48,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!G48)","v":0},{"$f":"IF(OR(F48=\"Fiber\",F48=\"\"),0,(G48/VLOOKUP(F48,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J48=\"Fiber\",J48=\"\"),0,VLOOKUP(J48,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!K48)","v":0},{"$f":"IF(OR(J48=\"Fiber\",J48=\"\"),0,(K48/VLOOKUP(J48,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N48=\"Fiber\",N48=\"\"),0,VLOOKUP(N48,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!O48)","v":0},{"$f":"IF(OR(N48=\"Fiber\",N48=\"\"),0,(O48/VLOOKUP(N48,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R48=\"\",0,VLOOKUP(R48,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R48=\"\",0,VLOOKUP(R48,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U48=\"\",0,VLOOKUP(U48,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["CDMA","GY",null,null,null,null,null,{"$f":"IF(OR(F49=\"Fiber\",F49=\"\"),0,VLOOKUP(F49,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!G49)","v":0},{"$f":"IF(OR(F49=\"Fiber\",F49=\"\"),0,(G49/VLOOKUP(F49,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J49=\"Fiber\",J49=\"\"),0,VLOOKUP(J49,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!K49)","v":0},{"$f":"IF(OR(J49=\"Fiber\",J49=\"\"),0,(K49/VLOOKUP(J49,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N49=\"Fiber\",N49=\"\"),0,VLOOKUP(N49,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!O49)","v":0},{"$f":"IF(OR(N49=\"Fiber\",N49=\"\"),0,(O49/VLOOKUP(N49,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R49=\"\",0,VLOOKUP(R49,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R49=\"\",0,VLOOKUP(R49,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U49=\"\",0,VLOOKUP(U49,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,0,0]
["CDMA","GYY",null,null,null,null,null,{"$f":"IF(OR(F50=\"Fiber\",F50=\"\"),0,VLOOKUP(F50,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!G50)","v":0},{"$f":"IF(OR(F50=\"Fiber\",F50=\"\"),0,(G50/VLOOKUP(F50,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(J50=\"Fiber\",J50=\"\"),0,VLOOKUP(J50,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!K50)","v":0},{"$f":"IF(OR(J50=\"Fiber\",J50=\"\"),0,(K50/VLOOKUP(J50,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,null,{"$f":"IF(OR(N50=\"Fiber\",N50=\"\"),0,VLOOKUP(N50,'Feeder Misc'!$B$4:$M$34,5,0)*'GC-OTDOA'!O50)","v":0},{"$f":"IF(OR(N50=\"Fiber\",N50=\"\"),0,(O50/VLOOKUP(N50,'Feeder Misc'!$B$3:$P$34,15,0)))","v":0},null,{"$f":"IF(R50=\"\",0,VLOOKUP(R50,'TMA-DIPLEXER'!B$1:P$6,15,0))","v":0},{"$f":"IF(R50=\"\",0,VLOOKUP(R50,'TMA-DIPLEXER'!B$1:Q$6,16,0))","v":0},null,{"$f":"IF(U50=\"\",0,VLOOKUP(U50,'TMA-DIPLEXER'!B$16:P$19,15,0))","v":0},null,null,null,0,{"$f":"ROUND(I50+M50+Q50+V50,0)","v":0},0]
[]
["Instructions: GC to Fill-in the BLUE columns only"]
["Note: For Non-Macro AWS Installations (Most Common) -Fill in the Top Jumper Data (Columns N & O)"]
["Note: Fill-in TMA type only for external TMA's that are not controlled by the eNodeB!"]
["Note: For TMA's Additional Top Jumper -Combine total cable lengths and insert into column P."]
[null,null,null,"x"]
["TMA/Diplexer","Model Type",null,"*Used for TMA Type in Column \"R\""]
["TMA","ANDREW"]
["TMA","WESTELL"]
["TMA","ANDREW-BYPASS"]
["TMA","WESTELL-BYPASS"]
["TMA","NA"]
[]
["Diplexer","CLEARCOMM"]
["Diplexer","ANDREW"]
["Diplexer","RFS"]
["Diplexer","NA"]
[]
[]
["Manufacture","Feeder Type","Diameter","*Used for Feeder Type in Columns \"F, J, N\""]
["ANDREW","FSJ 4-50B","1/2\""]
["ANDREW","LDF 4-50A","1/2\""]
["ANDREW","LDF 5-50A","7/8\""]
["ANDREW","LDF 6-50A","1 1/4\""]
["ANDREW","LDF 7-50A","1 5/8\""]
["ANDREW","LDF 12-50","2 1/4\""]
["ANDREW","AVA 5-50","7/8\""]
["ANDREW","AVA 7-50","1 5/8\""]
["ANDREW","VXL 5-50","7/8\""]
["ANDREW","VXL 6-50","1 1/4\""]
["ANDREW","FXL 780","7/8\""]
["ANDREW","FXL 1873","1 5/8\""]
["Superior Essex","LHF 12D","1/2\""]
["Superior Essex","LHF 22D","7/8\""]
["Superior Essex","LHF 42D","1 5/8\""]
["EUPEN","EC 5-50A","7/8\""]
["EUPEN","EC 6-50A","1 1/4\""]
["EUPEN","EC 7-50A","1 5/8\""]
["Commscope","CR 1070 PE","7/8\""]
["Commscope","CR 1873 PE","1 5/8\""]
["RFS","LCF 12-50J","1/2\""]
["RFS","LCF 78-50JA","7/8\""]
["RFS","LCFS 114-50JA","1 1/4\""]
["RFS","LCF 158-50JA","1 5/8\""]
["Commscope","CR 540 Jumper","1/2\""]
["NK Cables","1 5/8\"-50","1 5/8\""]
["EUPEN","EC 4-50A","1/2\""]
["standard","1 5/8\"","1 5/8\""]
["standard","1/2\"","1/2\""]
["standard","1/2\" Coax","1/2\""]
["standard","LMR-240","1/4\""]

{"sheet":"(3) SECTOR","index":2,"n_rows":91,"n_cols":27,"rows_kept":91,"cut":false,"hidden":false,"merged":[[5,2,5,3],[5,6,5,7],[5,8,5,9],[5,10,5,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[1,1,1,11],[3,6,3,7],[3,8,3,9],[3,10,3,11],[4,6,4,7],[4,8,4,9],[4,10,4,11],[6,8,6,9],[3,2,3,3],[9,2,9,3],[9,6,9,7],[9,8,9,9],[9,10,9,11],[10,2,10,3],[10,6,10,7],[10,8,10,9],[10,10,10,11],[7,6,7,7],[7,8,7,9],[7,10,7,11],[8,2,8,3],[8,6,8,7],[8,8,8,9],[8,10,8,11],[9,4,9,5],[10,4,10,5],[15,4,15,5],[15,7,15,8],[15,10,15,11],[11,6,11,7],[11,8,11,9],[11,10,11,11],[13,1,15,2],[13,3,13,11],[14,3,14,5],[11,4,11,5],[14,9,14,11],[14,6,14,8],[18,1,18,2],[19,1,19,2],[20,1,20,2],[20,4,20,5],[20,7,20,8],[20,10,20,11],[16,1,16,2],[17,1,17,2],[17,4,17,5],[17,7,17,8],[17,10,17,11],[16,4,16,5],[16,7,16,8],[16,10,16,11],[23,1,23,2],[23,4,23,5],[23,7,23,8],[23,10,23,11],[21,1,21,11],[22,1,22,2],[22,4,22,5],[22,7,22,8],[22,10,22,11],[27,1,27,2],[27,4,27,5],[27,7,27,8],[27,10,27,11],[25,1,25,2],[25,4,25,5],[25,7,25,8],[25,10,25,11],[24,1,24,2],[24,4,24,5],[24,7,24,8],[24,10,24,11],[26,4,26,5],[26,7,26,8],[26,10,26,11],[30,1,30,2],[30,4,30,5],[30,7,30,8],[30,10,30,11],[28,1,28,2],[29,1,29,2],[29,4,29,5],[29,7,29,8],[29,10,29,11],[33,1,33,2],[33,4,33,5],[33,7,33,8],[33,10,33,11],[31,1,31,2],[32,1,32,2],[32,4,32,5],[32,7,32,8],[32,10,32,11],[36,1,36,2],[36,4,36,5],[36,7,36,8],[36,10,36,11],[34,1,34,11],[35,1,35,2],[35,4,35,5],[35,7,35,8],[35,10,35,11],[40,1,40,2],[40,4,40,5],[40,7,40,8],[40,10,40,11],[38,1,38,2],[38,4,38,5],[38,7,38,8],[38,10,38,11],[37,1,37,2],[37,4,37,5],[37,7,37,8],[37,10,37,11],[39,4,39,5],[39,7,39,8],[39,10,39,11],[43,1,43,2],[43,4,43,5],[43,7,43,8],[43,10,43,11],[41,1,41,2],[42,1,42,2],[42,4,42,5],[42,7,42,8],[42,10,42,11],[46,1,46,2],[46,4,46,5],[46,7,46,8],[46,10,46,11],[44,1,44,2],[45,1,45,2],[45,4,45,5],[45,7,45,8],[45,10,45,11],[49,1,49,2],[49,4,49,5],[49,7,49,8],[49,10,49,11],[47,1,47,11],[48,1,48,2],[48,4,48,5],[48,7,48,8],[48,10,48,11],[53,1,53,2],[53,4,53,5],[53,7,53,8],[53,10,53,11],[51,1,51,2],[51,4,51,5],[51,7,51,8],[51,10,51,11],[50,1,50,2],[50,4,50,5],[50,7,50,8],[50,10,50,11],[52,4,52,5],[52,7,52,8],[52,10,52,11],[56,1,56,2],[56,4,56,5],[56,7,56,8],[56,10,56,11],[54,1,54,2],[55,1,55,2],[55,4,55,5],[55,7,55,8],[55,10,55,11],[60,1,60,2],[60,4,60,5],[60,7,60,8],[60,10,60,11],[57,1,57,2],[58,1,58,2],[59,1,59,2],[59,4,59,5],[59,7,59,8],[59,10,59,11],[64,1,64,2],[64,4,64,5],[64,7,64,8],[64,10,64,11],[63,1,63,2],[63,4,63,5],[63,7,63,8],[63,10,63,11],[61,1,61,11],[62,1,62,2],[62,4,62,5],[62,7,62,8],[62,10,62,11],[69,1,69,2],[69,4,69,5],[69,7,69,8],[69,10,69,11],[67,1,67,2],[67,4,67,5],[67,7,67,8],[67,10,67,11],[65,1,65,2],[65,4,65,5],[65,7,65,8],[65,10,65,11],[66,4,66,5],[66,7,66,8],[66,10,66,11],[90,3,95,11],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[89,1,89,11],[90,1,95,2],[74,1,74,2],[74,4,74,5],[74,7,74,8],[74,10,74,11],[71,1,71,2],[72,1,72,2],[73,1,73,2],[73,4,73,5],[73,7,73,8],[73,10,73,11],[70,1,70,2],[70,4,70,5],[70,7,70,8],[70,10,70,11],[68,1,68,2],[75,1,75,11],[76,1,76,2],[76,4,76,5],[76,7,76,8],[76,10,76,11],[77,1,77,2],[77,4,77,5],[77,7,77,8],[77,10,77,11],[78,1,78,2],[78,4,78,5],[78,7,78,8],[78,10,78,11],[79,1,79,2],[79,4,79,5],[79,7,79,8],[79,10,79,11],[80,4,80,5],[80,7,80,8],[80,10,80,11],[81,1,81,2],[81,4,81,5],[81,7,81,8],[81,10,81,11],[82,1,82,2],[83,1,83,2],[83,4,83,5],[83,7,83,8],[83,10,83,11],[88,1,88,2],[88,4,88,5],[88,7,88,8],[88,10,88,11],[84,1,84,2],[84,4,84,5],[84,7,84,8],[84,10,84,11],[85,1,85,2],[86,1,86,2],[87,1,87,2],[87,4,87,5],[87,7,87,8],[87,10,87,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"PNW 3-SECTOR POST CONSTRUCTION FORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eNode B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 1 Unit"]
[null,"Site Name:",null,null,"RF ENGINEER:",null,null,null,"INDOOR/OUTDOOR:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 2 Units"]
[null,"Location # / Project:",null,null,"SYSTEM PERFORMANCE ENGINEER:",null,null,null,"700 Equipment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 3 Units"]
[null,"Date:",null,null,"Type of Structure:",null,null,null,"AWS Equipment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 4 Units"]
[null,"Address:",null,null,"Structure Ht (ft), include Appurtenance:                                                                    Structure Ht (ft):",null,null,null,"700 ENB Removed:"]
[null,"City/ County:",null,null,"Structure Ht (ft):",null,null,null,"RET Home Cable:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 5 Units"]
[null,"General Contractor:","Presco Telecommunications, Inc.",null,"Top Tip Height of VZW Antennas:",null,null,null,"Total # of Antennas:"]
[null,"Contact:","Evan Jones",null,"Latitude (NAD83)",null,null,null,"RAYCAP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 6 Units"]
[null,"GC Phone #: ","206-817-8013",null,"Longitude (NAD83)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUTURE USE ONLY"]
[null,"Construction Start/Finish:",null,null,"Structure Owner and / or Manager:"]
[]
[null,"Site Configuration"]
[null,null,null,"ALPHA",null,null,"BETA",null,null,"GAMMA"]
[null,null,null,"PRE","POST",null,"PRE","POST",null,"PRE","POST"]
[null,"Coaxial Cable Line/ Hybrid Cable Length (feet)"]
[null,"RAY CAP TYPE:"]
[null,"Number of Coaxial Cable Runs (quantity)"]
[null,"Coaxial Cable Size "]
[null,"Total Number of Antennas (quantity)"]
[]
[null,"TOTAL 700 ANTENNA"]
[null,"700 Antenna Azimuth"]
[null,"700 Antenna Manufacturer"]
[null,"700  Antenna Model"]
[null,"700 Antenna Serial #"]
[null,"700 Antenna Rad Center"]
[null,"700 RET Name/ Serial #"]
[null,"700 Antenna Electrical Tilt (EDT)"]
[null,"700 Antenna Mechanical Tilt (MDT)"]
[null,"700 TMA (Model/Serial #)"]
[null,"700 Diplexers (Tower-Model)"]
[null,"700 Diplexers (Shelter- Model)"]
[]
[null,"TOTAL AWS ANTENNA"]
[null,"AWS Antenna Azimuth"]
[null,"AWS Antenna Manufacturer"]
[null,"AWS  Antenna Model"]
[null,"AWS Antenna Serial #"]
[null,"AWS Antenna Rad Center"]
[null,"AWS RET Name/ Serial #"]
[null,"AWS Antenna Electrical Tilt (EDT)"]
[null,"AWS Antenna Mechanical Tilt (MDT)"]
[null,"AWS TMA  (Model/Serial #)"]
[null,"AWS Diplexers (Tower)"]
[null,"AWS Diplexers (Shelter)"]
[]
[null,"TOTAL 850MHz ANTENNA"]
[null,"850 MHz Antenna Azimuth"]
[null,"850 MHz Antenna Manufacturer"]
[null,"850 MHz  Antenna Model"]
[null,"850 Antenna Serial #"]
[null,"850 MHz Antenna Rad Center"]
[null,"850 RET Name/ Serial #"]
[null,"850 Antenna Electrical Tilt (EDT)"]
[null,"850 MHz Antenna Mechanical Tilt (MDT)"]
[null,"850 TMA  (Model/Serial #)"]
[null,"850 BIAS TEE (Make/Model)"]
[null,"850 Diplexers (Tower-Model)"]
[null,"850 Diplexers (Shelter- Model)"]
[]
[null,"TOTAL PCS-A ANTENNA"]
[null,"PCS Antenna Azimuth"]
[null,"PCS Antenna Manufacturer"]
[null,"PCS  Antenna Model"]
[null,"PCS Antenna Serial #"]
[null,"PCS Antenna Rad Center"]
[null,"PCS RET Name/ Serial #"]
[null,"PCS Antenna Electrical Tilt (EDT)"]
[null,"PCS Antenna Mechanical Tilt (MDT)"]
[null,"PCS TMA  (Model/Serial #)"]
[null,"PCS BIAS TEE (Make/Model)"]
[null,"PCS Diplexers (Tower-Model)"]
[null,"PCS Diplexers (Shelter- Model)"]
[]
[null,"TOTAL PCS-E ANTENNA"]
[null,"PCS Antenna Azimuth"]
[null,"PCS Antenna Manufacturer"]
[null,"PCS  Antenna Model"]
[null,"PCS Antenna Serial #"]
[null,"PCS Antenna Rad Center"]
[null,"PCS RET Name/ Serial #"]
[null,"PCS Antenna Electrical Tilt (EDT)"]
[null,"PCS Antenna Mechanical Tilt (MDT)"]
[null,"PCS TMA  (Model/Serial #)"]
[null,"PCS BIAS TEE (Make/Model)"]
[null,"PCS Diplexers (Tower-Model)"]
[null,"PCS Diplexers (Shelter- Model)"]
[]
[null,"COMMENTS:"]

{"sheet":"(3) SECTOR Split or Add","index":3,"n_rows":91,"n_cols":36,"rows_kept":91,"cut":false,"hidden":false,"merged":[[1,1,1,20],[3,2,3,3],[3,6,3,7],[3,8,3,10],[3,14,3,15],[3,16,3,17],[4,6,4,7],[4,8,4,10],[4,14,4,15],[4,16,4,17],[5,2,5,3],[5,6,5,7],[5,8,5,10],[5,14,5,15],[5,16,5,17],[6,2,6,3],[6,6,6,7],[6,8,6,10],[6,14,6,15],[6,16,6,17],[7,6,7,7],[7,8,7,10],[7,14,7,15],[7,16,7,17],[8,2,8,3],[8,6,8,7],[8,8,8,10],[8,14,8,15],[8,16,8,17],[9,2,9,3],[9,6,9,7],[9,8,9,10],[9,14,9,15],[9,16,9,17],[10,2,10,3],[10,6,10,7],[10,8,10,10],[10,14,10,15],[10,16,10,17],[11,6,11,7],[11,8,11,10],[11,14,11,15],[11,16,11,17],[15,7,15,8],[15,10,15,11],[15,13,15,14],[15,16,15,17],[15,19,15,20],[13,1,15,2],[13,3,13,11],[13,12,13,20],[14,3,14,5],[14,6,14,8],[14,9,14,11],[14,12,14,14],[14,15,14,17],[14,18,14,20],[15,4,15,5],[18,1,18,2],[19,1,19,2],[20,1,20,2],[20,4,20,5],[20,7,20,8],[20,10,20,11],[16,16,16,17],[16,19,16,20],[17,1,17,2],[17,4,17,5],[17,7,17,8],[17,10,17,11],[17,13,17,14],[17,16,17,17],[17,19,17,20],[16,1,16,2],[16,4,16,5],[16,7,16,8],[16,10,16,11],[16,13,16,14],[22,19,22,20],[23,1,23,2],[23,4,23,5],[23,7,23,8],[23,10,23,11],[23,13,23,14],[23,16,23,17],[23,19,23,20],[20,13,20,14],[20,16,20,17],[20,19,20,20],[21,1,21,19],[22,1,22,2],[22,4,22,5],[22,7,22,8],[22,10,22,11],[22,13,22,14],[22,16,22,17],[24,19,24,20],[25,1,25,2],[25,4,25,5],[25,7,25,8],[25,10,25,11],[25,13,25,14],[25,16,25,17],[25,19,25,20],[24,1,24,2],[24,4,24,5],[24,7,24,8],[24,10,24,11],[24,13,24,14],[24,16,24,17],[28,1,28,2],[29,1,29,2],[29,4,29,5],[29,7,29,8],[29,10,29,11],[29,13,29,14],[26,19,26,20],[27,1,27,2],[27,4,27,5],[27,7,27,8],[27,10,27,11],[27,13,27,14],[27,16,27,17],[27,19,27,20],[26,1,26,2],[26,4,26,5],[26,7,26,8],[26,10,26,11],[26,13,26,14],[26,16,26,17],[31,1,31,2],[32,1,32,2],[32,4,32,5],[32,7,32,8],[32,10,32,11],[32,13,32,14],[29,16,29,17],[29,19,29,20],[30,1,30,2],[30,4,30,5],[30,7,30,8],[30,10,30,11],[30,13,30,14],[30,16,30,17],[30,19,30,20],[34,1,34,19],[35,1,35,2],[35,4,35,5],[35,7,35,8],[35,10,35,11],[35,13,35,14],[35,16,35,17],[35,19,35,20],[32,16,32,17],[32,19,32,20],[33,1,33,2],[33,4,33,5],[33,7,33,8],[33,10,33,11],[33,13,33,14],[33,16,33,17],[33,19,33,20],[36,19,36,20],[37,1,37,2],[37,4,37,5],[37,7,37,8],[37,10,37,11],[37,13,37,14],[37,16,37,17],[37,19,37,20],[36,1,36,2],[36,4,36,5],[36,7,36,8],[36,10,36,11],[36,13,36,14],[36,16,36,17],[38,19,38,20],[39,1,39,2],[39,4,39,5],[39,7,39,8],[39,10,39,11],[39,13,39,14],[39,16,39,17],[39,19,39,20],[38,1,38,2],[38,4,38,5],[38,7,38,8],[38,10,38,11],[38,13,38,14],[38,16,38,17],[40,19,40,20],[41,1,41,2],[42,1,42,2],[42,4,42,5],[42,7,42,8],[42,10,42,11],[42,13,42,14],[42,16,42,17],[42,19,42,20],[40,1,40,2],[40,4,40,5],[40,7,40,8],[40,10,40,11],[40,13,40,14],[40,16,40,17],[43,19,43,20],[44,1,44,2],[45,1,45,2],[45,4,45,5],[45,7,45,8],[45,10,45,11],[45,13,45,14],[45,16,45,17],[45,19,45,20],[43,1,43,2],[43,4,43,5],[43,7,43,8],[43,10,43,11],[43,13,43,14],[43,16,43,17],[46,19,46,20],[47,1,47,19],[48,1,48,2],[48,4,48,5],[48,7,48,8],[48,10,48,11],[48,13,48,14],[48,16,48,17],[48,19,48,20],[46,1,46,2],[46,4,46,5],[46,7,46,8],[46,10,46,11],[46,13,46,14],[46,16,46,17],[49,19,49,20],[50,1,50,2],[50,4,50,5],[50,7,50,8],[50,10,50,11],[50,13,50,14],[50,16,50,17],[50,19,50,20],[49,1,49,2],[49,4,49,5],[49,7,49,8],[49,10,49,11],[49,13,49,14],[49,16,49,17],[51,19,51,20],[52,1,52,2],[52,4,52,5],[52,7,52,8],[52,10,52,11],[52,13,52,14],[52,16,52,17],[52,19,52,20],[51,1,51,2],[51,4,51,5],[51,7,51,8],[51,10,51,11],[51,13,51,14],[51,16,51,17],[53,19,53,20],[54,1,54,2],[55,1,55,2],[55,4,55,5],[55,7,55,8],[55,10,55,11],[55,13,55,14],[55,16,55,17],[55,19,55,20],[53,1,53,2],[53,4,53,5],[53,7,53,8],[53,10,53,11],[53,13,53,14],[53,16,53,17],[56,19,56,20],[57,1,57,2],[58,1,58,2],[59,1,59,2],[59,4,59,5],[59,7,59,8],[59,10,59,11],[59,13,59,14],[59,16,59,17],[59,19,59,20],[56,1,56,2],[56,4,56,5],[56,7,56,8],[56,10,56,11],[56,13,56,14],[56,16,56,17],[60,19,60,20],[61,1,61,19],[62,1,62,2],[62,4,62,5],[62,7,62,8],[62,10,62,11],[62,13,62,14],[62,16,62,17],[62,19,62,20],[60,1,60,2],[60,4,60,5],[60,7,60,8],[60,10,60,11],[60,13,60,14],[60,16,60,17],[63,19,63,20],[64,1,64,2],[64,4,64,5],[64,7,64,8],[64,10,64,11],[64,13,64,14],[64,16,64,17],[64,19,64,20],[63,1,63,2],[63,4,63,5],[63,7,63,8],[63,10,63,11],[63,13,63,14],[63,16,63,17],[65,19,65,20],[66,1,66,2],[66,4,66,5],[66,7,66,8],[66,10,66,11],[66,13,66,14],[66,16,66,17],[66,19,66,20],[65,1,65,2],[65,4,65,5],[65,7,65,8],[65,10,65,11],[65,13,65,14],[65,16,65,17],[67,19,67,20],[68,1,68,2],[69,1,69,2],[69,4,69,5],[69,7,69,8],[69,10,69,11],[69,13,69,14],[69,16,69,17],[69,19,69,20],[67,1,67,2],[67,4,67,5],[67,7,67,8],[67,10,67,11],[67,13,67,14],[67,16,67,17],[70,19,70,20],[71,1,71,2],[72,1,72,2],[73,1,73,2],[73,4,73,5],[73,7,73,8],[73,10,73,11],[73,13,73,14],[73,16,73,17],[73,19,73,20],[70,1,70,2],[70,4,70,5],[70,7,70,8],[70,10,70,11],[70,13,70,14],[70,16,70,17],[74,19,74,20],[89,1,89,19],[90,1,95,2],[90,3,95,11],[90,12,95,20],[74,1,74,2],[74,4,74,5],[74,7,74,8],[74,10,74,11],[74,13,74,14],[74,16,74,17],[75,1,75,19],[76,1,76,2],[76,4,76,5],[76,7,76,8],[76,10,76,11],[76,13,76,14],[76,16,76,17],[76,19,76,20],[77,1,77,2],[77,4,77,5],[77,7,77,8],[77,10,77,11],[77,13,77,14],[77,16,77,17],[77,19,77,20],[78,1,78,2],[78,4,78,5],[78,7,78,8],[78,10,78,11],[78,13,78,14],[78,16,78,17],[78,19,78,20],[79,1,79,2],[79,4,79,5],[79,7,79,8],[79,10,79,11],[79,13,79,14],[79,16,79,17],[79,19,79,20],[80,1,80,2],[80,4,80,5],[80,7,80,8],[80,10,80,11],[80,13,80,14],[80,16,80,17],[80,19,80,20],[81,1,81,2],[81,4,81,5],[81,7,81,8],[81,10,81,11],[81,13,81,14],[81,16,81,17],[81,19,81,20],[82,1,82,2],[83,1,83,2],[83,4,83,5],[83,7,83,8],[83,10,83,11],[83,13,83,14],[83,16,83,17],[83,19,83,20],[84,1,84,2],[84,4,84,5],[84,7,84,8],[84,10,84,11],[84,13,84,14],[84,16,84,17],[84,19,84,20],[85,1,85,2],[86,1,86,2],[87,1,87,2],[87,4,87,5],[87,7,87,8],[87,10,87,11],[87,13,87,14],[87,16,87,17],[87,19,87,20],[88,1,88,2],[88,4,88,5],[88,7,88,8],[88,10,88,11],[88,13,88,14],[88,16,88,17],[88,19,88,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,"PNW 3-SECTOR plus Sector Split/Add POST CONSTRUCTION FORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eNode B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 1 Unit"]
[null,"Site Name:",null,null,null,null,"RF ENGINEER:",null,null,null,null,null,null,null,"INDOOR/OUTDOOR:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 2 Units"]
[null,"Location # / Project:",null,"LTE/AWS",null,null,"SYSTEM PERFORMANCE ENGINEER:",null,null,null,null,null,null,null,"700 Equipment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 3 Units"]
[null,"Date:",null,null,null,null,"Type of Structure:",null,null,null,null,null,null,null,"700 Equipment (B2B):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 4 Units"]
[null,"Address:",null,null,null,null,"Structure Ht (ft), include Appurtenance:                                                                    Structure Ht (ft):",null,null,null,null,null,null,null,"700 ENB Removed:"]
[null,"City/ County:","City","County",null,null,"Structure Ht (ft):",null,null,null,null,null,null,null,"AWS Equipment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 5 Units"]
[null,"General Contractor:",null,null,null,null,"Top Tip Height of VZW Antennas:",null,null,null,null,null,null,null,"AWS Equipment (B2B):"]
[null,"Contact:",null,null,null,null,"Latitude (NAD83)",null,null,null,null,null,null,null,"RET Home Cable:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRH - 6 Units"]
[null,"GC Phone #: ",null,null,null,null,"Longitude (NAD83)",null,null,null,null,null,null,null,"Total # of Antennas:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUTURE USE ONLY"]
[null,"Construction Start/Finish:",null,null,null,null,"Structure Owner and / or Manager:",null,null,null,null,null,null,null,"RAYCAP"]
[]
[null,"Site Configuration",null,"Sectors Alpha, Beta, Gamma",null,null,null,null,null,null,null,null,"Sectors Alpha-2, Beta-2, Gamma-2"]
[null,null,null,"ALPHA",null,null,"BETA",null,null,"GAMMA",null,null,"ALPHA 2",null,null,"BETA 2",null,null,"GAMMA 2"]
[null,null,null,"PRE","POST",null,"PRE","POST",null,"PRE","POST",null,"PRE","POST",null,"PRE","POST",null,"PRE","POST"]
[null,"Coaxial Cable Line/ Hybrid Cable Length (feet)"]
[null,"RAYCAP:"]
[null,"Number of Coaxial Cable Runs (quantity)"]
[null,"Coaxial Cable Size "]
[null,"Total Number of Antennas (quantity)"]
[]
[null,"TOTAL 700 ANTENNA"]
[null,"700 Antenna Azimuth"]
[null,"700 Antenna Manufacturer"]
[null,"700  Antenna Model"]
[null,"700 Antenna Serial #"]
[null,"700 Antenna Rad Center"]
[null,"700 RET Name/ Serial #"]
[null,"700 Antenna Electrical Tilt (EDT)"]
[null,"700 Antenna Mechanical Tilt (MDT)"]
[null,"700 TMA (Model/Serial #)"]
[null,"700 Diplexers (Tower-Model)"]
[null,"700 Diplexers (Shelter- Model)"]
[]
[null,"TOTAL AWS ANTENNA"]
[null,"AWS Antenna Azimuth"]
[null,"AWS Antenna Manufacturer"]
[null,"AWS  Antenna Model"]
[null,"AWS Antenna Serial #"]
[null,"AWS Antenna Rad Center"]
[null,"AWS RET Name/ Serial #"]
[null,"AWS Antenna Electrical Tilt (EDT)"]
[null,"AWS Antenna Mechanical Tilt (MDT)"]
[null,"AWS TMA  (Model/Serial #)"]
[null,"AWS Diplexers (Tower)"]
[null,"AWS Diplexers (Shelter)"]
[]
[null,"TOTAL 850MHz ANTENNA"]
[null,"850 MHz Antenna Azimuth"]
[null,"850 MHz Antenna Manufacturer"]
[null,"850 MHz  Antenna Model"]
[null,"850 MHz Antenna Serial #"]
[null,"850 MHz Antenna Rad Center"]
[null,"850 RET Name/ Serial #"]
[null,"850 Antenna Electrical Tilt (EDT)"]
[null,"850 MHz Antenna Mechanical Tilt (MDT)"]
[null,"850 TMA  (Model/Serial #)"]
[null,"850 BIAS TEE (Make/Model)"]
[null,"850 Diplexers (Tower-Model)"]
[null,"850 Diplexers (Shelter- Model)"]
[]
[null,"TOTAL PCS-A ANTENNA"]
[null,"PCS Antenna Azimuth"]
[null,"PCS Antenna Manufacturer"]
[null,"PCS Antenna Serial #"]
[null,"PCS  Antenna Model"]
[null,"PCS Antenna Rad Center"]
[null,"PCS RET Name/ Serial #"]
[null,"PCS Antenna Electrical Tilt (EDT)"]
[null,"PCS Antenna Mechanical Tilt (MDT)"]
[null,"PCS TMA  (Model/Serial #)"]
[null,"PCS BIAS TEE (Make/Model)"]
[null,"PCS Diplexers (Tower-Model)"]
[null,"PCS Diplexers (Shelter- Model)"]
[]
[null,"TOTAL PCS-E ANTENNA"]
[null,"PCS Antenna Azimuth"]
[null,"PCS Antenna Manufacturer"]
[null,"PCS Antenna Serial #"]
[null,"PCS  Antenna Model"]
[null,"PCS Antenna Rad Center"]
[null,"PCS RET Name/ Serial #"]
[null,"PCS Antenna Electrical Tilt (EDT)"]
[null,"PCS Antenna Mechanical Tilt (MDT)"]
[null,"PCS TMA  (Model/Serial #)"]
[null,"PCS BIAS TEE (Make/Model)"]
[null,"PCS Diplexers (Tower-Model)"]
[null,"PCS Diplexers (Shelter- Model)"]
[]
[null,"COMMENTS:"]

{"sheet":"Sweep-PIM","index":4,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":false,"merged":[[65,0,67,3],[65,4,67,12],[90,4,92,12],[90,0,92,3]]}
["Sector ","Frequency","Color Code","Ant RL-Mandantory for all NEW Antennas","PIM Ant-Mandatory for all NEW Antennas","PIM Coax-Mandatory for all NEW Coax Systems","PIM Sys-Mandatory for all NEW Coax/Ant Systems","IL-Mandatory for all NEW Coax Systems","RL Load-Mandatory for all NEW Coax Systems","RL Sys-Mandatory for all NEW Coax/Ant Systems","DTF Load-Mandatory for all NEW Coax Systems","DTF Short-Mandatory for all NEW Coax Systems","DTF Sys-Mandatory for all NEW Coax/Ant Systems"]
[]
["Alpha",850,"WY"]
["Alpha",850,"WYY"]
[]
["Beta",850,"BY"]
["Beta",850,"BYY"]
[]
["Gamma",850,"GY"]
["Gamma",850,"GYY"]
[]
["Alpha","PCS-A","WP"]
["Alpha","PCS-A","WPP"]
[]
["Beta","PCS-A","BP"]
["Beta","PCS-A","BPP"]
[]
["Gamma","PCS-A","GP"]
["Gamma","PCS-A","GPP"]
[]
["Alpha","PCS-E","WWP"]
["Alpha","PCS-E","WWPP"]
[]
["Beta","PCS-E","BBP"]
["Beta","PCS-E","BBPP"]
[]
["Gamma","PCS-E","GGP"]
["Gamma","PCS-E","GGPP"]
[]
["Alpha",700,"WO"]
["Alpha",700,"WOO"]
[]
["Beta",700,"BO"]
["Beta",700,"BOO"]
[]
["Gamma",700,"GO"]
["Gamma",700,"GOO"]
[]
["Alpha","AWS","WR"]
["Alpha","AWS","WRR"]
[]
["Beta","AWS","BR"]
["Beta","AWS","BRR"]
[]
["Gamma","AWS","GR"]
["Gamma","AWS","GRR"]
[]
["Alpha","700 (Sector Split)","WOOO"]
["Alpha","700 (Sector Split)","WOOOO"]
[]
["Beta","700 (Sector Split)","BOOO"]
["Beta","700 (Sector Split)","BOOOO"]
[]
["Gamma","700 (Sector Split)","GOOO"]
["Gamma","700 (Sector Split)","GOOOO"]
[]
["Alpha","AWS (Sector Split)","WRRR"]
["Alpha","AWS (Sector Split)","WRRRR"]
[]
["Beta","AWS (Sector Split)","BRRR"]
["Beta","AWS (Sector Split)","BRRRR"]
[]
["Gamma","AWS (Sector Split)","GRRR"]
["Gamma","AWS (Sector Split)","GRRRR"]
[]
["Notes/Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"GPS"]
[null,null,"B"]
[null,null,"PP"]
[null,null,"PBP"]
[null,null,"PPB"]
[]
["Notes/Comments:"]

{"sheet":"RET Screen Shot","index":5,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"*Example Shown Below"]

{"sheet":"Fiber OTDR Results","index":6,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,37,1],[35,2,37,5],[35,8,37,9],[35,10,37,13]]}
[]
[null,"Test Date","Overall Length","Reflection","Loss","Pass/Fail",null,null,null,"Test Date","Overall Length","Reflection","Loss","Pass/Fail"]
["AWS",null,null,null,null,null,null,null,"AWS B2B"]
["Alpha A 1310nm",null,null,null,null,null,null,null,"Alpha (2) A 1310nm"]
["Alpha A 1550nm",null,null,null,null,null,null,null,"Alpha (2) A 1550nm"]
["Alpha B 1310nm",null,null,null,null,null,null,null,"Alpha (2) B 1310nm"]
["Alpha B 1550nm",null,null,null,null,null,null,null,"Alpha (2) B 1550nm"]
[]
["Beta A 1310nm",null,null,null,null,null,null,null,"Beta (2) A 1310nm"]
["Beta A 1550nm",null,null,null,null,null,null,null,"Beta (2) A 1550nm"]
["Beta B 1310nm",null,null,null,null,null,null,null,"Beta (2) B 1310nm"]
["Beta B 1550nm",null,null,null,null,null,null,null,"Beta (2) B 1550nm"]
[]
["Gamma A 1310nm",null,null,null,null,null,null,null,"Gamma (2) A 1310nm"]
["Gamma A 1550nm",null,null,null,null,null,null,null,"Gamma (2) A 1550nm"]
["Gamma B 1310nm",null,null,null,null,null,null,null,"Gamma (2) B 1310nm"]
["Gamma B 1550nm",null,null,null,null,null,null,null,"Gamma (2) B 1550nm"]
[]
["LTE",null,null,null,null,null,null,null,"LTE B2B"]
["Alpha A 1310nm",null,null,null,null,null,null,null,"Alpha (2) A 1310nm"]
["Alpha A 1550nm",null,null,null,null,null,null,null,"Alpha (2) A 1550nm"]
["Alpha B 1310nm",null,null,null,null,null,null,null,"Alpha (2) B 1310nm"]
["Alpha B 1550nm",null,null,null,null,null,null,null,"Alpha (2) B 1550nm"]
[]
["Beta A 1310nm",null,null,null,null,null,null,null,"Beta (2) A 1310nm"]
["Beta A 1550nm",null,null,null,null,null,null,null,"Beta (2) A 1550nm"]
["Beta B 1310nm",null,null,null,null,null,null,null,"Beta (2) B 1310nm"]
["Beta B 1550nm",null,null,null,null,null,null,null,"Beta (2) B 1550nm"]
[]
["Gamma A 1310nm",null,null,null,null,null,null,null,"Gamma (2) A 1310nm"]
["Gamma A 1550nm",null,null,null,null,null,null,null,"Gamma (2) A 1550nm"]
["Gamma B 1310nm",null,null,null,null,null,null,null,"Gamma (2) B 1310nm"]
["Gamma B 1550nm",null,null,null,null,null,null,null,"Gamma (2) B 1550nm"]
[]
[]
["Notes/Comments:",null,null,null,null,null,null,null,"Notes/Comments:"]

{"sheet":"Feeder Misc","index":7,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":true,"merged":[[0,0,0,15],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,15]]}
["Transmission Line Specifications"]
[null,null,null,"700 Band",null,"850 Band",null,"1700 Band",null,"1900 Band",null,"2100 Band",null,"Delay"]
["Manufacture","Feeder","Diameter","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Rel.Velocity","delay m/ns","delay ft/ns"]
["ANDREW","LDF 4-50A","1/2\"",1.83E-2,6.0100000000000001E-2,2.0334285714285714E-2,6.6677142857142851E-2,null,null,3.1600000000000003E-2,0.10399999999999998,3.3399999999999999E-2,0.11,0.88,0.26400000000000001,0.86614173360000013]
["ANDREW","LDF 5-50A","7/8\"",1.03E-2,3.3700000000000001E-2,1.1485714285714287E-2,3.7568571428571423E-2,null,null,1.805E-2,5.9299999999999999E-2,1.9199999999999998E-2,6.2899999999999998E-2,0.89,0.26700000000000002,0.87598425330000007]
["ANDREW","LDF 6-50A","1 1/4\"",7.3200000000000001E-3,2.4E-2,8.171142857142856E-3,2.678285714285714E-2,null,null,1.3100000000000001E-2,4.2950000000000002E-2,1.3899999999999999E-2,4.5599999999999995E-2,0.89,0.26700000000000002,0.87598425330000007]
["ANDREW","LDF 7-50A","1 5/8\"",6.0200000000000002E-3,1.9740000000000001E-2,6.7388571428571428E-3,2.210742857142857E-2,null,null,1.095E-2,3.5915000000000002E-2,1.1650000000000001E-2,3.8239999999999996E-2,0.88,0.26400000000000001,0.86614173360000013]
["ANDREW","LDF 12-50","2 1/4\"",5.1900000000000002E-3,1.703E-2,5.827714285714285E-3,1.9132857142857142E-2,null,null,9.6150000000000003E-3,3.1555E-2,1.026E-2,3.3660000000000002E-2,0.88,0.26400000000000001,0.86614173360000013]
["ANDREW","AVA 5-50","7/8\"",9.4299999999999991E-3,3.0929999999999999E-2,1.0474571428571429E-2,3.4361999999999997E-2,null,null,1.6345000000000002E-2,5.364E-2,1.7310000000000002E-2,5.6779999999999997E-2,0.91,0.27300000000000002,0.89566929270000006]
["ANDREW","AVA 7-50","1 5/8\"",5.6100000000000004E-3,1.84E-2,6.2477142857142853E-3,2.0509142857142858E-2,null,null,9.9299999999999996E-3,3.2579999999999998E-2,1.0540000000000001E-2,3.4569999999999997E-2,0.92,0.27600000000000002,0.90551181240000012]
["ANDREW","VXL 5-50","7/8\"",1.119E-2,3.6699999999999997E-2,1.2441714285714287E-2,4.082714285714286E-2,null,null,1.9565000000000003E-2,6.4190000000000011E-2,2.0729999999999998E-2,6.8019999999999997E-2,0.88,0.26400000000000001,0.86614173360000013]
["ANDREW","VXL 6-50","1 1/4\"",7.9500000000000005E-3,2.6070000000000003E-2,8.8760000000000002E-3,2.9132571428571428E-2,null,null,1.4279999999999999E-2,4.6854999999999994E-2,1.5180000000000001E-2,4.981E-2,0.88,0.26400000000000001,0.86614173360000013]
["ANDREW","FXL 780","7/8\"",9.8099999999999993E-3,3.2189999999999996E-2,1.0902E-2,3.5764285714285714E-2,null,null,1.7024999999999998E-2,5.5854999999999995E-2,1.8020000000000001E-2,5.9130000000000002E-2,0.88,0.26400000000000001,0.86614173360000013]
["ANDREW","FXL 1873","1 5/8\"",5.5400000000000007E-3,1.8169999999999999E-2,6.1777142857142855E-3,2.0282857142857144E-2,null,null,9.8949999999999993E-3,3.2465000000000001E-2,1.0509999999999999E-2,3.449E-2,0.88,0.26400000000000001,0.86614173360000013]
["Superior Essex","LHF 12D","1/2\"",1.83E-2,6.0100000000000001E-2,2.0334285714285714E-2,6.6677142857142851E-2,null,null,3.1600000000000003E-2,0.10399999999999998,3.3399999999999999E-2,0.11,0.88,null,1.1399999999999999]
["Superior Essex","LHF 22D","7/8\"",1.03E-2,3.3700000000000001E-2,1.1485714285714287E-2,3.7568571428571423E-2,null,null,1.805E-2,5.9299999999999999E-2,1.9199999999999998E-2,6.2899999999999998E-2,0.89,null,1.1200000000000001]
["Superior Essex","LHF 42D","1 5/8\"",6.0200000000000002E-3,1.9740000000000001E-2,6.7388571428571428E-3,2.210742857142857E-2,null,null,1.095E-2,3.5915000000000002E-2,1.1650000000000001E-2,3.8239999999999996E-2,0.88,null,1.1100000000000001]
["EUPEN","EC 5-50A","7/8\"",9.6399999999999993E-3,3.1600000000000003E-2,1.0719148936170214E-2,3.5117021276595745E-2,null,null,1.66E-2,5.4600000000000003E-2,1.7570588235294119E-2,5.7729411764705876E-2,0.89,0.26700000000000002,0.87598425330000007]
["EUPEN","EC 6-50A","1 1/4\"",6.9799999999999992E-3,2.29E-2,7.7600000000000004E-3,2.5451063829787235E-2,null,null,1.2199999999999999E-2,0.04,1.2952941176470589E-2,4.23764705882353E-2,0.88,0.26400000000000001,0.86614173360000013]
["EUPEN","EC 7-50A","1 5/8\"",5.6999999999999993E-3,1.8700000000000001E-2,6.3439999999999998E-3,2.0834285714285711E-2,null,null,9.9799999999999993E-3,3.27E-2,1.06E-2,3.4599999999999999E-2,0.89,0.26700000000000002,0.87598425330000007]
["Commscope","CR 1070 PE","7/8\"",9.1000000000000004E-3,2.9900000000000003E-2,1.0148571428571429E-2,3.3257142857142853E-2,{"$f":"1.52/100","v":1.52E-2},null,1.6299999999999999E-2,5.3399999999999996E-2,1.7299999999999999E-2,5.67E-2,0.88,0.26400000000000001,0.86614173360000013]
["Commscope","CR 1873 PE","1 5/8\"",5.5000000000000005E-3,1.8200000000000001E-2,6.1114285714285706E-3,2.0134285714285712E-2,null,null,1.0150000000000001E-2,3.3349999999999998E-2,1.0800000000000001E-2,3.5400000000000001E-2,0.88,0.26400000000000001,0.86614173360000013]
["RFS","LCF 12-50J","1/2\"",1.8100000000000002E-2,5.9500000000000004E-2,2.0134285714285712E-2,6.5977142857142859E-2,null,null,3.1100000000000003E-2,0.10199999999999999,3.2899999999999999E-2,0.10800000000000001,0.88,0.26400000000000001,0.86614173360000013]
["RFS","LCF 78-50JA","7/8\"",9.8300000000000002E-3,3.2300000000000002E-2,1.0985714285714286E-2,3.5894285714285712E-2,null,null,1.72E-2,5.6500000000000002E-2,1.83E-2,5.9900000000000002E-2,0.89,0.26700000000000002,0.87598425330000007]
["RFS","LCFS 114-50JA","1 1/4\"",7.3099999999999997E-3,2.4E-2,8.1611428571428564E-3,2.678285714285714E-2,null,null,1.30875E-2,4.2834999999999998E-2,1.3899999999999999E-2,4.5499999999999999E-2,0.89,0.26700000000000002,0.87598425330000007]
["RFS","LCF 158-50JA","1 5/8\"",5.9099999999999995E-3,1.9400000000000001E-2,6.6188571428571433E-3,2.1708571428571428E-2,null,null,1.0750000000000003E-2,3.5250000000000004E-2,1.1399999999999999E-2,3.7599999999999995E-2,0.9,0.27,0.88582677300000012]
["Commscope","CR 540 Jumper","1/2\"",{"$f":"1.74/100","v":1.7399999999999999E-2},5.2199999999999996E-2,1.9E-2,5.8464000000000002E-2,{"$f":"2.87/100","v":2.87E-2},null,{"$f":"3.04/100","v":3.04E-2},9.1200000000000003E-2,{"$f":"3.2/100","v":3.2000000000000001E-2},9.6000000000000002E-2,0.88,0.26400000000000001,0.86614173360000013]
["NK Cables","1 5/8\"-50","1 5/8\"",5.6499999999999996E-3,1.695E-2,6.3280000000000003E-3,1.8984000000000001E-2,null,null,9.8356104E-3,2.95068312E-2,1.0396240192799999E-2,3.1188720578399998E-2,null,null,0.89]
["EUPEN","EC 4-50A","1/2\"",1.83E-2,5.4900000000000004E-2,2.0496000000000004E-2,6.1488000000000008E-2,null,null,3.1856932800000008E-2,9.5570798400000018E-2,3.3672777969600005E-2,0.10101833390880002,null,null,0.88]
["standard","1 5/8\"","1 5/8\"",5.6100000000000004E-3,1.6830000000000001E-2,6.2832000000000009E-3,1.8849600000000005E-2,null,null,9.7659777600000008E-3,2.9297933280000001E-2,1.0322638492320001E-2,3.0967915476960005E-2,null,null,0.90551181240000012]
["standard","LMR-400","1/2\"",1.83E-2,5.4900000000000004E-2,2.0496000000000004E-2,6.1488000000000008E-2,null,null,3.1856932800000008E-2,9.5570798400000018E-2,3.3672777969600005E-2,0.10101833390880002,null,null,1.2]
["standard","FSJ 4-50B","1/2\"",2.9510000000000002E-2,8.8529999999999998E-2,3.3051200000000003E-2,9.9153600000000008E-2,null,null,5.1371480160000003E-2,0.15411444048,5.4299654529120001E-2,0.16289896358736,null,null,0.81]
["standard","1/2\" Coax","1/2\"",1.83E-2,5.4900000000000004E-2,2.0496000000000004E-2,6.1488000000000008E-2,null,null,3.1856932800000008E-2,9.5570798400000018E-2,3.3672777969600005E-2,0.10101833390880002,null,null,0.86614173360000013]
[null,"LMR-240","1/4\"",6.7500000000000004E-2,0.20250000000000001,7.5999999999999998E-2,0.248,null,null,0.112,0.33600000000000002,0.11899999999999999,0.35699999999999998,null,null,1.21]
["Fiber","Fiber",null,0,0,0,0,null,null,0,0,0,0,1,0.3,0.98425196999999998]

{"sheet":"TMA-DIPLEXER","index":8,"n_rows":19,"n_cols":17,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Type","Model","Diameter","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Loss (dB/ft)","Loss (dB/m)","Rel.Velocity","delay m/ns","DL delay ft/ns","UL delay ft/ns"]
["TMA","COMMSCOPE",null,null,null,null,null,null,null,null,null,null,null,null,null,60,180]
["TMA","WESTELL",null,null,null,null,null,null,null,null,null,null,null,null,null,60,180]
["TMA","ANDREW-BYPASS",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["TMA","WESTELL-BYPASS",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["TMA","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Diplexer","ANDREW",null,null,null,null,null,null,null,null,null,null,null,null,null,11]
["Diplexer","RFS",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Diplexer","CLEARCOMM",null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
["Diplexer","NA",null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Sheet1","index":9,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["LTE ENB"]
["RRUL-- 1 Unit/6601"]
["RRUL-- 2 Units/6601"]
["RRUL-- 3 Units/ 6601"]
[]
["N/A"]
["LTE SHELF ADD"]
["RRUL-- 1 Unit/ ENB"]
["RRUL-- 2 Units/ENB"]
["RRUL-- 3 Units/ ENB"]
["RRUL-- 1 Unit/6601"]
["RRUL-- 2 Units/6601"]
["RRUL-- 3 Units/ 6601"]
[]
[]
[]
["AWS ENB"]
["AWS SHELF ADD"]
["RRUS-- 1 Unit/ ENB"]
["RRUS-- 2 Units/ENB"]
["RRUS-- 3 Units/ ENB"]
["RRUS-- 1 Unit/6601"]
["RRUS-- 2 Units/6601"]
["RRUS-- 3 Units/ 6601"]
[]
["N/A"]
["AWS ENB"]
["AWS SHELF ADD"]
["RRUS-- 1 Unit/ ENB"]
["RRUS-- 2 Units/ENB"]
["RRUS-- 3 Units/ ENB"]
["RRUS-- 1 Unit/6601"]
["RRUS-- 2 Units/6601"]
["RRUS-- 3 Units/ 6601"]
[]
["YES"]
["NO"]
[]
["INDOOR"]
["OUTDOOR"]
[]
["N/A"]
["MAIN"]
["MAIN/SECTOR"," "]
["MAIN/ DIST/ SECTOR"]
["SECTOR"]