{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Station Offset Tile Flowline","Info","GetTitleBlock"],"not_rendered":{"charts":0,"images":0,"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":"Station Offset Tile Flowline","index":0,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,7,1,9]]}
[null,null,null,null,null,null,{"$f":"Info!A1","v":"Tile G shots converter for C3D FL Profile.xlsm v0.50"}]
[null,"Data from Station Offset to Points ",null,null,null,"Input Tile Depth Below G",null,"Computed",null,null,null,"Data formatted for the Text file"]
["Point","Station","Offset","Elevation","Description","FT","Inches","Ground Z","Sta","Tile FL Z",null,"Station [space] Elevation"]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(D4,\"'\",\"\")","v":""},{"$f":"ROUND(SUBSTITUTE(B4,\"+\",\"\"),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(H4-F4-G4/12,1)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISERROR(J4),\"\",CONCATENATE(I4,\" \",J4))","v":""}]
[null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(D5,\"'\",\"\")","v":""},{"$f":"ROUND(SUBSTITUTE(B5,\"+\",\"\"),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(H5-F5-G5/12,1)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(ISERROR(J5),\"\",CONCATENATE(I5,\" \",J5))","v":""}]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$f":"ROUND(SUBSTITUTE(B9,\"+\",\"\"),1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(H9-F9-G9/12,1)","v":{"$error":"#VALUE!"}},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[null,null,null,null,null,null,null,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,""]
[]
["End","End","End","End","End","End","End","End","End","End","End","End"]

{"sheet":"Info","index":1,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,0,5,3],[6,0,6,3],[67,0,67,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[14,0,14,3],[13,0,13,3],[19,0,19,3],[30,0,30,3],[33,0,33,3],[42,0,42,3],[36,0,36,3],[39,0,39,3]]}
["Tile G shots converter for C3D FL Profile.xlsm v0.50"]
["2024-03-26"]
[]
["Description:"]
["This spreadsheet processes Station/Offset/Elevation values of shots exported from AutoCAD Civil 3D and converts the data into Station Elevation values for importing as a Civil 3D profile."]
[]
[]
[]
["How to Use:"]
["1. Click Enable Content for Macros."]
["2.  Paste values exported from the Station Offset to Points report of Civil 3D into cell A4 of the Station Offset Tile Flowline tab. "]
["3. Delete values that do not have useable data for tile flowline elevations. DO NOT delete columns H through L."]
["4. Click on the Station cell dropdown and choose Sort A to Z."]
["5. In columns F and G enter the values for Feet and Inches of tile depth below the ground shot elevation."]
["6. Click the Export Station Elevation to Txt File button and set the file name and location.         (Or manually paste the values from Column L into a text file.)"]
[]
["Limitations:"]
["23 points"]
[]
[]
[]
["Program support:"]
["State Conservation Engineer"]
["USDA Natural Resources Conservation Service"]
["210 Walnut St, Room 693"]
["Des Moines, Iowa 50309-2180"]
["(515) 284-4135"]
[]
["Updates"]
["v0.5"]
["Added exporting directly to a file."]

{"sheet":"GetTitleBlock","index":2,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"CONCATENATE(#REF!,#REF!,#REF!)","v":{"$error":"#REF!"}}]
[]
["First row Items"]
[]
["Project:",{"$f":"RIGHT(A2,LEN(A2)-I19)","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"FIND(A19,A2)+8","v":{"$error":"#REF!"}}]
["Basin Description:",{"$f":"RIGHT(A3,LEN(A3)-I20)","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"FIND(A20,A3)+18","v":{"$error":"#REF!"}}]
[]
[]
["Source String for remaining items"]
[{"$f":"CONCATENATE(A1,A2,A3,\" \",A4,\" \",A5,\" \",A6,\" \",A7,\" \",A8,\" \",A9,\" \",A10,\" \",A11,\" \",A12,\" \",A13, A14, A15)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]