{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover"," RPL Abbreviations","Check List","Change List","RPL","SLD","Crossings","Route Eng"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":86,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,3,23,5],[0,0,4,2],[0,3,4,5],[0,6,4,8],[5,0,16,8],[26,7,26,8],[26,5,26,6],[26,2,26,4],[26,0,26,1],[18,1,21,2],[18,6,21,7],[24,0,24,1],[24,2,24,4],[24,5,24,6],[24,7,24,8],[31,0,31,1],[30,0,30,1],[30,2,30,4],[30,5,30,6],[30,7,30,8],[28,0,28,1],[28,2,28,4],[28,5,28,6],[28,7,28,8]]}
[null,null,null,"© 2006",null,null,"Marine Operations Department"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Issue: \nPSR06",null,null,null,null,"DATE:\n06 Nov 2006"]
[]
[]
[]
[]
[null,null,null,"AUTHORISATION"]
["SIGNATORY",null,"SIGNATURE",null,null,"NAME",null,"DATE"]
[]
["ORIGINATOR",null,null,null,null,"A. Palmer-Felgate",null,"2006-11-06"]
[]
["CHECKED"]
[]
["PURCHASER"]
["ACCEPTED"]

{"sheet":" RPL Abbreviations","index":1,"n_rows":105,"n_cols":5,"rows_kept":105,"cut":false,"hidden":false,"merged":[[5,0,5,3],[6,0,6,3],[7,0,7,3],[0,0,0,4],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["ROUTE POSITION LIST (RPL) ABBREVIATIONS"]
["RPL Naming Convention",null,null,null,"RPL Issue"]
["DESK TOP STUDY RPLs",null,null,null,"DTS (1,2…)"]
["SURVEY ROUTE RPLs - (Agreed survey route with subsequent changes, during survey ops)",null,null,null,"SR (1, 2…)"]
["POST SURVEY ROUTE RPLs - (incl. Slack, PLUP/DN, Bus, transitions and Repeaters etc)",null,null,null,"PSR (1, 2…)"]
["AS-BUILT RPL - (Manufactured lengths)",null,null,null,"AB (1, 2…)"]
["POST-LOAD RPLs - (Loaded cable lengths)",null,null,null,"PL (1, 2…)"]
["AS-LAID RPLs - (subsequent issue numbers reflect repairs/changes)",null,null,null,"AL (1, 2…)"]
[]
["Abbreviation","Meaning",null,"Typical Use in MakaiPlan","MakaiPlan Type"]
["AB-xxx","As-Built"]
["AC","Alter Course"]
["AF","As Found (Cable) by MG / SS",null,"CX China-US AF MAG","Ref"]
["AL-xxx","As-Laid"]
["BA","Beach Allowance",null,"BA 50m","Cable"]
["BAS","Burial Assessment Survey"]
["BJ","Beach Joint",null,null,"Body"]
["BL","Baseline",null,null,"Ref"]
["BMH","Beach ManHole",null,"BMH Porth Curno"]
["BU-xxx","Branching Unit",null,"BU-001 Abidjan","Body"]
["CC","Cable Corridor",null,"Enter CC","Ref"]
["CR","Contract Route"]
["CRS","Cable Route Study"]
["CX","Cable Crossing",null,"CX Old Cable OOS DB","Ref"]
["CZ","Contiguous Zone",null,null,"Ref"]
["DA","Double Armour",null,null,"Cable"]
["DA1","Double Armour 1",null,null,"Cable"]
["DA2","Double Armour 2",null,null,"Cable"]
["DAH","Double Armour Heavy",null,null,"Cable"]
["DAM","Double Armour Medium",null,null,"Cable"]
["DB","Database position of cable",null,"CX Old Cable OOS DB"]
["DE","Duct End",null,"DE","Ref"]
["DS","Duct start",null,"DS","Ref"]
["DTS","Desk Top Study"]
["DWA","Deep Water Armoured",null,null,"Cable"]
["DWP","Deep Water Protected",null,null,"Cable"]
["EEZ","Exclusive Economic Zone",null,"EEZ Country MB","Ref"]
["EOB","End of burial",null,"PLUP EOB","Ref"]
["EP","End pipe",null,"EP","Ref"]
["FS","Final Splice",null,"FS Segment Name","Body"]
["FSA","Final Splice Allowance",null,null,"Cable"]
["FSPL","Fibre Splice",null,null,"Body"]
["HA","Heavy Armour",null,null,"Cable"]
["IN","Information",null,"IN Start of CC","Ref"]
["IPM","Installation Project Manager"]
["IS","Initial Splice",null,"IS Segment Name","Body"]
["JB-xxx","Joint Box",null,"JB-001 Any other comment","Body"]
["KP","Kilometre Point"]
["LC","Land Cable (instead of Land)",null,null,"Cable"]
["LP","Landing Point",null,"LP Porth Curno","Ref"]
["LPM","Line Project Manager"]
["LW","Lightweight",null,null,"Cable"]
["LWA","Light Wire Armoured",null,null,"Cable"]
["LWP","Lightweight Protected",null,null,"Cable"]
["LWS","Lightweight Screened",null,null,"Cable"]
["MB","Maritime Boundary",null,"TW Country MB","Ref"]
["MG","Magnetometer Identified Cable",null,"CX Unidentified MG"]
["MIG","Marine Installation Guide"]
["OOS","Out of Service",null,"CX Old Cable OOS DB"]
["PEU-xxx","Passive Equaliser Unit",null,"PEU-001","Body"]
["PLB","Post Lay Burial",null,"PLB Start","Ref"]
["PLDN","Plough Down",null,"PLDN","Ref"]
["PLI","Post-Lay Inspection"]
["PLIB","Post Lay Inspection and Burial"]
["PLUP","Plough Up",null,"PLUP","Ref"]
["PL-xxx","Post Load"]
["PN","Planned cable",null,"CX Planned cable name PN","Ref"]
["PSCF","Pure Silica Core Fibre"]
["PSR-xxx","Post Survey Route"]
["PX","Pipeline Crossing",null,"PX Pipeline name","Ref"]
["RA","Rock Armour",null,null,"Cable"]
["RAH","Remote Amplifier Housing",null,"RAH-001","Body"]
["RCLW","Reinforced Cable Lightweight",null,null,"Cable"]
["RCLWP","Reinforced Cable Lightweight Protected",null,null,"Cable"]
["REH","Route Engineering Handbook"]
["RPL","Route Position List"]
["RPTR-xxx","Repeater",null,"RPTR-001","Body"]
["SA","Single Armour",null,"TR SA/SAH","Cable"]
["SAH","Single Armour Heavy",null,"TR SA/SAH","Cable"]
["SAL","Single Armour Light",null,"TR SA/SAL","Cable"]
["SC","Slack Change",null,"SC 3%","Ref"]
["SE","Shore End",null,null,"Ref"]
["SEQ-xxx","Shape Equaliser",null,"SEQ-001","Body"]
["SJ-YYY-xxx","Ship Joint",null,"SJ-OVK-001","Body"]
["SLD","Straight Line Diagram"]
["SLLI","Shipboard Load & Lay Instructions"]
["SOB","Start of burial",null,"PLDN SOB","Ref"]
["SP","Start pipe",null,"SP","Ref"]
["SPA","Special Applications",null,null,"Cable"]
["SPDA","Special Purpose Double Armour",null,null,"Cable"]
["SPEU-xxx","Super Passive Equaliser Unit",null,"SPEU-001","Body"]
["SR-xxx","Survey Route"]
["SS","Side Scan Identified Cable",null,"CX Cable name  AF SS","Ref"]
["TEQA","Active Tilt Equaliser",null,"TEQA-001","Body"]
["TEQP","Passive Tilt Equaliser",null,"TEQP-001","Body"]
["TEQ-xxx","Tilt Equaliser",null,"TEQ-001","Body"]
["TO","Tolerance",null,"TO +350m/-25m","Ref"]
["TP","Temperature"]
["TPA","Traffic Precautionary Area",null,"Enter TPA"]
["TR","Transition",null,"TR LWP-40/LW--40","Body"]
["TSS","Traffic Separation Scheme",null,"Enter TSS"]
["TSZ","Traffic Separation Zone",null,"Enter TSZ"]
["TW","Territorial Waters",null,"TW Country MB","Ref"]
["WD","Water Depth",null,"WD 2300m","Ref"]
["WK","Wreck",null,"WK Wreck name","Ref"]

{"sheet":"Check List","index":2,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[27,0,27,10],[28,0,28,10],[17,0,17,10],[24,0,24,1],[0,0,0,10],[8,0,8,10],[12,0,12,10],[44,0,44,10],[19,0,19,10],[23,0,23,10],[21,0,21,10],[25,0,25,10],[2,0,2,10],[4,0,4,10],[6,0,6,10],[14,0,14,10],[10,0,10,10],[16,0,16,10],[39,0,39,10],[37,0,37,10],[31,0,31,10],[33,0,33,10],[35,0,35,10],[30,0,30,10]]}
["ROUTE POSITION LIST (RPL) CHECKLIST",null,null,null,null,null,null,null,null,null,null,"Yes","No","N/A"]
[]
["Contingency on planned transitions?"]
[]
["Final splice allowance included?"]
[]
["Branching Unit allowance included?"]
[]
["Cable on beach for joint and coil?"]
[null,null,"          "]
["Is the landing point on the survey the same position as the manhole position?"]
[]
["Do the cable transitions follow logically?"]
[]
["Are plough up and plough down positions in agreement with cable types?"]
[null,null,null,null,null," "]
["Check repeater positioning against:"]
["Final & Initial splice, deep burial and PLUP/PLDN positions, etc"]
[]
["Does the slack change at the plough up and down positions?"]
[]
["Are the MakaiPlan bottom slack values conforming to the current \"Route Engineering Handbook\" guidelines?"]
[]
["Laying buffer required/not required?"]
[]
["Correct projection and central meridian?"]
[]
["Has the total distance changed since last issue?"]
[]
[]
["Has the total cable length changed since last issue?"]
[]
[]
["Has the RPL been printed in Mercator and courses checked?"]
[]
["Has the entire route been plotted on A0 paper?"]
[]
["Does all route engineering conform to the current \"Route Engineering Guidelines\""]
[]
["Has a copy of this RPL been passed to Marine Engineering Management for database inclusion?"]

{"sheet":"Change List","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,3,9,15],[0,0,0,15],[1,3,1,15],[2,3,2,15],[4,3,4,15],[3,0,3,15],[8,3,8,15],[7,3,7,15],[6,3,6,15],[5,3,5,15]]}
["RPL, SLD & Route Engineering - CHANGES & TRACKING SHEET"]
["ISSUE","DOCUMENT","DATE","CHANGE"]
["CRE","RPL",null,"CRE route\nRoute length:  km\nCable length:  km"]
[]
["PSR-01","RPL","2006-02-08","Post AUV survey RPL.  Manufactures lengths applied - Note joint required to merge SA sections\nRoute length: 52.100km\nCable length: 52.362km"]
["PSR-02","RPL","2006-02-09","Re-engineered to allow 2.3 km spare SA\nRoute length: 52.100km\nCable length: 52.657km"]
["PSR-03","RPL","2006-03-24","Route reversed for eastward lay direction. FS replaced with ship joint and FS allowance removed\nRoute length: 52.100km\nCable length: 52.381km"]
["PSR-04","RPL","2006-04-18","Re-route off Duke Energy pipe to increase separation to >100m\nRoute length: 52.121km\nCable length: 52.396km"]
["PSR-05","RPL","2006-05-11","HDD exit point coordinate (landward end) updated to asbuilt coordinate (N4074054.4, E608118.8 WGS84, UTM Z10N).\nRoute length: 52.121km\nCable length: 52.396km"]
["PSR-06","RPL","2006-11-06","Route reversed for new lay direction.  Cable lengths updated from tanking plan on Maersk Defender\nRoute length: 52.121km\nCable length: 52.396km"]

{"sheet":"RPL","index":4,"n_rows":105,"n_cols":30,"rows_kept":105,"cut":false,"hidden":false,"merged":[[102,15,102,17],[103,15,103,17],[104,15,104,17],[0,2,0,4],[0,5,0,7],[100,15,100,17],[101,15,101,17]]}
["Point\nNo","Comment","Latitude",null,null,"Longitude",null,null,"A/C","Brg\n(°)","Alter Course\n(- P + S)","Depth\n(m)","Leg Dist\n(km)","Cum KP\nDist\n(km)","Reverse\nKP Dist\n(km)","Cable\nType","Surface\nSlack\n(%)","Leg\nCable\n(km)","Cum\nCable\n(km)","Cable by\nType\n(km)","Target\nBurial\n(m)","Comment","Auto\nLabel","Bottom\nSlack\n(%)","Body","Cum Dist\nby Rptr\n(km)","Reverse\nCable Dist\n(km)",null,null,"Bottom RPL: "]
[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,"MARS"]
[1,"HDD Start",36,48.369500000000002,"N",121,47.277099999999997,"W",null,null,null,20,null,0,52.121000000000002,null,null,null,0,null,null,"50m allowance Assy:  50 allowance",null,null,null,null,52.396000000000001,null,null,"mars_rovsurvey_ab-06_06-nov-06"]
[null,null,null,null,null,null,null,null,null,294.93400000000003,null,null,0,null,null,"SAL","N/A",0.05,null,null,null,"Cable Allowance","Pt-Cable","N/A",null,null,null,null,null,"2006-11-06"]
[2,"Cable Allowance",36,48.369500000000002,"N",121,47.277099999999997,"W",null,null,null,20,null,0,52.121000000000002,null,null,null,0.05,null,null,"Start of cable allowance",null,null,null,null,52.346000000000004,null,null,"16:25:10"]
[null,null,null,null,null,null,null,null,null,294.93400000000003,null,null,1.0409999999999999,null,null,"SAL",0.8,1.0489999999999999,null,null,null,null,null,0.8]
[3,"HDD End",36,48.606699999999996,"N",121,47.9116,"W",null,null,0.38,20,null,1.0409999999999999,51.08,null,null,null,1.099,null,null,null,null,null,null,null,51.297000000000004]
[null,null,null,null,null,null,null,null,null,295.31599999999997,null,null,4.0000000000000001E-3,null,null,"SAL",0.8,4.0000000000000001E-3,null,null,null,null,null,0.8]
[4,"SC 0.25%",36,48.607700000000001,"N",121,47.914200000000001,"W",null,null,null,20,null,1.0449999999999999,51.076000000000001,null,null,null,1.103,null,null,null,null,null,null,null,51.292999999999999]
[null,null,null,null,null,null,null,null,null,295.31599999999997,null,null,5.0000000000000001E-3,null,null,"SAL",0.25,5.0000000000000001E-3,null,null,null,null,null,0.25]
[5,"PLDN",36,48.608800000000002,"N",121,47.917000000000002,"W",null,null,null,20,null,1.05,51.071000000000005,null,null,null,1.1080000000000001,null,null,null,"PLDN",null,null,null,51.288000000000004]
[null,null,null,null,null,null,null,null,null,295.31599999999997,null,null,0.39800000000000002,null,null,"SAL",0.25,0.39900000000000002,null,null,null,null,"Bury",0.25]
[6,"AC",36,48.700800000000001,"N",121,48.158999999999999,"W","AC",null,21.36,20,null,1.448,50.673000000000002,null,null,null,1.5069999999999999,null,null,null,"AC1",null,null,null,50.889000000000003]
[null,null,null,null,null,null,null,null,null,316.68099999999998,null,null,5.2569999999999997,null,null,"SAL",0.25,5.2709999999999999,null,null,null,null,"Bury",0.25]
[7,"ENTER Naval Operating Area",36,50.768999999999998,"N",121,50.585099999999997,"W",null,null,null,25,null,6.7050000000000001,45.416000000000004,null,null,null,6.7779999999999996,null,null,"ng Area",null,null,null,null,45.618000000000002]
[null,null,null,null,null,null,null,null,null,316.68099999999998,null,null,0.161,null,null,"SAL",0.25,0.161,null,null,null,null,"Bury",0.25]
[8,"AC",36,50.832000000000001,"N",121,50.658999999999999,"W","AC",null,-15.02,26,null,6.8659999999999997,45.255000000000003,null,null,null,6.9390000000000001,null,null,null,"AC2",null,null,null,45.457000000000001]
[null,null,null,null,null,null,null,null,null,301.66500000000002,null,null,2.657,null,null,"SAL",0.25,2.6629999999999998,null,null,null,null,"Bury",0.25]
[9,"AC",36,51.586100000000002,"N",121,52.180399999999999,"W","AC",null,-11.09,36,null,9.5229999999999997,42.597999999999999,null,null,null,9.6020000000000003,null,null,null,"AC3",null,null,null,42.793999999999997]
[null,null,null,null,null,null,null,null,null,290.58,null,null,7.4909999999999997,null,null,"SAL",0.25,7.5110000000000001,null,null,null,null,"Bury",0.25]
[10,"AC",36,53.009900000000002,"N",121,56.900199999999998,"W","AC",null,-8.83,40,null,17.013999999999999,35.106999999999999,null,null,null,17.113,null,null,null,"AC4",null,null,null,35.283000000000001]
[null,null,null,null,null,null,null,null,null,281.74599999999998,null,null,1.0860000000000001,null,null,"SAL",0.25,1.0880000000000001,null,null,null,null,"Bury",0.25]
[11,"AC",36,53.129399999999997,"N",121,57.615600000000001,"W","AC",null,-11.44,40,null,18.100000000000001,34.021000000000001,null,null,null,18.201000000000001,null,null,null,"AC5",null,null,null,34.195]
[null,null,null,null,null,null,null,null,null,270.31,null,null,1.4910000000000001,null,null,"SAL",0.25,1.4950000000000001,null,null,null,null,"Bury",0.25]
[12,"EXIT Naval Operating Area",36,53.133800000000001,"N",121,58.619100000000003,"W",null,null,null,44,null,19.591000000000001,32.53,null,null,null,19.696000000000002,null,null,"ng Area",null,null,null,null,32.700000000000003]
[null,null,null,null,null,null,null,null,null,270.31,null,null,4.8760000000000003,null,null,"SAL",0.25,4.8879999999999999,null,null,null,null,"Bury",0.25]
[13,"AC",36,53.148099999999999,"N",122,1.9011,"W","AC",null,-14.98,60,null,24.466999999999999,27.654000000000003,null,null,null,24.584,null,null,null,"AC6",null,null,null,27.812000000000001]
[null,null,null,null,null,null,null,null,null,255.32900000000001,null,null,2.556,null,null,"SAL",0.25,2.5619999999999998,null,null,null,null,"Bury",0.25]
[14,"AC",36,52.798200000000001,"N",122,3.5649000000000002,"W","AC",null,-14.93,71,null,27.023,25.098000000000003,null,null,null,27.146000000000001,null,null,null,"AC7",null,null,null,25.25]
[null,null,null,null,null,null,null,null,null,240.40299999999999,null,null,1.1719999999999999,null,null,"SAL",0.25,1.175,null,null,null,null,"Bury",0.25]
[15,"3NM LIMIT",36,52.485199999999999,"N",122,4.2507000000000001,"W",null,null,null,79,null,28.195,23.926000000000002,null,null,null,28.321000000000002,null,null,null,null,null,null,null,24.074999999999999]
[null,null,null,null,null,null,null,null,null,240.40299999999999,null,null,5.1719999999999997,null,null,"SAL",0.25,5.1849999999999996,null,null,null,null,"Bury",0.25]
[16,"TR SAL/SA",36,51.104100000000003,"N",122,7.2766000000000002,"W",null,null,null,101,null,33.366999999999997,18.754000000000005,null,null,null,33.506,33.506000000000007,null,null,null,null,null,null,18.89]
[null,null,null,null,null,null,null,null,null,240.40299999999999,null,null,1.4370000000000001,null,null,"SA",0.25,1.4410000000000001,null,null,null,null,"Bury",0.25]
[17,"AC",36,50.720300000000002,"N",122,8.1173999999999999,"W",null,null,0.48,109,null,34.804000000000002,17.317,null,null,null,34.947000000000003,null,null,null,null,null,null,null,17.448999999999998]
[null,null,null,null,null,null,null,null,null,240.88499999999999,null,null,0.72599999999999998,null,null,"SA",0.26,0.72799999999999998,null,null,null,null,"Bury",0.25]
[18,"AC",36,50.529200000000003,"N",122,8.5442999999999998,"W","AC",null,17.27,114,null,35.53,16.591000000000001,null,null,null,35.674999999999997,null,null,null,"AC8",null,null,null,16.721000000000004]
[null,null,null,null,null,null,null,null,null,258.15499999999997,null,null,0.308,null,null,"SA",0.26,0.309,null,null,null,null,"Bury",0.25]
[19,"AC",36,50.494999999999997,"N",122,8.7470999999999997,"W","AC",null,-13.72,116,null,35.838000000000001,16.283000000000001,null,null,null,35.984000000000002,null,null,null,"AC9",null,null,null,16.411999999999999]
[null,null,null,null,null,null,null,null,null,244.43600000000001,null,null,0.25,null,null,"SA",0.26,0.251,null,null,null,null,"Bury",0.25]
[20,"PLUP",36,50.436700000000002,"N",122,8.8986999999999998,"W",null,null,null,120,null,36.088000000000001,16.033000000000001,null,null,null,36.234999999999999,null,null,null,"PLUP",null,null,null,16.161000000000001]
[null,null,null,null,null,null,null,null,null,244.43600000000001,null,null,2E-3,null,null,"SA",0.26,2E-3,null,null,null,null,null,0.25]
[21,"SC 1.0%",36,50.436199999999999,"N",122,8.8999000000000006,"W",null,null,null,120,null,36.090000000000003,16.030999999999999,null,null,null,36.237000000000002,null,null,null,null,null,null,null,16.158999999999999]
[null,null,null,null,null,null,null,null,null,244.43600000000001,null,null,9.6000000000000002E-2,null,null,"SA",1.03,9.6000000000000002E-2,null,null,null,null,null,1]
[22,"Smooth Ridge Start",36,50.413899999999998,"N",122,8.9580000000000002,"W",null,null,null,122,null,36.186,15.935,null,null,null,36.332999999999998,null,null,null,null,null,null,null,16.063000000000002]
[null,null,null,null,null,null,null,null,null,244.43600000000001,null,null,0.23100000000000001,null,null,"SA",1.03,0.23300000000000001,null,null,null,null,null,1]
[23,"AC",36,50.360100000000003,"N",122,9.0980000000000008,"W","AC",null,1.47,127,null,36.417000000000002,15.704000000000001,null,null,null,36.566000000000003,null,null,null,"AC10",null,null,null,15.83]
[null,null,null,null,null,null,null,null,null,245.90100000000001,null,null,0.54600000000000004,null,null,"SA",1.1499999999999999,0.55300000000000005,null,null,null,null,null,1]
[24,"SJ 1",36,50.2395,"N",122,9.4335000000000004,"W","AC",null,12.19,154,null,36.963000000000001,15.158000000000001,null,null,null,37.119,null,null,"Assy: Start of cable allowance","AC11",null,"JNT-A",null,15.277000000000001]
[null,null,null,null,null,null,null,null,null,245.90100000000001,null,null,2.9000000000000001E-2,null,null,"SA",1.46,0.03,null,null,null,null,null,1]
[25,"AC",36,50.2361,"N",122,9.4527999999999999,"W","AC",null,-8.41,157,null,36.991999999999997,15.129000000000005,null,null,null,37.149000000000001,null,null,null,"AC12",null,null,null,15.247]
[null,null,null,null,null,null,null,null,null,249.67699999999999,null,null,0.13,null,null,"SA",1.95,0.13200000000000001,null,null,null,null,null,1]
[26,"AC",36,50.2117,"N",122,9.5348000000000006,"W","AC",null,-13.17,175,null,37.122,14.999000000000002,null,null,null,37.280999999999999,null,null,null,"AC13",null,null,null,15.115]
[null,null,null,null,null,null,null,null,null,236.505,null,null,0.185,null,null,"SA",3.25,0.191,null,null,null,null,null,1]
[27,"AC",36,50.156799999999997,"N",122,9.6380999999999997,"W","AC",null,-9.56,214,null,37.307000000000002,14.814,null,null,null,37.472000000000001,null,null,null,"AC14",null,null,null,14.923999999999999]
[null,null,null,null,null,null,null,null,null,226.94800000000001,null,null,0.55500000000000005,null,null,"SA",2.16,0.56699999999999995,null,null,null,null,null,1]
[28,"AC",36,49.951599999999999,"N",122,9.9113000000000007,"W","AC",null,-12.32,294,null,37.862000000000002,14.259,null,null,null,38.039000000000001,null,null,null,"AC15",null,null,null,14.356999999999999]
[null,null,null,null,null,null,null,null,null,214.624,null,null,0.45900000000000002,null,null,"SA",1.07,0.46400000000000002,null,null,null,null,null,1]
[29,"AC",36,49.747599999999998,"N",122,10.086499999999999,"W","AC",null,-14.17,309,null,38.320999999999998,13.8,null,null,null,38.503,null,null,null,"AC16",null,null,null,13.893000000000001]
[null,null,null,null,null,null,null,null,null,200.45,null,null,0.56499999999999995,null,null,"SA",1.04,0.57099999999999995,null,null,null,null,null,1]
[30,"AC",36,49.461100000000002,"N",122,10.2194,"W","AC",null,-7.48,324,null,38.886000000000003,13.234999999999999,null,null,null,39.073999999999998,null,null,null,"AC17",null,null,null,13.322000000000003]
[null,null,null,null,null,null,null,null,null,192.96700000000001,null,null,1.08,null,null,"SA",1.0900000000000001,1.091,null,null,null,null,null,1]
[31,"AC",36,48.892499999999998,"N",122,10.382199999999999,"W","AC",null,18.03,365,null,39.966000000000001,12.154999999999999,null,null,null,40.164999999999999,null,null,null,"AC18",null,null,null,12.231000000000002]
[null,null,null,null,null,null,null,null,null,210.99799999999999,null,null,0.58499999999999996,null,null,"SA",1.05,0.59099999999999997,null,null,null,null,null,1]
[32,"AC",36,48.621400000000001,"N",122,10.5848,"W","AC",null,13.15,383,null,40.551000000000002,11.57,null,null,null,40.756,null,null,null,"AC19",null,null,null,11.64]
[null,null,null,null,null,null,null,null,null,224.14599999999999,null,null,0.71799999999999997,null,null,"SA",1.17,0.72699999999999998,null,null,null,null,null,1]
[33,"AC",36,48.342700000000001,"N",122,10.921200000000001,"W","AC",null,-9.36,422,null,41.268999999999998,10.852000000000004,null,null,null,41.482999999999997,null,null,null,"AC20",null,null,null,10.913000000000004]
[null,null,null,null,null,null,null,null,null,214.785,null,null,1.107,null,null,"SA",1.02,1.119,null,null,null,null,null,1]
[34,"AC",36,47.850999999999999,"N",122,11.346,"W","AC",null,-14.23,445,null,42.375999999999998,9.7449999999999992,null,null,null,42.601999999999997,null,null,null,"AC21",null,null,null,9.794000000000004]
[null,null,null,null,null,null,null,null,null,200.55600000000001,null,null,0.14199999999999999,null,null,"SA",1.04,0.14299999999999999,null,null,null,null,null,1]
[35,"Smooth Ridge End",36,47.779299999999999,"N",122,11.3794,"W",null,null,null,449,null,42.518000000000001,9.6030000000000015,null,null,null,42.744999999999997,null,null,null,null,null,null,null,9.6510000000000034]
[null,null,null,null,null,null,null,null,null,200.55600000000001,null,null,7.4999999999999997E-2,null,null,"SA",1.04,7.5999999999999998E-2,null,null,null,null,null,1]
[36,"PLDN",36,47.741199999999999,"N",122,11.3971,"W",null,null,null,451,null,42.593000000000004,9.5279999999999987,null,null,null,42.820999999999998,null,null,null,"PLDN",null,null,null,9.5749999999999993]
[null,null,null,null,null,null,null,null,null,200.55600000000001,null,null,2E-3,null,null,"SA",1.04,1E-3,null,null,null,null,"Bury",1]
[37,"SC 0.25%",36,47.740400000000001,"N",122,11.397500000000001,"W",null,null,null,451,null,42.594999999999999,9.5260000000000034,null,null,null,42.822000000000003,null,null,null,null,null,null,null,9.5739999999999981]
[null,null,null,null,null,null,null,null,null,200.55600000000001,null,null,0.85599999999999998,null,null,"SA",0.31,0.85899999999999999,null,null,null,null,"Bury",0.25]
[38,"AC",36,47.306899999999999,"N",122,11.5997,"W","AC",null,-14.22,481,null,43.451000000000001,8.67,null,null,null,43.680999999999997,null,null,null,"AC22",null,null,null,8.7149999999999999]
[null,null,null,null,null,null,null,null,null,186.34,null,null,1.0580000000000001,null,null,"SA",0.36,1.0620000000000001,null,null,null,null,"Bury",0.25]
[39,"TR SA/SAL",36,46.738399999999999,"N",122,11.6782,"W",null,null,null,528,null,44.509,7.6120000000000019,null,null,null,44.743000000000002,11.237,null,null,null,null,null,null,7.6529999999999987]
[null,null,null,null,null,null,null,null,null,186.34,null,null,8.1000000000000003E-2,null,null,"SAL",0.42,8.2000000000000003E-2,null,null,null,null,"Bury",0.25]
[40,"AC",36,46.694699999999997,"N",122,11.684200000000001,"W","AC",null,-14.19,533,null,44.59,7.5309999999999988,null,null,null,44.825000000000003,null,null,null,"AC23",null,null,null,7.570999999999998]
[null,null,null,null,null,null,null,null,null,172.14699999999999,null,null,1.0529999999999999,null,null,"SAL",0.49,1.0569999999999999,null,null,null,null,"Bury",0.25]
[41,"AC",36,46.131,"N",122,11.5876,"W","AC",null,-14.12,605,null,45.643000000000001,6.4780000000000015,null,null,null,45.881999999999998,null,null,null,"AC24",null,null,null,6.5140000000000029]
[null,null,null,null,null,null,null,null,null,158.02500000000001,null,null,0.13500000000000001,null,null,"SAL",0.68,0.13700000000000001,null,null,null,null,"Bury",0.25]
[42,"TW USA EXIT",36,46.063000000000002,"N",122,11.5535,"W",null,null,null,617,null,45.777999999999999,6.3430000000000035,null,null,null,46.018999999999998,null,null,null,null,null,null,null,6.3770000000000024]
[null,null,null,null,null,null,null,null,null,158.02500000000001,null,null,0.97,null,null,"SAL",0.56000000000000005,0.97499999999999998,null,null,null,null,"Bury",0.25]
[43,"AC",36,45.576900000000002,"N",122,11.309699999999999,"W","AC",null,12.25,693,null,46.747999999999998,5.3730000000000047,null,null,null,46.994,null,null,null,"AC25",null,null,null,5.402000000000001]
[null,null,null,null,null,null,null,null,null,170.27199999999999,null,null,1.2769999999999999,null,null,"SAL",0.5,1.2829999999999999,null,null,null,null,"Bury",0.25]
[44,"AC",36,44.8964,"N",122,11.1647,"W","AC",null,10.65,760,null,48.024999999999999,4.0960000000000036,null,null,null,48.277000000000001,null,null,null,"AC26",null,null,null,4.1189999999999998]
[null,null,null,null,null,null,null,null,null,180.922,null,null,2.7480000000000002,null,null,"SAL",0.28999999999999998,2.7559999999999998,null,null,null,null,"Bury",0.25]
[45,"PLUP",36,43.410699999999999,"N",122,11.1944,"W",null,null,null,822,null,50.773000000000003,1.347999999999999,null,null,null,51.033000000000001,null,null,"1.5 x WD before NODE","PLUP",null,null,null,1.3629999999999995]
[null,null,null,null,null,null,null,null,null,180.922,null,null,2E-3,null,null,"SAL",0.37,2E-3,null,null,null,null,null,0.25]
[46,"SC 1.0%",36,43.409799999999997,"N",122,11.1945,"W",null,null,null,823,null,50.774999999999999,1.3460000000000036,null,null,null,51.034999999999997,null,null,null,null,null,null,null,1.3610000000000042]
[null,null,null,null,null,null,null,null,null,180.922,null,null,1.2709999999999999,null,null,"SAL",1.1200000000000001,1.286,null,null,null,null,null,1]
[47,"CTA Tail Start SAH-20",36,42.722299999999997,"N",122,11.2082,"W",null,null,null,880,null,52.045999999999999,7.5000000000002842E-2,null,null,null,52.320999999999998,7.5779999999999994,null,"75m tail on CTA Assy:  75m tail on TRF",null,null,null,null,7.5000000000002842E-2]
[null,null,null,null,null,null,null,null,null,180.922,null,null,7.4999999999999997E-2,null,null,"SAH-20",1,7.4999999999999997E-2,null,null,null,null,null,1]
[48,"NODE",36,42.682000000000002,"N",122,11.209,"W",null,null,null,880,null,52.121000000000002,0,null,null,null,52.396000000000001,7.4999999999999997E-2,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable Type",null,null,"Length"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAL",null,null,{"$f":"SUMIF($P$4:$P$97,P102,$R$4:$R$97)","v":41.084000000000017}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA",null,null,{"$f":"SUMIF($P$4:$P$97,P103,$R$4:$R$97)","v":11.237}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAH-20",null,null,{"$f":"SUMIF($P$4:$P$97,P104,$R$4:$R$97)","v":7.4999999999999997E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,null,{"$f":"SUM($S$102:$S$104)","v":52.396000000000022}]

{"sheet":"SLD","index":5,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"BMH",null,"SA",null,"SJ 1",null,"SA",null,"SAL",null,"SAH-20",null,"NODE"]
[null,null,"SAL",null,"SA",null,"SA",null,"SA",null,"SAL",null,"SAH-20"]
[null,null,33.506,null,3.613,null,0,null,7.6239999999999997,null,7.5780000000000003,null,7.4999999999999997E-2]
[null,0,null,33.506,null,37.119,null,37.119,null,44.743000000000002,null,{"$f":"K7+J8","v":52.321000000000005},null,{"$f":"M7+L8","v":52.396000000000008}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"WD 880m"]
[]
[]
[null,"CABLE SUMMARY",null,null,null,null,null,"BODIES"]
[]
[null,"CABLE","SAL","SA","SA-C7","TOTAL",null,"JOINT",1]
[null,null,null,null,null,null,null,"BU",1]
[null,"SYSTEM",41.084000000000003,11.237,7.4999999999999997E-2,{"$f":"SUM(C16:E16)","v":52.396000000000008}]
[]
[null,"SPARE"]
[]
[null,"TOTAL",{"$f":"SUM(C16:C18)","v":41.084000000000003},{"$f":"SUM(D16:D18)","v":11.237},{"$f":"SUM(E16:E18)","v":7.4999999999999997E-2},{"$f":"SUM(F16:F18)","v":52.396000000000008}]
[]
[null,"SPARES NOT INCLUDED"]

{"sheet":"Crossings","index":6,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,5,0,7],[0,8,0,10],[8,2,8,12],[9,2,9,12],[6,2,6,12],[4,2,4,12],[5,2,5,12],[7,2,7,12],[10,2,10,12],[11,2,11,12],[16,2,16,12],[12,2,12,12],[13,2,13,12],[14,2,14,12],[15,2,15,12]]}
["Comment","Cable Status","Cable Type","Method located/ Info Srce","Action Needed","Latitude",null,null,"Longitude",null,null,"Depth (m)","Cum KP Dist (km)","System Cable Type","Xing Angle (deg)","Crossed Cable type","Cable Owner","Sediment Type","Distance to SYSTEM RPTR (km)","Distance to Existing RPTR (km)"]
["Pipeline","AF IS",null,"SSS","PLB",36,48.742400000000004,"N",121,48.088900000000002,"W",19,50.694000000000003,"SAL"]
[]
[]
[null,"RC","Shelf (<xxxxm water depth - SUBJECT TO ROUTE CLEARANCE FOR BURIAL"]
[null,"None","Shelf (<xxxxm water depth - NO BURIAL/SURFACE LAID  (no RC needed)"]
[null,"None","Deep Water (>xxxxm water depth = surface laid)"]
[null,"PROP","Proposed Cable System"]
[null,"OOS","Out-of-Service Cable"]
[null,"IS","In-Service Cable / Pipeline"]
[null,"PLB","Post lay burial required at in-service crossing"]
[null,"MAGGIE","Identified by Magnetometer. In-service cables subject 250m PLUP & PLDN"]
[null,"AF (SSS)","Identified by Side Scan Sonar.  In-service cables subject 250m PLUP & PLDN"]
[null,"AF (SBP)","Identified by Sub-Bottom Profiler.  In-service cables subject 250m PLUP & PLDN"]
[null,"ARCS","Admiralty Charts"]
[null,"DB (ASN)","ASN Database.  In-service cables subject 500m PLUP & PLDN"]
[null,"DB (GMSL)","Global Marine Systems Limited Database (Date). In-service cables subject 500m PLUP & PLDN"]

{"sheet":"Route Eng","index":7,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,5],[1,0,1,12]]}
["Start\nPosition",null,null,"End\nPosition",null,null,"Start\nKP","End\nKP","Leg\nDistance\n(km)","Cable\nType","Average\nSlack\n(%)","Burial\nType","Comments"]
["NOT COMPLETED"]