{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Function"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Function","index":0,"n_rows":40,"n_cols":121,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,2,2,3],[5,2,5,3]]}
[]
[]
[null,null,"BSEE Data Path (User-Input)"]
[null,null,"C:\\TIMSInputData"]
[]
[null,null,"User-Defined Folder Name to Save Export Files"]
[null,null,"Output"]
[]
[null,null,"Import File Name.CSV (Choose from List)"]
[null,null,"PIPELINE"]
[]
[null,null,"Export File Name","Doc. Ref. ID"]
[null,null,{"$f":"IF(D13=1,\"Platforms\",IF(D13=2,\"Platform Characteristics\",IF(D13=3,\"Pipelines\",IF(D13=4,\"Production\",IF(D13=5,\"OSTS Inspection Data\",\"Wells\")))))","v":"Pipelines"},{"$f":"IF(C10=\"PLATFORMS\",1,IF(C10=\"PLATFORM_CHARS\",2,IF(C10=\"PIPELINE\",3,IF(C10=\"PRODUCTION\",4,IF(C10=\"INSPECTION\",5,6)))))","v":3}]
[]
[]
[]
[]
[]
[]
[null,null,"NOTE:"]
[null,null,"1. User Input in \"Blue\" Font"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ","BA","BB","BC","BD","BE","BF","BG","BH","BI","BJ","BK","BL","BM","BN","BO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DocRefID","SheetName",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Operators","CompanyName","CompanyNumber","qualifyingVintageHeritage","isMainOperator","CompanyAbbreviation","Address","City","State","ZIP","Country","ResponsiblePerson","Role","ParentNum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Platforms","AR","BLK","STNAME","CPXID","STN","OperatorNum","STRTYP","InstallDate","FedOrState","WD","DH","Quarters","NumberLegs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Platform Characteristics","CPXID","STN","INSPYEAR","Latitude","Longitude","BracingLong","BracingTran","Grouting","PARENT_CMPLX_ID","DRILLING_FLAG","FIRED_VESSEL_FL","RISK_TYPE_CODE","ALOC_MTR_FLAG","ATTENDED_8_HR_FL","CONDN_PROD_FLAG","DISTANCE_TO_SH","GAS_PROD_FLAG","GAS_FLARING_FLAG","MAJ_CMPLX_FLAG","LACT_MTR_FLAG","INJECTION_CODE","HELIPORT_FLAG","WORKOVER_FLAG","WATER_PROD_FLAG","TANK_GAUGE_FLAG","SUL_PROD_FLAG","STORE_TANK_FLAG","RIG_COUNT","QTR_TYPE_CODE","PROD_EQMT_FLAG","PRODUCTION_FLAG","POWER_SOURCE_TYP","POWER_GEN_FLAG","OIL_PROD_FLAG","GAS_SALE_MTR_FL","FIELD_NAME_CODE","DISTRICT_CODE","CRANE_COUNT","COMPRESSOR_FLAG","COMGL_PROD_FLAG","METER_PROVER_FL","CAT_PROTCT_TYPE","DECK_COUNT","MAJ_STRUC_FLAG","LEG_SIZE","STEL_COMP_COUNT","SLOT_DRILL_COUNT","SLOT_COUNT","SLANT_SLOT_CNT","UNDWTR_COMP_CNT","PTFRM_DECK_SIZE","PILE_GROUT_CODE","PILES_COUNT","PLTFRM_AUTH_CD","SUBDISTRICT_CODE","CAIS_COUNT","FLARING_BOOM_FL","H2S_EQMT_NUM","DESTROYED_DATE","DESTROYED_REMARKS","SHAPE","ACTUAL_REMOVAL_CODE","DESGN_LIFE_NUM","PILE_SIZE","HLPRT_GROSS_WGT","MooringLines"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Pipelines","INSTALL_DATE","REMOVAL_DATE","SEGMENT_NUM","SEG_LENGTH","ORIG_ID_NAME","ORIG_AR_CODE","ORIG_BLK_NUM","ORIG_LSE_NUM","DEST_ID_NAME","DEST_AR_CODE","DEST_BLK_NUM","DEST_LSE_NUM","ABAN_APRV_DT","ABAN_DATE","APPROVED_DATE","AUTH_CODE","BD_PPL_SDV_FL","BUR_DSGN_FL","CAT_LIFE_TM","DEP_FLAG","PPL_CONST_DATE","LK_DETEC_FL","LAST_REV_DATE","INIT_HS_DT","FED_ST_LGTH","STATUS_CODE","PPL_SIZE_CODE","ROW_NUMBER","RECV_MAOP_PRSS","RECV_SEG_NUM","PRPSL_CON_DT","PROD_CODE","SYS_DESIG_CODE","FACIL_OPERATOR","MIN_WTR_DPTH","MAX_WTR_DPTH","PROT_NUMBER","MAOP_PRSS","CATHODIC_CODE","BIDIR_FLAG","BD_PPL_FSV_FL","APRV_CODE","ABAN_TYPE","MAOP_TYPE","G_SYS_DESIG_CODE","DGTZ_DATA_FLAG","ALT_PROD_CODE","PPL_ROW_STAT_CD","PPL_ROW_ISS_DATE","PPL_ROW_PRMTE","SDE_PLOT_CODE","SDE_COMPANY_DESG","SDE_FEATURE_DATE","ONSHR_ST_LGTH","LAST_UPDATED_BY","OIL_CONDENSATE_API_GRAVITY","H2S_CONCENTRATION_NUM","OLD_PIPE_USED_FLAG","CAT_DSGN_TYPE_CD","ANODE_TYPE_CODE","SURFACE_SEGMENT_NUMBER","SN_ORIG_AREA_BLOCK_FK","SN_DEST_AREA_BLOCK_FK","ORIG_COMPLEX_ID_NUM","ORIG_STRUCTURE_NUMBER","DEST_COMPLEX_ID_NUM","DEST_STRUCTURE_NUMBER","ORIG_SN_BOREHOLE_FK","DEST_SN_BOREHOLE_FK","SHAPE","Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Production","COMPLEX_ID_NUM","STRUCTURE_NUMBER","STRUCTURE_NAME","Oil bbls","Gas mcf","Platfrom Operator","INSTALL_DATE","REMOVAL_DATE","YEAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"OSTS Inspection Data","STRUCTURE_NUMBER","COMPLEX_ID_NUM","INSP_YEAR","CAT_POT_ACPT_CD","CAT_SURV_PERF","ABV_WTR_INSP","LAST_REV_DATE","MJ_UNDWTR_DMG","MN_UNDWTR_DMG","PTFRM_COND_CODE","REPAIR_COMP_DT","MN_ABVWTR_DMG","MJ_ABVWTR_DMG","UNDWTR_INSP","INSP_DECK_COUNT","INSP_SLOT_COUNT","INSP_BED_COUNT","INSP_QTR_TYPE_CD","INSP_LEVEL","COMMENTS","MMS_COMPANY_NUM","MMS_START_DATE","NEXT_UNDWTR_INSP_DUE_DT","COATING_SYSTEM_CODE","NEXT_LEVEL_III_INSP_DUE_DT","ECL","NextLevel2InspectionDate","PreviousL3","DeckHeight"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Wells","SN_BOREHOLE","API_WELL_NUMBER","WELL_NAME","WELL_SPUD_DATE","WELL_NAME_SUFFIX","WELL_NM_ST_SFIX","WELL_NM_BP_SFIX","MMS_COMPANY_NUM","BOTM_SORT_NAME","SURF_OPER_NUM","SURF_SORT_NAME","SURF_FLD_NAME_CD","SURF_LEASE_NUM","SURF_AREA_CODE","SURF_BLOCK_NUM","BOTM_FLD_NAME_CD","BOTM_LEASE_NUM","BOTM_AREA_CODE","BOTM_BLOCK_NUM","MMS_PLAN_AREA_CD","DISTRICT_CODE","ABV_MUDLINE_HT","APD_APRV_DATE","BH_TOTAL_MD","BOREHOLE_STAT_CD","BOTM_E_W_CODE","BOTM_LATITUDE","BOTM_N_S_CODE","BOTM_X_COORD_LOC","BOTM_N_S_DIST","SURF_N_S_CODE","SURF_LONGITUDE","SURF_LATITUDE","SURF_E_W_DIST","SURF_E_W_CODE","RKB_ELEVATION","MINERAL_CODE","CASING_CUT_CODE","WELL_TYPE_CODE","WELL_BORE_TVD","WATER_DEPTH","UNDWTR_COMP_STUB","TOTAL_DEPTH_DATE","TIMS_PAAS_CODE","SURF_Y_COORD_LOC","SURF_X_COORD_LOC","SURF_N_S_DIST","BOTM_Y_COORD_LOC","BOTM_LONGITUDE","BOTM_E_W_DIST","BOREHOLE_STAT_DT","BLW_MUDLINE_DPTH","API_SUFFIX_NUM","WELL_TD_SS","BH_UNIT_AGT_CODE","WELL_CL_CODE","WELL_LONG_ID","WELL_INFO_DUE_DT","UNDWTR_COMP_BUOY","SN_APD_FK","BOREHOLE_ADD_DT","COMPLEX_ID_NUM","STRUCTURE_NUMBER","WELL_SUM_RECV_DT","HWDC_SCRUB_DT","WELL_BP_ST_KICKOFF_MD","LAST_UPDT_DATE","LOG_DATA_AND_SURVEYS_DUE_DT","ANALYTICAL_REPORTS_DUE_DT","SUB_SURF_LONGITUDE","SUB_SURF_LATITUDE","SUB_SURF_NAD_YR_CD","SURF_DEPT_CALC_FL","SURF_LAST_UPDT_DT","SUB_BOTM_LATITUDE","SUB_BOTM_LONGITUDE","SURF_LOC_CALC_CD","SUBSEA_COMPLETION_FLAG","SUBSEA_PROTECTION_FLAG","SUBSEA_COMPLETION_BUOY_FLAG","SUBSEA_TREE_HEIGHT_AML","OBSTRUCTION_TYPE_CD","OBSTRUCTION_BUOY_FLAG","OBSTRUCTION_PROTECTION_FLAG","OBSTRUCTION_HEIGHT_AML","SUB_BOTM_E_W_CODE","SUB_BOTM_E_W_DIST","SUB_BOTM_N_S_CODE","SUB_BOTM_N_S_DIST","SUB_BOTM_X_COORD_LOC","SUB_BOTM_Y_COORD_LOC","SUB_BOTM_LOC_CALC_CD","SUB_BOTM_NAD_YR_CD","FNL_SURF_PLAT_ENTERED_DT","BOTM_LAST_UPDT_BY_DIR_DT","SURF_LOC_VRFY_DT","BOTM_LOC_VRFY_DT","SUB_BOTM_LAST_UPDT_DT","WELL_REVIEW_COMPLETE_DT","SUB_BOTM_DEPT_CALC_FL","PUBLIC_RELEASE_FLAG"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSPECTION",null,null,null,null,null,"PLATFORMS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPXID","STN","INSP_YEAR","CPXID*1000+STN",null,null,"CPXID","STN","OperatorNum","CPXID*1000 + STN"]