Uncle.Sam113
New Member
- Joined
- Sep 4, 2012
- Messages
- 1
Dear Excell pros, please help me on finding right formula or script for doing following. Have a list of operations per day (see below). in this workbook on another sheet which is printout sheet, i want to enter ONLY number of report (first column) in printout sheet, and to see the operations per day (as you see there is multiple number on one day report). Lookup function doesn't work here (maybe if double lookup, then i would have another row to number daily operations, however don't know how to do that). Would be prefferable to avoid using scripts so after me changing value in REPORT DATE cell on printout list it will show me operations for the day instantly, however, if it is not possible then scripts are better than nothing.
On printout sheet only one cell is for entry --- Number of report. All others are formulas to come back with information from another sheets.
Looking and appreciating for your help.
If i didn't formulate my question correct, please ask, I'll try to chase this post until find a solution.
<tbody>
</tbody>
On printout sheet only one cell is for entry --- Number of report. All others are formulas to come back with information from another sheets.
Looking and appreciating for your help.
If i didn't formulate my question correct, please ask, I'll try to chase this post until find a solution.
| REP # | DATE | FROM | TO | HOURS | PHASE | TASK | ACTIVITY | CODE | NPT | DETAILS OF OPERATION | ||||||||||
| 1 | 19-Aug-12 | 12:00 | 0:00 | 12.00 hrs | PRE | MOB | P | Rig accepted at 12:00. Started preparation and mixing of mud. M/U and setback 6 stands HWDP, M/U 17 1/2" Smith Bit and BHA#1 (17 1/2" Bit, Bit Sub, 9" DC, 2 ea X/O, 6 ea 5" HWDP). | ||||||||||||
| 2 | 20-Aug-12 | 0:00 | 3:00 | 3.00 hrs | P | Continue preparing and mixing mud. | ||||||||||||||
| 2 | 20-Aug-12 | 3:00 | 3:30 | 0.50 hrs | P | Conduct safety meeting prior to spud and perform BOP drill. | ||||||||||||||
| 2 | 20-Aug-12 | 3:30 | 17:30 | 14.00 hrs | SURF | P | Spud the well and drill from surface to 66 m. WOB: 1-2 T, Flow Rate: 400-600 gpm, RPM: 60-65. | |||||||||||||
| 2 | 20-Aug-12 | 17:30 | 18:00 | 0.50 hrs | SURF | DRILL | CIR | P | Circulate bottom up to clean hole. | |||||||||||
| 2 | 20-Aug-12 | 18:00 | 19:30 | 1.50 hrs | SURF | DRILL | PUL | P | POOH for BHA change, no overpull. Observe bit partially ball up. B/O and clean up bit. L/D 1 ea 9"DC. | |||||||||||
| 2 | 20-Aug-12 | 19:30 | 21:00 | 1.50 hrs | SURF | DRILL | BHPULD | P | M/U Slb tools and new BHA (17 1/2"Bit + Bit Sub + 2 ea Telescope Bot Saver Sub + MWD + Telescope Top Saver Sub | |||||||||||
| 2 | 20-Aug-12 | 21:00 | 21:30 | 0.50 hrs | SURF | DRILL | BHATST | P | Test MWD at 110 strokes,OK. | |||||||||||
| 2 | 20-Aug-12 | 21:30 | 22:30 | 1.00 hrs | SURF | DRILL | BHPULD | P | M/U 17 1/2" Stabilizer + 9" NMDC and RIH to bottom. No tight hole. | |||||||||||
| 2 | 20-Aug-12 | 22:30 | 00:00 | 1.50 hrs | SURF | DRILL | DRL | P | Drill 17 1/2" hole from 66m to 76 m . WOB: 2 T, Flow Rate: 650 - 670gpm, RPM:75 SPP: 650 Psi | |||||||||||
| 3 | 21-Aug-12 | 00:00 | 00:00 | 24.00 hrs | SURF | DRILL | DRL | P | Drill 17 12" hole from 76m to 216m. WOB: 2 T, Flow Rate: 960 gpm, RPM: 100, SPP: 1400 psi, Average ROP: 6.08 m | |||||||||||
| 4 | 22-Aug-12 | 00:00 | 03:30 | 3.50 hrs | SURF | DRILL | DRL | P | Drill 17 12" hole from 216 m to 234 m. WOB: 2 T, Flow Rate: 960 gpm, RPM: 100, SPP: 1400 psi | |||||||||||
| 4 | 22-Aug-12 | 03:30 | 4:30 | 1.00 hrs | SURF | CLEAN | CIR | P | Circulate to clean hole prior to wiper trip. | |||||||||||
| 4 | 22-Aug-12 | 4:30 | 7:00 | 2.50 hrs | SURF | P | Wiper trip to 22 m. Observe overpull 8t at 168 m and 5t at 142 m. Reciprocate the string, OK. Start RIH. | |||||||||||||
| 4 | 22-Aug-12 | 7:00 | 9:00 | 2.00 hrs | SURF | P | Circulation prior to POOH. Spot 63 bbl HI-VIS on bottom . | |||||||||||||
| 4 | 22-Aug-12 | 9:00 | 12:00 | 3.00 hrs | SURF | P | POOH, no overpull. L/D BHA and Slb tools, B/O 17 1/2" bit. ( Dull: 1-1-WT-A-E-I-NO-TD) | |||||||||||||
| 4 | 22-Aug-12 | 12:00 | 12:30 | 0.50 hrs | SURF | P | R/U 13 3/8"Casing tools. Conduct pre-job safety meeting prior to 13 3/8" casing running. | |||||||||||||
| 4 | 22-Aug-12 | 12:30 | 17:00 | 4.50 hrs | SURF | P | P/U first joint 13 3/8"csg with float shoe, fill it up w/mud for fuction test shoe, OK. Run 19 joints 13 3/8" K-55 #54.5 BTC casings. Tag at 234 m w/2 t, OK. Set shoe at 232m. | |||||||||||||
| 4 | 22-Aug-12 | 17:00 | 18:00 | 1.00 hrs | SURF | P | Preparation for cement job. M/U cementing head and cementing lines, test lines,OK. Circulation at bottom prior to cement job. | |||||||||||||
| 4 | 22-Aug-12 | 18:00 | 20:00 | 2.00 hrs | SURF | P | Conduct pre-job safety meeting prior to cement job. Fill lines w/ 10 bbl water, test lines to 2000 psi for 5 minutes, OK. Pump 40 bbls preflush fluid as a spacer, drop bottom plug. Pump 139 bbl 12 ppg lead slurry w/ 4.5 bpm rate. Pump 47 bbl 15.4 ppg tail slurry w/ 4 bpm rate. Drop top plug, displace it w/ 110 bbl mud. Bump the plug at 900 psi. Test the plug to 1350 psi for 5 minutes, OK. Observe and dump 50 bbl cement at surface. Check any returns, no returns. Full circulation during cement job. |
<tbody>
</tbody>
