{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Staking Table","Report Run","Lat-Long Report","Output"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Staking Table","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Staking Table"]
["Mile and Tower","Station"]
[null,null,null,"Number of rows"]
[null,null,null,{"$f":"COUNTA(A:A)-2","v":0}]
[]
[null,null,null,"Line Name"]
[null,null,null,null,null,"made by Chris Norman normanc@sce.com 7-28-2011"]
[null,null,null,null,null,"Procedure"]
[null,null,null,null,null,"1) Open PLS CADD File"]
[null,null,null,"Run by:",null,"2) Open FEA File and add a feature code 10.  Call it \"cable\", give it a red star symbol for profile view, and make sure it is not on the ground"]
[null,null,null,null,null,"3) In Sections, Display Option, Display all sections at 25 deg-F, initial RS, and wind from left"]
[null,null,null,null,null,"4) In the Sections table,  Under \"Command To Apply\" select \"Create Survey Points at Specified intervals along wires for all wires, click OK"]
[null,null,null,"<<Inputs>>",null,"5) Select your 10 FAA feature code from the dialogue box that pops up and click ok."]
[null,null,null,null,null,"6) Now, go to Terrain / TIN / TIN interpolation of Z and H for non ground survey points and select code 10"]
[null,null,null,null,null,"7) Go to Terrain / Survey data display options, and choose draw symbol selected in FEA table, check draw only designated FEA code 10, and draw only points above TIN <height> feet, and click OK."]
[null,null,null,null,null,"8) Now go to Terrain and create Survey Data Report"]
[null,null,null,null,null,"9) copy the station column and paste it in the \"Report Run\" sheet of this document under \"Station\""]
[null,null,null,null,null,"Note: Click on \"Clear data\" button on this page to clear data from all four tabs."]
[null,null,null,null,null,"10) copy the height column and paste it in the \"Report Run\" sheet of the document under \"Height\""]
[null,null,null,null,null,"11) Sort station and height data based on stationing values"]
[null,null,null,null,null,"12) Open the Staking Table and copy the Mile & Tower and station columns and paste it to the left on this sheet under \"Mile and Tower\" , sort by station"]
[null,null,null,null,null,"13) Run the Lat-Long Report Under Lines / Reports / Structure Longitude and Latitude Report and paste the results in the Lat-Long Report Sheet (b5)"]
[null,null,null,null,null,"14) Click the \"Run Report\" Button above."]
[null,null,null,null,null,"15) Copy contents of \"Output\" and Paste special \"values only\" to another spread sheet"]

{"sheet":"Report Run","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Station","Height"]
[]
[null,null,null,"Number of Rows"]
[null,null,null,{"$f":"COUNTA(A:A)-1","v":0}]

{"sheet":"Lat-Long Report","index":2,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Struct. Number","Structure Name","Longitude  (deg)","Latitude  (deg)","Elevation  (ft)","Structure Height (ft)","Longitude  (DMS)","Latitude  (DMS)"]

{"sheet":"Output","index":3,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,3,1,5],[1,6,1,8],[0,0,0,8]]}
[]
[null,null,null,"From",null,null,"To"]
["From","To","Max Height","Lat ","Long","CL Hub Elev.","Lat ","Long","CL Hub Elev."]