/n 25 File Home Insert Page Layout Formulas A Data Review Show Queries From Table View Add-ins Nitro PDF Pro Acrobat KPDC list of activities and WSPS Rev. 3- Excel Tell me what you want to do... Connections Properties 22 Access Web From From From From Other Text Sources Existing New Refreshi Connections Query-Recent Sources All Edit Links Z Sort Filter Clear Reapply Advanced Text to Data Flash Remove Columns Fill Duplicates Validation" Consolidate Relationships Manage Get External Data Get & Transform Connections Sort & Filter Data Tools 111 ✓ fx Draft A D E KPDC List of Rig Activities vs Procedures G H 1001 Trip In and Out of the Hole 1002 Back Reaming/Pumping Out of the Hole Nov-23 Draft Reviewed 1003 Picking Up and Laying Down Singles by Hyd. Catwalk 1004 Making up and laying down BHA OP SOP 001 Drilling Operations SOP Approved Translated 1009 Picking up and laying down drill collars Nov-23 Draft 1019 Drilling Ahead Making ng Top Drive Connections Draft 1022 Laying Down Casing & Tubing Draft 1029 Jarring and Post Jarring operation OP SOP 001 Drilling Operations SOP Nov-23 PDC Draft 1035 Fishing Operations Draft 1044 Displace Wellbore 1031 Slip and Cut Drilling Line OP SOP 001 KP-PRO-OPM-011 1091 Remove and install hammerless washpipe OP SOP 001 Drilling Operations SOP Cutting & slipping of drilling line Drilling Operations SOP Nov-23 PDC Draft Nov-23 KPDC Draft 30.10.2023 KPDC Draft 2014 Picking Up Doubles by Hyd. Catwalk OP SOP 001 Drilling Operations SOP 03.11.2023 KPDO Draft General Operations on Rig Floor 1134 Run in hole casing, using CRT & PULD Machine 1112 Operating Hawkjaw OP SOP 001 Drilling Operations SOP 01.03.2024 KPDC Draft Nov-23 Draft 1132 Pickup DPS and rack back stands on derrick OP SOP 001 Drilling Operations SOP Nov-23 Draft 1008 Leak Off Pressure and FIT Test 1024 Running completion string 1099 Change Tong Dies 1005 Make Up Whipstock BHA 1021 Preparing Casing Liner Tubing DP 1030 Rig Up-Down RIH Slickline-Wireline 1053 Operating Man Rider Air Winch 1065 Installing wear ring 1066 Drifting stand from monkey board 1090 Operating Air Hoist Nov-23 Draft Nov-23 Draft Nov-23 Draft OP SOP 001 Drilling Operations SOP PDC Draft Nov-23 Draft Draft Draft OP SOP.001 Drilling Operations SOP PDC g Draft Draft Nov-23 Draft 31 32 1026 Rig up-down cement lines and cement job Revi 1012 General Pit Operations Nov-23 Draft OP SOP 001 Drilling Operations SOP PDC Draft 33 1043 Mud Mixing 2 General operations on Pits 34 1078 Cleaning mud tanks operation KP-PRO-HSE-011 KP-PRO-HSE-019 Handling of hazardous substances Nov-23 KPD Draft 35 1083 Trip tank operations OP SOP.001 Confined space entry Drilling Operations SOP Nov-23 KPDO Draft Nov-23 Draft 36 1023 Cleaning Discharge Screens on Mud Pump Nov-23 Draft 37 General operations in Mud Pumps 1028 Cleaning Suction Screens on Mud Pump OP SOP 001 Drilling Operations SOP Nov-23 PDC Draft 38 1133 Shale shakers service Nov-23 Draft 39 4 Hotworks in welding shop 1016 General Welding Work ES SOP.002 1015 General Electrical Work 40 41 42 5 General Electrical works 43 44 45 46 1093 Charging batteries 1006 Pressure Testing Surface Piping and Mud Lines 1007 Casing and Liner Test KP-PRO-OPM-017 KP-PRO-OPM-018 KP-PRO-HSE-018,KP PRO-HSE-018 KP-PRO-OPM-021 Preventive maintenance verification procedure Hand and BOP test procedure Safe Working Standards SOP Preventive maintenance verification procedure Hand and power tools Nov-23 Draft Nov-23 KPDC Draft Nov-23 KPDC BOP test procedure 1039 Operating Test Pump 1041 Testing BOP on stump 2011 KPDC WSP Pressure test with SubCHECKER KP-PRO-OPM-017 KP-PRO-OPM-017 OP SOP.001 BOP test procedure BOP test procedure Drilling Operations SOP Draft Nov-23 KPDO Draft Nov-23 KPDQ Draft Nov-23 KPDC Draft 30.10.2023 KPDC Draft 06.11.2023 KPDC Draft WSP + Ready 126 of 129 records found Type here to search H In the "I" column create a drop down list. Allow user to only select one of four entries Not Developed 2. Draft 3. Reviewed 4. Approved X Perazich, Milan Share What-If Forecast Group Ungroup Subtotal Data Model Analysis Sheet Forecast Outline 16 K L M 0 P Q R SA X 79°F Mostly cloudy ^ 10:58 AM 4/24/2024 5. Translated This is used to demonstrate progress... Not developed being initial state and Translated is final state Only allow these four selections in the I column 2. Have the entries change color when selected. Use colors as above 3. Develop in new tab on bottom a pie graph. The graph must update with as the enteries are updated. The pie graph will be a way to visualize how much has been completed. Example pie graph will show xxx percent complete for each entrie….. Initally the graph will show 0% not developed, 100% completed, 0% reviewed, 0% approved, 0% translated….... but as I updated the entries in the other page, the expectation is the graph will adjust appropriately. would like the graph colors to be consistant with the colors uses in prior page too. 3d 10%