I've got a pivot table, in which I am using an "Ending Date" as a Report Filter. I would like to be able to apply a "Value Filter" to this, but Excel 2010 is not letting me. I understand that I can check off multiple dates, but I have a lot of dates in there. I'd like to see the information...
I'm looking at possibly running some fiber optic cable in a few of my wells to get a better representation of a production log and to try and find our if we have any thief zones. I'm looking for a way to ensure that I get the cable to the bottom perfs in these wells and I would like the fiber to...
I'm trying to generate an Excel cash flow model to determine whether or not to use chemical to help slow down the corrosion of my tubing. I was hoping to be able to run a series of scenarios, i.e. continuous injection, batch treating monthly, bi-monthly, quarterly, etc. along with different...
So here's the deal. I get emailed daily production from 9 wells, each is a separate file and each file gets renamed for each month/year. I take each of these 9 separate files, (soon to be quite a bit more) and have to take the past week's data from them and put it on another spreadsheet that I...
I have a spreadsheet with quite a few tabs, each of which is linked to multiple charts. We add data daily and I wanted to have the charts update dynamically. I am in the process of naming the dynamic ranges and found that in order to do so that the names of my tabs needed to have no spaces...
Hi guys. I am not the best at writing code. I typically just record simple macros. However, I have a sheet that gets updated daily and I want to be able to take the last 7 rows (a weeks worth) of data and export into a separate table on another sheet. Any help would be greatly appreciated...
I'm not the greatest at writing code. I usually just record simple macros. However I am trying to write a macro to take the last 7 rows from one spreadsheet that changes everyday, and export them to another spreadsheet. I'm trying to make some nice weekly production tables and charts. Any...
Hi all, I free-handed a bullet shaped part by using the spline tool and some lines and then revolved it around the center line. I am left with a part that very much resembles what I want it to. Is there any way that I can dimension my splines? I just need a few of the angles. Thanks for any...
Can someone briefly explain to me why the loading J-curve of a gas well will show a decrease in minimum rate for stable flow as the WGR gets higher? I'm having a hard time seeing why.
I just want to do a quick drawing using the drawing feature in SolidWorks. No need to build parts yet. I was just wondering if it is possible to change some of the lines to dashed or dotted lines? Any info on how to do this would be greatly appreciated. Thanks.
Just beginning to mess around with SolidWorks. I was wondering if it would be possible to somehow take a .DWG file that a client sent me and import it into SolidWorks as a part (.SLDPRT)?
Hi, new here. I was wondering how one goes about putting dimensions on helix in a drawing on SolidWorks? Any help/advice will be greatly appreaciated. Thanks.
Jake